BitqueryBitqueryData Store
Browse datasets
Solana logoSolanaTradesPoolsTransfersOHLCV

Pump.fun

Every bonding-curve trade, token creation, migration and pool on Pump.fun, plus per-token OHLCV, decoded and USD-priced.

By · Updated

Coverage
Last 12 monthsto Oct 28, 2026 · yesterday
Tables
4Parquet, one prefix each
Columns
137across 4 tables
Coverage ends yesterday, UTC

Overview

Complete historical record of Pump.fun activity on Solana: every bonding-curve trade, every token creation, every migration to PumpSwap or Raydium, and per-token candles.

Trades are decoded from the Pump.fun program instructions and priced in USD at block time. Creations and migrations sit in one table keyed by the program method (create_v2, migrate, migrate_v2) so you can reconstruct launch cohorts and graduation funnels without touching an RPC.

Use cases

  • Launch-to-graduation funnel analysis across creator cohorts
  • Sniper and bundler detection using slot-level ordering
  • Bonding-curve price impact and slippage modelling
  • Backtesting memecoin momentum strategies

4 tables

137 columns · free sample for each table

pumpfun_trades

82 columns

One row per bonding-curve buy or sell, with both legs of the trade and USD pricing.

solana/dex_trades/pumpfun<start_slot>_<end_slot>.parquet50 slots per file
Browse columns Sample fileSample updated Apr 7, 2026

pumpfun_creation_migrations

16 columns

Token creations and migrations in one table, distinguished by Instruction_Program_Method.

solana/pumpfun_creation_migrations<YYYY-MM-DD>.parquetone file per day
Browse columns Sample fileSample updated Jul 17, 2026

pumpfun_dex_pools

28 columns

Pool registry for graduated tokens on PumpSwap.

Pumpfun_Sample/dex_poolsone file per pool snapshot
Browse columns Sample fileSample updated Jul 21, 2026

pumpfun_ohlcv

11 columns

Per-token 1-minute candles in USD.

Pumpfun_Sample/ohlcv<MintAddress>.parquetone file per token
Browse columns Sample fileSample updated Jul 21, 2026

Schema reference

