ELAYAverage amount of transactions fee in contracts
    Updated 2022-10-25
    with metapool as ( select avg(transaction_fee/10e17),date_trunc('day', block_timestamp)
    from near.core.fact_transactions
    where date_trunc('day', block_timestamp) > current_date - 90
    and tx_receiver='meta-pool.near'
    group by date_trunc('day', block_timestamp))
    ,contractmainburrow as (select avg(transaction_fee/10e17),date_trunc('day', block_timestamp)
    from near.core.fact_transactions
    where date_trunc('day', block_timestamp) > current_date - 90
    and tx_receiver='contract.main.burrow.near'
    group by date_trunc('day', block_timestamp) )

    select 'meta-pool.near' , *
    from metapool
    UNION ALL
    select 'contract.main.burrow.near' , *
    from contractmainburrow
    Run a query to Download Data