chispastop 20 weekly y00ts whales
Updated 2023-09-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
BUYER_ADDRESS AS buyer_address,
SUM(PRICE_USD) AS usd_spent,
SUM(PRICE) AS ETH_spent,
COUNT(*) AS nfts_bought
FROM
POLYGON.nft.ez_nft_sales
WHERE
PROJECT_NAME = 'y00ts'
AND EVENT_TYPE = 'sale'
AND BLOCK_TIMESTAMP > CURRENT_DATE - 7
AND BUYER_ADDRESS != '0x29469395eaf6f95920e59f858042f0e28d98a20b' -- exclude blur's contract
GROUP BY
BUYER_ADDRESS
HAVING
SUM(PRICE_USD) > 0
ORDER BY
usd_spent DESC
LIMIT 20;
Run a query to Download Data