select distinct tx_to as address, * from

solana.core.fact_transfers

where tx_from in (

'9AhKqLR67hwapvG8SA2JFXaCshXc9nALJjpKaHZrsbkw',

'6JZoszTBzkGsskbheswiS6z2LRGckyFY4SpEGiLZqA9p')

and mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

and block_timestamp > '2022-12-24'

select

date_trunc('{{date_range}}',block_timestamp) as date,

count(distinct address) as n_holders,

sum(n_holders) over (order by date asc rows between unbounded preceding and current row) as total_n_holders

from airdrop_txns

group by date

order by date desc