Query editor
-- ============================================================================-- cbBTC Cross-Chain Overview: Supply, Flows, Rankings (Fully Self-Contained)-- ============================================================================-- Inlines the full EVM + Solana dependency chain. Designed to be materialized-- as result_cbbtc_dashboard_overview with a daily refresh.---- Type handling: EVM addresses are varbinary (hex); Solana are varchar (base58).-- To UNION them cleanly, EVM addresses are cast to varchar via CAST() in the-- raw transfer CTEs before the chains are merged.---- Methodology:-- Supply = all-time cumulative mint - burn (zero-address on EVM; native-- action='mint'/'burn' on Solana). Not windowed.-- Flow = 35-day rolling window, same-tx netted + infra exclusion-- (turnover_ratio >= 50 AND n_distinct_txs >= 20 AND-- is_smart_contract=true for EVM, behavioral-only for Solana).-- ============================================================================-- ── 1. EVM CONTRACT MAP ────────────────────────────────────────────────────WITH evm_contracts AS (SELECT contract_address, chain FROM (VALUES('0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf', 'ethereum'),('0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf', 'base'),('0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf', 'arbitrum'),('0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf', 'monad')) AS t(contract_address, chain)),-- ── 2. EVM ALL-TIME SUPPLY ────────────────────────────────────────────────evm_supply AS (SELECTt.blockchain AS chain,SUM(CASE WHEN t."from" = 0x0000000000000000000000000000000000000000 THEN t.amount ELSE 0 END) AS total_minted,SUM(CASE WHEN t."to" = 0x0000000000000000000000000000000000000000 THEN t.amount ELSE 0 END) AS total_burnedFROM tokens.transfers tINNER JOIN evm_contracts cON t.blockchain = c.chainAND t.contract_address = from_hex(c.contract_address)WHERE (t."from" = 0x0000000000000000000000000000000000000000OR t."to" = 0x0000000000000000000000000000000000000000)GROUP BY 1),-- ── 3. SOLANA ALL-TIME SUPPLY ─────────────────────────────────────────────solana_supply AS (SELECT'solana' AS chain,SUM(CASE WHEN action = 'mint' THEN amount_display ELSE 0 END) AS total_minted,SUM(CASE WHEN action = 'burn' THEN amount_display ELSE 0 END) AS total_burnedFROM tokens_solana.transfersWHERE token_mint_address = 'cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij'AND action IN ('mint', 'burn')),-- ── 4. ALL-CHAIN SUPPLY ───────────────────────────────────────────────────all_supply AS (SELECT chain, total_minted, total_burned, total_minted - total_burned AS circulating_supplyFROM evm_supplyUNION ALL