COUNT(*) AS "Number of Swaps"

,COUNT(DISTINCT origin_from_address) AS "Number of Swappers"

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

bsc.defi.ez_dex_swaps

WHERE 1=1

AND PLATFORM LIKE '%pancakeswap%'

AND EVENT_NAME = 'Swap'

AND DATE_PART(YEAR,BLOCK_TIMESTAMP) = 2024