select

CLOSE as Bonk_Price,

last24,

(Bonk_Price - last24) / last24 * 100 as BONKChange24

from

solana.price.fact_prices_ohlc_hourly

join (

select

asset_id,

close as last24

from

solana.price.fact_prices_ohlc_hourly

where

asset_id = 'bonk'

and hour = current_date - interval '24 hour'

) using (asset_id)

where

ASSET_ID = 'bonk'

order by

hour DESC

limit

1

), BOME as (

select

CLOSE as BOME_Price,

last24,

(BOME_Price - last24) / last24 * 100 as BOMEChange24

from

solana.price.fact_prices_ohlc_hourly

join (

select

asset_id,

close as last24

from

solana.price.fact_prices_ohlc_hourly