-- forked from 5C - polygon most popular nft markets among all users @ https://flipsidecrypto.xyz/edit/queries/fc85d67a-c28e-4d97-8b00-e3fccdeeea01
select
platform_name,
count(distinct buyer_address) as buyers,
count(distinct seller_address) as sellers,
count(distinct tx_hash) as transactions
from polygon.nft.ez_nft_sales
where
block_timestamp::date >='2023-01-01'
and block_timestamp::date < '2024-01-01'
group by 1
order by 2 desc, 3 desc
-- limit 5