date_trunc('day', block_timestamp) as date,

sum(price) as sales_volume

from flow.core.fact_nft_sales

where date >= '2022-05-09'

and tx_succeeded = true

group by 1