'Solana' as type,

date(block_timestamp) as date,

count(distinct tx_id) as txs,

count(distinct purchaser) as buyers

from solana.core.fact_nft_sales

where date between current_date()-91 and current_date()-1

group by date