Trawl
Menu
Get a price
Launchpad

Pump.fun historical data as Parquet

Every Pump.fun instruction and event in Solana history, decoded with an Anchor IDL that we checked against real transactions. Trawl gives you 32 event tables and 56 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
6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P
Preset
pumpfun
Tables
32 event tables and 56 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 SOL a trade moved is in ev-trade_event; buy and sell hold only the limits.

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":"pumpfun","start_epoch":1058,"end_epoch":1058}'

-- then, in DuckDB, on the files of the job
SELECT slot, signature, mint, sol_amount, token_amount
FROM 'ev-trade_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-add_quote_control_mint_event
fields: quote_control base58 string, authority base58 string, quote_mint base58 string, initial_virtual_quote_reserves u64, timestamp i64
ev-admin_cto_event
fields: timestamp i64, authority base58 string, mint base58 string, bonding_curve base58 string, old_creator base58 string, new_creator base58 string, is_holder_reward bool, is_cashback_coin bool, old_creator_fee_bps u64, new_creator_fee_bps u64, sharing_config_reset bool, swept_to_holder_vault u64, pool_updated bool
ev-admin_set_idl_authority_event
fields: idl_authority base58 string
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-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_creator_fee_event
fields: timestamp i64, creator base58 string, creator_fee u64, quote_mint base58 string
ev-complete_event
fields: user base58 string, mint base58 string, bonding_curve base58 string, timestamp i64, quote_mint base58 string
ev-complete_pump_amm_migration_event
fields: user base58 string, mint base58 string, mint_amount u64, sol_amount u64, pool_migration_fee u64, bonding_curve base58 string, timestamp i64, pool base58 string, quote_mint base58 string
ev-create_event
fields: name string, symbol string, uri string, mint base58 string, bonding_curve base58 string, user base58 string, creator base58 string, timestamp i64, virtual_token_reserves u64, virtual_sol_reserves u64, real_token_reserves u64, token_total_supply u64, token_program base58 string, is_mayhem_mode bool, is_cashback_enabled bool, quote_mint base58 string, virtual_quote_reserves u64, creator_fee_bps u64, is_holder_reward bool, depth u8
ev-distribute_creator_fees_event
fields: timestamp i64, mint base58 string, bonding_curve base58 string, sharing_config base58 string, admin base58 string, shareholders JSON string, distributed u64, quote_mint base58 string
ev-distribute_fee_to_holders_event
fields: timestamp i64, mint base58 string, quote_mint base58 string, recipients u64, total u64
ev-extend_account_event
fields: account base58 string, user base58 string, current_size u64, new_size u64, timestamp i64
ev-init_user_volume_accumulator_event
fields: payer base58 string, user base58 string, timestamp i64
ev-migrate_bonding_curve_creator_event
fields: timestamp i64, mint base58 string, bonding_curve base58 string, sharing_config base58 string, old_creator base58 string, new_creator base58 string
ev-minimum_distributable_fee_event
fields: minimum_required u64, distributable_fees u64, can_distribute bool
ev-post_complete_buy_event
fields: user base58 string, mint base58 string, bonding_curve base58 string, quote_mint base58 string, timestamp i64, base_out u64, quote_in u64, fee_basis_points u64, field_fee u64, creator_fee_basis_points u64, creator_fee u64, buyback_fee u64, pool_base_reserves_before u64, pool_quote_reserves_before u64, pool_base_reserves_after u64, pool_quote_reserves_after u64
ev-remove_quote_control_mint_event
fields: quote_control base58 string, authority base58 string, quote_mint base58 string, timestamp i64
ev-reserved_fee_recipients_event
fields: timestamp i64, reserved_fee_recipient base58 string, reserved_fee_recipients JSON string
ev-set_creator_event
fields: timestamp i64, mint base58 string, bonding_curve base58 string, creator base58 string
ev-set_metaplex_creator_event
fields: timestamp i64, mint base58 string, bonding_curve base58 string, metadata base58 string, creator base58 string
ev-set_params_event
fields: initial_virtual_token_reserves u64, initial_virtual_sol_reserves u64, initial_real_token_reserves u64, final_real_sol_reserves u64, token_total_supply u64, fee_basis_points u64, withdraw_authority base58 string, enable_migrate bool, pool_migration_fee u64, creator_fee_basis_points u64, fee_recipients JSON string, timestamp i64, set_creator_authority base58 string, admin_set_creator_authority base58 string
ev-set_quote_control_admin_event
fields: quote_control base58 string, authority base58 string, old_admin base58 string, new_admin base58 string, timestamp i64
ev-set_quote_control_mint_reserves_event
fields: quote_control base58 string, authority base58 string, quote_mint base58 string, old_initial_virtual_quote_reserves u64, new_initial_virtual_quote_reserves u64, timestamp i64
ev-set_quote_control_reserves_admin_event
fields: quote_control base58 string, authority base58 string, old_reserves_admin base58 string, new_reserves_admin base58 string, timestamp i64
ev-sweep_bonding_curve_fee_event
fields: timestamp i64, mint base58 string, bonding_curve base58 string, quote_mint base58 string, recipient 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-trade_event
fields: mint base58 string, sol_amount u64, token_amount u64, is_buy bool, user base58 string, timestamp i64, virtual_sol_reserves u64, virtual_token_reserves u64, real_sol_reserves u64, real_token_reserves u64, fee_recipient base58 string, fee_basis_points u64, field_fee u64, creator base58 string, creator_fee_basis_points u64, creator_fee u64, track_volume bool, total_unclaimed_tokens u64, total_claimed_tokens u64, current_sol_volume u64, last_update_timestamp i64, ix_name string, mayhem_mode bool, cashback_fee_basis_points u64, cashback u64, buyback_fee_basis_points u64, buyback_fee u64, shareholders JSON string, quote_mint base58 string, quote_amount u64, virtual_quote_reserves u64, real_quote_reserves u64, holder_rewards_bps u64, holder_rewards u64, creator_fee_unclaimed u64
ev-update_creator_fee_config_event
fields: timestamp i64, authority base58 string, creator_fee_configurable bool, max_configurable_creator_fee_bps u64
ev-update_global_authority_event
fields: global base58 string, authority base58 string, new_authority base58 string, timestamp i64
ev-update_mayhem_virtual_params_event
fields: timestamp i64, mint base58 string, virtual_token_reserves u64, virtual_sol_reserves u64, new_virtual_token_reserves u64, new_virtual_sol_reserves u64, real_token_reserves u64, real_sol_reserves u64

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-add_quote_control_mint
accounts: authority, global, quote_control, system_program, event_authority, program
args: quote_mint base58 string, initial_virtual_quote_reserves u64
ix-add_quote_mint
accounts: global, authority, event_authority, program
args: quote_mint base58 string
ix-admin_cto
accounts: admin_set_creator_authority, global, mint, quote_mint, quote_token_program, associated_token_program, system_program, bonding_curve, current_creator, current_creator_quote_token_account, creator_vault, creator_vault_quote_token_account, holder_creator_vault, holder_creator_vault_quote_token_account, pump_amm, amm_global_config, pool_authority, pool, pump_amm_event_authority, coin_creator_vault_authority, coin_creator_vault_ata, sharing_config, pump_fees, pump_fees_event_authority, event_authority, program
args: is_holder_reward bool, creator_fee_bps u64, new_creator base58 string
ix-admin_set_idl_authority
accounts: authority, global, idl_account, system_program, program_signer, event_authority, program
args: idl_authority base58 string
ix-admin_update_token_incentives
accounts: authority, global, 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, pump_token_supply_per_day u64
ix-buy
accounts: global, fee_recipient, mint, bonding_curve, associated_bonding_curve, associated_user, user, system_program, token_program, creator_vault, event_authority, program, global_volume_accumulator, user_volume_accumulator, fee_config, fee_program
args: amount u64, max_sol_cost u64, track_volume JSON string, partial_fill JSON string
ix-buy_exact_quote_in_v2
accounts: global, base_mint, quote_mint, base_token_program, quote_token_program, associated_token_program, fee_recipient, associated_quote_fee_recipient, buyback_fee_recipient, associated_quote_buyback_fee_recipient, bonding_curve, associated_base_bonding_curve, associated_quote_bonding_curve, user, associated_base_user, associated_quote_user, creator_vault, associated_creator_vault, sharing_config, global_volume_accumulator, user_volume_accumulator, associated_user_volume_accumulator, fee_config, fee_program, system_program, event_authority, program
args: spendable_quote_in u64, min_tokens_out u64, partial_fill JSON string
ix-buy_exact_quote_in_v3
accounts: global, base_mint, quote_mint, base_token_program, quote_token_program, bonding_curve, associated_base_bonding_curve, associated_quote_bonding_curve, user, associated_base_user, associated_quote_user, user_volume_accumulator, fee_config, buyback_fee_recipient, system_program, event_authority, program
args: spendable_quote_in u64, min_tokens_out u64, partial_fill JSON string
ix-buy_exact_sol_in
accounts: global, fee_recipient, mint, bonding_curve, associated_bonding_curve, associated_user, user, system_program, token_program, creator_vault, event_authority, program, global_volume_accumulator, user_volume_accumulator, fee_config, fee_program
args: spendable_sol_in u64, min_tokens_out u64, track_volume JSON string, partial_fill JSON string
ix-buy_v2
accounts: global, base_mint, quote_mint, base_token_program, quote_token_program, associated_token_program, fee_recipient, associated_quote_fee_recipient, buyback_fee_recipient, associated_quote_buyback_fee_recipient, bonding_curve, associated_base_bonding_curve, associated_quote_bonding_curve, user, associated_base_user, associated_quote_user, creator_vault, associated_creator_vault, sharing_config, global_volume_accumulator, user_volume_accumulator, associated_user_volume_accumulator, fee_config, fee_program, system_program, event_authority, program
args: amount u64, max_sol_cost u64, partial_fill JSON string
ix-buy_v3
accounts: global, base_mint, quote_mint, base_token_program, quote_token_program, bonding_curve, associated_base_bonding_curve, associated_quote_bonding_curve, user, associated_base_user, associated_quote_user, user_volume_accumulator, fee_config, buyback_fee_recipient, system_program, event_authority, program
args: amount u64, max_sol_cost u64, partial_fill JSON string
ix-claim_cashback
accounts: user, user_volume_accumulator, system_program, event_authority, program
ix-claim_cashback_v2
accounts: user, user_volume_accumulator, quote_mint, quote_token_program, associated_token_program, associated_user_volume_accumulator, associated_quote_user, 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_creator_fee
accounts: creator, creator_vault, system_program, event_authority, program
ix-collect_creator_fee_v2
accounts: creator, creator_token_account, creator_vault, creator_vault_token_account, quote_mint, quote_token_program, associated_token_program, system_program, event_authority, program
ix-create
accounts: mint, mint_authority, bonding_curve, associated_bonding_curve, global, mpl_token_metadata, metadata, user, system_program, token_program, associated_token_program, rent, event_authority, program
args: name string, symbol string, uri string, creator base58 string
ix-create_v2
accounts: mint, mint_authority, bonding_curve, associated_bonding_curve, global, user, system_program, token_program, associated_token_program, mayhem_program_id, global_params, sol_vault, mayhem_state, mayhem_token_vault, event_authority, program
args: name string, symbol string, uri string, creator base58 string, is_mayhem_mode bool, is_cashback_enabled JSON string, creator_fee_bps JSON string, is_holder_reward JSON string
ix-distribute_creator_fees
accounts: mint, bonding_curve, sharing_config, creator_vault, system_program, event_authority, program
ix-distribute_creator_fees_v2
accounts: payer, mint, bonding_curve, sharing_config, creator_vault, system_program, event_authority, program, creator_vault_quote_token_account, quote_mint, quote_token_program, associated_token_program
args: initialize_ata bool
ix-distribute_fee_to_holders
accounts: global, holder_reward_claim_authority, mint, holder_rewards, holder_rewards_token_account, quote_mint, quote_token_program, associated_token_program, system_program, event_authority, program
args: amounts JSON string
ix-extend_account
accounts: account, user, system_program, event_authority, program
ix-get_minimum_distributable_fee
accounts: mint, bonding_curve, sharing_config, creator_vault
ix-init_user_volume_accumulator
accounts: payer, user, user_volume_accumulator, system_program, event_authority, program
ix-initialize
accounts: global, user, system_program
ix-initialize_quote_control
accounts: quote_control, user, system_program
ix-migrate
accounts: global, withdraw_authority, mint, bonding_curve, associated_bonding_curve, user, system_program, token_program, pump_amm, pool, pool_authority, pool_authority_mint_account, pool_authority_wsol_account, amm_global_config, wsol_mint, lp_mint, user_pool_token_account, pool_base_token_account, pool_quote_token_account, token_2022_program, associated_token_program, pump_amm_event_authority, event_authority, program, rent
ix-migrate_bonding_curve_creator
accounts: mint, bonding_curve, sharing_config, event_authority, program
ix-migrate_v2
accounts: global, withdraw_authority, base_mint, quote_mint, bonding_curve, associated_base_bonding_curve, associated_quote_bonding_curve, user, system_program, pump_amm, pool, pool_authority, pool_authority_mint_account, pool_authority_quote_account, amm_global_config, lp_mint, user_pool_token_account, pool_base_token_account, pool_quote_token_account, base_token_program, quote_token_program, token_2022_program, associated_token_program, pump_amm_event_authority, rent, event_authority, program
ix-multi_hop_curve_swap
accounts: global, fee_config, pump_amm_global_config, user, source_authority, source, destination, buyback_fee_recipient, token_program, token_2022_program, system_program, event_authority, program
args: amount_in u64, hop_fees binary
ix-remove_quote_control_mint
accounts: authority, global, quote_control, system_program, event_authority, program
args: quote_mint base58 string
ix-remove_quote_mint
accounts: global, authority, event_authority, program
args: quote_mint base58 string
ix-sell
accounts: global, fee_recipient, mint, bonding_curve, associated_bonding_curve, associated_user, user, system_program, creator_vault, token_program, event_authority, program, fee_config, fee_program
args: amount u64, min_sol_output u64
ix-sell_v2
accounts: global, base_mint, quote_mint, base_token_program, quote_token_program, associated_token_program, fee_recipient, associated_quote_fee_recipient, buyback_fee_recipient, associated_quote_buyback_fee_recipient, bonding_curve, associated_base_bonding_curve, associated_quote_bonding_curve, user, associated_base_user, associated_quote_user, creator_vault, associated_creator_vault, sharing_config, user_volume_accumulator, associated_user_volume_accumulator, fee_config, fee_program, system_program, event_authority, program
args: amount u64, min_sol_output u64
ix-sell_v3
accounts: global, base_mint, quote_mint, base_token_program, quote_token_program, bonding_curve, associated_base_bonding_curve, associated_quote_bonding_curve, user, associated_base_user, associated_quote_user, user_volume_accumulator, fee_config, buyback_fee_recipient, system_program, event_authority, program
args: amount u64, min_sol_output u64
ix-set_creator
accounts: set_creator_authority, global, mint, metadata, bonding_curve, event_authority, program
args: creator base58 string
ix-set_max_curve_depth
accounts: global, authority, event_authority, program
args: max_curve_depth u8
ix-set_mayhem_virtual_params
accounts: sol_vault_authority, mayhem_token_vault, mint, global, bonding_curve, token_program, event_authority, program
ix-set_metaplex_creator
accounts: mint, metadata, bonding_curve, event_authority, program
ix-set_params
accounts: global, authority, event_authority, program
args: initial_virtual_token_reserves u64, initial_virtual_sol_reserves u64, initial_real_token_reserves u64, token_total_supply u64, fee_basis_points u64, withdraw_authority base58 string, enable_migrate bool, pool_migration_fee u64, creator_fee_basis_points u64, set_creator_authority base58 string, admin_set_creator_authority base58 string
ix-set_quote_control_admin
accounts: global, authority, quote_control, event_authority, program
args: new_admin base58 string
ix-set_quote_control_mint_reserves
accounts: authority, global, quote_control, event_authority, program
args: quote_mint base58 string, initial_virtual_quote_reserves u64
ix-set_quote_control_reserves_admin
accounts: authority, global, quote_control, event_authority, program
args: new_reserves_admin base58 string
ix-set_reserved_fee_recipients
accounts: global, authority, event_authority, program
args: whitelist_pda base58 string
ix-set_virtual_quote_reserves
accounts: global, authority, event_authority, program
args: initial_virtual_quote_reserves u64
ix-sweep_creator_fee
accounts: payer, global, base_mint, quote_mint, quote_token_program, associated_token_program, system_program, bonding_curve, associated_quote_bonding_curve, recipient, associated_quote_recipient, event_authority, program
ix-sweep_protocol_fee
accounts: payer, global, base_mint, quote_mint, quote_token_program, associated_token_program, system_program, bonding_curve, associated_quote_bonding_curve, recipient, associated_quote_recipient, event_authority, program
ix-sync_user_volume_accumulator
accounts: user, global_volume_accumulator, user_volume_accumulator, event_authority, program
ix-toggle_cashback_enabled
accounts: global, authority, event_authority, program
args: enabled bool
ix-toggle_create_v2
accounts: global, authority, event_authority, program
args: enabled bool
ix-toggle_mayhem_mode
accounts: global, authority, event_authority, program
args: enabled bool
ix-update_buyback_config
accounts: global, authority, event_authority, program
args: buyback_basis_points u64
ix-update_creator_fee_config
accounts: global, authority, event_authority, program
args: creator_fee_configurable bool, max_configurable_creator_fee_bps u64
ix-update_global_authority
accounts: global, authority, new_authority, event_authority, program
ix-update_holder_reward_config
accounts: global, authority, event_authority, program
args: is_holder_reward_enabled bool, holder_reward_claim_authority base58 string

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

Get Pump.fun data for your range.

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

Get a price