with events as (
select block_timestamp,
SYMBOL,
AMOUNT_USD,
from arbitrum.vertex.ez_clearing_house_events
UNION
select block_timestamp,
SYMBOL,
AMOUNT_USD,
from mantle.vertex.ez_clearing_house_events
UNION
select block_timestamp,
SYMBOL,
AMOUNT_USD,
from base.vertex.ez_clearing_house_events
UNION
select block_timestamp,
SYMBOL,
AMOUNT_USD,
from sei.vertex.ez_clearing_house_events
)
SELECT
date_trunc(week, block_timestamp) daily,
SYMBOL,
sum(AMOUNT_USD) volume ,
sum (volume) over (partition by SYMBOL order by daily) cum_net_volume
FROM
events
GROUP BY 1,2