Query editor
WITH base_pools AS (SELECT * FROM query_6710433),first_balance_day AS (SELECTaddress AS creator_wallet,MIN(CAST(day AS DATE)) AS first_dayFROM solana_utils.daily_balancesWHERE address IN (SELECT DISTINCT creator_signer FROM base_pools)AND day <= CAST((SELECT MAX(analysis_date) FROM base_pools) AS TIMESTAMP)GROUP BY address),first_funding AS (SELECT *FROM (SELECTt.to_owner,t.block_time,t.from_owner,t.amount_display,t.tx_id,ROW_NUMBER() OVER (PARTITION BY t.to_ownerORDER BY t.block_time ASC) as rnFROM tokens_solana.transfers tJOIN first_balance_day fbdON t.to_owner = fbd.creator_walletAND t.block_date = fbd.first_dayWHERE t.token_version = 'native'AND t.token_mint_address = 'So11111111111111111111111111111111111111111')WHERE rn = 1)SELECTbp.pool_address,bp.creator_signer,bp.dex,bp.pool_type,bp.token_a,bp.token_b,bp.vault_a,bp.vault_b,bp.created_at AS pool_creation_time,bp.analysis_date,fbd.first_day AS wallet_first_day,ff.block_time AS wallet_funding_time,ff.from_owner AS wallet_funder,ff.amount_display AS wallet_funding_sol,ff.tx_id AS wallet_funding_tx,CASEWHEN ff.from_owner IS NOT NULL THEN '🔍 HAS FUNDER'ELSE '❌ NO FUNDER'END AS funding_status,