maybeyonasens_claim_avg
Updated 2021-12-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with claims as (
select block_timestamp,origin_address as claimer, tx_id, amount/pow(10,18) as ens_claimed
from (
select distinct * from (
select * from ethereum.udm_events
where
tx_id in (
select tx_id from ethereum.udm_events
where
contract_address='0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
and event_name = 'Claim'
)
and event_type = 'erc20_transfer'
)
)
)
select
avg(ens_claimed) as avg_claim,
min(ens_claimed) as min_claim,
max(ens_claimed) as max_claim
from claims
limit 100
Run a query to Download Data