SELECT

COLUMN1 AS "Asset", COLUMN2 AS TOKEN_ADDRESS, COLUMN3 AS DECIMALS

FROM

(VALUES

('stAPT', '0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::stapt_token::stakedapt', 8),

('CAKE', '0x159df6b7689437016108a019fd5bef736bac692b6d4a1f10c941f6fbb9a74ca6::oft::cakeoft', 8),

('tAPT', '0x84d7aeef42d38a5ffc3ccef853e1b82e4958659d16a7de736a29c55fbbeb0114::staked_aptos_coin::stakedaptoscoin', 8),

('WETH(Wormhole)', '0xcc8a89c8dce9693d354449f1f73e60e14e347417854f029db5bc8e7454008abb::coin::t', 8),

('APT', '0x1::aptos_coin::aptoscoin', 8),

('zUSDC', '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::usdc', 6),

('zUSDT', '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::usdt', 6),

('zWETH', '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::weth', 6),

('USDC(Wormhole)', '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::t', 6),

('USDT(Wormhole)', '0xa2eda21a58856fda86451436513b867c97eecb4ba099da5775520e0f7492e852::coin::t', 6),

('USDT', '0x6684d15d691e3e5edbf3474eba252e0dd29b7dfbefa6cc7c2e00811fd454c75a::tether::usdt', 6)

)

),

PRICES AS (

SELECT

CASE

WHEN TOKEN_ADDRESS = '0x84d7aeef42d38a5ffc3ccef853e1b82e4958659d16a7de736a29c55fbbeb0114::staked_aptos_coin::StakedAptosCoin' THEN 'tAPT'

WHEN TOKEN_ADDRESS = '0xcc8a89c8dce9693d354449f1f73e60e14e347417854f029db5bc8e7454008abb::coin::T' THEN 'WETH(Wormhole)'

WHEN TOKEN_ADDRESS = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WETH' THEN 'zWETH'

WHEN TOKEN_ADDRESS = '0x1::aptos_coin::AptosCoin' THEN 'APT'

WHEN TOKEN_ADDRESS = '0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::stapt_token::StakedApt' THEN 'stAPT'

END AS "Asset",

PRICE AS PRICE_USD,

FROM aptos.price.ez_prices_hourly

WHERE

TOKEN_ADDRESS IN ('0x84d7aeef42d38a5ffc3ccef853e1b82e4958659d16a7de736a29c55fbbeb0114::staked_aptos_coin::StakedAptosCoin',

'0xcc8a89c8dce9693d354449f1f73e60e14e347417854f029db5bc8e7454008abb::coin::T', '0x1::aptos_coin::AptosCoin',

'0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WETH',