Query editor
-- WITH ranked_calls AS (-- SELECT-- tx_id,-- block_time,-- tx_signer AS trader,-- account_arguments,-- data,-- log_messages,-- ROW_NUMBER() OVER (-- PARTITION BY tx_id-- ORDER BY outer_instruction_index DESC,-- inner_instruction_index DESC-- ) AS rn-- FROM solana.instruction_calls-- WHERE block_time >= CURRENT_TIMESTAMP - INTERVAL '30' DAY-- AND tx_success = true-- AND executing_account =-- 'proVF4pMXVaYqmy4NjniPh4pqKNfMmsihgd4wdkCX3u'-- AND (-- -- SwapArgs family (order_id @ 9, amount_in @ 17, expect_amount_out @ 25, slippage @ 33, routes.len @ 35)-- varbinary_starts_with(data, from_hex('f8c69e91e17587c8')) -- swap-- OR varbinary_starts_with(data, from_hex('132c829448382cee')) -- proxy_swap-- OR varbinary_starts_with(data, from_hex('bbc9d433109bec3c')) -- swap_toc-- OR varbinary_starts_with(data, from_hex('7fd66bbd175a2f68')) -- swap_toc_v2-- OR varbinary_starts_with(data, from_hex('aa2955b184501f35')) -- swap_tob-- OR varbinary_starts_with(data, from_hex('4801d7f2084b36d8')) -- swap_tob_v2 (newly added)-- OR varbinary_starts_with(data, from_hex('dfaad8eacc06f119')) -- swap_tob_with_receiver-- OR varbinary_starts_with(data, from_hex('be9ca9b0959aa16c')) -- swap_tob_enhanced-- -- SwapArgsTokenLedger family (order_id @ 9, expect_amount_out @ 17, slippage @ 25, routes.len @ 27; amount_in not in data)-- OR varbinary_starts_with(data, from_hex('245c93db1ab09f5a')) -- swap_tob_with_token_ledger-- OR varbinary_starts_with(data, from_hex('ef5d0acaa1867f82')) -- swap_tob_with_receiver_token_ledger (newly added)-- )-- ),-- classified AS (-- SELECT-- *,-- ( varbinary_starts_with(data, from_hex('245c93db1ab09f5a'))-- OR varbinary_starts_with(data, from_hex('ef5d0acaa1867f82'))-- ) AS is_token_ledger-- FROM ranked_calls-- WHERE rn = 1-- )-- SELECT-- tx_id,-- trader,-- block_time,-- element_at(account_arguments, 4) AS input_token_mint,-- element_at(account_arguments, 5) AS output_token_mint,-- -- amount_in:-- -- * SwapArgs: instruction data offset 17 (8 bytes, little-endian u64)-- -- * SwapArgsTokenLedger: not in data — parse from log `source_token_change`-- CASE WHEN is_token_ledger-- THEN TRY_CAST(-- split(-- split_part(-- element_at(-- filter(log_messages, log -> strpos(log,-- 'source_token_change') > 0)