copies a column name
137 columns
pumpfun_trades82 columnsOne row per bonding-curve buy or sell, with both legs of the trade and USD pricing.
ColumnTypeDescription
Block4
Block_DateDateUTC date of the block
Block_HeightUInt64Block height
Block_SlotUInt64Solana slot
Block_TimeDateTimeBlock time, UTC (Parquet timestamp in microseconds; the file stores no time zone)
Instruction7
Instruction_CallPathArrayIndices of the parent instructions
Instruction_ExternalSeqNumberUInt32Instruction external seq number
Instruction_IndexUInt32Instruction index in the transaction
Instruction_InternalSeqNumberUInt32Instruction internal seq number
Instruction_Program_AddressStringProgram address
Instruction_Program_MethodStringDecoded method name
Instruction_Program_NameStringDecoded program name
Trade_Buy29
Trade_Buy_Account_AddressStringTrade buy account address
Trade_Buy_Account_Token_OwnerStringTrade buy account token owner
Trade_Buy_AmountDecimalAmount bought, decimal adjusted
Trade_Buy_AmountInUSDFloat64Amount bought in USD
Trade_Buy_Currency_CollectionAddressStringTrade buy currency collection address
Trade_Buy_Currency_DecimalsUInt32Decimals of the bought currency
Trade_Buy_Currency_EditionNonceUInt32Trade buy currency edition nonce
Trade_Buy_Currency_FungibleBoolTrade buy currency fungible
Trade_Buy_Currency_MetadataAddressStringTrade buy currency metadata address
Trade_Buy_Currency_MintAddressStringMint of the bought currency
Trade_Buy_Currency_NameStringName of the bought currency
Trade_Buy_Currency_ProgramAddressStringTrade buy currency program address
Trade_Buy_Currency_SellerFeeBasisPointsUInt32Trade buy currency seller fee basis points
Trade_Buy_Currency_SymbolStringSymbol of the bought currency
Trade_Buy_Currency_TokenCreator_AddressArrayTrade buy currency token creator address
Trade_Buy_Currency_TokenStandardStringTrade buy currency token standard
Trade_Buy_Currency_UriStringTrade buy currency uri
Trade_Buy_Currency_UpdateAuthorityStringTrade buy currency update authority
Trade_Buy_Currency_VerifiedCollectionBoolTrade buy currency verified collection
Trade_Buy_Order_AccountStringTrade buy order account
Trade_Buy_Order_BuySideBoolTrade buy order buy side
Trade_Buy_Order_LimitAmountUInt64Trade buy order limit amount
Trade_Buy_Order_LimitPriceUInt64Trade buy order limit price
Trade_Buy_Order_MintStringTrade buy order mint
Trade_Buy_Order_OrderIdStringTrade buy order order id
Trade_Buy_Order_OwnerStringTrade buy order owner
Trade_Buy_Order_PayerStringTrade buy order payer
Trade_Buy_PriceFloat64Price of the bought currency in units of the sold currency
Trade_Buy_PriceInUSDFloat64Price of the bought currency in USD
Trade_Dex3
Trade_Dex_ProgramAddressStringDEX program address
Trade_Dex_ProtocolFamilyStringDEX protocol family, e.g. Uniswap, Pumpfun
Trade_Dex_ProtocolNameStringDEX protocol name and version
Trade3
Trade_IndexUInt32Trade index within the transaction
Trade_Market_MarketAddressStringMarket / pool address
Trade_PriceAsymmetryFloat64Relative difference between buy and sell side USD values
Trade_Sell29
Trade_Sell_Account_AddressStringTrade sell account address
Trade_Sell_Account_Token_OwnerStringTrade sell account token owner
Trade_Sell_AmountDecimalAmount sold, decimal adjusted
Trade_Sell_AmountInUSDFloat64Amount sold in USD
Trade_Sell_Currency_CollectionAddressStringTrade sell currency collection address
Trade_Sell_Currency_DecimalsUInt32Decimals of the sold currency
Trade_Sell_Currency_EditionNonceUInt32Trade sell currency edition nonce
Trade_Sell_Currency_FungibleBoolTrade sell currency fungible
Trade_Sell_Currency_MetadataAddressStringTrade sell currency metadata address
Trade_Sell_Currency_MintAddressStringMint of the sold currency
Trade_Sell_Currency_NameStringName of the sold currency
Trade_Sell_Currency_ProgramAddressStringTrade sell currency program address
Trade_Sell_Currency_SellerFeeBasisPointsUInt32Trade sell currency seller fee basis points
Trade_Sell_Currency_SymbolStringSymbol of the sold currency
Trade_Sell_Currency_TokenCreator_AddressArrayTrade sell currency token creator address
Trade_Sell_Currency_TokenStandardStringTrade sell currency token standard
Trade_Sell_Currency_UriStringTrade sell currency uri
Trade_Sell_Currency_UpdateAuthorityStringTrade sell currency update authority
Trade_Sell_Currency_VerifiedCollectionBoolTrade sell currency verified collection
Trade_Sell_Order_AccountStringTrade sell order account
Trade_Sell_Order_BuySideBoolTrade sell order buy side
Trade_Sell_Order_LimitAmountUInt64Trade sell order limit amount
Trade_Sell_Order_LimitPriceUInt64Trade sell order limit price
Trade_Sell_Order_MintStringTrade sell order mint
Trade_Sell_Order_OrderIdStringTrade sell order order id
Trade_Sell_Order_OwnerStringTrade sell order owner
Trade_Sell_Order_PayerStringTrade sell order payer
Trade_Sell_PriceFloat64Price of the sold currency in units of the bought currency
Trade_Sell_PriceInUSDFloat64Price of the sold currency in USD
Transaction7
Transaction_FeeDecimalTransaction fee in the native currency
Transaction_FeeInUSDFloat64Transaction fee in USD
Transaction_FeePayerStringFee payer
Transaction_IndexUInt32Position of the transaction in the block
Transaction_Result_SuccessBool1 if the transaction succeeded
Transaction_SignatureStringTransaction signature (base58)
Transaction_SignerStringTransaction signer
Sample file
pumpfun_creation_migrations16 columnsToken creations and migrations in one table, distinguished by Instruction_Program_Method.
ColumnTypeDescription
Transaction_SignatureStringTransaction signature (base58)
Transaction_SignerStringTransaction signer
Instruction_Program_MethodStringDecoded method name
Pool_Market_BaseCurrency_MintAddressStringPool market base currency mint address
Pool_Market_BaseCurrency_NameStringPool market base currency name
Pool_Market_BaseCurrency_TokenCreators_AddressArrayPool market base currency token creators address
Pool_Market_BaseCurrency_SymbolStringPool market base currency symbol
Pool_Market_BaseCurrency_DecimalsInt32Pool market base currency decimals
Pool_Market_BaseCurrency_FungibleBoolPool market base currency fungible
Pool_Market_BaseCurrency_UriStringPool market base currency uri
Pool_Market_QuoteCurrency_MintAddressStringPool market quote currency mint address
Pool_Market_QuoteCurrency_NameStringPool market quote currency name
Block_SlotInt64Solana slot
Block_TimeStringBlock time, UTC (ISO-8601 string ending in Z)
Transaction_Result_SuccessInt321 if the transaction succeeded (stored as an 8-bit integer)
Indexing_OnTrunkInt321 if the block is on the canonical chain (stored as an 8-bit integer)
Sample file
pumpfun_dex_pools28 columnsPool registry for graduated tokens on PumpSwap.
ColumnTypeDescription
Block2
Block_SlotInt64Solana slot
Block_TimeStringBlock time, UTC (ISO-8601 string ending in Z)
Pool_BaseCurrency6
Pool_BaseCurrency_ChangeAmountDecimalPool base currency change amount, in raw units (integer stored as text)
Pool_BaseCurrency_ChangeAmount_InUSDFloat64Pool base currency change amount in USD
Pool_BaseCurrency_PostAmountDecimalPool base currency post amount, in raw units (integer stored as text)
Pool_BaseCurrency_PriceFloat64Pool base currency price
Pool_BaseCurrency_PostAmount_InUSDFloat64Pool base currency post amount in USD
Pool_BaseCurrency_Price_InUSDFloat64Pool base currency price in USD
Pool_Dex3
Pool_Dex_ProgramAddressStringPool dex program address
Pool_Dex_ProtocolFamilyStringPool dex protocol family
Pool_Dex_ProtocolNameStringPool dex protocol name
Pool_Market5
Pool_Market_BaseCurrency_DecimalsInt32Pool market base currency decimals
Pool_Market_BaseCurrency_MintAddressStringPool market base currency mint address
Pool_Market_MarketAddressStringPool market market address
Pool_Market_QuoteCurrency_DecimalsInt32Pool market quote currency decimals
Pool_Market_QuoteCurrency_MintAddressStringPool market quote currency mint address
Pool_QuoteCurrency6
Pool_QuoteCurrency_ChangeAmountDecimalPool quote currency change amount, in raw units (integer stored as text)
Pool_QuoteCurrency_ChangeAmount_InUSDFloat64Pool quote currency change amount in USD
Pool_QuoteCurrency_PostAmountDecimalPool quote currency post amount, in raw units (integer stored as text)
Pool_QuoteCurrency_PostAmount_InUSDFloat64Pool quote currency post amount in USD
Pool_QuoteCurrency_Price_InUSDFloat64Pool quote currency price in USD
Pool_QuoteCurrency_PriceFloat64Pool quote currency price
PoolEvent1
PoolEvent_IndexInt32Pool event index
Transaction5
Transaction_SignatureStringTransaction signature (base58)
Transaction_SignerStringTransaction signer
Transaction_FeeDecimalTransaction fee in lamports (integer stored as text)
Transaction_Result_SuccessBool1 if the transaction succeeded
Transaction_IndexInt32Position of the transaction in the block
Sample file
pumpfun_ohlcv11 columnsPer-token 1-minute candles in USD.
ColumnTypeDescription
TimeStringCandle start time, UTC (ISO-8601 string ending in Z)
Open_Price_InUSDDecimalOpen price in USD
High_Price_InUSDDecimalHigh price in USD
Low_Price_InUSDDecimalLow price in USD
Close_Price_InUSDDecimalClose price in USD
MintAddressStringToken mint
Side_MintAddressStringQuote token mint
MarketAddressStringMarket address
ProtocolNameStringProtocol name
Volume_InUSDDecimalVolume in USD
Trade_CountInt64Trades in the candle
Sample file

