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', -365, NOW())GROUP BY token_mint_address),graduated_tokens AS (SELECTdate_time,COUNT(DISTINCT token_address) AS daily_graduated_token_countFROM (SELECTDATE_TRUNC('day', block_date) AS date_time,account_arguments[3] AS token_addressFROM solana.instruction_callsWHERE executing_account = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'AND bytearray_substring(data, 1, 8) IN (0x9beae792ec9ea21e, 0xbbcb121fceedfe29)AND tx_success = trueAND block_slot >= 266793916AND block_date < DATE '2025-03-21'UNION ALLSELECTDATE_TRUNC('day', block_date) AS date_time,account_arguments[2] AS token_addressFROM solana.instruction_callsWHERE executing_account = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'AND bytearray_substring(data, 1, 8) = 0xb712469c946da122AND tx_success = trueAND block_slot < 266793916AND block_date < DATE '2025-03-19'UNION ALLSELECTDATE_TRUNC('day', block_time) AS date_time,account_arguments[3] AS token_addressFROM solana.instruction_callsWHERE executing_account = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'AND bytearray_substring(data, 1, 8) IN (0x9beae792ec9ea21e, 0xbbcb121fceedfe29)AND block_time >= DATE '2025-03-20'AND tx_success = TRUEAND (cardinality(inner_instructions) > 0 OR is_inner = true)) all_gradsGROUP BY date_time),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)