Trawl
Menu
Get a price
DEX

PumpSwap historical data as Parquet

Every PumpSwap instruction and event in Solana history, decoded with an Anchor IDL that we checked against real transactions. Trawl gives you 27 event tables and 38 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
pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA
Preset
pump-swap
Tables
27 event tables and 38 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":"pump-swap","start_epoch":1058,"end_epoch":1058}'

-- then, in DuckDB, on the files of the job
SELECT slot, signature, timestamp, base_mint, pool
FROM 'ev-admin_cto_pool_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-admin_cto_pool_event
fields: timestamp i64, base_mint base58 string, pool base58 string, old_coin_creator base58 string, new_coin_creator base58 string, is_holder_reward bool, is_cashback_coin bool, old_creator_fee_bps u64, new_creator_fee_bps u64
ev-admin_update_token_incentives_event
fields: start_time i64, end_time i64, day_number u64, token_supply_per_day u64, mint base58 string, seconds_in_a_day i64, timestamp i64
ev-boost_buy_and_burn_event
fields: timestamp i64, mint base58 string, bonding_curve base58 string, pool base58 string, authority base58 string, quote_amount_in_requested u64, quote_amount_in_used u64, base_amount_burned u64, virtual_quote_reserves decimal string, real_quote_reserves_after u64, base_reserves_after u64, boost_vault_remaining u64
ev-buy_event
fields: timestamp i64, base_amount_out u64, max_quote_amount_in u64, user_base_token_reserves u64, user_quote_token_reserves u64, pool_base_token_reserves u64, pool_quote_token_reserves u64, quote_amount_in u64, lp_fee_basis_points u64, lp_fee u64, protocol_fee_basis_points u64, protocol_fee u64, quote_amount_in_with_lp_fee u64, user_quote_amount_in u64, pool base58 string, user base58 string, user_base_token_account base58 string, user_quote_token_account base58 string, protocol_fee_recipient base58 string, protocol_fee_recipient_token_account base58 string, coin_creator base58 string, coin_creator_fee_basis_points u64, coin_creator_fee u64, track_volume bool, total_unclaimed_tokens u64, total_claimed_tokens u64, current_sol_volume u64, last_update_timestamp i64, min_base_amount_out u64, ix_name string, cashback_fee_basis_points u64, cashback u64, buyback_fee_basis_points u64, buyback_fee u64, virtual_quote_reserves decimal string, can_boost bool, base_supply u64, holder_rewards_bps u64, holder_rewards u64, creator_fee_unclaimed u64
ev-claim_cashback_event
fields: user base58 string, amount u64, timestamp i64, total_claimed u64, total_cashback_earned u64
ev-claim_token_incentives_event
fields: user base58 string, mint base58 string, amount u64, timestamp i64, total_claimed_tokens u64, current_sol_volume u64
ev-close_user_volume_accumulator_event
fields: user base58 string, timestamp i64, total_unclaimed_tokens u64, total_claimed_tokens u64, current_sol_volume u64, last_update_timestamp i64
ev-collect_coin_creator_fee_event
fields: timestamp i64, coin_creator base58 string, coin_creator_fee u64, coin_creator_vault_ata base58 string, coin_creator_token_account base58 string
ev-create_config_event
fields: timestamp i64, admin base58 string, lp_fee_basis_points u64, protocol_fee_basis_points u64, protocol_fee_recipients JSON string, coin_creator_fee_basis_points u64, admin_set_coin_creator_authority base58 string
ev-create_pool_event
fields: timestamp i64, index u16, creator base58 string, base_mint base58 string, quote_mint base58 string, base_mint_decimals u8, quote_mint_decimals u8, base_amount_in u64, quote_amount_in u64, pool_base_amount u64, pool_quote_amount u64, minimum_liquidity u64, initial_liquidity u64, lp_token_amount_out u64, pool_bump u8, pool base58 string, lp_mint base58 string, user_base_token_account base58 string, user_quote_token_account base58 string, coin_creator base58 string, is_mayhem_mode bool, creator_fee_bps u64, can_edit_creator_fee bool, is_holder_reward bool
ev-deposit_event
fields: timestamp i64, lp_token_amount_out u64, max_base_amount_in u64, max_quote_amount_in u64, user_base_token_reserves u64, user_quote_token_reserves u64, pool_base_token_reserves u64, pool_quote_token_reserves u64, base_amount_in u64, quote_amount_in u64, lp_mint_supply u64, pool base58 string, user base58 string, user_base_token_account base58 string, user_quote_token_account base58 string, user_pool_token_account base58 string
ev-disable_event
fields: timestamp i64, admin base58 string, disable_create_pool bool, disable_deposit bool, disable_withdraw bool, disable_buy bool, disable_sell bool
ev-extend_account_event
fields: timestamp i64, account base58 string, user base58 string, current_size u64, new_size u64
ev-init_boost_event
fields: timestamp i64, mint base58 string, bonding_curve base58 string, pool base58 string, virtual_quote_reserves decimal string, real_quote_reserves_after u64
ev-init_user_volume_accumulator_event
fields: payer base58 string, user base58 string, timestamp i64
ev-migrate_pool_coin_creator_event
fields: timestamp i64, base_mint base58 string, pool base58 string, sharing_config base58 string, old_coin_creator base58 string, new_coin_creator base58 string
ev-reserved_fee_recipients_event
fields: timestamp i64, reserved_fee_recipient base58 string, reserved_fee_recipients JSON string
ev-sell_event
fields: timestamp i64, base_amount_in u64, min_quote_amount_out u64, user_base_token_reserves u64, user_quote_token_reserves u64, pool_base_token_reserves u64, pool_quote_token_reserves u64, quote_amount_out u64, lp_fee_basis_points u64, lp_fee u64, protocol_fee_basis_points u64, protocol_fee u64, quote_amount_out_without_lp_fee u64, user_quote_amount_out u64, pool base58 string, user base58 string, user_base_token_account base58 string, user_quote_token_account base58 string, protocol_fee_recipient base58 string, protocol_fee_recipient_token_account base58 string, coin_creator base58 string, coin_creator_fee_basis_points u64, coin_creator_fee u64, cashback_fee_basis_points u64, cashback u64, buyback_fee_basis_points u64, buyback_fee u64, virtual_quote_reserves decimal string, can_boost bool, base_supply u64, holder_rewards_bps u64, holder_rewards u64, creator_fee_unclaimed u64
ev-set_bonding_curve_coin_creator_event
fields: timestamp i64, base_mint base58 string, pool base58 string, bonding_curve base58 string, coin_creator base58 string
ev-set_boost_authority_event
fields: timestamp i64, admin base58 string, old_boost_authority base58 string, new_boost_authority base58 string
ev-set_metaplex_coin_creator_event
fields: timestamp i64, base_mint base58 string, pool base58 string, metadata base58 string, coin_creator base58 string
ev-sweep_pool_fee_event
fields: timestamp i64, pool base58 string, base_mint base58 string, quote_mint base58 string, recipient base58 string, payer base58 string, amount u64, bucket u8
ev-sync_user_volume_accumulator_event
fields: user base58 string, total_claimed_tokens_before u64, total_claimed_tokens_after u64, timestamp i64
ev-update_admin_event
fields: timestamp i64, admin base58 string, new_admin base58 string
ev-update_creator_fee_config_event
fields: timestamp i64, admin base58 string, creator_fee_configurable bool, max_configurable_creator_fee_bps u64
ev-update_fee_config_event
fields: timestamp i64, admin base58 string, lp_fee_basis_points u64, protocol_fee_basis_points u64, protocol_fee_recipients JSON string, coin_creator_fee_basis_points u64, admin_set_coin_creator_authority base58 string
ev-withdraw_event
fields: timestamp i64, lp_token_amount_in u64, min_base_amount_out u64, min_quote_amount_out u64, user_base_token_reserves u64, user_quote_token_reserves u64, pool_base_token_reserves u64, pool_quote_token_reserves u64, base_amount_out u64, quote_amount_out u64, lp_mint_supply u64, pool base58 string, user base58 string, user_base_token_account base58 string, user_quote_token_account base58 string, user_pool_token_account base58 string

