select block_timestamp,

tx_to as address

from

solana.core.fact_transfers

where tx_from in (

'9AhKqLR67hwapvG8SA2JFXaCshXc9nALJjpKaHZrsbkw',

and mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

and block_timestamp > '2022-12-24')

select

block_timestamp::date as date,

count(distinct(address)) as airdrop_address,

sum(airdrop_address) over (order by date asc) as cumulative_airdrop_addresses

from airdrop_tx

group by date

order by date desc