theericstoneuniswap airdrop
    Updated 2021-07-22
    with airdropees as (
    -- Anchor is airdrop recipients and the amounts they received
    select
    to_address as airdrop_recipient,
    sum(amount) as total_claimed,
    min(block_timestamp) as first_claim_time
    from ethereum.udm_events where from_address = LOWER('0x090d4613473dee047c3f2706764f49e0821d256e')
    and block_timestamp > '2020-09-16 21:32:51.000' and block_timestamp < '2020-11-01'
    and symbol = 'UNI'
    and origin_function_name = 'claim'
    group by 1
    ),

    nextactions as (
    SELECT
    final.airdrop_recipient,
    final.total_claimed,
    final.first_claim_time,
    final.to_label_subtype,
    final.action_taken,
    sum(final.amount) as total_sent
    from (
    SELECT
    b.block_timestamp,
    a.airdrop_recipient,
    a.total_claimed,
    a.first_claim_time,
    b.to_label_subtype,
    concat(b.origin_function_name,b.event_name) as action_taken,
    b.amount
    FROM ethereum.udm_events b
    LEFT JOIN airdropees a
    on b.from_address = a.airdrop_recipient
    WHERE b.contract_address = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984'
    and b.block_timestamp > '2020-09-16 21:32:51.000'
    ) final
    Run a query to Download Data