Query editor
WITH target_day AS (SELECT TRY_CAST(FORMAT('%s-%s-%s',SUBSTRING(CAST({{to_date}} AS VARCHAR), 1, 4),SUBSTRING(CAST({{to_date}} AS VARCHAR), 5, 2),SUBSTRING(CAST({{to_date}} AS VARCHAR), 7, 2)) AS TIMESTAMP) AS snapshot_day),latest_balances_until AS (SELECTtoken_balance_owner,MAX(day) AS last_seen_dayFROM solana_utils.daily_balances, target_dayWHERE token_mint_address = 'J3umBWqhSjd13sag1E1aUojViWvPYA5dFNyqpKuX3WXj'AND day <= snapshot_dayGROUP BY token_balance_owner)SELECT COUNT(*) AS holder_countFROM solana_utils.daily_balances dbJOIN latest_balances_until lbuON db.token_balance_owner = lbu.token_balance_ownerAND db.day = lbu.last_seen_dayWHERE db.token_mint_address = 'J3umBWqhSjd13sag1E1aUojViWvPYA5dFNyqpKuX3WXj'AND db.token_balance > 0;