count(DISTINCT buyer_address) as buyers,

count(*) as sales,

sum(price) as "Volume (Near)",

sum("Volume (Near)") over (order by daily asc) as cum_near,

sum(price_usd) as "Volume (USD)",

avg(price) as "Avg Price (Near)",

avg(price_usd) as "Avg Price (USD)"

from near.nft.ez_nft_sales

where nft_address = 'aa-harvest-moon-relics.near'

and block_timestamp::Date >= '2024-07-26'

group by 1