Aggregator
Jupiter Swap v6 historical data as Parquet
Every Jupiter Swap v6 instruction and event in Solana history, decoded with an Anchor IDL that we checked against real transactions. Trawl gives you 6 event tables and 19 instruction tables, with a column for each account, argument and field. Calls from other programs (CPI) are in the result too.
Updated
The preset
- Program
- JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4
- Preset
jupiter-v6- Tables
- 6 event tables and 19 instruction tables, and
part-*with the raw bytes of each match - Price
- $4 for one recent epoch, $8.68 for one week of chain
The price is the same for every program: you pay for the archive the scan reads, not for the rows. Pricing.
# ask for a price: a 402 with the quote, no payment yet curl -X POST https://trawl.run/scan \ -H 'Content-Type: application/json' \ -d '{"preset":"jupiter-v6","start_epoch":1058,"end_epoch":1058}' -- then, in DuckDB, on the files of the job SELECT slot, signature, amm, input_mint, input_amount FROM 'ev-swap_event-*.parquet' ORDER BY slot LIMIT 10;
Add "filter": {"accounts": ["<wallet>"]} to keep only the transactions
that touch one wallet. How a filter changes a preset.
Event tables
One table for each event in the IDL. Each row also has log_index and the context columns. An event
that the program writes two ways gives one row.
ev-fee_eventfields:
account base58 string, mint base58 string, amount u64ev-swap_eventfields:
amm base58 string, input_mint base58 string, input_amount u64, output_mint base58 string, output_amount u64ev-swaps_eventfields:
swap_events JSON stringev-candidate_swap_resultsfields:
results JSON stringev-candidate_swap_quote_errorfields:
candidate_index u64, in_amount u64, error_code u64ev-best_swap_out_amount_violationfields:
expected_out_amount u64, out_amount u64Instruction tables
One table for each instruction in the IDL: the named accounts, then the arguments. Each row also has the context
columns: slot, tx_index, signature, success, fee, program_id, ix_index, is_inner, inner_index, stack_height, accounts. What each one
holds.
ix-claimaccounts:
args:
wallet, program_authority, system_programargs:
id u8ix-claim_tokenaccounts:
args:
payer, wallet, program_authority, program_token_account, destination_token_account, mint, token_program, associated_token_program, system_programargs:
id u8ix-close_tokenaccounts:
args:
operator, wallet, program_authority, program_token_account, mint, token_programargs:
id u8, burn_all boolix-withdraw_token_account_excess_lamportsaccounts:
args:
operator, wallet, program_authority, token_programargs:
id u8ix-create_idempotent_associated_token_accountaccounts:
payer, associated_token_account, owner, mint, associated_token_program, system_program, token_program, close_authorityix-create_token_ledgeraccounts:
token_ledger, payer, system_programix-create_token_accountaccounts:
args:
token_account, user, mint, token_program, system_programargs:
bump u8ix-close_wsol_token_accountaccounts:
token_account, user, token_program, system_programix-exact_out_routeaccounts:
args:
token_program, user_transfer_authority, user_source_token_account, user_destination_token_account, destination_token_account, source_mint, destination_mint, platform_fee_account, token_2022_program, event_authority, programargs:
route_plan JSON string, out_amount u64, quoted_in_amount u64, slippage_bps u16, platform_fee_bps u8ix-routeaccounts:
args:
token_program, user_transfer_authority, user_source_token_account, user_destination_token_account, destination_token_account, destination_mint, platform_fee_account, event_authority, programargs:
route_plan JSON string, in_amount u64, quoted_out_amount u64, slippage_bps u16, platform_fee_bps u8ix-route_with_token_ledgeraccounts:
args:
token_program, user_transfer_authority, user_source_token_account, user_destination_token_account, destination_token_account, destination_mint, platform_fee_account, token_ledger, event_authority, programargs:
route_plan JSON string, quoted_out_amount u64, slippage_bps u16, platform_fee_bps u8ix-set_token_ledgeraccounts:
token_ledger, token_accountix-shared_accounts_exact_out_routeaccounts:
args:
token_program, program_authority, user_transfer_authority, source_token_account, program_source_token_account, program_destination_token_account, destination_token_account, source_mint, destination_mint, platform_fee_account, token_2022_program, event_authority, programargs:
id u8, route_plan JSON string, out_amount u64, quoted_in_amount u64, slippage_bps u16, platform_fee_bps u8ix-shared_accounts_routeaccounts:
args:
token_program, program_authority, user_transfer_authority, source_token_account, program_source_token_account, program_destination_token_account, destination_token_account, source_mint, destination_mint, platform_fee_account, token_2022_program, event_authority, programargs:
id u8, route_plan JSON string, in_amount u64, quoted_out_amount u64, slippage_bps u16, platform_fee_bps u8ix-shared_accounts_route_with_token_ledgeraccounts:
args:
token_program, program_authority, user_transfer_authority, source_token_account, program_source_token_account, program_destination_token_account, destination_token_account, source_mint, destination_mint, platform_fee_account, token_2022_program, token_ledger, event_authority, programargs:
id u8, route_plan JSON string, quoted_out_amount u64, slippage_bps u16, platform_fee_bps u8ix-exact_out_route_v2accounts:
args:
user_transfer_authority, user_source_token_account, user_destination_token_account, source_mint, destination_mint, source_token_program, destination_token_program, destination_token_account, event_authority, programargs:
out_amount u64, quoted_in_amount u64, slippage_bps u16, platform_fee_bps u16, positive_slippage_bps u16, route_plan JSON stringix-route_v2accounts:
args:
user_transfer_authority, user_source_token_account, user_destination_token_account, source_mint, destination_mint, source_token_program, destination_token_program, destination_token_account, event_authority, programargs:
in_amount u64, quoted_out_amount u64, slippage_bps u16, platform_fee_bps u16, positive_slippage_bps u16, route_plan JSON stringix-shared_accounts_exact_out_route_v2accounts:
args:
program_authority, user_transfer_authority, source_token_account, program_source_token_account, program_destination_token_account, destination_token_account, source_mint, destination_mint, source_token_program, destination_token_program, event_authority, programargs:
id u8, out_amount u64, quoted_in_amount u64, slippage_bps u16, platform_fee_bps u16, positive_slippage_bps u16, route_plan JSON stringix-shared_accounts_route_v2accounts:
args:
program_authority, user_transfer_authority, source_token_account, program_source_token_account, program_destination_token_account, destination_token_account, source_mint, destination_mint, source_token_program, destination_token_program, event_authority, programargs:
id u8, in_amount u64, quoted_out_amount u64, slippage_bps u16, platform_fee_bps u16, positive_slippage_bps u16, route_plan JSON stringFiles are split at 2 GB: ix-<name>-tNN-SSSS.parquet. Large integers stay
exact: u128 is a decimal string. All decoded types.
Get Jupiter Swap v6 data for your range.
Select an epoch range and get a firm price. You pay only when you send the job.