SELECT

buyer_address AS BUYER,

platform_name,

COUNT(*) AS nft_sales,

SUM(price_usd) AS pricevolume,

SUM(tx_fee_usd) AS total_fees

FROM avalanche.nft.ez_nft_sales

WHERE platform_name = 'opensea'

AND block_timestamp >= '2024-01-01'

GROUP BY 1, 2

SELECT

BUYER,

platform_name,

nft_sales,

pricevolume,

total_fees,

nft_sales over (order by BUYER) AS avg_nft_sales_per_buyer,

pricevolume over (order by BUYER) as avg_price_per_buyer

FROM buyer_sales

ORDER BY nft_sales DESC;

LIMIT 10