WITH claimed_jup AS (

SELECT

t.block_timestamp,

t.amount AS JUP_Claimed,

p.price AS current_jup_price,

p.price * t.amount AS current_value_usd,

t.mint,

t.tx_from,

t.tx_to, -- Include tx_to here

t.tx_id,

e.instruction

FROM

solana.core.fact_transfers t

JOIN

solana.price.ez_prices_hourly p

ON

t.mint = p.token_address

AND

p.hour = (SELECT MAX(hour) FROM solana.price.ez_prices_hourly WHERE token_address = t.mint)

INNER JOIN

solana.core.fact_events e

ON

t.block_timestamp = e.block_timestamp

AND

t.tx_id = e.tx_id

INNER JOIN

solana.core.fact_transactions tx

ON

t.block_timestamp = tx.block_timestamp

AND

t.tx_id = tx.tx_id

WHERE

tx.succeeded

AND