Select date(block_timestamp) date, sum(sales_amount), count(distinct tx_id)
from solana.core.fact_nft_sales
inner join solana.core.dim_labels on
solana.core.fact_nft_sales.mint = solana.core.dim_labels.address
where solana.core.dim_labels.label = 'aurory'
and solana.core.dim_labels.label_subtype = 'nf_token_contract'
group by DATE
order by date desc