sinahosseinzadeh2023-03-31 02:33 PM
    WITH
    pre_airdrop AS (
    SELECT
    to_address,
    SUM(amount) AS total_amount
    FROM
    avalanche.core.fact_token_transfers
    WHERE
    token_symbol = 'ARB'
    AND to_address IN ('address1', 'address2', 'address3') -- replace with the list of addresses from the previous query
    AND transfer_date >= '2022-03-01'
    AND transfer_date < '2022-04-01'
    GROUP BY
    to_address
    ),
    post_airdrop AS (
    SELECT
    to_address,
    SUM(amount) AS total_amount
    FROM
    avalanche.core.fact_avax_transfers
    WHERE
    token_symbol = 'ARB'
    AND to_address IN ('address1', 'address2', 'address3') -- replace with the list of addresses from the previous query
    AND transfer_date >= '2022-04-01'
    AND transfer_date < '2022-05-01'
    GROUP BY
    to_address
    )
    SELECT
    pre_airdrop.to_address,
    pre_airdrop.total_amount AS pre_airdrop_amount,
    COALESCE(post_airdrop.total_amount, 0) AS post_airdrop_amount
    FROM
    pre_airdrop
    LEFT JOIN post_airdrop ON pre_airdrop.to_address = post_airdrop.to_address;

    Run a query to Download Data