-- forked from turkey - myswap hours @ https://flipsidecrypto.xyz/edit/queries/7eaf21c8-05b9-458b-9f97-287d11f15e7a

-- forked from turkey - zklend hours @ https://flipsidecrypto.xyz/edit/queries/3ad8b94a-b73b-40d8-9ed9-6fa82445ed98

with

prices as (SELECT HOUR::date as datex,

case when symbol = 'USDT' then '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8'

when symbol = 'USDC' then '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8'

when symbol = 'DAI' then '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3'

when symbol = 'WBTC' then '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac'

when symbol = 'wstETH' then '0x042b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2'

when symbol = 'WETH' then '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7'

end as addy,

case when symbol = 'WETH' then 'ETH' else SYMBOL end as token,

DECIMALS , avg(PRICE) as pr

from crosschain.core.ez_hourly_prices

where HOUR::date >= current_date - 730

and SYMBOL in ('USDT','USDC','DAI','WBTC','WETH','wstETH')

and BLOCKCHAIN = 'ethereum'

GROUP by 1,2,3,4),

unfr_info as ( with tb0 as (

SELECT tx_hash as hash0,

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

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

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

when INPUTS[2]:value = '0x727a63f78ee3f1bd18f78009067411ab369c31dece1ae22e16f567906409905' then 'Starkpunks'

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

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

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

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

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

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