tokenid,

nft_address,

case when nft_address = '0xc36442b4a4522e871399cd717abdd847ab11fe88' then 'Uniswap V3: Positions NFT (UNI-V3-POS)'--credit to ali3n

when nft_address = '0x58a3c68e2d3aaf316239c003779f71acb870ee47' then 'Curve SynthSwap (CRV/SS)'

when nft_address = '0x218615c78104e16b5f17764d35b905b638fe4a92' then 'Omni Derivative Token DOODLE (nDOODLE)'

when nft_address = '0xa2caea05ff7b98f10ad5ddc837f15905f33feb60' then 'WMasterChef'

when nft_address = '0x80825c93a9e7c9fbf05ee32d629636e4bfb2c9fe' then 'Team.Finance Lock (TFL)'

when nft_address = '0x25cd67e2dfec471acd3cdd3b22ccf7147596dd8b' then 'Metroverse Blackout City Block (METROBLOCk)'

when nft_address = '0x5660e206496808f7b5cdb8c56a696a96ae5e9b23' then 'NFTfi Promissory Note (PNNFI)'

when nft_address = '0x06799a1e4792001aa9114f0012b9650ca28059a3' then 'Uniswap V2: Positions NFT (UNI-V2-POS)'

when nft_address = '0xdbe09a801e19c6568c515b0e24cc2337442d4f41' then 'WireNode'

when nft_address = '0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8' then 'KyberSwap v2 NFT Positions Manager (KS2-NPM)'

when nft_address = '0x4757f744ec0cf2e3500dc655f55100c943a59cbb' then 'short Squeeth (sSQU)'

when nft_address = '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523' then 'Pooly - Judge (POOLY3)'

when nft_address = '0x2a0408ceb664148718e1ef6082acea9fe257ef19' then 'ApeX OG NFT (APEX-OG)'

when nft_address = '0xeb6c5accafd8515c1b9e4c794bdc41532c5543ec' then 'DGFamily (DGFAM)'

when nft_address = '0xa8384862219188a8f03c144953cf21fc124029ee' then 'LUSDBondNFT (LUSDBOND)'

when nft_address = '0x5520eebb6585c1bd9b32cb9c7456301ee647f278' then 'Awesome Collection, Patek Philippe... (5131R)'

when nft_address = '0xda564f21bd3f9f5240ade363a0b33adb138d3996' then 'Awesome Collection, Richard Mille ... (RM055)'

when nft_address = '0x2c5a6db2288d7b59882752854c00d3fbe1e3b89b' then 'Awesome Collection, Patek Philippe... (5650G)'

when nft_address = '0x6c415673c79b31aca38669ad9fb5cdb7012c0e8e' then 'Bound NFT WPUNKS (boundWPUN...)'

when nft_address = '0x54522da62a15225c95b01bd61ff58b866c50471f' then 'Primitive RMM'

when nft_address = '0xc49b65e5a350292afda1f239ebefe562668717c2' then 'Hyphen Liquidity Token (Hyphen-LP)'

else coalesce (initcap(project_name),initcap(address_name),initcap(nft_address)) end as Project_Title,

sum (mint_price_usd) as Total_Volume,

avg (mint_price_usd) as Average_Volume,

median (mint_price_usd) as Median_Volume,

max (mint_price_usd) as Maximum_Volume

from ethereum.core.ez_nft_mints t1 left outer join ethereum.core.dim_labels t2 on t1.nft_address = t2.address

where mint_price_usd > 0

and block_Timestamp::date >= '2022-01-01' and block_timestamp::date < '2023-01-01'

group by 2, 3, 4

order by Maximum_Volume DESC

limit 10)