with pricet as ( select median(price) as price_median, date_trunc('day', hour) as date from ethereum.price.fact_hourly_token_prices where token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' group by date ), tab1 as ( -- L1 select 'L1' as type, 'Ethereum' as blockchain, t1.block_timestamp, t1.tx_hash, tx_fee * price_median as fee_price, amount_in_usd as amount_usd, origin_from_address from ethereum.defi.ez_dex_swaps t1 join pricet t2 on date = date_trunc('day', block_timestamp) join ethereum.core.fact_transactions t3 on t3.tx_hash = t1.tx_hash where not amount_usd is null and platform = 'curve' union -- L2 select 'L2' as type, 'Optimism' as blockchain, t1.block_timestamp, t1.tx_hash, tx_fee * price_median as fee_price, amount_in_usd as amount_usd, origin_from_address from optimism.defi.ez_dex_swaps t1 join pricet t2 on date = date_trunc('day', block_timestamp) join optimism.core.fact_transactions t3 on t3.tx_hash = t1.tx_hash where not amount_usd is null and platform = 'curve' union select 'L2' as type, 'Arbitrum' as blockchain, t1.block_timestamp, t1.tx_hash, tx_fee * price_median as fee_price, amount_in_usd as amount_usd, origin_from_address from arbitrum.defi.ez_dex_swaps t1 join pricet t2 on date = date_trunc('day', block_timestamp) join arbitrum.core.fact_transactions t3 on t3.tx_hash = t1.tx_hash where not amount_usd is null and platform = 'curve' ) select case when fee_price < .025 then '< .025$' when fee_price < .05 then '< .025$ - .05$' when fee_price < .075 then '< .05$ - .075$' when fee_price < .1 then '< .075$ - .10$' when fee_price < .15 then '< .10$ - .15$' when fee_price < .20 then '< .15$ - .20$' when fee_price < .25 then '< .20$ - .25$' when fee_price < .30 then '< .30$ - .30$' when fee_price < .50 then '< .30$ - .50$' when fee_price < 1 then '< .50$ - 1$' when fee_price < 2 then '< 1$ - 2$' else '>= 2$' end as fee_type, count(distinct tx_hash) as txns from tab1 group by fee_type

Investigating Curve Finance