AGGREGATOR | ORIGIN_FUNCTION_SIGNATURE | COUNT(DISTINCT TX_HASH) | |
|---|---|---|---|
1 | rango | 0x66155375 | 1 |
2 | rango | 0xdadb693f | 1748 |
3 | rango | 0x345ad697 | 1 |
4 | lifi | 0x849ce572 | 10120 |
LI.FIBase Query for Analysis
Updated 2025-05-15
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from 1Month Comparison Bridge Included @ https://flipsidecrypto.xyz/studio/queries/156227c0-d80c-45e1-84f1-d62cf7da239e
-- Rango on Base: tx_hash sample = '0x34e7e70271abe0087d70f786927521967730eaa33053b48b45ae8df39a1e5945'
-- event_name = 'RangoBridgeInitiated'
WITH decodedTXN AS (
SELECT tx_hash, src_chain, decoded_log, block_timestamp, event_name,origin_function_signature
FROM (
SELECT tx_hash, decoded_log, block_timestamp, event_name, origin_function_signature, 'Ethereum' AS src_chain FROM ethereum.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date- 90 and block_timestamp < current_date- 70
UNION
SELECT tx_hash, decoded_log, block_timestamp, event_name, origin_function_signature, 'Polygon' AS src_chain FROM polygon.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - 90 and block_timestamp < current_date- 70
UNION
SELECT tx_hash, decoded_log, block_timestamp, event_name, origin_function_signature, 'BSC' AS src_chain FROM bsc.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - 90 and block_timestamp < current_date- 70
UNION
SELECT tx_hash, decoded_log, block_timestamp, event_name, origin_function_signature,'BASE' AS src_chain FROM base.core.ez_decoded_event_logs
WHERE block_timestamp >=current_date - 90 and block_timestamp < current_date- 70
UNION
SELECT tx_hash, decoded_log, block_timestamp, event_name, origin_function_signature, 'Arbitrum' AS src_chain FROM arbitrum.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - 90 and block_timestamp < current_date- 70
UNION
SELECT tx_hash, decoded_log, block_timestamp, event_name, origin_function_signature, 'OP' AS src_chain FROM optimism.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - 90 and block_timestamp < current_date- 70
UNION
SELECT tx_hash, decoded_log, block_timestamp, event_name, origin_function_signature, 'Avalanche' AS src_chain FROM avalanche.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - 90 and block_timestamp < current_date- 70
UNION
SELECT tx_hash, decoded_log, block_timestamp, event_name, origin_function_signature, 'Gnosis' AS src_chain FROM gnosis.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - 90 and block_timestamp < current_date- 70
)),
prices as (
SELECT hour, price, decimals, symbol, iff(is_native,'0x0000000000000000000000000000000000000000', token_address) as token_address, 'Arbitrum' AS chain FROM arbitrum.price.ez_prices_hourly
UNION
SELECT hour, price, decimals, symbol, iff(is_native,'0x0000000000000000000000000000000000000000', token_address) as token_address, 'OP' AS chain FROM optimism.price.ez_prices_hourly
Last run: 16 days ago
4
107B
432s