Query editor
-- ============================================================-- BITCOIN PNL — FLAT FORMAT (for charts)-- Parameter: {{period}} → enum: month, quarter, year-- ============================================================WITH base AS (SELECTdate_trunc('{{period}}', date) AS period,COUNT(*) AS block_count,SUM(transaction_count) AS tx_count,SUM(total_fees) AS fees_native,0.0 AS fee_burn_native,SUM(mint_reward) AS issuance_native,SUM(total_reward) AS miner_revenue_nativeFROM bitcoin.blocksGROUP BY 1),price AS (SELECTdate_trunc('{{period}}', minute) AS period,AVG(price) AS avg_price_usd,MIN_BY(price, minute) AS open_price,MAX_BY(price, minute) AS close_priceFROM prices.usdWHERE blockchain IS NULLAND symbol = 'BTC'GROUP BY 1),with_supply AS (SELECTb.*,SUM(b.issuance_native) OVER (ORDER BY b.periodROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS circulating_supplyFROM base b)SELECT'Bitcoin' AS network,s.period,s.block_count,s.tx_count,-- PnL natives.fees_native,s.fee_burn_native,s.issuance_native,s.issuance_native - s.fee_burn_native AS net_emission_native,s.fees_native - s.issuance_native AS net_earnings_native,-- PnL USDp.avg_price_usd,s.fees_native * p.avg_price_usd AS fees_usd,s.issuance_native * p.avg_price_usd AS issuance_usd,(s.fees_native - s.issuance_native)* p.avg_price_usd AS net_earnings_usd,