Instruction 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-admin_cto_pool
accounts: payer, global_config, pool, pool_authority, system_program, event_authority, program
args: coin_creator base58 string, is_holder_reward bool, creator_fee_bps u64
ix-admin_update_token_incentives
accounts: admin, global_config, global_volume_accumulator, mint, global_incentive_token_account, associated_token_program, system_program, token_program, event_authority, program
args: start_time i64, end_time i64, seconds_in_a_day i64, day_number u64, token_supply_per_day u64
ix-boost_buy_and_burn
accounts: pool, authority, global_config, base_mint, quote_mint, pool_base_token_account, pool_quote_token_account, boost_vault_authority, boost_vault, base_token_program, quote_token_program, event_authority, program
args: quote_amount_in u64, min_base_amount_burned u64
ix-buy
accounts: pool, user, global_config, base_mint, quote_mint, user_base_token_account, user_quote_token_account, pool_base_token_account, pool_quote_token_account, protocol_fee_recipient, protocol_fee_recipient_token_account, base_token_program, quote_token_program, system_program, associated_token_program, event_authority, program, coin_creator_vault_ata, coin_creator_vault_authority, global_volume_accumulator, user_volume_accumulator, fee_config, fee_program
args: base_amount_out u64, max_quote_amount_in u64, track_volume JSON string
ix-buy_exact_quote_in
accounts: pool, user, global_config, base_mint, quote_mint, user_base_token_account, user_quote_token_account, pool_base_token_account, pool_quote_token_account, protocol_fee_recipient, protocol_fee_recipient_token_account, base_token_program, quote_token_program, system_program, associated_token_program, event_authority, program, coin_creator_vault_ata, coin_creator_vault_authority, global_volume_accumulator, user_volume_accumulator, fee_config, fee_program
args: spendable_quote_in u64, min_base_amount_out u64, track_volume JSON string
ix-buy_exact_quote_in_v2
accounts: pool, user, global_config, base_mint, quote_mint, user_base_token_account, user_quote_token_account, pool_base_token_account, pool_quote_token_account, base_token_program, quote_token_program, system_program, user_volume_accumulator, fee_config, buyback_fee_recipient, event_authority, program
args: spendable_quote_in u64, min_base_amount_out u64
ix-buy_v2
accounts: pool, user, global_config, base_mint, quote_mint, user_base_token_account, user_quote_token_account, pool_base_token_account, pool_quote_token_account, base_token_program, quote_token_program, system_program, user_volume_accumulator, fee_config, buyback_fee_recipient, event_authority, program
args: base_amount_out u64, max_quote_amount_in u64
ix-claim_cashback
accounts: user, user_volume_accumulator, quote_mint, quote_token_program, user_volume_accumulator_wsol_token_account, user_wsol_token_account, system_program, event_authority, program
ix-claim_token_incentives
accounts: user, user_ata, global_volume_accumulator, global_incentive_token_account, user_volume_accumulator, mint, token_program, system_program, associated_token_program, event_authority, program, payer
ix-close_user_volume_accumulator
accounts: user, user_volume_accumulator, event_authority, program
ix-collect_coin_creator_fee
accounts: quote_mint, quote_token_program, coin_creator, coin_creator_vault_authority, coin_creator_vault_ata, coin_creator_token_account, event_authority, program
ix-create_config
accounts: admin, global_config, system_program, event_authority, program
args: lp_fee_basis_points u64, protocol_fee_basis_points u64, protocol_fee_recipients JSON string, coin_creator_fee_basis_points u64, admin_set_coin_creator_authority base58 string
ix-create_pool
accounts: pool, global_config, creator, base_mint, quote_mint, lp_mint, user_base_token_account, user_quote_token_account, user_pool_token_account, pool_base_token_account, pool_quote_token_account, system_program, token_2022_program, base_token_program, quote_token_program, associated_token_program, event_authority, program
args: index u16, base_amount_in u64, quote_amount_in u64, coin_creator base58 string, is_mayhem_mode bool, is_cashback_coin JSON string, creator_fee_bps JSON string, can_edit_creator_fee JSON string, is_holder_reward JSON string
ix-deposit
accounts: pool, global_config, user, base_mint, quote_mint, lp_mint, user_base_token_account, user_quote_token_account, user_pool_token_account, pool_base_token_account, pool_quote_token_account, token_program, token_2022_program, event_authority, program
args: lp_token_amount_out u64, max_base_amount_in u64, max_quote_amount_in u64
ix-disable
accounts: admin, global_config, event_authority, program
args: disable_create_pool bool, disable_deposit bool, disable_withdraw bool, disable_buy bool, disable_sell bool
ix-extend_account
accounts: account, user, system_program, event_authority, program
ix-init_boost
accounts: pool, global_config, creator, base_mint, quote_mint, pool_base_token_account, pool_quote_token_account, boost_vault_authority, boost_vault, quote_token_program, system_program, associated_token_program, event_authority, program
ix-init_user_volume_accumulator
accounts: payer, user, user_volume_accumulator, system_program, event_authority, program
ix-migrate_pool_coin_creator
accounts: pool, sharing_config, event_authority, program
ix-multi_hop_swap
accounts: user, user_in_token_account, user_out_token_account, global_config, fee_config, user_volume_accumulator, buyback_fee_recipient, token_program, token_2022_program, system_program, event_authority, program, pump_program, pump_global, pump_fee_config, pump_event_authority
args: amount_in u64, min_amount_out u64
ix-sell
accounts: pool, user, global_config, base_mint, quote_mint, user_base_token_account, user_quote_token_account, pool_base_token_account, pool_quote_token_account, protocol_fee_recipient, protocol_fee_recipient_token_account, base_token_program, quote_token_program, system_program, associated_token_program, event_authority, program, coin_creator_vault_ata, coin_creator_vault_authority, fee_config, fee_program
args: base_amount_in u64, min_quote_amount_out u64
ix-sell_v2
accounts: pool, user, global_config, base_mint, quote_mint, user_base_token_account, user_quote_token_account, pool_base_token_account, pool_quote_token_account, base_token_program, quote_token_program, system_program, user_volume_accumulator, fee_config, buyback_fee_recipient, event_authority, program
args: base_amount_in u64, min_quote_amount_out u64
ix-set_boost_authority
accounts: admin, global_config, boost_authority, system_program, event_authority, program
ix-set_coin_creator
accounts: pool, metadata, bonding_curve, event_authority, program
ix-set_reserved_fee_recipients
accounts: global_config, admin, event_authority, program
args: whitelist_pda base58 string
ix-sweep_creator_fee
accounts: payer, global_config, pool, quote_mint, quote_token_program, pool_quote_token_account, recipient, recipient_token_account, system_program, associated_token_program, event_authority, program
ix-sweep_protocol_fee
accounts: payer, global_config, pool, quote_mint, quote_token_program, pool_quote_token_account, recipient, recipient_token_account, system_program, associated_token_program, event_authority, program
ix-sync_user_volume_accumulator
accounts: user, global_volume_accumulator, user_volume_accumulator, event_authority, program
ix-toggle_boost
accounts: admin, global_config
args: enabled bool
ix-toggle_cashback_enabled
accounts: admin, global_config, event_authority, program
args: enabled bool
ix-toggle_mayhem_mode
accounts: admin, global_config, event_authority, program
args: enabled bool
ix-transfer_creator_fees_to_pump
accounts: wsol_mint, token_program, system_program, associated_token_program, coin_creator, coin_creator_vault_authority, coin_creator_vault_ata, pump_creator_vault, event_authority, program
ix-transfer_creator_fees_to_pump_v2
accounts: payer, quote_mint, token_program, system_program, associated_token_program, coin_creator, coin_creator_vault_authority, coin_creator_vault_ata, pump_creator_vault, pump_creator_vault_ata, event_authority, program
ix-update_admin
accounts: admin, global_config, new_admin, event_authority, program
ix-update_buyback_config
accounts: admin, global_config, event_authority, program
args: buyback_basis_points u64
ix-update_creator_fee_config
accounts: admin, global_config, system_program, event_authority, program
args: creator_fee_configurable bool, max_configurable_creator_fee_bps u64
ix-update_fee_config
accounts: admin, global_config, event_authority, program
args: lp_fee_basis_points u64, protocol_fee_basis_points u64, protocol_fee_recipients JSON string, coin_creator_fee_basis_points u64, admin_set_coin_creator_authority base58 string
ix-withdraw
accounts: pool, global_config, user, base_mint, quote_mint, lp_mint, user_base_token_account, user_quote_token_account, user_pool_token_account, pool_base_token_account, pool_quote_token_account, token_program, token_2022_program, event_authority, program
args: lp_token_amount_in u64, min_base_amount_out u64, min_quote_amount_out u64

Files are split at 2 GB: ix-<name>-tNN-SSSS.parquet. Large integers stay exact: u128 is a decimal string. All decoded types.

Get PumpSwap data for your range.

Select an epoch range and get a firm price. You pay only when you send the job.

Get a price