with final_data as (
select *
from (
select to_date(block_timestamp) as date,
sum(gas_used/1e12) as gas_volume,
sum(transaction_fee/1e18) as txn_fee_volume
from near.core.fact_transactions
where date >= '2022-01-01'
and date <= '2022-12-31'
group by date
)
)
select * from final_data