flipside

1Month Comparison Bridge Included

LI.FI1Month Comparison Bridge Included

Updated 2025-05-05

-- forked from 1Month Comparison Time Series copy @ https://flipsidecrypto.xyz/studio/queries/a7ad9d4a-106d-4441-99df-dde7b4735c8d

-- 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- {{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 (

Last run: 9 days ago

	SRC_CHAIN	AGGREGATOR	BRIDGENAME	AGG_BRIDGE	N_TXNS	VOL
1	BSC	rango	xyFinance	rango-xyFinance	897	51457.540263351
2	OP	lifi	symbiosis	lifi-symbiosis	250	14231.917195192
3	Arbitrum	lifi	across	lifi-across	567	55674.896191995
4	OP	lifi	stargateV2	lifi-stargateV2	26	13049.188193056
5	Arbitrum	lifi	allbridge	lifi-allbridge	17	643.162769989
6	Ethereum	rango	allbridgeCore	rango-allbridgeCore	1	133.959511263
7	BASE	rango	satellite	rango-satellite	2	1188.263260329
8	Polygon	rango	allbridgeCore	rango-allbridgeCore	42	548.842542333
9	Avalanche	lifi	mayan	lifi-mayan	2	1280.595500418
10	OP	lifi	across	lifi-across	272	14765.173300558
11	BASE	rango	stargate	rango-stargate	889	30922.655207595
12	Ethereum	lifi	stargateV2	lifi-stargateV2	69	18991.82293067
13	Polygon	lifi	hop	lifi-hop	2	77.33988219
14	BSC	lifi	mayan	lifi-mayan	354	208063.495545096
15	Polygon	lifi	across	lifi-across	206	6758.815728208
16	Ethereum	rango	satellite	rango-satellite	67	1988.383044499
17	BSC	rango	satellite	rango-satellite	133	3890.179399066
18	Ethereum	lifi	across	lifi-across	1227	263216.914031146
19	Polygon	lifi	allbridge	lifi-allbridge	39	1543.428412652
20	Ethereum	lifi	symbiosis	lifi-symbiosis	1095	316206.778978383

74

5KB

437s