flipside

Cross-Chain DEX Swap Gas Fee Analysis (7D)

gihankumarCross-Chain DEX Swap Gas Fee Analysis (7D)

Updated 2025-04-25

WITH chain_data AS (

SELECT 'ethereum' AS chain, platform, swaps.tx_hash, tx.gas_price, tx.gas_used

FROM ethereum.defi.ez_dex_swaps swaps

JOIN ethereum.core.fact_transactions tx ON swaps.tx_hash = tx.tx_hash

WHERE tx.block_timestamp >= CURRENT_DATE - INTERVAL '7 days'

UNION ALL

SELECT 'arbitrum' AS chain, platform, swaps.tx_hash, tx.gas_price_paid, tx.gas_used

FROM arbitrum.defi.ez_dex_swaps swaps

JOIN arbitrum.core.fact_transactions tx ON swaps.tx_hash = tx.tx_hash

WHERE tx.block_timestamp >= CURRENT_DATE - INTERVAL '7 days'

UNION ALL

SELECT 'optimism' AS chain, platform, swaps.tx_hash, tx.gas_price, tx.gas_used

FROM optimism.defi.ez_dex_swaps swaps

JOIN optimism.core.fact_transactions tx ON swaps.tx_hash = tx.tx_hash

WHERE tx.block_timestamp >= CURRENT_DATE - INTERVAL '7 days'

UNION ALL

SELECT 'base' AS chain, platform, swaps.tx_hash, tx.gas_price, tx.gas_used

FROM base.defi.ez_dex_swaps swaps

JOIN base.core.fact_transactions tx ON swaps.tx_hash = tx.tx_hash

WHERE tx.block_timestamp >= CURRENT_DATE - INTERVAL '7 days'

UNION ALL

SELECT 'polygon' AS chain, platform, swaps.tx_hash, tx.gas_price, tx.gas_used

FROM polygon.defi.ez_dex_swaps swaps

JOIN polygon.core.fact_transactions tx ON swaps.tx_hash = tx.tx_hash

WHERE tx.block_timestamp >= CURRENT_DATE - INTERVAL '7 days'

)

SELECT

Last run: about 1 month ago

	CHAIN	PLATFORM	SWAP_COUNT	AVG_GAS_FEE_GWEI	AVG_GAS_FEE_ETH
1	polygon	hashflow-v3	200	0.215913	2.15913427e-10
2	polygon	curve	49691	0.145882	1.45881618e-10
3	polygon	kyberswap-v1	8062	0.114001	1.14000934e-10
4	polygon	dodo-v1	3803	0.113772	1.13772085e-10
5	polygon	balancer	106644	0.084879	8.4879048e-11
6	polygon	quickswap-v3	764130	0.076292	7.6292084e-11
7	polygon	dodo-v2	22906	0.074771	7.4770723e-11
8	polygon	uniswap-v3	1537046	0.067857	6.7856888e-11
9	polygon	woofi	7691	0.063098	6.3097998e-11
10	polygon	sushiswap	89342	0.057992	5.7991559e-11
11	polygon	fraxswap	2923	0.053779	5.377912e-11
12	polygon	quickswap-v2	1650012	0.045862	4.5861957e-11
13	polygon	kyberswap-v2	1804	0.025333	2.5333032e-11
14	polygon	uniswap-v2	58128	0.020433	2.043258e-11
15	ethereum	sushiswap	52390	0.009021	9.020855e-12
16	ethereum	pancakeswap-v3	36120	0.008961	8.960773e-12
17	ethereum	uniswap-v3	868071	0.005582	5.581657e-12
18	ethereum	curve	67019	0.003291	3.290935e-12
19	ethereum	dodo-v2	4546	0.00285	2.850257e-12
20	ethereum	kyberswap-v2	15	0.002462	2.462065e-12

89

4KB

75s