zakkisyedENS airdrop claimed everyday
Updated 2021-12-07
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
›
⌄
WITH claim_tx AS (
SELECT DISTINCT tx_id,
block_timestamp,
tx_id,
contract_address,
to_address,
amount/1e18 as amount1,
amount_usd/1e18 as amount2
FROM ethereum.udm_events
WHERE contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
AND event_name = 'transfer'
AND block_timestamp > '21-11-01'
AND tx_id IN (SELECT DISTINCT
tx_id
FROM ethereum.udm_events
WHERE contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
AND event_name = 'Claim')
)
SELECT SUM(amount1) AS ens_claimed, sum(amount2) as claim_amt_usd, date_trunc('day', block_timestamp)
--SUM (amount) / 1e18 / 25000000 * 100 AS ens_claimed_percent
FROM claim_tx
group by block_timestamp
order by 2 ASC
Run a query to Download Data