MufasaTotal fee on daily basis in 2022
    Updated 2023-01-11
    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
    Run a query to Download Data