Mrftiyour gas fee
    Updated 7 hours ago
    -- forked from raw-turquoise copy copy copy @ https://flipsidecrypto.xyz/studio/queries/442eff73-2491-413a-b041-01a4ec36b5ed

    WITH address_fees AS (
    SELECT
    from_address,
    SUM(TX_FEE_PRECISE) AS total_fee
    FROM
    monad.testnet.fact_transactions
    GROUP BY
    from_address
    ),
    ranked_fees AS (
    SELECT
    from_address,
    total_fee,
    RANK() OVER (ORDER BY total_fee DESC) AS fee_rank
    FROM
    address_fees
    )
    SELECT
    fee_rank AS "Address Rank",
    total_fee AS "Total Fee"
    FROM
    ranked_fees
    WHERE
    from_address = LOWER('{{Address}}');


    Last run: about 7 hours agoAuto-refreshes every 12 hours
    Address Rank
    Total Fee
    1
    3221891.620569936
    1
    22B
    32s