binhachon2. [Hard] Post Airdrop Behavior - % claimed per day
    Updated 2021-12-04
    with airdrop_claimed as(
    select
    distinct block_timestamp,
    to_address,
    amount / 1e18 as amount
    from
    ethereum.udm_events
    where
    origin_function_signature = '0x76122903'
    and contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
    and event_type = 'erc20_transfer'
    )
    select
    date_trunc('day', block_timestamp) as blocktime,
    sum(amount) / 25000000 * 100 as percentage_claimed_per_day
    from
    airdrop_claimed
    group by
    blocktime

    Run a query to Download Data