PapasotOHMv2 holders and price
Updated 2022-05-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
27
28
29
30
›
⌄
with OHM_price as
(SELECT
date_trunc('day',hour) as block_day,
avg(price) as ohm_price
from ethereum.token_prices_hourly
WHERE
symbol = 'OHM' AND
token_address = '0x64aa3364f17a4d01c6f1751fd97c2bd3d7e7f1d5' AND
block_day > '2021-09-01'
group by block_day
)
select balance_date,
count(user_address) as Holders,
avg(ohm_price) as OHM_price_USD
--CORR (OHM_price_USD,Holders)
from ethereum.erc20_balances
left join OHM_price a on block_day = balance_date
where symbol = 'OHM'
AND contract_address = '0x64aa3364f17a4d01c6f1751fd97c2bd3d7e7f1d5'
group by balance_date
order by balance_date
-- 0x64aa3364f17a4d01c6f1751fd97c2bd3d7e7f1d5
-- 0x64aa3364f17a4d01c6f1751fd97c2bd3d7e7f1d5
Run a query to Download Data