SELECT

token_address,

symbol,

name,

price,

CASE

WHEN token_address = '0x532f27101965dd16442e59d40670faf5ebb142e4' THEN price * 9909886699

WHEN token_address = '0x4ed4e862860bed51a9570b96d89af5e1b0efefed' THEN price * 18239297692

WHEN token_address = '0xac1bd2486aaf3b5c0fc3fd868558b082a531b2b4' THEN price * 420690000000

END AS market_cap

FROM base.price.ez_prices_hourly

WHERE token_address IN (

'0x532f27101965dd16442e59d40670faf5ebb142e4',

'0x4ed4e862860bed51a9570b96d89af5e1b0efefed',

'0xac1bd2486aaf3b5c0fc3fd868558b082a531b2b4'

)

AND hour >= DATEADD('day', -1, CURRENT_TIMESTAMP())

QUALIFY ROW_NUMBER() OVER (PARTITION BY token_address ORDER BY hour DESC) = 1

SELECT

MAX(CASE WHEN token_address = '0x532f27101965dd16442e59d40670faf5ebb142e4' THEN market_cap END) as brett_market_cap,

MAX(CASE WHEN token_address = '0x4ed4e862860bed51a9570b96d89af5e1b0efefed' THEN market_cap END) as mochi_market_cap,

MAX(CASE WHEN token_address = '0xac1bd2486aaf3b5c0fc3fd868558b082a531b2b4' THEN market_cap END) as toshi_market_cap

FROM token_metrics;