select
date_trunc('day', block_timestamp) as day,
count(distinct tx_to) as holders,
sum(holders) over (order by day asc) as cumulative_holders
from solana.core.fact_transfers
where 1 = 1
and block_timestamp > '2022-12-24'
and mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
and (
tx_from = '9AhKqLR67hwapvG8SA2JFXaCshXc9nALJjpKaHZrsbkw' or
tx_from = '6JZoszTBzkGsskbheswiS6z2LRGckyFY4SpEGiLZqA9p'
)
group by day
order by day desc