adriaparcerisasethereum recent 6
Updated 2023-01-20
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
31
32
33
›
⌄
with
news as (
SELECT
distinct from_address,
min(block_timestamp) as debut
from ethereum.core.fact_transactions
group by 1
),
t1 as (
select trunc(debut,'day') as date,
count(distinct from_address) as new_users
from news
where debut between '2023-01-01 06:03:23.000' and '2023-01-16 14:38:47.000'
group by 1
),
t2 as (
select
trunc(hour,'day') as date,
avg(price) as eth_price,
LAG(eth_price,1) IGNORE NULLS OVER (ORDER BY date) as last_price,
((eth_price-last_price)/eth_price)*100 as eth_price_change
from ethereum.core.fact_hourly_token_prices where symbol='WETH' and hour between '2023-01-01' and '2023-01-16'
group by 1
),
t4 as (
select
t1.date,
new_users,eth_price,eth_price_change
from t1
join t2 on t1.date=t2.date
)
select * from t4
order by 1 asc
Run a query to Download Data