SELECT 'Arbitrum' AS Chain, AMOUNT_IN_USD,AMOUNT_OUT_USD, TX_HASH, ORIGIN_FROM_ADDRESS,BLOCK_TIMESTAMP

FROM arbitrum.defi.ez_dex_swaps

UNION ALL

SELECT 'Ethereum' AS Chain, AMOUNT_IN_USD,AMOUNT_OUT_USD, TX_HASH, ORIGIN_FROM_ADDRESS, BLOCK_TIMESTAMP

FROM ethereum.defi.ez_dex_swaps)

SELECT

Chain as "Chain",

SUM((AMOUNT_IN_USD+AMOUNT_OUT_USD)/2)AS "Total DEX Volume",

COUNT(DISTINCT TX_HASH) AS Transactions,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS Users,

FROM Combined_events

WHERE year(BLOCK_TIMESTAMP)='2024'

GROUP BY Chain