piperBase - NFT Collections by Sales Volume copy
Updated 2023-09-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
CASE
--WHEN NFT_ADDRESS = lower('0xBa5e05cb26b78eDa3A2f8e3b3814726305dcAc83') THEN 'Base Paint'
WHEN PROJECT_NAME != '' THEN PROJECT_NAME
ELSE NFT_ADDRESS
END AS "Collection",
SUM(PRICE) AS "Sales Volume in ETH"
FROM
base.nft.ez_nft_sales
WHERE
PROJECT_NAME != 'veNFT'
AND
PROJECT_NAME != 'DackieOnBase'
AND
PROJECT_NAME != 'NFToshis'
--BLOCK_TIMESTAMP >= '2023-08-25' AND BLOCK_TIMESTAMP < '2023-09-02'
--BLOCK_TIMESTAMP >= '2023-09-01' AND BLOCK_TIMESTAMP < '2023-09-09'
--BLOCK_TIMESTAMP >= '2023-09-08' AND BLOCK_TIMESTAMP < '2023-09-16'
AND
PLATFORM_NAME = 'opensea'
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10
Run a query to Download Data