Afonso_DiazUntitled Query
Updated 2023-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with t as (
select purchaser,
min(block_timestamp)::date as min_date
from solana.core.fact_nft_sales
where marketplace = 'exchange art'
and succeeded = 1
group by 1
)
select min_date as day,
count (distinct purchaser) as new_buyers_count,
sum (new_buyers_count) over (order by day) as cumulative_new_buyers_count
from t
where day > current_date - 90
group by 1
order by 1
Run a query to Download Data