nitsNew User Sandbox Stats
Updated 2022-11-26
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT date(first_use) as day, count(DISTINCT buyer_address) as total_buyers,
sum(total_buyers) over (order by day) as cum_buyers
from
(SELECT buyer_address, min(block_timestamp) as first_use
from
ethereum.core.ez_nft_sales
where (nft_address ilike '0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38')
GROUP by 1)
where date(first_use) >= CURRENT_DATE - {{n}}
GROUP by 1
-- LIMIT 100
Run a query to Download Data