SELECT

date_trunc('week', block_timestamp) as date,

count(distinct buyer) as users,

avg(users) over (order by date) as avg_users_day,

sum(users) over (order by date) as cum_users,

sum(price) as FLOW_volume,

avg(price) as avg_NFT_price_FLOW,

avg(FLOW_volume) over (order by date) as avg_volume,

sum(FLOW_volume) over (order by date) as cum_volume,

count(distinct tx_id) as sales,

avg(sales) over (order by date) as avg_sales_day,

sum(sales) over (order by date) as cum_sales,

avg(price) as daily_avg_sales_price,

avg(daily_avg_sales_price) over (order by date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW ) as avg_price_ma_7day,

min(price) as price_floor,

max(price) as max_price

FROM flow.nft.ez_nft_sales

where nft_collection ='A.e5bf4d436ca23932.BBxBarbieCard'

and block_timestamp>'2023-05-01'

GROUP BY 1

order by 1 asc