maybeyonasthordrop_stakers
Updated 2021-11-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
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