Query editor
WITH pumpdotfun_tokens AS (SELECTMIN(block_time) AS time,token_mint_addressFROM tokens_solana.transfersWHERE action = 'mint'AND outer_executing_account = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'AND block_time >= DATE_ADD('day', -220, NOW())GROUP BY token_mint_address),daily_tokens AS (SELECTDATE_TRUNC('day', time) AS date_time,COUNT(*) AS daily_token_count,'Pumpdotfun' AS platformFROM pumpdotfun_tokensGROUP BY DATE_TRUNC('day', time))SELECTdate_time,platform,daily_token_count,SUM(daily_token_count) OVER (PARTITION BY platform ORDER BY date_time ASC) AS cumulative_token_countFROM daily_tokensWHERE date_time >= DATE_ADD('day', -220, NOW())ORDER BY date_time DESC, platform ASC;