select date_trunc(day, block_timestamp) as date,

count(distinct buyer) as buyer_count,

count(distinct seller) as seller_count,

count(*) as sale_count,

sum(price) as sale_volume

from flow.core.fact_nft_sales

where nft_collection ilike ('%allday%') and tx_succeeded = TRUE

group by date