smartymetricssession 2 flipsidecrypto EXer2
Updated 2024-10-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
WITH bayc AS
(
SELECT *
FROM ethereum.nft.ez_nft_sales
WHERE
NFT_ADDRESS = lower('0xBC4CA0EdA7647A8aB7C2061c2E118A18a936f13D') -- BAYC NFT
AND
block_timestamp::date >= '2024-01-01'
)
SELECT
BUYER_ADDRESS,
COUNT(DISTINCT TOKENID) as n_nfts
FROM bayc
GROUP BY BUYER_ADDRESS
ORDER BY n_nfts DESC
LIMIT 10
-- SELECT
-- BUYER_ADDRESS,
-- COUNT(DISTINCT TOKENID) as n_nfts
-- FROM ethereum.nft.ez_nft_sales
-- WHERE
-- NFT_ADDRESS = lower('0xBC4CA0EdA7647A8aB7C2061c2E118A18a936f13D') -- BAYC NFT
-- AND
-- block_timestamp::date >= '2024-01-01'
-- GROUP BY BUYER_ADDRESS
-- ORDER BY n_nfts DESC
-- LIMIT 10
QueryRunArchived: QueryRun has been archived