maybeyonasthordrop_stakers
    Updated 2021-11-26
    with airdrops as (
    select
    block_timestamp,
    block_id,
    tx_id,
    event_inputs:account::string as user,
    event_inputs:userClaim::string/pow(10,18) as tokens_claimed
    from ethereum.events_emitted
    where --tx_id = '0x81e53958ca674ab6e10fe39bbb4b55e2bc9dfd67afc3321826217a537730d5d7'
    -- contract_address = '0xa5f2211b9b8170f694421f2046281775e8468044'
    -- and
    tx_to_address='0x8526cec1d97a68c0e69420488d04dec5f101b46e'
    and event_name='Claimed'
    and event_removed = FALSE
    ),
    rune_vest as (
    select
    block_timestamp,
    block_id,
    tx_id,
    origin_address as user,
    amount/pow(10,18) as tokens_staked
    from ethereum.udm_events
    where
    contract_address = '0xebcd3922a199cd1358277c6458439c13a93531ed'
    and origin_function_name = 'transferAndCall'
    ),
    vest_droppers as (
    select distinct user from rune_vest
    where user in (select user from airdrops)
    )

    select * from vest_droppers
    Run a query to Download Data