with tab as (

select

date_trunc('day', BLOCK_TIMESTAMP)::date AS date,

SYMBOL,

ORIGIN_FROM_ADDRESS,

AMOUNT_USD,

TX_HASH

from blast.core.ez_token_transfers

WHERE AMOUNT_USD > 0

),

daily_aggregates as (

select

date,

SYMBOL,

sum(AMOUNT_USD) as volume,

avg(AMOUNT_USD) as avg_volume,

count(distinct TX_HASH) as num_unique_bridges,

count(distinct ORIGIN_FROM_ADDRESS) as num_unique_bridgers

from tab

group by

date,

SYMBOL

date,

SYMBOL,

volume,

avg_volume,

num_unique_bridges,

num_unique_bridgers,

sum(num_unique_bridges) over (partition by SYMBOL order by date) as cum_num_unique_bridges,

sum(num_unique_bridgers) over (partition by SYMBOL order by date) as cum_num_unique_bridgers

from daily_aggregates

order by date;