block_timestamp::date as date,

count (distinct tx_hash) as Sales_Count,

count (distinct buyer_address) as Buyers_Count,

count (distinct seller_address) as Sellers_Count,

sum (price_usd) as Total_USD_Volume,

avg (price_usd) as Average_USD_Volume,

min (price_usd) as Min_USD_Volume,

max (price_usd) as Max_USD_Volume,

sum (total_usd_volume) over (order by date) as Cumulative_Volume,

sum (sales_count) over (order by date) as Cumulative_Sales_Count

from optimism.core.ez_nft_sales

where nft_address = lower('0x2831Aa51DE4E3bB318Cf01eAcd8a7FdbB440ac3A')

and price_usd > 0

group by 1

order by 1 asc