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

count (DISTINCT buyer_address) as BUYER,

count (DISTINCT seller_address) as sellers,

count (*) Nft_sales,

sum (price_usd) as pricevolume,

sum (Tx_fee_usd) as gas_fees,

sum (platform_fee_usd) as platform_fee

from avalanche.nft.ez_nft_sales

WHERE PLATFORM_NAME = 'joepegs'

block_timestamp >= '2024-01-01'

GROUP by 1

) SELECT

week,

BUYER,

sellers,

Nft_sales,

pricevolume,

gas_fees,

platform_fee,

sum (BUYER) over (ORDER by week) as buyers_overtime,

sum (Nft_sales) over (ORDER by week) as Nft_sales_overtime,

sum (sellers) over (ORDER by week) as sellers_overtime,

AVG (pricevolume) as Average

from sales

GROUP by 1,2,3,4,5,6,7

ORDER by week DESC