DATE | AGGREGATOR | BRIDGENAME | N_TXNS | VOL | |
|---|---|---|---|---|---|
1 | 2025-04-30 00:00:00.000 | rango | across | 28 | 3669.541778664 |
2 | 2025-04-23 00:00:00.000 | lifi | stargateV2 | 4 | 3733.59502185 |
3 | 2025-04-18 00:00:00.000 | lifi | across | 35 | 2203.207291599 |
4 | 2025-04-19 00:00:00.000 | lifi | mayan | 1 | 109.195763849 |
5 | 2025-04-15 00:00:00.000 | lifi | stargateV2Bus | 11 | 282.507922266 |
6 | 2025-04-23 00:00:00.000 | lifi | stargateV2Bus | 47 | 3514.3994248 |
7 | 2025-04-28 00:00:00.000 | rango | xyFinance | 8 | 228.228607639 |
8 | 2025-04-17 00:00:00.000 | lifi | cbridge | 2 | 76.054386103 |
9 | 2025-04-29 00:00:00.000 | rango | across | 33 | 6084.942979943 |
10 | 2025-04-25 00:00:00.000 | lifi | stargateV2Bus | 42 | 4098.743867826 |
11 | 2025-05-07 00:00:00.000 | rango | xyFinance | 13 | 2045.829623496 |
12 | 2025-04-24 00:00:00.000 | lifi | across | 55 | 1580.506783269 |
13 | 2025-05-09 00:00:00.000 | rango | across | 25 | 929.486934226 |
14 | 2025-04-29 00:00:00.000 | lifi | stargateV2 | 4 | 61.141740126 |
15 | 2025-05-08 00:00:00.000 | rango | across | 36 | 1401.210878125 |
16 | 2025-05-04 00:00:00.000 | rango | across | 29 | 1577.488939189 |
17 | 2025-04-23 00:00:00.000 | rango | stargate | 8 | 4.90455988 |
18 | 2025-05-14 00:00:00.000 | rango | xyFinance | 33 | 2083.181526348 |
19 | 2025-05-13 00:00:00.000 | rango | stargate | 21 | 931.286284757 |
20 | 2025-04-21 00:00:00.000 | lifi | stargateV2Bus | 30 | 658.269184639 |
LI.FI1Month Comparison Time Series copy
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 Time Series @ https://flipsidecrypto.xyz/studio/queries/5931e7ad-5eec-46ff-bd53-2ec9a48ce2a3
-- Rango on Base: 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-30
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 - 30
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 - 30
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 - 30
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 - 30
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 - 30
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 - 30
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 - 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
Last run: 16 days ago
...
178
11KB
130s