denze-e7j2NU2022 CE (Art Blocks)
Updated 2023-02-08
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
31
32
33
34
35
36
›
⌄
SELECT
CASE
WHEN nft_address = '0x059edd72cd353df5106d2b9cc5ab83a52287ac3a' AND (tokenid BETWEEN 0 AND 1000000) THEN 'Chromie Squiggle by Snowfro'
WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 78000000 AND 79000000) THEN 'Fidenza by Tyler Hobbs'
WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 215000000 AND 216000000) THEN 'Gazers by Matt Kane'
WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 163000000 AND 164000000) THEN 'Meridian by Matt DesLauriers'
WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 13000000 AND 14000000) THEN 'Ringers by Dmitri Cherniak'
WHEN nft_address = '0x64780ce53f6e966e18a22af13a2f97369580ec11' AND (tokenid BETWEEN 0 AND 1000000) THEN 'Petro National by John Gerrard'
WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 227000000 AND 228000000) THEN 'Kai-Gen by Takeshi Murata, Christopher Rutledge, J. Krispy'
WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 150000000 AND 160000000) THEN 'Fragments of an Infinite Field by Monica Rizzolli'
WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 23000000 AND 24000000) THEN 'Archetype by Kjetil Golid'
WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 225000000 AND 226000000) THEN 'Vortex by Jen Stark'
WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 53000000 AND 54000000) THEN 'Subscapes by Matt DesLauriers'
WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 228000000 AND 229000000) THEN 'Incomplete Control by Tyler Hobbs'
WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 226000000 AND 227000000) THEN 'Getijde by Bart Simons'
WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 7000000 AND 8000000) THEN 'Elevated Deconstructions by luxpris'
ELSE 'Other'
END AS name
, SUM(price) AS vol_eth
, SUM(creator_fee) AS CE_eth
FROM ethereum.core.ez_nft_sales
WHERE true
AND block_timestamp BETWEEN '2022-06-15' AND '2023-01-01'
-- AND nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'
-- -- AND tokenid BETWEEN 78000000 AND 79000000 -- Fidenzas
-- -- AND tokenid BETWEEN 215000000 AND 216000000 -- Gazers
-- AND tokenid BETWEEN 189000000 AND 190000000 -- CryptoNewYorkers
AND nft_address IN (
'0x059edd72cd353df5106d2b9cc5ab83a52287ac3a'
, '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'
, '0x64780ce53f6e966e18a22af13a2f97369580ec11'
)
AND currency_symbol IN ('ETH', 'WETH')
AND platform_name = 'opensea'
GROUP BY 1
Run a query to Download Data