date_trunc(day,BLOCK_TIMESTAMP)::date as date,

TX_FROM,

ADDRESS_NAME,

sum(amount) as toal_amount,

sum(toal_amount) over (partition by ADDRESS_NAME order by date rows between unbounded preceding and current row ) as cum_toal_amount,

count(tx_id) as transaction_count,

sum(transaction_count) over (partition by ADDRESS_NAME order by date rows between unbounded preceding and current row ) as cum_transaction_count

from solana.core.fact_transfers t,solana.core.dim_labels l

where t.TX_FROM = l.address

and mint in (

'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

) and LABEL_TYPE = 'cex'

group by 1,2,3 order by 1