select
date_trunc('day', block_timestamp) as time,
sum(amount_in) as "Traded $DEGEN",
sum ("Traded $DEGEN") over (order by time) as "Cumulative trading volume"
from
base.defi.ez_dex_swaps
where
token_in = lower('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed')
group by 1
order by 1