princefarzamSolana transaction Fees (For true and false transactions)
    Updated 2022-05-03
    SELECT DISTINCT
    'total fees for transactions',
    (SELECT
    SUM(fee)/POW(10,9)
    FROM
    solana.transactions
    WHERE
    block_timestamp >= '2022-01-01'
    AND succeeded='TRUE'
    ) AS total_fees_for_true_tx,
    (SELECT
    SUM(fee)/POW(10,9)
    FROM
    solana.transactions
    WHERE
    block_timestamp >= '2022-01-01'
    AND succeeded='FALSE'
    ) AS total_fees_for_false_tx
    FROM solana.transactions
    Run a query to Download Data