avg (price_usd) as flow_price

from flow.core.fact_prices

where symbol ='FLOW'

and source ='coinmarketcap'

group by 1

),

nft_price as ( SELECT*,

price * b.flow_price as nft_usd_price

from flow.core.ez_nft_sales a

join priceTb b on a.block_timestamp::date = b.p_date

),

raceday_buyer as (select block_timestamp,

tx_id,

buyer,

nft_collection,

nft_usd_price

from nft_price

where nft_collection = 'A.329feb3ab062d289.RaceDay_NFT'

and tx_succeeded = 'TRUE'

)

SELECT date_trunc('week', block_timestamp) as week,

split(nft_collection, '.')[2] as collection,

COUNT(DISTINCT tx_id) sales,

COUNT(DISTINCT buyer) buyers,

sum(nft_usd_price) as sales_usd_vol,

row_number() over (order by week DESC) as rank,

sum(sales) over (partition by collection order by week) as cum_sales,

sum(sales_usd_vol) over (partition by collection order by week) as cum_sales_usd_vol

FROM raceday_buyer

group by 1, 2