select

*

--date_trunc('day', block_timestamp::date) as date,

--max(block_timestamp) as last_updated,

--count(distinct signers[0]) as profiles_created

FROM solana.core.fact_transactions, lateral flatten(input => instructions)

WHERE value:programId IN ('SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6')--, 'Cargo8a1e6NkGyrjy4BQEW4ASGKs9KSyDyUrXMfpJoiH')

AND succeeded = 'true'

AND log_messages::string LIKE '%WithdrawCargoFromFleet%'

--AND log_messages::string NOT LIKE '%Idl%'

and block_timestamp > '2023-09-21' --AND block_timestamp < current_date --'2023-06-16'

limit 100