DATE_TRUNC('day', block_timestamp) AS sale_date,

SUM(SUM(amount_usd)) OVER (ORDER BY DATE_TRUNC('day', block_timestamp)) AS cumulative_sales_usd

FROM

sei.nft.ez_nft_sales

WHERE

tx_succeeded = TRUE

GROUP BY

sale_date

ORDER BY

sale_date ASC;