Query editor
-- ============================================================-- ETHEREUM INCOME STATEMENT — SIMPLIFIED-- Reads from saved chart query, formats for table display-- ============================================================WITH metrics AS (SELECT*,ROW_NUMBER() OVER (ORDER BY period DESC) AS pnFROM query_7615358),recent AS (SELECT * FROM metrics WHERE pn <= 16)SELECTperiod,-- RevenueROUND(fees_native, 2) AS total_fees_eth,ROUND(fee_burn_native, 2) AS fee_burn_eth,ROUND(fees_native - fee_burn_native, 2) AS net_revenue_eth,-- Revenue USDCAST(ROUND(fees_native * avg_price_usd, 0) AS BIGINT) AS fees_usd,CAST(ROUND(fee_burn_native * avg_price_usd, 0) AS BIGINT) AS fee_burn_usd,CAST(ROUND((fees_native - fee_burn_native) * avg_price_usd, 0) AS BIGINT) AS net_revenue_usd,-- CostsROUND(issuance_native, 2) AS issuance_eth,CAST(ROUND(issuance_usd, 0) AS BIGINT) AS issuance_usd,-- Supply impactROUND(net_emission_native, 2) AS net_emission_eth,-- Net earningsROUND(net_earnings_native, 2) AS net_earnings_eth,CAST(ROUND(net_earnings_usd, 0) AS BIGINT) AS net_earnings_usd,-- Contexttx_count,ROUND(avg_fee_per_tx_native, 6) AS avg_fee_per_tx_eth,CAST(ROUND(avg_price_usd, 0) AS BIGINT) AS avg_eth_price_usdFROM recentORDER BY period DESC