0-MIDnew nft buyers
Updated 2023-01-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tab1 as (
select min(BLOCK_TIMESTAMP::date) as date
,PURCHASER
from terra.core.fact_nft_sales
where CURRENCY='uluna'
and TX_SUCCEEDED='TRUE'
group by 2)
select date
,case
when date>='2022-12-11' and date<'2022-12-25' then 'TWO WEEKS BEFORE HOLIDAYS'
when date>='2022-12-25' and date<='2023-01-07' then 'DURING THE HOLIDAYS' end as time_status
,count(distinct PURCHASER) as new_buyers
from tab1
where date>='2022-12-11' and date<='2023-01-07'
group by 1,2
Run a query to Download Data