Query editor
-- Bitcoin quantum vulnerability: P2PK supply stratified by block height era-- 21Shares Research | Quantum Vulnerability Monitor---- The ~1.1M BTC Satoshi estimate comes from Sergio Lerner's Patoshi analysis-- (coinbase outputs in blocks 0-36000 matching a specific nonce pattern).-- This query provides a coarser but fully on-chain breakdown by era.---- Era definitions:-- Satoshi era (blocks 0-36,000): Jan 2009 - Dec 2009. Overlaps with Patoshi pattern.-- Early mining (blocks 36,001-200,000): ~Jan 2010 - Sep 2012.-- Post-2012 (blocks 200,001+): Rare — P2PK was largely abandoned by then.SELECTCASEWHEN o.block_height <= 36000 THEN '1. Satoshi era (blocks 0-36K, 2009)'WHEN o.block_height <= 200000 THEN '2. Early mining (blocks 36K-200K, 2010-2012)'ELSE '3. Post-2012 (blocks 200K+)'END AS era,COUNT(*) AS utxo_count,ROUND(SUM(o.value), 4) AS total_btc,ROUND(SUM(o.value) * 68000, 0) AS approx_usd_at_68k,MIN(o.block_height) AS min_block,MAX(o.block_height) AS max_blockFROM bitcoin.outputs oWHERE o.type = 'pubkey'AND NOT EXISTS (SELECT 1FROM bitcoin.inputs iWHERE i.spent_tx_id = o.tx_idAND i.spent_output_number = o.index)GROUP BY 1ORDER BY 1