NakedCollectorWeb2: NIKE DEEP DIVE (RTFKT KICKS) – PRIMARY SALES
Updated 2024-08-19
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
date_trunc('{{Granularity}}', block_timestamp) as date,
nft_address,
case
when nft_address = '0x86825dfca7a6224cfbd2da48e85df2fc3aa7c4b1' then 'MNLTH 1'
when nft_address = '0xf661d58cfe893993b11d53d11148c4650590c692' then 'RTFKT x Nike Dunk Genesis CRYPTOKICKS'
when nft_address = '0x9a06ef3a841316a9e2c1c93b9c21a7342abe484f' then 'RTFKT Skin Vial: EVO X'
when nft_address = '0x212590b0dac9502e0591b79db4cedeb6356dcc36' then 'AR Hoodie Pre-Forged'
when nft_address = '0x1bb6edf7b129967d512086fbdf489ed659580916' then 'AR Hoodie Forged'
when nft_address = '0x348fc118bcc65a92dc033a951af153d14d945312' then 'CloneX Mintvial'
when nft_address = '0xa49a0e5ef83cf89ac8aae182f22e6464b229efc8' then 'RTFKT x Nike Air Force 1 (aka RTFKT Clone X Forging SZN 1)'
when nft_address = '0x029af5c555807c2b5d337478e5f895e8f3b557e2' then 'Space Drip Forging - RTFKT Space Drip x Nike Air Force 1'
when nft_address = '0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b' then 'CloneX'
when nft_address = '0x6d4bbc0387dd4759eee30f6a482ac6dc2df3facf' then 'RTFKT X NIKE Trillium Lace Engine' --(RTFKT x NIKE MNTLTH until Dec 4th 2022)
when nft_address = '0x9930929903f9c6c83d9e7c70d058d03c376a8337' then 'Creators'
when nft_address = '0xb7be4001bff2c5f4a61dd2435e4c9a19d8d12343' then 'Loot Pod (PodX)'
when nft_address = '0xd3f69f10532457d35188895feaa4c20b730ede88' then 'Space Drip'
when nft_address = '0xc541fc1aa62384ab7994268883f80ef92aac6399' then 'Space Drip 1.2'
when nft_address = '0x0972290a80333d19c6703073c3e57134a4ca0127' then 'Bonus Items'
when nft_address = '0xae3d8d68b4f6c3ee784b2b0669885a315ba77c08' then 'Punk Project Gen1'
when nft_address = '0x6b47e7066c7db71aa04a1d5872496fe05c4c331f' then 'Purple RTFKT X Atari Sneakers'
when nft_address = '0x2250D7c238392f4B575Bb26c672aFe45F0ADcb75' then 'FEWOCiOUS x RTFKT'
when nft_address = '0x253ef258563e146f685e60219da56a6b75178e19' then 'RTFKT X RIMOWA'
when nft_address = '0x6c410cf0b8c113dc6a7641b431390b11d5515082' then 'Animus Egg' --when nft_address = '0xb7be4001bff2c5f4a61dd2435e4c9a19d8d12343' then 'Pod X'
when nft_address = '0x56a67d475ded20f1120d6377988ae12992888ac4' then 'RTFKT - MNLTH X (NIKE MNLTH)'
when nft_address = '0x11708dc8a3ea69020f520c81250abb191b190110' then 'RTFKT Cryptokicks iRL'
when nft_address = '0x43764f5b8973f62a6f10914516131c1489e3190d' then 'RTFKT X TAKASHI MURAKAMI X GAGOSIAN CLONE X NYC'
when nft_address = '0x08507226c0afb9a908bb4b117c311c2376584d60' then 'RTFKT X TAKASHI MURAKAMI X GEISAI EVENT'
when nft_address = '0xa2846817e33fcd4e761579cbb53722254f38a438' then 'RTFKT x Nike Dunk Genesis VOID'
when nft_address = '0xa4ea8b820aabc2569ce42a88252a36a51103d0b1' then 'RTFKT x D.O.A.F AR Helmet'
when nft_address = '0xbf2f2a7128e9a0531402c99366383834655418d2' then 'RTFKT x Nike Footballverse Jersey'
else project_name
end as project_name,
sum(MINT_PRICE_USD) as "Primary Sales (USD)",
NFT_COUNT as NFT_COUNT,
count (distinct NFT_TO_ADDRESS) as "Unique Minters",
QueryRunArchived: QueryRun has been archived