fat3mehUntitled Query
Updated 2022-05-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with new_wallets as (
select * from (
select
date(block_timestamp) as date,
from_address as wallets
from ethereum_core.fact_transactions
where to_address = lower('0xdef171fe48cf0115b1d80b88dc8eab59176fee57'))
),
min as (
select
wallets,
min(date) as date
from new_wallets
group by wallets
)
select
date,
count(distinct wallets) as new_users
from min
where date > '2021-10-01' and date < '2021-12-01'
group by date
Run a query to Download Data