Query editor
WITH eth_supply AS (SELECT 120215297 - SUM(eb.base_fee_per_gas*et.gas_used/POWER(10, 18))AS eth_supplyFROM ethereum.transactions etINNER JOIN ethereum.blocks eb ON eb.number = et.block_numberAND eb.time >= CAST('2023-08-31' AS date)WHERE et.block_time >= CAST('2023-08-31' AS date)), latest_eth_price AS (SELECT price AS eth_priceFROM prices.usdWHERE symbol = 'ETH'ORDER BY minute DESCLIMIT 1)SELECT (eth_supply * eth_price) / CAST(1e9 AS DOUBLE) AS eth_mcapFROM eth_supply, latest_eth_price