select block_timestamp,

tx_id,

--marketplace, --A.4eb8a10cb9f87357.NFTStorefront

--currency, --A.ead892083b3e2c6c.DapperUtilityCoin

nft_id,

buyer,

seller,

price,

tokenflow,

counterparties

from flow.core.ez_nft_sales

where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

and tx_succeeded = TRUE

),

top_preseason_sellers as (

select seller,

sum (price) as sell_volume,

count (tx_id) as total_sales,

rank () over (order by sell_volume desc) as rank

from allday_raw_sales

where block_timestamp >= '2022-08-04' and block_timestamp < '2022-08-29' --Preseason started August 4th and ended August 28th.

group by seller

order by sell_volume desc

--qualify rank <= 10

),

top_preseason_buyers as (

select buyer,

sum (price) as buy_volume,

count (tx_id) as total_buys,

rank () over (order by buy_volume desc) as rank

from allday_raw_sales

where block_timestamp >= '2022-08-04' and block_timestamp < '2022-08-29' --Preseason started August 4th and ended August 28th.

group by buyer