KaskoazulUntitled Query
Updated 2022-10-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with sellers as (
select block_timestamp::date as fecha,
seller_address as address
from ethereum.core.ez_nft_sales
),
buyers as (
select block_timestamp::date as fecha,
seller_address as address
from ethereum.core.ez_nft_sales
)
select date_trunc ('month', fecha) as dia,
count (distinct address) as unique_users
from (select * from sellers
union all
select * from buyers)
group by fecha
order by fecha desc
Run a query to Download Data