flipside

    transaction fee in ETH
    SocioCryptotransaction fee in ETH
    Updated 2023-05-20
    SELECT date_Trunc('day',block_timestamp) as date,
    avg(tx_fee) as avg_txn_per_daye, -- average transaction per block
    sum(tx_fee) as sum_tx_fee
    FROM arbitrum.core.fact_transactions
    WHERE date <= CURRENT_DATE-1
    GROUP BY date--, name
    ORDER BY date DESC

    Run a query to Download Data