Query editor
WITH base_pools AS (SELECT * FROM query_6710433),-- 1️⃣ Первый день появления кошелька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),-- 2️⃣ Первый native funding + технические поляfirst_funding AS (SELECT *FROM (SELECTt.to_owner,t.block_time,t.from_owner,t.amount_display,t.tx_id,-- 🔥 ДОБАВЛЯЕМ ПОЛЯ ДЛЯ КЛАСТЕРИЗАЦИИt.tx_signer,t.outer_executing_account,t.inner_instruction_index,t.outer_instruction_index,t.token_version,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)-- 3️⃣ Финальный слой pool_entitiesSELECTbp.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,