BUYER_ADDRESS AS buyer_address,

SUM(PRICE_USD) AS usd_spent,

SUM(PRICE) AS ETH_spent,

COUNT(*) AS nfts_bought

POLYGON.nft.ez_nft_sales

NFT_ADDRESS = LOWER('0x670fd103b1a08628e9557cd66b87ded841115190')

AND BLOCK_TIMESTAMP >= CURRENT_TIMESTAMP - INTERVAL '24 HOURS'

AND BUYER_ADDRESS != '0x29469395eaf6f95920e59f858042f0e28d98a20b' -- exclude blur's contract

AND BUYER_ADDRESS != '0x227c7df69d3ed1ae7574a1a7685fded90292eb48' -- exclude another contract

GROUP BY

BUYER_ADDRESS

SUM(PRICE_USD) > 0

ORDER BY

usd_spent DESC

20;