mucryptoEthereum, active wallets
Updated 2023-03-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with ethereum as (select
date_trunc('day', block_timestamp) as day,
count(distinct from_address) as "ACTIVE WALLETS"
from ethereum.core.fact_transactions
where block_timestamp::date between '2022-05-04' and '2022-05-15'
and to_address is not null
group by 1),
luna as (select
date(hour) as "Day",
avg(price) as "AVERAGE LUNA PRICE, USD"
from ethereum.core.fact_hourly_token_prices
where "Day" between '2022-05-04' and '2022-05-15'
and symbol = 'LUNA'
group by 1)
select ethereum."ACTIVE WALLETS", luna."AVERAGE LUNA PRICE, USD", luna."Day"
from ethereum
join luna
on ethereum.day=luna."Day"
Run a query to Download Data