date(block_timestamp) as day,

CASE WHEN BLOCK_TIMESTAMP >= '2022-10-11'

THEN 'After hack'

ELSE 'Before hack' END as time_period,

count(DISTINCT tx_id) as no_of_txns,

count(DISTINCT PURCHASER) as no_of_buyers,

count(distinct seller) as no_of_sellers,

round(sum(sales_amount),2) as tot_volume

FROM solana.core.fact_nft_sales

where block_timestamp >= dateadd(day, -60, getdate())

and sales_amount > 0

GROUP BY 1, 2