Drsimonwhale watching...(AVAX)
    Updated 2023-08-04
    WITH whales AS (
    SELECT
    DATE_TRUNC('{{Time_frame}}', BLOCK_TIMESTAMP) AS DATE,
    SYMBOL,
    FROM_ADDRESS AS "Sender whale Address",
    TO_ADDRESS AS "Receiver whale Address",
    AMOUNT_USD ,
    SUM(AMOUNT_USD) AS total_volume_USD,
    CASE
    WHEN AMOUNT_USD BETWEEN 1000 AND 9999 THEN 'Sender whales between 1000 - 9999 USD 🐟'
    WHEN AMOUNT_USD BETWEEN 10000 AND 99999 THEN 'Sender whales between 10000 - 99999 USD 🐡'
    WHEN AMOUNT_USD BETWEEN 100000 AND 999999 THEN 'Sender whales between 100000 - 999999 USD 🐬'
    WHEN AMOUNT_USD BETWEEN 1000000 AND 9999999 THEN 'Sender whales between 1000000 - 9999999 USD 🦈'
    WHEN AMOUNT_USD >= 10000000 THEN 'Sender whales more than 10000000 USD 🐋'
    ELSE '0'
    END AS "Sender whales",
    CASE
    WHEN AMOUNT_USD BETWEEN 1000 AND 9999 THEN 'Receiver whales between 1000 - 9999 USD 🐟'
    WHEN AMOUNT_USD BETWEEN 10000 AND 99999 THEN 'Receiver whales between 10000 - 99999 USD 🐡'
    WHEN AMOUNT_USD BETWEEN 100000 AND 999999 THEN 'Receiver whales between 100000 - 999999 USD 🐬'
    WHEN AMOUNT_USD BETWEEN 1000000 AND 9999999 THEN 'Receiver whales between 1000000 - 9999999 USD 🦈'
    WHEN AMOUNT_USD >= 10000000 THEN 'Receiver whales more than 10000000 USD 🐋'
    ELSE '0'
    END AS "Receiver whales",AMOUNT
    FROM
    avalanche.core.ez_token_transfers
    WHERE
    SYMBOL IN ('WAVAX', 'AVAX')

    and (FROM_ADDRESS = ('{{Whale_Address}}') OR TO_ADDRESS = ('{{Whale_Address}}'))


    AND AMOUNT >= {{Amount_AVAX}}


    Run a query to Download Data