Query editor
WITH moonshot_tokens AS (SELECTMIN(block_time) AS time,token_mint_address,'Moonshot' AS platformFROM tokens_solana.transfersWHERE action = 'mint'AND outer_executing_account = 'MoonCVVNZFSYkqNXP6bxHLPL6QQJiMagDL3qcqUQTrG'GROUP BY token_mint_address),daily_moonshot_tokens AS (SELECTDATE_TRUNC('day', time) AS date_time,COUNT(*) AS daily_moonshot_tokensFROM moonshot_tokensWHERE DATE_TRUNC('day', time) < CURRENT_DATEGROUP BY DATE_TRUNC('day', time)ORDER BY DATE_TRUNC('day', time) DESC)SELECTdate_time,daily_moonshot_tokens,SUM(daily_moonshot_tokens) OVER (ORDER BY date_time ASC) AS cumulative_moonshot_tokensFROM daily_moonshot_tokensORDER BY date_time DESC;