zakkisyedENS airdrop claimed vs ENS price daily
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
›
⌄
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 > current_date - 45
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), claim_amt_usd/ens_claimed as ENS_price
--SUM (amount) / 1e18 / 25000000 * 100 AS ens_claimed_percent
FROM claim_tx
group by block_timestamp
order by 3 ASC
Run a query to Download Data