from crosschain.price.ez_hourly_token_prices

where SYMBOL = 'WETH'

and BLOCKCHAIN = 'ethereum'

and hour::date >= '2023-08-16'

GROUP by 1)

SELECT ((INPUTS[1]:value[3]:value)/pow(10,18)) as "Sale price in $ETH", round("Sale price in $ETH"*pr,2) as "Sale price in $USD",

case when INPUTS[1]:value[2]:value = '0x60c7bac593716c5ab7b9dcb98c2cb97dcee9eef49bd2e8329383b35f7232452'

then 'Samurai Legends'

when INPUTS[1]:value[2]:value = '0x5b5b1b7b6f683cf5c765cc5599fc05c16fddcfbe14846b6e2ec5ba9e3848b34'

then 'Expectium Shares'

when INPUTS[1]:value[2]:value = '0x7d74935a915f3551bc0ce992aa0dd46d5e7606d0607a4cacc532da675f431b7'

then 'Mage Cats'

when INPUTS[1]:value[2]:value = '0x2d679a171589777bc996fb27767ff9a2e44c7e07967760dea3df31704ab398a'

then 'Stark Guardians'

when INPUTS[1]:value[2]:value = '0x59df550c89bebee3808b2256d76001e1a3703817e04781c17bd75b17b4959f2'

then 'Starknet Monsterz'

when INPUTS[1]:value[2]:value = '0x708e824e3b83b1e9b644b52b9b9281f949acca5516f65a5df37f19bdc846a5b'

then 'Early Starkers'

when INPUTS[1]:value[2]:value = '0x727a63f78ee3f1bd18f78009067411ab369c31dece1ae22e16f567906409905'

then 'Starkpunks'

when INPUTS[1]:value[2]:value = '0x60582df2cd4ad2c988b11fdede5c43f56a432e895df255ccd1af129160044b8'

then 'StarkVerse Gallery'

when INPUTS[1]:value[2]:value = '0x5dbdedc203e92749e2e746e2d40a768d966bd243df04a6b712e222bc040a9af' then 'Starknet.id'

when INPUTS[1]:value[2]:value = '0x7606cac9053e9b8b573a4b0a0ce608880f64869e24b8a605210d7a85bb6e5f1' then 'Spok'

when INPUTS[1]:value[2]:value = '0x1b22f7a9d18754c994ae0ee9adb4628d414232e3ebd748c386ac286f86c3066' then 'Argent Xplorer'

when INPUTS[1]:value[2]:value = '0x1435498bf393da86b4733b9264a86b58a42b31f8d8b8ba309593e5c17847672' then 'briq Sets'

when INPUTS[1]:value[2]:value = '0x3859bf9178b48a4ba330d6872ab5a6d3895b64d6631197beefde6293bc172cd' then 'Dreamy BoTTy'

when INPUTS[1]:value[2]:value = '0x12f8e318fe04a1fe8bffe005ea4bbd19cb77a656b4f42682aab8a0ed20702f0' then 'StarkRock'

when INPUTS[1]:value[2]:value = '0x76503062d78f4481be03c9145022d6a4a71ec0719aa07756f79a2384dc7ef16' then 'Starknet Quest'

when INPUTS[1]:value[2]:value = '0x106c94dc954944b3893e2102d9ad5065d04a0ec9b08910891d8eedb75965334' then 'Starknet Turkiye: Defi Adventure'

when INPUTS[1]:value[2]:value = '0x69573524616d02f22bfcf0851413ba8feeb3d43f7f537362f6036d954e3a6ad' then 'StarkBunny'

when INPUTS[1]:value[2]:value = '0x57c4b510d66eb1188a7173f31cccee47b9736d40185da8144377b896d5ff3' then 'Starknet Journey Set by Braavos'

when INPUTS[1]:value[2]:value = '0x4a3621276a83251b557a8140e915599ae8e7b6207b067ea701635c0d509801e' then 'Mint Square Storefront'