binhachon1. [Easy] New Active Users
Updated 2021-12-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
date_trunc('day', block_timestamp) as blocktime,
count(to_address) as daily_new_users
from
(
select
block_timestamp,
to_address,
row_number () over (
partition by to_address
order by
block_timestamp
) as rownumber
from
ethereum.dex_swaps
where
from_address = '0xdef171fe48cf0115b1d80b88dc8eab59176fee57' qualify rownumber = 1
)
where
block_timestamp > getdate() - interval '90 days'
group by
blocktime
Run a query to Download Data