select

block_timestamp::date as date,

player,

CASE

when block_timestamp >= '2022-09-09' and block_timestamp <= '2022-09-13' then 'Week 1'

when block_timestamp < '2022-09-09' then 'PreSeason'

when block_timestamp > '2022-09-13' then 'After Week 1'

end as Weeks,

sum(price) as sales_volume,

sum(sales_volume) over(order by date) as Total_sales_Volume,

count(distinct buyer) as N_Buyers,

count(distinct seller) as N_Seller,

max(price) as Maximum_Price,

min(Price) as Minimum_Price,

median(price) as Median_Price,

count(distinct TX_ID) as N_Tx

from flow.core.ez_nft_sales s join flow.core.dim_allday_metadata a on s.NFT_ID = a.NFT_ID and s.NFT_COLLECTION = a.NFT_COLLECTION

where player != 'N/A'

and player ilike '{{PlayerName}}'--, 'Nick Chubb', 'Jonathan Taylor', 'D''Andre Swift', 'Leonard Fournette')

and TX_SUCCEEDED = 'TRUE'

and block_timestamp >= '2022-08-12'

group by 1,2,3

)

select

* from players_details