WITH fill_events AS (

SELECT

block_timestamp

, decoded_instruction:name AS event_name

, decoded_instruction

, tx_id

FROM solana.core.ez_events_decoded

WHERE 1 = 1

AND block_timestamp::date = '2024-01-13'

-- AND block_timestamp < current_date

-- AND block_timestamp::date = '2023-12-08'

AND program_id = 'jupoNjAxXgZ4rjzxzPMP4oxduvQsQtZzyknqvzYNrNu'

AND decoded_instruction:name = 'flashFillOrder'

AND succeeded

ORDER BY block_timestamp

, cte AS (

SELECT *

from solana.core.fact_events

WHERE 1 = 1

AND block_timestamp::date = '2024-01-13'

AND program_id = 'jupoNjAxXgZ4rjzxzPMP4oxduvQsQtZzyknqvzYNrNu'

AND tx_id IN (SELECT tx_id FROM fill_events)

----QUALIFY row_number() OVER (PARTITION BY tx_id ORDER BY index desc) = 1

, open_index AS (

SELECT

block_timestamp