Query editor
-- ============================================================================-- cbBTC All-Time Circulating Supply by Chain (EVM + Solana)-- ============================================================================-- EVM side: tokens.transfers spell, mint/burn via zero-address convention.-- Solana side: tokens_solana.transfers spell, native action='mint'/'burn'-- classification (more reliable than reconstructing from owner addresses).---- Cost note: full-history scan per chain. Run as a scheduled materialized-- view rather than on every page load.-- ============================================================================WITH cbbtc_contracts AS (SELECT contract_address, chainFROM (VALUES('0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf', 'ethereum'),('0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf', 'base'),('0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf', 'arbitrum'),('0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf', 'monad')) AS t(contract_address, chain)),evm_mint_burn 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 cbbtc_contracts cON t.blockchain = c.chainAND t.contract_address = from_hex(c.contract_address)WHERE (t."from" = 0x0000000000000000000000000000000000000000OR t."to" = 0x0000000000000000000000000000000000000000)GROUP BY 1),solana_mint_burn 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'))SELECT chain, total_minted, total_burned, total_minted - total_burned AS circulating_supplyFROM evm_mint_burnUNION ALLSELECT chain, total_minted, total_burned, total_minted - total_burned AS circulating_supplyFROM solana_mint_burnORDER BY circulating_supply DESC