binhachon4. [Easy] Claim vs. Price
    Updated 2021-12-15
    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'
    ),
    ens_price as(
    select
    *
    from
    ethereum.token_prices_hourly
    where
    token_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
    and price < 10000
    )
    select
    blocktime,
    price,
    amount,
    sum(amount) over (
    order by
    blocktime
    ) as total_amount
    from
    (
    select
    date_trunc('hour', block_timestamp) as blocktime,
    sum(amount) as amount,
    price
    from
    Run a query to Download Data