KuramaOA-AVAX-10: Open Analytics Bounty: Avalanche (August 22)
    Updated 2022-08-26
    -- filtered after 2022-05-01 since avax data before seems odd.

    with table_avax as (select date_trunc('hour', block_timestamp) as date, sum(tx_count) as total_tx_count from avalanche.core.fact_blocks
    where to_date(block_timestamp) between current_date - 14 and current_date
    group by date),

    avax_average as (select avg(total_tx_count) as avax_average_tx from table_avax )

    select a.date, a.total_tx_count as avax_total_tx_count, b.avax_average_tx from table_avax a
    join avax_average b
    Run a query to Download Data