lj1024Prio fees
    Updated 2024-01-04
    SELECT
    floor(block_id / 432000) epoch,
    sum(fee - 5000 * ARRAY_SIZE(signers)) / 1e9 prio_fees
    FROM
    solana.core.fact_transactions
    WHERE
    SUCCEEDED = TRUE
    AND floor(block_id / 432000) > 530
    group by floor(block_id / 432000)
    order by floor(block_id / 432000) desc
    QueryRunArchived: QueryRun has been archived