Query editor
WITH new_tokens_solana as (SELECTtoken_mint_address,MIN(block_time) as birth_dateFROM tokens_solana.transfers-- WHERE action = 'mint'-- and outer_executing_account = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'WHERE outer_executing_account = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'GROUP BY 1)SELECTdate_trunc('day',block_time) as date_time,COUNT(DISTINCT(tx_signer)) as total_addresses_creating,COUNT(DISTINCT(tr.token_mint_address)) as total_tokens_launched,SUM(COUNT(DISTINCT(tr.token_mint_address))) OVER (ORDER BY date_trunc('day',block_time)) as cumulative_tokensFROM tokens_solana.transfers trINNER JOIN new_tokens_solana nON n.token_mint_address = tr.token_mint_addressAND tr.block_time = birth_dateWHERE DATE('2024-02-01') < DATE(block_time)GROUP BY 1ORDER BY 1 DESC