DATE | AGGREGATOR | SRC_CHAIN | N_TXNS | VOL | |
---|---|---|---|---|---|
1 | 2025-06-22 00:00:00.000 | lifi | Ethereum | 97 | 12513.361866231 |
2 | 2025-06-03 00:00:00.000 | rango | Avalanche | 11 | 15.172146121 |
3 | 2025-06-03 00:00:00.000 | lifi | OP | 11 | 76.830142191 |
4 | 2025-06-06 00:00:00.000 | lifi | OP | 6 | 99.421743443 |
5 | 2025-06-19 00:00:00.000 | rango | Arbitrum | 11 | 186.254290482 |
6 | 2025-06-06 00:00:00.000 | lifi | Avalanche | 11 | 75.196336566 |
7 | 2025-06-02 00:00:00.000 | rango | Polygon | 33 | 1836.416300494 |
8 | 2025-06-09 00:00:00.000 | rango | BASE | 18 | 464.015714308 |
9 | 2025-06-11 00:00:00.000 | rango | OP | 24 | 729.928962825 |
10 | 2025-06-20 00:00:00.000 | lifi | Ethereum | 152 | 23697.694953824 |
11 | 2025-06-21 00:00:00.000 | lifi | OP | 9 | 438.080215782 |
12 | 2025-05-25 00:00:00.000 | rango | Avalanche | 20 | 45.797104158 |
13 | 2025-06-20 00:00:00.000 | rango | Polygon | 9 | 201.424793569 |
14 | 2025-05-29 00:00:00.000 | rango | Avalanche | 15 | 18.028911799 |
15 | 2025-06-07 00:00:00.000 | rango | BASE | 9 | 2468.774603781 |
16 | 2025-06-07 00:00:00.000 | rango | Polygon | 29 | 7024.895293635 |
17 | 2025-06-16 00:00:00.000 | lifi | Polygon | 28 | 2529.239069993 |
18 | 2025-06-18 00:00:00.000 | rango | Avalanche | 10 | 8.669772285 |
19 | 2025-06-09 00:00:00.000 | rango | Ethereum | 31 | 15176.272761647 |
20 | 2025-06-18 00:00:00.000 | lifi | Arbitrum | 31 | 2997.814715898 |
LI.FI1Month Comparison Time Series
Updated 2025-06-23Copy Reference Fork
99
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
›
⌄
-- Rango tx_hash sample = '0x34e7e70271abe0087d70f786927521967730eaa33053b48b45ae8df39a1e5945'
-- event_name = 'RangoBridgeInitiated'
WITH decodedTXN AS (
SELECT tx_hash, src_chain, decoded_log, block_timestamp, event_name
FROM (
SELECT tx_hash, decoded_log, block_timestamp, event_name, 'Ethereum' AS src_chain FROM ethereum.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - {{past_days}}
UNION
SELECT tx_hash, decoded_log, block_timestamp, event_name, 'Polygon' AS src_chain FROM polygon.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - {{past_days}}
UNION
SELECT tx_hash, decoded_log, block_timestamp, event_name, 'BSC' AS src_chain FROM bsc.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - {{past_days}}
UNION
SELECT tx_hash, decoded_log, block_timestamp, event_name, 'BASE' AS src_chain FROM base.core.ez_decoded_event_logs
WHERE block_timestamp >=current_date - {{past_days}}
UNION
SELECT tx_hash, decoded_log, block_timestamp, event_name, 'Arbitrum' AS src_chain FROM arbitrum.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - {{past_days}}
UNION
SELECT tx_hash, decoded_log, block_timestamp, event_name, 'OP' AS src_chain FROM optimism.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - {{past_days}}
UNION
SELECT tx_hash, decoded_log, block_timestamp, event_name, 'Avalanche' AS src_chain FROM avalanche.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - {{past_days}}
UNION
SELECT tx_hash, decoded_log, block_timestamp, event_name, 'Gnosis' AS src_chain FROM gnosis.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - {{past_days}}
)),
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
UNION
Last run: 12 days ago
364
22KB
361s