SELECT

date_trunc('day', block_timestamp) as day,

count(DISTINCT tx_id) as sales,

sum(SALES_AMOUNT) as sales_volume,

avg(SALES_AMOUNT) as average_price,

count(DISTINCT PURCHASER) as buyers,

min(SALES_AMOUNT) as floor_price

from solana.core.fact_nft_sales

LEFT outer JOIN solana.core.dim_nft_metadata

on solana.core.fact_nft_sales.mint = solana.core.dim_nft_metadata.mint

WHERE contract_name LIKE 'Thugbirdz'

GROUP by 1