DATE(BLOCK_TIMESTAMP) AS trading_day,

SUM((AMOUNT_IN_USD + AMOUNT_OUT_USD)/2) AS "Daily Volume USD",

SUM("Daily Volume USD") OVER (ORDER BY trading_day) AS "Total Volume Traded",

COUNT(*) AS "Daily Swaps"

, SUM("Daily Swaps") OVER (ORDER BY trading_day) AS "Total Swaps"

,COUNT(DISTINCT origin_from_address) AS "Swappers"

, SUM("Swappers") OVER (ORDER BY trading_day) AS "Total Swappers"

bsc.defi.ez_dex_swaps

WHERE 1=1

AND PLATFORM like '%pancakeswap%'

AND BLOCK_TIMESTAMP >= '2024-01-01'

GROUP BY

trading_day

ORDER BY

trading_day;