Query editor
-- ============================================================================-- Section 2: Chain Inflow and Outflow Dashboard (EVM + Solana)-- ============================================================================-- | Chain | Current Supply | Inflow | Outflow | Net Flow | Supply Change % |-- Current Supply: all-time mint-burn (query_7839079, now covers Solana too).-- Inflow/Outflow: unioned economic net flow models, EVM (query_7839057) +-- Solana (query_7839520), both same-tx-netted and infra-excluded using the-- same turnover_ratio >= 50 / n_distinct_txs >= 20 threshold.-- ============================================================================WITH supply AS (SELECT chain, circulating_supply FROM query_7839079),unioned_flow AS (SELECT chain, net_amount FROM query_7839057UNION ALLSELECT chain, net_amount FROM query_7839520),window_flow AS (SELECTchain,SUM(CASE WHEN net_amount > 0 THEN net_amount ELSE 0 END) AS inflow,SUM(CASE WHEN net_amount < 0 THEN -net_amount ELSE 0 END) AS outflow,SUM(net_amount) AS net_flowFROM unioned_flowGROUP BY 1)SELECTs.chain,s.circulating_supply AS current_supply,COALESCE(w.inflow, 0) AS inflow_35d,COALESCE(w.outflow, 0) AS outflow_35d,COALESCE(w.net_flow, 0) AS net_flow_35d,ROUND(100.0 * COALESCE(w.net_flow, 0) / NULLIF(s.circulating_supply, 0), 2) AS supply_change_pct_35dFROM supply sLEFT JOIN window_flow w ON w.chain = s.chainORDER BY s.circulating_supply DESC