princefarzamSolana transaction Fees (For all transactions)
    Updated 2022-05-03
    with daily_fees as(
    SELECT
    date_trunc('day', block_timestamp) AS day,
    SUM(fee)/POW(10,9) AS total_fees_per_day
    FROM
    solana.transactions
    WHERE
    day >= '2022-01-01'
    GROUP BY day
    ORDER BY day ASC
    )
    SELECT
    day,
    SUM(total_fees_per_day) over(ORDER BY day ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as CUM_DAYLY_FEES
    FROM daily_fees

    Run a query to Download Data