SELECT

date_trunc('month', block_timestamp) as month,

platform,

CASE

WHEN block_timestamp < '2023-10-17' THEN 'No Fee'

WHEN block_timestamp >= '2023-10-17' AND block_timestamp < '2024-04-10' THEN '0.15%'

ELSE '0.25%'

END AS fee_category,

SUM(amount_in_usd) as volume,

COUNT(DISTINCT trader) as traders,

COUNT(DISTINCT tx_hash) as swaps

FROM crosschain.defi.ez_dex_swaps

WHERE block_timestamp >= '2023-01-01'

AND blockchain = 'ethereum'

GROUP BY 1, 2, 3

SELECT

platform,

fee_category,

AVG(volume) as avg_monthly_volume,

AVG(traders) as avg_monthly_traders,

AVG(swaps) as avg_monthly_swaps

FROM monthly_data

GROUP BY 1, 2

ORDER BY

platform,

CASE

WHEN fee_category = 'No Fee' THEN 1

WHEN fee_category = '0.15%' THEN 2

WHEN fee_category = '0.25%' THEN 3

END