Ask an AI about this data

Send this dataset’s full schema to an assistant and ask it anything. It reads the plain-text brief first, so the answer comes from the real column list rather than a guess.

Start with
Ask Claude Ask ChatGPT

Opens a new chat with the question filled in. Nothing about you is sent to Bitquery, and the assistant sees only the public brief.

Delivery

Parquet files in a Requester Pays S3 bucket or a Cloudflare R2 bucket, chosen at checkout. On S3 you download with your own AWS account and AWS bills the transfer; on R2 you download with a read-only API key and pay no egress. Layout:

# pumpfun_trades: 50 slots per file
solana/dex_trades/pumpfun<start_slot>_<end_slot>.parquet

# pumpfun_creation_migrations: one file per day
solana/pumpfun_creation_migrations<YYYY-MM-DD>.parquet

# pumpfun_dex_pools: one file per pool snapshot
Pumpfun_Sample/dex_pools

# pumpfun_ohlcv: one file per token
Pumpfun_Sample/ohlcv<MintAddress>.parquet
  1. Download a free sampleNo email needed.
  2. Pay nowName, work email and licence check.
  3. Pay the invoiceBy card or bank transfer.
  4. Download from S3 or R2The team prepares the export and emails the bucket path, plus a read-only API key for R2 orders.

