Query editor
WITH pool_entities AS (SELECT * FROM query_6726649),enriched AS (SELECTpe.*,CASE WHEN ca.address IS NOT NULL THEN 1 ELSE 0 END AS is_cex,CASEWHEN pe.funding_type = '🟡 PROGRAM_CPI_TRANSFER' THEN 1ELSE 0END AS is_program_cpi,DATE_DIFF('day', pe.wallet_first_day, pe.pool_creation_time)AS wallet_age_daysFROM pool_entities peLEFT JOIN cex_solana.addresses caON ca.address = pe.wallet_funderAND ca.blockchain = 'solana'),-- 2️⃣ Группировка по fundercluster_summary AS (SELECTwallet_funder AS cluster_id,COUNT(DISTINCT creator_signer) AS cluster_size,COUNT(DISTINCT pool_address) AS pools_created,SUM(wallet_funding_sol) AS total_sol_funded,MIN(wallet_funding_time) AS first_funding_time,MAX(wallet_funding_time) AS last_funding_time,MIN(wallet_age_days) AS min_wallet_age_days,MAX(wallet_age_days) AS max_wallet_age_days,MIN(funding_lag_days) AS min_funding_lag_days,MAX(funding_lag_days) AS max_funding_lag_days,MAX(is_cex) AS is_cex,MAX(is_program_cpi) AS has_program_cpiFROM enrichedWHERE wallet_funder IS NOT NULLGROUP BY wallet_funder)-- 3️⃣ Финальный скорингSELECTcs.cluster_id,cs.cluster_size,cs.pools_created,cs.total_sol_funded,cs.first_funding_time,cs.last_funding_time,cs.min_wallet_age_days,cs.max_wallet_age_days,