Gas Fees By Specific Date

gas_fees_by_specific_date.sql

WITH block_book AS (
  SELECT b.number,
  FROM `bigquery-public-data.crypto_ethereum_classic.blocks` b
  WHERE DATE(timestamp) = "2020-01-05"
),
transactions_by_block AS (
SELECT t.block_number, t.hash, t.gas, t.gas_price, t.receipt_gas_used,  t.receipt_cumulative_gas_used
FROM `bigquery-public-data.crypto_ethereum_classic.transactions` t
)
SELECT t.block_number, SUM((t.receipt_gas_used/1000000000) * (t.gas_price / 1000000000)) as total_fees from transactions_by_block t JOIN block_book b on t.block_number = b.number 
group by t.block_number
order by t.block_number