date_trunc('day', block_timestamp) as date1,

avg(SALES_AMOUNT/1e6) as Avg,

min(SALES_AMOUNT/1e6) as Min,

max(SALES_AMOUNT/1e6) as Max

from terra.core.fact_nft_sales

where block_timestamp > current_date - 60

group by 1

order by 1