with claimt as (

select

date_trunc('day', BLOCK_TIMESTAMP) as dates,

count(distinct to_ADDRESS) as users,

sum(amount) as claimed_amount,

sum(amount_usd) as claim_usd_amt

from blast.core.ez_token_transfers

where contract_address = lower('0xb1a5700fA2358173Fe465e6eA4Ff52E36e88E2ad')

and FROM_ADDRESS = lower('0xf7be503166828fe8565c520d66645ac6a06bbdd7')

and ORIGIN_FUNCTION_SIGNATURE = '0xcd9829d9'

and TO_ADDRESS != '0xa4bd562c37c19c569c5b4418d12d35fa9964931f'

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,

17000000000 - 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