SELECT
trunc(block_timestamp,'week') as date,
--symbol,
sum(case when is_taker='true' then amount_usd else 0 end) as volume,
sum(volume) over (order by date) as total_volume,
count(distinct trader) as active_traders
from arbitrum.vertex.ez_perp_trades
where block_timestamp<current_date
group by 1 order by 1 desc