SELECT HOUR, PRICE

FROM aptos.price.ez_prices_hourly

WHERE TOKEN_ADDRESS ='0x55987edfab9a57f69bac759674f139ae473b5e09a9283848c1f87faf6fc1e789::shrimp::ShrimpCoin'

ORDER BY HOUR DESC

LIMIT 1

),

Uptos AS (

SELECT HOUR, PRICE

FROM aptos.price.ez_prices_hourly

WHERE TOKEN_ADDRESS ='0x4fbed3f8a3fd8a11081c8b6392152a8b0cb14d70d0414586f0c9b858fcd2d6a7::UPTOS::UPTOS'

ORDER BY HOUR DESC

LIMIT 1

),

Doodoo AS (

SELECT HOUR, PRICE

FROM aptos.price.ez_prices_hourly

WHERE TOKEN_ADDRESS ='0x73eb84966be67e4697fc5ae75173ca6c35089e802650f75422ab49a8729704ec::coin::DooDoo'

ORDER BY HOUR DESC

LIMIT 1

);

SELECT

(SELECT PRICE FROM Shrimp) AS "SHRIMP Current Price",

(SELECT PRICE FROM Uptos) AS "UPTOS Current Price",

(SELECT PRICE FROM Doodoo) AS "DooDoo Current Price";