date_trunc('day', block_timestamp) as day,

count(*) as events,

sum(sales_amount / power(10, 6)) as sales_volume,

avg(sales_amount / power(10, 6)) as avg_sales_price

from terra.core.fact_nft_sales

group by 1

order by 1