DATE | AGGREGATOR | SRC_CHAIN | N_TXNS | VOL | |
|---|---|---|---|---|---|
1 | 2025-03-09 00:00:00.000 | lifi | BASE | 15 | 609.062646641 |
2 | 2025-03-27 00:00:00.000 | rango | Arbitrum | 65 | 14691.508908913 |
3 | 2025-03-26 00:00:00.000 | lifi | Arbitrum | 80 | 18472.378368412 |
4 | 2025-03-21 00:00:00.000 | rango | BSC | 59 | 977.565760421 |
5 | 2025-03-23 00:00:00.000 | rango | Ethereum | 20 | 1535.881951128 |
6 | 2025-03-09 00:00:00.000 | lifi | Avalanche | 4 | 5.134844801 |
7 | 2025-03-20 00:00:00.000 | lifi | Polygon | 22 | 1751.831240495 |
8 | 2025-04-01 00:00:00.000 | rango | OP | 12 | 239.660281837 |
9 | 2025-03-11 00:00:00.000 | lifi | OP | 4 | 39.100101425 |
10 | 2025-03-11 00:00:00.000 | lifi | Arbitrum | 3 | 14.13813872 |
11 | 2025-04-01 00:00:00.000 | lifi | Arbitrum | 106 | 25848.485807919 |
12 | 2025-03-31 00:00:00.000 | rango | BASE | 22 | 2090.847034215 |
13 | 2025-04-02 00:00:00.000 | lifi | Ethereum | 145 | 21413.741712743 |
14 | 2025-03-13 00:00:00.000 | rango | BASE | 9 | 347.154533738 |
15 | 2025-03-07 00:00:00.000 | lifi | BSC | 68 | 8609.206651351 |
16 | 2025-03-22 00:00:00.000 | lifi | OP | 33 | 617.417429856 |
17 | 2025-03-31 00:00:00.000 | rango | Ethereum | 6 | 54.003911725 |
18 | 2025-03-10 00:00:00.000 | rango | Avalanche | 1 | 9.628989836 |
19 | 2025-03-05 00:00:00.000 | rango | Ethereum | 8 | 110.239716492 |
20 | 2025-03-16 00:00:00.000 | lifi | BASE | 41 | 6200.239535059 |
LI.FI1Month Comparison Time Series
Updated 2025-04-03
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 * , 'Ethereum' AS src_chain FROM ethereum.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date-30
UNION
SELECT *, 'Polygon' AS src_chain FROM polygon.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - 30
UNION
SELECT *, 'BSC' AS src_chain FROM bsc.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - 30
UNION
SELECT *, 'BASE' AS src_chain FROM base.core.ez_decoded_event_logs
WHERE block_timestamp >=current_date - 30
UNION
SELECT *, 'Arbitrum' AS src_chain FROM arbitrum.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - 30
UNION
SELECT *, 'OP' AS src_chain FROM optimism.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - 30
UNION
SELECT *, 'Avalanche' AS src_chain FROM avalanche.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - 30
UNION
SELECT *, 'Gnosis' AS src_chain FROM gnosis.core.ez_decoded_event_logs
WHERE block_timestamp >= current_date - 30
)),
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: 23 days ago
...
417
25KB
402s