0xHaM-dUntitled Query
Updated 2022-11-22Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('{{Frequency}}',min_date)::date as date,
count(buyer_address) as new_users,
sum(new_users) over (order by date ) as total_new_users
from (select buyer_address, min(block_timestamp) as min_date
from ethereum.core.ez_nft_sales
where nft_address = '0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205'
and price_usd > 0
group by 1)
group by 1
order by 1 desc
Run a query to Download Data