select

t5.dt,

t5.pair,

ROUND(t5.buy_total) as buy_total,

ROUND(t5.sell_total) as sell_total,

ROUND(t5.cvd_sol) as net_token,

ROUND(t5.buy_total + abs(t5.sell_total)) as volume_token,

ROUND(t5.buy_notional_total) as buy_notional_total,

ROUND(t5.sell_notional_total) as sell_notional_total,

ROUND(t5.cvd_notional) as net_notional,

ROUND(t5.buy_notional_total + abs(t5.sell_notional_total)) as volume_notional,

ROUND(sum(t5.buy_total) over (order by t5.dt asc)) as buy_cumulative,

ROUND(sum(t5.sell_total) over (order by t5.dt asc)) as sell_cumulative,

ROUND(sum(t5.cvd_sol) over (order by t5.dt asc)) as cvd_token,

ROUND(sum(t5.buy_notional_total) over (order by t5.dt asc)) as buy_notional_cumulative,

ROUND(sum(t5.sell_notional_total) over (order by t5.dt asc)) as sell_notional_cumulative,

ROUND(sum(t5.cvd_notional) over (order by t5.dt asc)) as cvd_notional

from (

select

t2.dt,

t2.pair,

t2.buy_total,

t4.sell_total,

t2.buy_total + t4.sell_total as cvd_sol,

t2.buy_notional_total,

t4.sell_notional_total,

t2.buy_notional_total + t4.sell_notional_total as cvd_notional

from (

select

date_trunc('hour', t1.block_timestamp) as dt,

-- t1.block_timestamp::date as dt,

-- date_trunc('day', t1.block_timestamp) as dt,

t1.type,

t1.pair,