Query editor
-- ============================================================================-- cbBTC Protocol Address Labels -- SEED TABLE, NEEDS ADDRESS VERIFICATION-- ============================================================================-- Purpose: maps known protocol/contract addresses interacting with cbBTC to a-- human-readable label, category, and chain. This is the table Section 5/6/7-- joins against to turn raw addresses into "Aave", "Morpho", "Aerodrome", etc.---- STATUS: this pass only confirms WHICH protocols support cbBTC and on WHICH-- chains, sourced from Coinbase's launch announcement and follow-up coverage-- (Aerodrome, Curve, Aave, Compound, Morpho, Sky/Maker, deBridge, Maple, Spark,-- Moonwell). It does NOT yet contain verified onchain contract addresses ---- those placeholders are marked 'TODO_VERIFY' and must be replaced with actual-- pool/market contract addresses pulled from each protocol's own deployment-- docs or via Dune's searchTablesByContractAddress before this table is joined-- into any flow query. Shipping placeholder addresses into a flow table would-- silently produce zero matches and look like "no protocol activity" -- worse-- than not having the table at all.---- Maintenance: add a row per (protocol, chain, contract_address). Keep-- 'category' values consistent: lending | dex | bridge | vault | yield |-- custodian | other.-- ============================================================================SELECT * FROM (VALUES('TODO_VERIFY', 'aave', 'lending', 'base', 'Aave v3 cbBTC market on Base'),('TODO_VERIFY', 'aave', 'lending', 'ethereum', 'Aave v3 cbBTC market on Ethereum'),('TODO_VERIFY', 'compound', 'lending', 'base', 'Compound v3 cbBTC market'),('TODO_VERIFY', 'morpho', 'lending', 'base', 'Morpho cbBTC vaults/markets'),('TODO_VERIFY', 'morpho', 'lending', 'ethereum', 'Morpho cbBTC vaults/markets'),('TODO_VERIFY', 'spark', 'lending', 'base', 'Spark Protocol cbBTC collateral'),('TODO_VERIFY', 'sky_maker', 'lending', 'ethereum', 'Sky (fka MakerDAO) cbBTC collateral'),('TODO_VERIFY', 'moonwell', 'lending', 'base', 'Moonwell cbBTC market'),('TODO_VERIFY', 'aerodrome', 'dex', 'base', 'Aerodrome cbBTC liquidity pools'),('TODO_VERIFY', 'curve', 'dex', 'ethereum', 'Curve cbBTC pools'),('TODO_VERIFY', 'curve', 'dex', 'base', 'Curve cbBTC pools'),('TODO_VERIFY', 'debridge', 'bridge', 'multichain', 'deBridge cross-chain swaps for cbBTC'),('TODO_VERIFY', 'maple', 'yield', 'ethereum', 'Maple Finance RWA/cbBTC product')) AS t(contract_address, protocol_name, category, chain, notes)