flipside

    Arbitrum - Open Analyitics Bounty: Daily Number of Fees
    piperArbitrum - Open Analyitics Bounty: Daily Number of Fees
    Updated 2022-07-26


    SELECT
    block_timestamp::date AS date,
    COUNT(DISTINCT(tx_fee)) AS number_of_fees,
    SUM(number_of_fees) OVER (ORDER BY date ASC) AS cum_fees
    FROM
    arbitrum.core.fact_transactions
    GROUP BY date

    Run a query to Download Data