SocioCryptoGNOSIS TX_fee
    Updated 2022-07-30
    SELECT date_trunc('day',block_timestamp) as date,
    sum(tx_fee) as fee,
    sum(fee) over(ORDER BY date) as cumulative_fee,
    avg(tx_fee) as daily_avg_fee,
    count(*) as n_txns
    FROM gnosis.core.fact_transactions
    WHERE date >= '2022-01-01'
    GROUP BY date
    ORDER BY date DESC


    Run a query to Download Data