flipside

1Month Comparison Time Series

LI.FI1Month Comparison Time Series

Updated 2025-05-05

-- 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: 14 days ago

	DATE	AGGREGATOR	SRC_CHAIN	N_TXNS	VOL
1	2025-04-20 00:00:00.000	lifi	BSC	443	22612.245553695
2	2025-04-19 00:00:00.000	rango	Arbitrum	39	1098.303397215
3	2025-04-17 00:00:00.000	rango	OP	49	17391.695959774
4	2025-05-04 00:00:00.000	rango	Polygon	34	879.771052278
5	2025-04-28 00:00:00.000	rango	Avalanche	1	2
6	2025-04-28 00:00:00.000	rango	Arbitrum	34	1878.63233749
7	2025-05-02 00:00:00.000	rango	Ethereum	133	16371.852927695
8	2025-05-15 00:00:00.000	rango	OP	10	121.635719419
9	2025-04-17 00:00:00.000	lifi	OP	64	26443.199337086
10	2025-04-28 00:00:00.000	rango	Ethereum	26	1118.689298097
11	2025-04-27 00:00:00.000	rango	BASE	25	1026.193423678
12	2025-04-18 00:00:00.000	lifi	Ethereum	188	32922.947859912
13	2025-05-15 00:00:00.000	rango	BASE	16	1548.804693016
14	2025-04-30 00:00:00.000	lifi	BASE	134	43344.7048693
15	2025-04-22 00:00:00.000	rango	Polygon	82	795.061545784
16	2025-04-18 00:00:00.000	lifi	Polygon	497	12704.699171263
17	2025-04-16 00:00:00.000	lifi	Avalanche	7	39.005113007
18	2025-04-23 00:00:00.000	rango	Ethereum	24	50672.725747464
19	2025-04-22 00:00:00.000	lifi	Polygon	161	13723.632548522
20	2025-04-24 00:00:00.000	lifi	Avalanche	11	47.221709606

...

334

20KB

564s