SELECT date(block_timestamp) as day, count(DISTINCT tx_id) as total_txs,
count(DISTINCT purchaser) as buyers,
sum(sales_amount)/pow(10,6) as net_sale,
sum(net_sale) over (order by day) as cum_sale
from terra.core.fact_nft_sales
where tx_succeeded = TRUE and currency = 'uluna' and day >= CURRENT_DATE -{{N}}
GROUP by 1