with raw_data AS (

SELECT

f.index AS log_index

, f.value AS log_text

, a.block_timestamp

, a.tx_id

from solana.core.fact_transactions a

, lateral flatten (input => log_messages) f

WHERE 1 = 1

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

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

--AND block_timestamp > current_date - 1

AND block_timestamp > '2023-11-13'

AND block_timestamp < current_date

-- AND tx_id = '54mzbrdXfmLDfXdBMAj4tyTQsBSnGsiVKJPZvS7R5Pk6vBmaKw6VLfoqr7t4ttyRDW9uxygu8Za1u1ndioPjEYhw'

AND ARRAY_CONTAINS('Program PERPHjGBqRHArX4DySjwM6UJHiR3sWAatqfdBS2qQJu invoke [1]'::variant, log_messages)

-- AND (

-- ARRAY_CONTAINS('Program log: Instruction: IncreasePosition'::variant, log_messages)

-- OR

-- ARRAY_CONTAINS('Program log: Instruction: DecreasePosition'::variant, log_messages)

-- )

AND (

log_text ilike 'Program log: Instruction: IncreasePosition%'

OR

log_text ilike 'Program log: Instruction: DecreasePosition%'

OR

log_text ilike 'Program log: Instruction: LiquidatePosition%'

OR

log_text ilike 'Program log: Instruction: LiquidateFullPosition%'

OR

log_text ilike 'Program log: Collected fee:%'

)

AND log_text NOT ilike '%PreSwap'

AND log_text NOT ilike '%PostSwap'