DrsimonTop 100 transfers of the whales per AVAX
    Updated 2023-07-03
    SELECT DISTINCT
    SYMBOL,
    FROM_ADDRESS AS "Sender whale Address",
    TO_ADDRESS AS "Receiver whale Address",
    AMOUNT as AMOUNT_AVAX,
    AMOUNT_USD,
    SUM(AMOUNT_USD) AS total_AMOUNT_USD
    FROM
    avalanche.core.ez_token_transfers
    WHERE
    SYMBOL IN ('WAVAX', 'AVAX')
    AND AMOUNT_USD >= 10000000
    and AMOUNT_USD is not null
    GROUP BY
    1,
    2,
    3,
    4,
    5
    ORDER BY
    4 DESC
    LIMIT 100
    Run a query to Download Data