-- Step 1: Get the most recent price of the token

SELECT

PRICE,

SYMBOL,

HOUR

FROM

base.price.ez_prices_hourly;

WHERE

TOKEN_ADDRESS = '0x532f27101965dd16442e59d40670faf5ebb142e4'

ORDER BY

HOUR DESC

LIMIT 1 -- Get the latest price

SELECT

t.SYMBOL,

t.PRICE,

9910236395 AS CIRCULATING_SUPPLY, -- Replace with actual circulating supply

(t.PRICE * 9910236395 ) AS market_cap -- Replace with actual circulating supply

FROM

token_price t;