date_trunc('day', block_timestamp),

sum(sales_amount)

from solana.core.fact_nft_sales left outer join solana.core.dim_labels

on mint = solana.core.dim_labels.address

where label like 'aurory'

group by 1