-- 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