date_trunc('day',BLOCK_TIMESTAMP) as day,

player,

count(distinct SELLER) as sellers,

count(distinct buyer) as buyers,

sum(price) as volume_sale,

count(tx_id) as sale_count,

avg(price) as average_sale_price,

volume_sale/count(distinct date_trunc(day, block_timestamp)) as average_volume_day,

avg(average_sale_price) OVER (partition by player ORDER BY day ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as MA_7_Days

from flow.core.fact_nft_sales x left outer join flow.core.dim_topshot_metadata y on x.NFT_ID=y.NFT_ID

where TX_SUCCEEDED='TRUE' and CURRENCY='A.ead892083b3e2c6c.DapperUtilityCoin'

and x.NFT_COLLECTION='A.0b2a3299cc857e29.TopShot'

and player in ('Kyrie Irving','Kevin Durant')

and BLOCK_TIMESTAMP>='2022-06-30'

group by 1,2

order by 1