Query editor
WITH chain_revenue AS (SELECTday,SUM(CASE WHEN symbol = 'CELO' THEN tx_fee_token ELSE 0 END) as fee_CELO,SUM(CASE WHEN symbol = 'USD₮' THEN tx_fee_token ELSE 0 END) as fee_USDT,SUM(CASE WHEN symbol = 'USDm' THEN tx_fee_token ELSE 0 END) as fee_USDm,SUM(CASE WHEN symbol = 'EURm' THEN tx_fee_token ELSE 0 END) as fee_EURm,SUM(CASE WHEN symbol = 'USDC' THEN tx_fee_token ELSE 0 END) as fee_USDC,-- omitting others, as summing them up makes no senseSUM(CASE WHEN symbol = 'CELO' THEN tx_fee_token * token_price_USD ELSE 0 END) as fee_CELO_usd,SUM(CASE WHEN symbol = 'USD₮' THEN tx_fee_token * token_price_USD ELSE 0 END) as fee_USDT_usd,SUM(CASE WHEN symbol = 'USDm' THEN tx_fee_token * token_price_USD ELSE 0 END) as fee_USDm_usd,SUM(CASE WHEN symbol = 'EURm' THEN tx_fee_token * token_price_USD ELSE 0 END) as fee_EURm_usd,SUM(CASE WHEN symbol = 'USDC' THEN tx_fee_token * token_price_USD ELSE 0 END) as fee_USDC_usd,-- COPm excluded: the Dune price feed for it is wrong by ~3 orders of magnitude-- (~$0.90 per COPm vs the real Colombian-peso peg of ~$0.00024), which inflated-- others_usd by thousands of dollars. Real COPm fee revenue is well under $1/day.SUM(CASE WHEN symbol NOT IN ('CELO', 'USD₮', 'USDm', 'EURm', 'USDC', 'COPm') THEN tx_fee_token * token_price_USD ELSE 0 END) as others_usdFROM query_6898180GROUP BY day)SELECT * FROM chain_revenueLEFT JOIN (SELECT day, batcher_cost_eth, proposer_cost_eth, challenger_cost_ethFROM query_6898212) USING (day)LEFT JOIN (-- query_6898371 returns one row per EigenDA payment event. Summing per day-- keeps a day with several payments (2025-09-10 has three) as a single row;-- joined unaggregated it repeated that day's revenue once per payment.SELECT day, SUM(onDemandPayment) / 1e18 AS EigenDA_cost_ethFROM query_6898371GROUP BY day) USING (day)LEFT JOIN (SELECTtimestamp as day,price as eth_price_usdFROM prices.dayWHERE blockchain = 'ethereum'AND contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 -- WETH) USING (day)ORDER BY day