flipside

1Month Comparison Bridge Included

LI.FI1Month Comparison Bridge Included

Updated 3 days ago

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

	SRC_CHAIN	AGGREGATOR	BRIDGENAME	AGG_BRIDGE	N_TXNS	VOL
1	BSC	lifi	stargateV2Bus	lifi-stargateV2Bus	116	9264.139457448
2	BSC	lifi	squid	lifi-squid	2	0.06795840884
3	Ethereum	rango	xyFinance	rango-xyFinance	585	266782.725389375
4	Polygon	lifi	symbiosis	lifi-symbiosis	8	616.715416593
5	OP	rango	satellite	rango-satellite	1	0.119854958
6	OP	lifi	symbiosis	lifi-symbiosis	2	23.040342802
7	Ethereum	rango	across	rango-across	1226	197985.23512382
8	Avalanche	lifi	symbiosis	lifi-symbiosis	8	1857.679257193
9	Ethereum	lifi	across	lifi-across	172	13109.567679576
10	Polygon	rango	xyFinance	rango-xyFinance	568	25408.515443105
11	OP	lifi	stargateV2	lifi-stargateV2	2	100.098071057
12	Arbitrum	lifi	cbridge	lifi-cbridge	20	11106.357220824
13	BASE	lifi	allbridge	lifi-allbridge	2	590.585024237
14	Polygon	lifi	stargateV2Bus	lifi-stargateV2Bus	13	32.106093213
15	Arbitrum	lifi	stargateV2	lifi-stargateV2	4	4187.596920458
16	OP	rango	xyFinance	rango-xyFinance	426	21610.163561745
17	Arbitrum	rango	stargate	rango-stargate	560	25501.309216448
18	Avalanche	rango	stargate	rango-stargate	300	4105.905811736
19	BSC	rango	stargate	rango-stargate	4624	363609.141200247
20	BASE	rango	satellite	rango-satellite	2	1.331680898

67

4KB

215s