Need new data after your purchase?

Kafka Streams sends new Solana data in real time, so your copy can stay current after the files end. It is sold on an Enterprise plan.

Read the Kafka docs

Time windows

Every window includes all 4 tables and 137 columns. Only the time range changes.

30 days
Latest month
Sep 28, 2026 → Oct 28, 2026
$300
Pay now
183 days
Last 6 months
Apr 28, 2026 → Oct 28, 2026
$1,500
Pay now
365 days
Last 12 months
Oct 28, 2025 → Oct 28, 2026
$3,000
Pay now
In every window
  • All 4 tables, 137 columns
  • Parquet files in the layout under Delivery
  • S3 or R2 download, chosen at checkout
  • Licensed under the Data License

FAQ

5 questions
What is included in Pump.fun?

Four Parquet tables: pumpfun_trades, pumpfun_creation_migrations, pumpfun_dex_pools and pumpfun_ohlcv, with 137 documented columns. Pump.fun transactions from a year ago to yesterday, refreshed daily.

How is the data delivered?

As flat Parquet files under a stable layout, one prefix per table, with a JSON manifest listing every file and its sha256. We prepare the files within 7 business days of purchase and email you the location. You choose at checkout where to collect them: a Requester Pays S3 bucket, downloaded with your own AWS account, or a Cloudflare R2 bucket with a read-only API key and no egress fees. Files stay available for 7 days from delivery.

How current is the data?

Refreshed daily with T+1 latency. A purchase made today includes everything up to yesterday.

Can I try before I buy?

Yes. Every table links to a public sample file with real records, and the sample bucket holds full Parquet files you can load directly. No email address required.

Are migrations to PumpSwap and Raydium included?

Yes. Creations and migrations sit in pumpfun_creation_migrations, distinguished by Instruction_Program_Method: create_v2 for launches, migrate and migrate_v2 for graduations.

Related datasets

All datasets
Solana logoSolanaLast 12 months

Solana DEX Trades and Pools

Every swap and every pool event across every indexed DEX program on Solana, in one schema, decoded and USD-priced at block time.

TradesPools
Tables
2
Columns
146
From
$600
Polymarket logoPolymarketFull history · daily

Polymarket

Polymarket fills, position splits, merges and payouts, and market results on Polygon since September 2025, with market titles, outcomes and USD values.

TradesEvents
Tables
3
Rows
≈1.8B
From
$400
Solana logoSolanaLast 12 months

Pump.fun Token Registry

Every Pump.fun token launched since October 2025, with its creator, name, symbol and URI at launch, every graduation to PumpSwap, and per-creator launch records.

EventsPools
Tables
3
Rows
≈30M
From
$100

Need a custom window, extra tables or CSV?

Tell us the chain, tables and date range.

Request a custom cut