nitsNew Buyers ens
Updated 2022-12-10
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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 '0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85')
GROUP by 1)
where date(first_use) >= CURRENT_DATE - {{n}}
GROUP by 1
-- LIMIT 100
Run a query to Download Data