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