mohammadhaccounts that have staked ETH with Lido
Updated 2022-06-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with A as(select count(ORIGIN_FROM_ADDRESS) as count_users,
date_trunc('day',block_timestamp) as block_day
from ethereum.core.ez_eth_transfers
where ORIGIN_TO_ADDRESS= '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
group by block_day
order by block_day desc),
B as(SELECT avg(PRICE) AS ETH_PRICE,date_trunc('day',hour) as block_day,
case when ETH_PRICE < 1500 then 'price<1500'
when ETH_PRICE between 1500 and 2000 then 'between_1500_to_2000'
when ETH_PRICE between 2001 and 3000 then 'between_2001_to_3000'
when ETH_PRICE between 3001 and 4000 then 'between_3001_to_4000'
else 'price>4000'
end as price_category
FROM ethereum.core.fact_hourly_token_prices
where block_day >= '2020-12-18'
AND SYMBOL = 'WETH'
group by block_day)
select A.count_users ,A.block_day ,B.price_category from A inner join B on A.block_day=B.block_day
Run a query to Download Data