WITH vol_arb AS ( SELECT SUM(AMOUNT_IN_USD) AS volume , COUNT(DISTINCT origin_from_address) AS wallets , COUNT(*) as txns , 'arbitrum' as chain , '2023-Q4' as fyear FROM arbitrum.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP >= '2023-10-01' AND BLOCK_TIMESTAMP < '2024-01-01ba' UNION ALL SELECT SUM(AMOUNT_IN_USD) AS volume , COUNT(DISTINCT origin_from_address) AS wallets , COUNT(*) as txns , 'arbitrum' as chain , '2024-Q1' as fyear FROM arbitrum.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP >= '2024-01-01' AND BLOCK_TIMESTAMP < '2024-04-01' ), vol_avax AS ( SELECT SUM(AMOUNT_IN_USD) AS volume , COUNT(DISTINCT origin_from_address) AS wallets , COUNT(*) as txns , 'avax' as chain , '2023-Q4' as fyear FROM avalanche.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP >= '2023-10-01' AND BLOCK_TIMESTAMP < '2024-01-01' UNION ALL SELECT SUM(AMOUNT_IN_USD) AS volume , COUNT(DISTINCT origin_from_address) AS wallets , COUNT(*) as txns , 'avas' as chain , '2024-Q1' as fyear FROM avalanche.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP >= '2024-01-01' AND BLOCK_TIMESTAMP < '2024-04-01' ), vol_base AS ( SELECT SUM(AMOUNT_IN_USD) AS volume , COUNT(DISTINCT origin_from_address) AS wallets , COUNT(*) as txns , 'base' as chain , '2023-Q4' as fyear FROM base.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP >= '2023-10-01' AND BLOCK_TIMESTAMP < '2024-01-01' UNION ALL SELECT SUM(AMOUNT_IN_USD) AS volume , COUNT(DISTINCT origin_from_address) AS wallets , COUNT(*) as txns , 'base' as chain , '2024-Q1' as fyear FROM base.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP >= '2024-01-01' AND BLOCK_TIMESTAMP < '2024-04-01' ), vol_bsc AS ( SELECT SUM(AMOUNT_IN_USD) AS volume , COUNT(DISTINCT origin_from_address) AS wallets , COUNT(*) as txns , 'bsc' as chain , '2023-Q4' as fyear FROM bsc.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP >= '2023-10-01' AND BLOCK_TIMESTAMP < '2024-01-01' UNION ALL SELECT SUM(AMOUNT_IN_USD) AS volume , COUNT(DISTINCT origin_from_address) AS wallets , COUNT(*) as txns , 'bsc' as chain , '2024-Q1' as fyear FROM bsc.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP >= '2024-01-01' AND BLOCK_TIMESTAMP < '2024-04-01' ), vol_ethereum AS ( SELECT SUM(AMOUNT_IN_USD) AS volume , COUNT(DISTINCT origin_from_address) AS wallets , COUNT(*) as txns , 'ethereum' as chain , '2023-Q4' as fyear FROM ethereum.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP >= '2023-10-01' AND BLOCK_TIMESTAMP < '2024-01-01' UNION ALL SELECT SUM(AMOUNT_IN_USD) AS volume , COUNT(DISTINCT origin_from_address) AS wallets , COUNT(*) as txns , 'ethereum' as chain , '2024-Q1' as fyear FROM ethereum.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP >= '2024-01-01' AND BLOCK_TIMESTAMP < '2024-04-01' ), vol_op AS ( SELECT SUM(AMOUNT_IN_USD) AS volume , COUNT(DISTINCT origin_from_address) AS wallets , COUNT(*) as txns , 'optimism' as chain , '2023-Q4' as fyear FROM optimism.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP >= '2023-10-01' AND BLOCK_TIMESTAMP < '2024-01-01' UNION ALL SELECT SUM(AMOUNT_IN_USD) AS volume , COUNT(DISTINCT origin_from_address) AS wallets , COUNT(*) as txns , 'optimism' as chain , '2024-Q1' as fyear FROM optimism.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP >= '2024-01-01' AND BLOCK_TIMESTAMP < '2024-04-01' ), vol_polygon AS ( SELECT SUM(AMOUNT_IN_USD) AS volume , COUNT(DISTINCT origin_from_address) AS wallets , COUNT(*) as txns , 'polygon' as chain , '2023-Q4' as fyear FROM polygon.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP >= '2023-10-01' AND BLOCK_TIMESTAMP < '2024-01-01' UNION ALL SELECT SUM(AMOUNT_IN_USD) AS volume , COUNT(DISTINCT origin_from_address) AS wallets , COUNT(*) as txns , 'polygon' as chain , '2024-Q1' as fyear FROM polygon.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP >= '2024-01-01' AND BLOCK_TIMESTAMP < '2024-04-01' ) SELECT * FROM vol_arb UNION ALL SELECT * FROM vol_ethereum UNION ALL SELECT * FROM vol_bsc UNION ALL SELECT * FROM vol_op UNION ALL SELECT * FROM vol_base UNION ALL SELECT * FROM vol_avax UNION ALL SELECT * FROM vol_polygon

teppakorn