date_trunc (day, block_timestamp) as date,

COUNT(DISTINCT TX_HASH) AS "Total swaps",

sum ("Total swaps") over (order by date) as "Cumulative swap count",

COUNT(DISTINCT TRADER) AS "Total swappers",

sum ("Total swappers") over (order by date) as "Cumulative swappers count",

SUM(COALESCE(AMOUNT_IN_USD, 0) + COALESCE(AMOUNT_OUT_USD, 0)) AS "Total trading Volume",

sum ("Total trading Volume") over (order by date) as "Cumulative trading volume (USD)"

FROM near.defi.ez_dex_swaps

TOKEN_IN_CONTRACT = 'purge-558.meme-cooking.near'

OR TOKEN_OUT_CONTRACT = 'purge-558.meme-cooking.near'

GROUP by 1

order by 1