masoud-mojProtocol transaction count race! copy
    Updated 2023-04-02
    -- forked from 106f27ec-c936-43fa-b3fb-cb49d41a42eb


    SELECT
    rank() over (ORDER BY count (DISTINCT tx_hash) DESC) as rank,
    from_address as address,
    count (DISTINCT tx_hash) as "transaction count"
    FROM
    polygon.core.fact_transactions
    where to_address = '0x68bdee1bf95ad730f379a05eb8c51fb5dfa07748'
    GROUP by address
    order by rank asc


    Run a query to Download Data