Query editor
WITH date_series AS (SELECTCAST(date_column as date) as dayFROM(VALUESsequence(cast('2025-01-22' as date),cast(date_trunc('day', current_timestamp) as date),interval '1' day)) AS t1(date_array)CROSS JOIN unnest(date_array) AS t2(date_column)),addresses as (select distinct token_balance_owner from solana_utils.daily_balanceswhere token_mint_address = '6NcdiK8B5KK2DzKvzvCfqi8EHaEqu48fyEzC8Mm9pump'),date_series_addresses as (select * from addresses join date_series on 1=1),carry_over_balances as (SELECT ds.day, ds.token_balance_owner, --date_trunc('day', db.day) AS truncated_day,coalesce(db.token_balance, LAG(db.token_balance, 1) IGNORE NULLS OVER (PARTITION BY ds.token_balance_owner ORDER BY ds.day)) as balancefrom date_series_addresses dsLEFT JOIN solana_utils.daily_balances db ON ds.day = db.day and ds.token_balance_owner = db.token_balance_ownerand db.token_mint_address = '6NcdiK8B5KK2DzKvzvCfqi8EHaEqu48fyEzC8Mm9pump')select day, count(distinct token_balance_owner) as holdersfrom carry_over_balanceswhere balance is not null and balance != 0group by dayorder by day asc