BUYER_ADDRESS,

PLATFORM_NAME,

COUNT(*) AS trades,

SUM(PRICE) AS volume_traded_pol,

AVG(PRICE) AS avg_price_pol

FROM

polygon.nft.ez_nft_sales

WHERE

PROJECT_NAME = '{{collection_name}}'

GROUP BY

PLATFORM_NAME, BUYER_ADDRESS

ORDER BY

trades DESC

LIMIT 10;