with claimt as (

select

date_trunc('day', BLOCK_TIMESTAMP) as dates,

count(distinct tx_to) as users,

sum(amount) as claimed_amount

from solana.core.fact_transfers

where tx_from = '4cZgUw6T8yYQ2CordAfSzS4Q5VKJNyVU3JEX6xGg2Xwy'

and mint = 'NYANpAp9Cr7YarBNrby7Xx4xU6No6JKTBuohNA3yscP'

and tx_to != 'C8FXTcztFpdjMjPZYtu6mMTs3M5fLzNKR7Q6vymkQC8e'

and amount > 0

group by 1)

select

dates,

ifnull(claimed_amount,0) as claimed_amount,

ifnull(users,0) as claimers,

sum(ifnull(claimed_amount,0)) over(order by dates asc) as cum_claimed_amount,

20000000 - sum(ifnull(claimed_amount,0)) over(order by dates asc) as cum_unclaimed_amount,

sum(ifnull(users,0)) over(order by dates asc) as cum_claimers

from claimt

order by 1 asc