ETC/ETH Daily Gas Usage Total

gas_used_daily_total.sql

WITH ethereum_total_gas as (
SELECT SUM(gas_used) as eth_sum_gas, 
       TIMESTAMP_TRUNC(timestamp, DAY) as eth_date,
FROM `bigquery-public-data.crypto_ethereum.blocks` 
GROUP BY eth_date),
etc_total_gas as (
SELECT SUM(gas_used) as etc_sum_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_total_gas eth
  LEFT JOIN etc_total_gas etc ON eth.eth_date = etc.etc_date
)
SELECT etc_date as date,
etc_sum_gas AS ETC,
eth_sum_gas AS ETH,
FROM total_transactions_book 
ORDER by etc_date