BLOCK_TIMESTAMP::date as day,

count(distinct PURCHASER) as prchsr,

sum(SALES_AMOUNT) as volume

from flipside_prod_db.solana.fact_nft_sales

where mint in (select ADDRESS from flipside_prod_db.solana.dim_labels

where label ilike '%StepN%'

and LABEL_TYPE='nft')

and BLOCK_TIMESTAMP>=CURRENT_DATE-75

and SUCCEEDED='TRUE'

group by 1