select --BLOCK_TIMESTAMP::date as date

case

when BLOCK_TIMESTAMP>='2022-12-30'and BLOCK_TIMESTAMP<'2023-01-06'then 'One Week Before Migration'

when BLOCK_TIMESTAMP>='2023-01-06'and BLOCK_TIMESTAMP<='2023-01-12'then 'One Week After Migration'

end as time_period

,sum(SALES_AMOUNT) as volume

,count(distinct SELLER) as sellers

,count(distinct PURCHASER) as buyers

,count(distinct TX_ID) as sales

,count(distinct MINT) as sold_token

from solana.core.fact_nft_sales

where SUCCEEDED ='TRUE'

and BLOCK_TIMESTAMP>='2022-12-30'and BLOCK_TIMESTAMP<='2023-01-12'

group by 1