ETC/ETH Daily Gas Usage Average

gas_used_daily_avg.sql

WITH ethereum_avg_gas as (
SELECT AVG(gas_used) as eth_avg_gas, 
       TIMESTAMP_TRUNC(timestamp, DAY) as eth_date,
FROM `bigquery-public-data.crypto_ethereum.blocks` 
GROUP BY eth_date),
etc_avg_gas as (
SELECT AVG(gas_used) as etc_avg_gas, 
       TIMESTAMP_TRUNC(timestamp, DAY) as etc_date,
FROM `bigquery-public-data.crypto_ethereum_classic.blocks` 
GROUP BY etc_date),
total_transactions_book AS (
  SELECT *
  FROM ethereum_avg_gas eth
  LEFT JOIN etc_avg_gas etc ON eth.eth_date = etc.etc_date
)
SELECT etc_date as date,
etc_avg_gas AS ETC,
eth_avg_gas AS ETH,
FROM total_transactions_book 
ORDER by etc_date