zakkisyed1. Addresses who claimed the ENS airdrop
Updated 2021-12-13
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
›
⌄
select T1.addresses_claimed, T2.price, T1.days
from
(
SELECT count (distinct(origin_address)) as addresses_claimed, date_trunc('day', block_timestamp) as days
--as Total_amount_in_USD, sum(amount) as Total_tokens_claimed
--event_name, event_type, block_timestamp
from
ethereum.udm_events
where --symbol = 'ENS'
--and
contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
and block_timestamp > '2021-11-01'
and event_name = 'Claim'
group by 2
) as T1
INNER JOIN
ethereum.token_prices_hourly as T2
ON T1.days = T2.(date_trunc('day', hour))
group by 3
Run a query to Download Data