0-MIDnew nft buyers
    Updated 2023-01-10
    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