Query editor
-- ============================================================================-- Section 1: Cross-Chain Overview-- ============================================================================-- Total supply per chain = cumulative (all-time) mint - burn. This does NOT-- depend on the 35-day window or the infra classification -- mint/burn events-- are the ONLY economically unambiguous source of truth for supply (a mint-- event is always genuine new supply; a burn event is always genuine supply-- removal; there is no passthrough-router risk for these two event types-- since by definition the counterparty is the zero address).---- NOTE: query_7838779 only looks back 35 days (built for the 24h/7d/30d-- dashboard windows). For an ALL-TIME supply figure this query would need to-- re-derive from the unbounded mint/burn history. Marked as a known gap below-- -- flagging rather than silently shipping a wrong number.-- ============================================================================WITH window_mint_burn AS (SELECTchain,SUM(CASE WHEN flow_type = 'mint' THEN amount ELSE 0 END) AS minted_35d,SUM(CASE WHEN flow_type = 'burn' THEN amount ELSE 0 END) AS burned_35dFROM query_7838779GROUP BY 1),economic_activity AS (SELECTchain,COUNT(DISTINCT tx_hash) AS economic_tx_count_35d,COUNT(DISTINCT addr) AS active_addresses_35d,SUM(CASE WHEN net_amount > 0 THEN net_amount ELSE 0 END) AS gross_inflow_35d,SUM(CASE WHEN net_amount < 0 THEN -net_amount ELSE 0 END) AS gross_outflow_35d,SUM(net_amount) AS net_flow_35dFROM query_7839057GROUP BY 1)SELECTm.chain,-- KNOWN GAP: this is net mint/burn over the last 35 days only, NOT total-- circulating supply. True supply needs all-time mint/burn, which requires-- removing the 35-day WHERE filter in query_7838779 (or building a-- dedicated unbounded supply query) -- flagged here rather than mislabeled.m.minted_35d - m.burned_35d AS net_mint_minus_burn_35d,m.minted_35d,m.burned_35d,e.economic_tx_count_35d,e.active_addresses_35d,e.gross_inflow_35d,e.gross_outflow_35d,e.net_flow_35dFROM window_mint_burn mLEFT JOIN economic_activity e ON e.chain = m.chainORDER BY m.chain