Query editor
WITH new_tokens AS (SELECTtoken_mint_address,MIN(block_time) AS birth_dateFROMtokens_solana.transfersWHEREaction = 'mint'AND outer_executing_account <> '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'GROUP BYtoken_mint_address),new_pump_tokens AS (SELECTtoken_mint_address,MIN(block_time) AS birth_dateFROMtokens_solana.transfersWHEREaction = 'mint'AND outer_executing_account = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'GROUP BYtoken_mint_address),daily_tokens AS (SELECTDATE_TRUNC('day', birth_date) AS date_time,COUNT(*) AS daily_tokensFROMnew_tokensGROUP BYDATE_TRUNC('day', birth_date)),daily_pump_tokens AS (SELECTDATE_TRUNC('day', birth_date) AS date_time,COUNT(*) AS daily_pump_tokensFROMnew_pump_tokensGROUP BYDATE_TRUNC('day', birth_date))SELECTall_dates.date_time,COALESCE(d.daily_tokens, 0) AS daily_tokens,COALESCE(p.daily_pump_tokens, 0) AS daily_pump_tokens,COALESCE(SUM(d.daily_tokens) OVER (ORDER BY all_dates.date_time), 0) AS total_tokens,COALESCE(SUM(p.daily_pump_tokens) OVER (ORDER BY all_dates.date_time), 0) AS total_tokens_from_pumpFROM(SELECT date_time FROM daily_tokensUNIONSELECT date_time FROM daily_pump_tokens) AS all_datesLEFT JOINdaily_tokens d ON all_dates.date_time = d.date_timeLEFT JOINdaily_pump_tokens p ON all_dates.date_time = p.date_timeWHEREall_dates.date_time >= CAST('2024-01-14' AS DATE)ORDER BYall_dates.date_time DESC;