-- forked from thehederawrites / volume traded by dexes @ https://flipsidecrypto.xyz/thehederawrites/q/RnWMrRXPqpJv/volume-traded-by-dexes
SELECT
platform,
SUM((AMOUNT_IN_USD + AMOUNT_OUT_USD)/2) AS Volume
FROM
aptos.defi.ez_dex_swaps
WHERE BLOCK_TIMESTAMP :: DATE = '{{date}}'
GROUP BY 1
Order by 2 desc