WITH price_accs AS (

SELECT *

FROM (

VALUES

('6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN', 'TRUMP')

) t(price_account, symbol)

),

raw_data AS (

SELECT

block_timestamp,

block_id,

decoded_instruction:accounts[1]:pubkey AS price_account,

decoded_instruction:accounts[0]:pubkey AS funding_account,

decoded_instruction:args:price::int AS price,

tx_id,

decoded_instruction

FROM solana.core.fact_decoded_instructions

WHERE 1 = 1

AND program_id = 'FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe4975bi2epH'

AND block_timestamp >= '2025-01-17 00:00'

AND price_account IN (

'6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

)

),

joined AS (

SELECT

block_timestamp,

price_account,

symbol,

price

FROM raw_data

LEFT JOIN price_accs USING(price_account)

SELECT