boomer771.ens C
Updated 2021-12-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with claim as (select tx_from_address, sum(event_inputs:value/1e18) as total_claims
from ethereum.events_emitted
where contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72' and event_name = 'Claim'
group by 1
order by 2 desc
limit 20),
domains as (select count(distinct event_inputs:name::string) as total_domain_registered, event_inputs:owner::string as address
from ethereum.events_emitted
where block_timestamp < '2021-11-01' and event_name = 'NameRegistered' and contract_address = '0x283af0b28c62c092c9727f1ee09c02ca627eb7f5'
group by 2)
select a.tx_from_address, a.total_claims, b.total_domain_registered
from claim a
left outer join domains b on a.tx_from_address = b.address
order by 2 desc
Run a query to Download Data