Query editor
-- ============================================================-- ETHEREUM PNL — FLAT FORMAT (for charts)-- Parameter: {{quarter}} → enum: month, quarter, year-- ============================================================WITH fees AS (SELECTdate_trunc('quarter', block_time) AS period,COUNT(*) AS tx_count,SUM(tx_fee) AS fees_native,SUM(CASEWHEN block_number >= 12965000 THENCOALESCE(element_at(tx_fee_breakdown, 'base_fee'), 0)+ COALESCE(element_at(tx_fee_breakdown, 'blob_fee'), 0)ELSE 0END) AS fee_burn_native,SUM(CASEWHEN block_number >= 12965000 THENCOALESCE(element_at(tx_fee_breakdown, 'priority_fee'), 0)ELSE tx_feeEND) AS priority_fee_native,SUM(tx_fee_usd) AS fees_usdFROM gas.feesWHERE blockchain = 'ethereum'GROUP BY 1),pow_issuance AS (SELECTdate_trunc('{{quarter}}', time) AS period,COUNT(*) AS block_count,SUM(CASEWHEN number < 4370000 THEN 5.0WHEN number < 7280000 THEN 3.0ELSE 2.0END) AS issuance_nativeFROM ethereum.blocksWHERE number < 15537394GROUP BY 1),pos_issuance AS (SELECTdate_trunc('{{quarter}}', block_date) AS period,SUM(reward_change) / 1e9 AS issuance_nativeFROM beacon.validator_day_summariesWHERE reward_change / 1e9 BETWEEN -1 AND 1GROUP BY 1),issuance AS (SELECTCOALESCE(pow.period, pos.period) AS period,COALESCE(pow.block_count, 0) AS block_count,COALESCE(pow.issuance_native, 0)