Sbhn_NPTop 5 Most Expensive Tokens
Updated 2023-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
--credit : alik110
select tokenid,
case when tokenid = '8177999377561514054784640740669082121869019857617054568424189809090225940242' then 'Arjen Robben 2020-21 • Rare 7/100'
when tokenid = '31329494973110383704371626801392032353209951673339102126116598927122924086643' then 'Diego Maradona 2019-20 • Rare 50/100'
when tokenid = '83354326167814136932449797259071503942864695154498562136031388517276777839091' then 'Cristiano Ronaldo 2019-20 • Rare 32/100'
when tokenid = '15276524878492698800545242421354425691520127974016542589536352091205877708723' then 'David Beckham 2012-13 • Rare 31/100'
when tokenid = '25727371642914556987084024411804916768676145684966967321425275646168468373290' then 'Diego Maradona 2019-20 • Rare 48/100'
when tokenid = '104097312268121844546538009460553077933041815076957187988692686265137461109799' then 'Diego Maradona 2019-20 • Rare 47/100'
when tokenid = '35377136929482696741968652293779119264217715981932265010219737833969423523458' then 'Willyan 2020-21 • Super Rare 3/10'
when tokenid = '48093350482711898469193426862863068610982509562156779586165871380192153550332' then 'Kazuyoshi Miura 2021-22 • Limited 133/1000'
when tokenid = '93916240977781223426562115550080790124061399362989789955609838837800417178222' then 'William Dutoît 2019-20 • Super Rare 5/10'
when tokenid = '93776972282828663881279942274832281701127302227416168811083141303699564193910' then 'Marco Ruben 2020-21 • Unique'
else tokenid end as tokenidentity,
max (price_usd) as Total_USD_Volume
from ethereum.core.ez_nft_sales t1 full outer join ethereum.core.dim_nft_metadata t2 on t1.nft_address = t2.contract_address and t1.tokenid = t2.token_id
where nft_address = '0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205'
and price_usd > 0
group by 1,2
order by 3 DESC
limit 5
Run a query to Download Data