s.*,

price_from.price AS price_swap_from,

price_to.price AS price_swap_to,

COALESCE(

s.swap_from_amount * price_from.price,

s.swap_to_amount * price_to.price

) AS usd_value

FROM solana.defi.fact_swaps_jupiter_summary s

LEFT JOIN solana.price.ez_prices_hourly price_from

ON price_from.token_address = s.swap_from_mint

AND price_from.hour = DATE_TRUNC('HOUR', s.block_timestamp)

LEFT JOIN solana.price.ez_prices_hourly price_to

ON price_to.token_address = s.swap_to_mint

AND price_to.hour = DATE_TRUNC('HOUR', s.block_timestamp)

WHERE (

s.swap_from_mint = 'CniPCE4b3s8gSUPhUiyMjXnytrEqUrMfSsnbBjLCpump'

OR s.swap_to_mint = 'CniPCE4b3s8gSUPhUiyMjXnytrEqUrMfSsnbBjLCpump'

)

AND s.is_limit_swap = 'true'

ORDER BY s.block_timestamp DESC;