Mrftiyour tx count
    Updated 2 hours ago
    -- forked from raw-turquoise copy copy @ https://flipsidecrypto.xyz/studio/queries/a7b0e398-d3af-46bc-8c2d-4ae8b2d082a9

    WITH address_tx_counts AS (
    SELECT
    from_address,
    COUNT(DISTINCT tx_hash) AS total_tx
    FROM
    monad.testnet.fact_transactions
    GROUP BY
    from_address
    ),
    ranked_tx_counts AS (
    SELECT
    from_address,
    total_tx,
    RANK() OVER (ORDER BY total_tx DESC) AS tx_rank
    FROM
    address_tx_counts
    )
    SELECT
    tx_rank AS "Address Rank by Tx Count",
    total_tx AS "Total Transactions"
    FROM
    ranked_tx_counts
    WHERE
    from_address = LOWER('{{Address}}');


    Last run: about 2 hours agoAuto-refreshes every 12 hours
    Address Rank by Tx Count
    Total Transactions
    1
    511079101
    1
    14B
    57s