BLOCK_TIMESTAMP::date as "Date",

CASE WHEN PLATFORM = 'uniswap-v2' THEN 'Uniswap' WHEN PLATFORM = 'sushiswap' THEN 'Sushiswap' END as "Platform",

COUNT(DISTINCT TX_HASH) as "TX Count",

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as "User Count",

SUM(AMOUNT_OUT_USD) as "Volume"

FROM ethereum.core.ez_dex_swaps

WHERE BLOCK_TIMESTAMP::date >= '2022-06-01' AND BLOCK_TIMESTAMP::date < CURRENT_DATE

AND PLATFORM IN ('uniswap-v2', 'sushiswap')

GROUP BY 1, 2

ORDER BY 1, 2