select date_trunc('day', block_timestamp) AS DATE,
sum(sales_amount) AS "Amount SOL"
from solana.core.fact_nft_sales left outer join solana.core.dim_labels
on mint = solana.core.dim_labels.address
where label like 'aurory'
and succeeded = 'true'
group by 1