initcap(PLATFORM) as PLATFORM,

COUNT(*) AS "Number of Swaps"

, COUNT(ORIGIN_FROM_ADDRESS) AS "Swappers"

, SUM(AMOUNT_IN_USD) AS "Volume Traded"

bsc.defi.ez_dex_swaps

WHERE 1=1

AND BLOCK_TIMESTAMP >= '2024-01-01'

AND EVENT_NAME LIKE '%Swap%'

GROUP BY

PLATFORM

ORDER BY

"Volume Traded" DESC;