Query editor
-- ENS | Monthly Protocol Revenue-- Cash basis: fees collected in each period × monthly avg ETH price for USD-- Revenue ETH = actual protocol fees received-- Revenue USD = Revenue ETH × monthly avg ETH/USD market price-- Controllers 1-5 | Proportional batch fix for C4 Dec 2024 - Sep 2025-- Window: all-time through last completed monthWITHraw_registrations AS (SELECT evt_block_time, CAST(cost AS DOUBLE) / 1e18 AS eth_feeFROM ethereumnameservice_ethereum.ETHRegistrarController_1_evt_NameRegisteredUNION ALLSELECT evt_block_time, CAST(cost AS DOUBLE) / 1e18FROM ethereumnameservice_ethereum.ETHRegistrarController_2_evt_NameRegisteredUNION ALLSELECT evt_block_time, CAST(cost AS DOUBLE) / 1e18FROM ethereumnameservice_ethereum.ETHRegistrarController_3_evt_NameRegisteredUNION ALLSELECT evt_block_time, (CAST(baseCost AS DOUBLE) + CAST(premium AS DOUBLE)) / 1e18FROM ethereumnameservice_ethereum.ETHRegistrarController_4_evt_NameRegisteredUNION ALLSELECT evt_block_time, (CAST(baseCost AS DOUBLE) + CAST(premium AS DOUBLE)) / 1e18FROM ethereumnameservice_ethereum.ETHRegistrarController_5_evt_NameRegistered),c123_renewals AS (SELECT evt_block_time, CAST(cost AS DOUBLE) / 1e18 AS eth_feeFROM ethereumnameservice_ethereum.ETHRegistrarController_1_evt_NameRenewedUNION ALLSELECT evt_block_time, CAST(cost AS DOUBLE) / 1e18FROM ethereumnameservice_ethereum.ETHRegistrarController_2_evt_NameRenewedUNION ALLSELECT evt_block_time, CAST(cost AS DOUBLE) / 1e18FROM ethereumnameservice_ethereum.ETHRegistrarController_3_evt_NameRenewedUNION ALLSELECT evt_block_time, CAST(cost AS DOUBLE) / 1e18FROM ethereumnameservice_ethereum.ETHRegistrarController_5_evt_NameRenewed),c4_raw AS (SELECT evt_block_time, CAST(cost AS DOUBLE) / 1e18 AS cost_eth, evt_tx_hashFROM ethereumnameservice_ethereum.ETHRegistrarController_4_evt_NameRenewed),-- Proportional batch fix: allocates tx.value to each renewal by its cost ratio-- Corrects C4 batch contract bug (0x78fe5b...790b2) Dec 2024 - Sep 2025 only-- Post-Oct 2025 batch contracts verified clean (ratio ~1.02, not 4000x)batch_tx_values AS (SELECT hash, CAST(value AS DOUBLE) / 1e18 AS tx_ethFROM ethereum.transactionsWHERE "to" = 0x78fe5b15685555ec0972272b826cd8e7ff8790b2AND block_time >= TIMESTAMP '2024-12-01'AND block_time < TIMESTAMP '2025-10-01'),batch_tx_cost_sum AS (SELECT r.evt_tx_hash, SUM(r.cost_eth) AS total_cost_ethFROM c4_raw rWHERE r.evt_tx_hash IN (SELECT hash FROM batch_tx_values)