PS0G1Top10 tokens on Avalanche with the most users
    Updated 2022-11-30
    --credit jacktheguy
    SELECT
    address_name,
    count(DISTINCT ORIGIN_TO_ADDRESS) as Users
    FROM avalanche.core.fact_token_transfers
    LEFT outer JOIN avalanche.core.dim_labels
    ON address = contract_address
    WHERE not address is NULL
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 10
    Run a query to Download Data