DATE_TRUNC('day', block_timestamp) AS "sale date",

SUM(price_usd) AS "daily volume(usd)",

COUNT(DISTINCT tx_hash) AS "transaction count",

SUM(SUM(price_usd)) OVER (

ORDER BY

DATE_TRUNC('day', block_timestamp)

) AS "cumulative volume(usd)",

SUM(COUNT(DISTINCT tx_hash)) OVER (

ORDER BY

DATE_TRUNC('day', block_timestamp)

) AS "cumulative transaction count"

arbitrum.nft.ez_nft_sales

block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 DAY'

GROUP BY

"sale date"

ORDER BY

"sale date" ASC;