count(distinct tx_hash) as transaction,

sum(transaction) over (order by date) as cum_transaction,

count(DISTINCT sender) as users,

sum(coalesce(amount_in_usd, amount_out_usd)) as volume_usd,

sum(volume_usd) over (order by date) as cum_volume_usd

FROM blast.defi.ez_dex_swaps

GROUP BY date

order by date desc