Delamir-6014Untitled Query
Updated 2022-11-17
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
›
⌄
with
eth_users as (
select * from (
select
from_address as user,
min(block_timestamp) as min_date,
count(distinct tx_hash) as txs
from ethereum_core.fact_transactions
group by 1
)
where min_date >= '2022-01-01'
)
select *,
sum(users) over(order by date) as cum_users
from (
select
date(min_date) as date,
count(distinct user) as users,
count(txs) as TXs
from eth_users
group by 1
)
Run a query to Download Data