Query editor
-- Fees & revenue: compute on full history; visualize last 12 months-- 632WITH-- ────────────────────────────-- Calendar of daily dates-- ────────────────────────────time AS (WITH time_seq AS (SELECT sequence(CAST('2021-03-01 00:00' AS TIMESTAMP),date_trunc('day', CAST(now() AS TIMESTAMP)),INTERVAL '1' day) AS time)SELECT t.timeFROM time_seqCROSS JOIN UNNEST(time) AS t(time)),-- ────────────────────────────-- Per-network daily fee USD-- ────────────────────────────eth_fee AS (SELECTtime,CAST(gas_price AS DOUBLE) * CAST(gas_used AS DOUBLE) * p.price / POWER(10, p.decimals) AS tx_fee_usd,'Ethereum' AS networkFROM (SELECT date_trunc('day', block_time) AS time, gas_price, gas_usedFROM ethereum.transactionsWHERE ("from" = 0x942f9ce5d9a33a82f88d233aeb3292e680230348 OR "from" = 0xcfafc6bdd1b92e510d5409ee460bb1a712165aa8)AND block_time > CAST('2021-03-01 00:00:00' AS TIMESTAMP)) xLEFT JOIN prices.usd pON x.time = p.minuteAND p.blockchain = 'ethereum'AND p.symbol = 'WETH'),op_fee AS (SELECTtime,(CAST(gas_price AS DOUBLE) * CAST(gas_used AS DOUBLE) + CAST(l1_fee AS DOUBLE)) * p.price / POWER(10, p.decimals) AS tx_fee_usd,'Optimism' AS networkFROM (SELECT date_trunc('day', block_time) AS time, gas_price, gas_used, l1_feeFROM optimism.transactionsWHERE ("from" = 0x942f9ce5d9a33a82f88d233aeb3292e680230348 OR "from" = 0xcfafc6bdd1b92e510d5409ee460bb1a712165aa8)AND block_time > CAST('2021-03-01 00:00:00' AS TIMESTAMP)) xLEFT JOIN prices.usd pON x.time = p.minuteAND p.blockchain = 'ethereum'AND p.symbol = 'WETH'),arb_fee AS (SELECTtime,