thea[NFT Marketplace Mega] Top NFT collection
Updated 2023-04-13Copy Reference Fork
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
›
⌄
with nft as (
select platform_name,
nft_address,
case
when nft_address = '0x60bb1e2aa1c9acafb4d34f71585d7e959f387769' then 'Art Gobblers'
when nft_address = '0x05da517b1bf9999b7762eaefa8372341a1a47559' then 'Keepers'
when nft_address = '0x7fda36c8daedcc55b73e964c2831d6161ef60a75' then 'Yaypegs'
when nft_address = '0x942bc2d3e7a589fe5bd4a5c6ef9727dfd82f5c8a' then 'Art Blocks Explorations'
when nft_address = '0x6f4388602c5dd6c593bf7c9cf3128aaa2a3e09ce' then 'Tickle'
when nft_address = '0xe1d7a7c25d6bacd2af454a7e863e7b611248c3e5' then 'JUUNI Grimoire'
when nft_address = '0x9251dec8df720c2adf3b6f46d968107cbbadf4d4' then '1337 skulls'
when nft_address = '0x0a8d311b99ddaa9ebb45fd606eb0a1533004f26b' then 'ETH GOBBLERS'
when nft_address = '0xf442459c8bb4b891b789e816775232b812eb2ccd' then 'Porkers'
when nft_address = '0x7df64f69544c5bf71171dc5ab69b8602c2ff1e27' then 'Kitaro World'
when nft_address = '0xbd5fb504d4482ef4366dfa0c0edfb85ed50a9bbb' then 'CornTown'
when nft_address = '0xaaa7a35e442a77e37cde2f445b359aabf5ad0387' then 'StreetMachine'
when nft_address = '0xa5d37c0364b9e6d96ee37e03964e7ad2b33a93f4' then 'CATGIRL ACADEMIA'
when nft_address = '0x2ee6af0dff3a1ce3f7e3414c52c48fd50d73691e' then 'Bored Ape Yacht Club'
when nft_address = '0x8d94b8ea78a51d783a413c73811511c900c8f365' then 'SudoWassie'
when nft_address = '0xf10a71e53398bf4e3cf5e2a0cad3c529ad19b834' then 'Floaties'
when nft_address = '0x1cef785aa885836cee4f53b6ace83d187d819639' then 'Wheyfus anonymous :3'
when nft_address = '0x65784d6f23de30a17122e96c0f0986c378ed6947' then 'Bored Ape Yoga Club'
when nft_address = '0xcb88735a1eae17ff2a2abaec1ba03d877f4bc055' then 'PHAYC'
when nft_address = '0xb7d405bee01c70a9577316c1b9c2505f146e8842' then 'V3 Phunks (V3PHUNKS)'
else project_name end as project_name,
count(distinct tx_hash) as sales_count,
sum(price_usd) as sales_volume
from ethereum.core.ez_nft_sales
where price_usd is not null
and platform_name in ('opensea', 'sudoswap', 'rarible', 'looksrare', 'x2y2', 'nftx', 'blur')
group by 1, 2, 3
)
select *
from (
select platform_name,
Run a query to Download Data