pumpfun_v1_solana

Tables

AMM_Buy_instruction

Buy order execution records from Pump.fun’s automated market maker (AMM) on Solana. Contains token swap details including quote amounts, base token outputs, user accounts, and pool state for analyzing meme coin trading activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`associated_token_program`	`STRING`	Program address of the Associated Token Account (ATA) Program on Solana. Base58-encoded Solana public key, consistently ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL.
`base_mint`	`STRING`	Token mint address of the base asset being purchased in the AMM swap. Consistently shows wrapped SOL (So11111111111111111111111111111111111111112) as the base token in Pump.fun transactions.
`base_token_program`	`STRING`	Program address of the Solana Token Program managing the base token account operations. Base58-encoded Solana public key, consistently TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`coin_creator_vault_ata`	`STRING`	Associated token account holding the token creator’s share of proceeds from the Pump.fun AMM pool. This vault accumulates platform fees or creator earnings from trades in the specified token.
`coin_creator_vault_authority`	`STRING`	Solana account address authorized to manage the token creator’s vault that holds fees or reserves. Typically a program-derived address (PDA) controlled by the AMM protocol.
`event_authority`	`STRING`	Account address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
`fee_config`	`STRING`	Configuration account address for fee structure parameters on this AMM (Automated Market Maker) pool. Empty string when default fee configuration is used.
`fee_program`	`STRING`	Address of the program responsible for processing protocol fees on this transaction. Empty string indicates no fee program was invoked for this buy instruction.
`global_config`	`STRING`	Account address storing global protocol configuration parameters. Base58-encoded Solana public key.
`global_volume_accumulator`	`STRING`	Global volume tracking account for the PumpFun protocol that aggregates trading activity across all pools. May be empty if volume tracking is disabled for the transaction.
`pool`	`STRING`	Account address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
`pool_base_token_account`	`STRING`	Associated token account held by the liquidity pool that stores the base token (typically SOL or wrapped SOL). This account receives quote tokens during buy transactions and dispenses base tokens to buyers.
`pool_quote_token_account`	`STRING`	Associated Token Account (ATA) holding the pool’s quote token reserves for the automated market maker (AMM). This is the liquidity pool’s side of the trading pair that users pay with when executing buy instructions.
`program`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`protocol_fee_recipient`	`STRING`	Account address that receives protocol fees from swap transactions. Base58-encoded Solana public key.
`protocol_fee_recipient_token_account`	`STRING`	Token account address where protocol fees are deposited. Base58-encoded Solana public key.
`quote_mint`	`STRING`	Token mint address for the quote currency (typically SOL or stablecoin) in the trading pair. Base58-encoded Solana program address representing the currency being traded against.
`quote_token_program`	`STRING`	Program address of the Solana Token Program managing the quote token account operations. Base58-encoded Solana public key, consistently TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`system_program`	`STRING`	Program address of the Solana System Program. 32-character string of ones representing the native system program identifier.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`user_base_token_account`	`STRING`	Token account address where the user’s base tokens are held. Base58-encoded Solana public key.
`user_quote_token_account`	`STRING`	Token account address where the user’s quote tokens are held. Base58-encoded Solana public key.
`user_volume_accumulator`	`STRING`	Account address tracking cumulative trading volume for this specific user across the protocol. Empty string indicates volume tracking is not enabled for this user.
`base_amount_out`	`BIGNUMERIC`	Amount of base token (typically SOL) received by the user in this buy transaction, denominated in the base token’s smallest unit (lamports for SOL). Values range from millions to hundreds of millions, representing the output side of the swap.
`max_quote_amount_in`	`BIGNUMERIC`	Maximum amount of quote token the user is willing to spend for this buy transaction. Expressed in the smallest denomination of the quote token (typically lamports for SOL).
`track_volume`	`BOOL`	Boolean flag indicating whether this transaction’s volume should be included in protocol-wide volume tracking metrics. Null values suggest volume tracking may not be enforced for all transactions.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

pool	user	program	base_mint	block_slot	quote_mint	global_config	surrogate_key	system_program	transaction_id	base_amount_out	block_timestamp	event_authority	instruction_type	executing_account	instruction_index	transaction_index	base_token_program	remaining_accounts	transaction_signer	max_quote_amount_in	quote_token_program	coin_creator_vault_ata	protocol_fee_recipient	pool_base_token_account	user_base_token_account	associated_token_program	pool_quote_token_account	user_quote_token_account	coin_creator_vault_authority	protocol_fee_recipient_token_account
12NsqH19BThBTKKnUa1tTd7G8UH36H492wm7YJWZvCZ8	4k7DPgc7sNVcCpUnucF9fxcV6VTzKjnqy9Y1ewszqumw	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	So11111111111111111111111111111111111111112	350495005	3WTEnzW7y2knJiBJetMvYBwh2x3ddqJdzNbCVj1SmJyh	ADyA8hdefvWN2dbGGWFotbzWxrAvLW83WG6QCVXvJKqw	350495005-3oxf6yMHSqWqRaCEHYjFipJZQt2X79pNfnc8QA7ifEpRPQb4PuN1a1zQPLTc2r8cxsgFV16XYgfa3aJ7i3Ej6qtw-2	11111111111111111111111111111111	3oxf6yMHSqWqRaCEHYjFipJZQt2X79pNfnc8QA7ifEpRPQb4PuN1a1zQPLTc2r8cxsgFV16XYgfa3aJ7i3Ej6qtw	68882430	2025-07-01T21:48:04.000Z	GS4CU59F31iL7aR2Q8zVS8DRrcRnXX1yjQ66TqNVQnaR	Buy	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	2	44	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	4k7DPgc7sNVcCpUnucF9fxcV6VTzKjnqy9Y1ewszqumw	13570056320	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	GbHsh1R9Jfg7ykMn2su7NFLs3pUdAapo4hSyTyKdWCmS	JCRGumoE9Qi5BBgULTgdgTLjSgkCMSbF62ZZfGs84JeU	FxYWenSeZqpnCMozNkrKV5sZ8NGzQyqm7ZZPC7pPMt9Z	GMHvmuGvPKUjTxuCu3Ps5RJU5eqHXd8CLA9AGZiEZ4K7	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL	3L5uzYGe9fhmayVMXhPHYbsiorA4yzJUA8VfLMZ2rEkg	HsGVRTqo6SdADxH3V7vniQA5112wHSDAWyKwQF6hjL57	8N3GDaZ2iwN65oxVatKTLPNooAVUJTbfiVJ1ahyqwjSk	TAnYHT1PMkcbe5nmbbgJeCUubU3HRKiwJanrfHguLFU
12NsqH19BThBTKKnUa1tTd7G8UH36H492wm7YJWZvCZ8	8wxAPrXzbTSbxFgZMxGDsviCp28HSJgaHu9MwE8Xuosj	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	So11111111111111111111111111111111111111112	350495270	3WTEnzW7y2knJiBJetMvYBwh2x3ddqJdzNbCVj1SmJyh	ADyA8hdefvWN2dbGGWFotbzWxrAvLW83WG6QCVXvJKqw	350495270-3GievicghSV4x8djw5Az6PRJfkxNhSC1qEuin6aoYoCU5d8ibWCYRogHL3b6CkA6Ky7AvLC8dY3ms2extsot4Fxv-2	11111111111111111111111111111111	3GievicghSV4x8djw5Az6PRJfkxNhSC1qEuin6aoYoCU5d8ibWCYRogHL3b6CkA6Ky7AvLC8dY3ms2extsot4Fxv	104335475	2025-07-01T21:49:51.000Z	GS4CU59F31iL7aR2Q8zVS8DRrcRnXX1yjQ66TqNVQnaR	Buy	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	2	299	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	8wxAPrXzbTSbxFgZMxGDsviCp28HSJgaHu9MwE8Xuosj	17859697006	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	GbHsh1R9Jfg7ykMn2su7NFLs3pUdAapo4hSyTyKdWCmS	JCRGumoE9Qi5BBgULTgdgTLjSgkCMSbF62ZZfGs84JeU	FxYWenSeZqpnCMozNkrKV5sZ8NGzQyqm7ZZPC7pPMt9Z	HQA7o4KGwLGvSdDp3HUunHU8akdTZgmunsQCTMDjtcPF	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL	3L5uzYGe9fhmayVMXhPHYbsiorA4yzJUA8VfLMZ2rEkg	HPxRBu6dYzgBUMuCdLiEz9EQBq39CDqMhrMPvxcBcvYE	8N3GDaZ2iwN65oxVatKTLPNooAVUJTbfiVJ1ahyqwjSk	TAnYHT1PMkcbe5nmbbgJeCUubU3HRKiwJanrfHguLFU
12NsqH19BThBTKKnUa1tTd7G8UH36H492wm7YJWZvCZ8	HUJe6pLBeqrD4Jk4BG2MmnfCdMrUECkQsrqWSNhBqYmJ	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	So11111111111111111111111111111111111111112	350494163	3WTEnzW7y2knJiBJetMvYBwh2x3ddqJdzNbCVj1SmJyh	ADyA8hdefvWN2dbGGWFotbzWxrAvLW83WG6QCVXvJKqw	350494163-4T6wWfq8pUXdmoQaWAhegNmHrt1RupuBZ2V2PwQQtaEuEqDQrVHjigBhoDaEX6pi7vwyhEcrXT5W92G1Q8MvQsQh-2	11111111111111111111111111111111	4T6wWfq8pUXdmoQaWAhegNmHrt1RupuBZ2V2PwQQtaEuEqDQrVHjigBhoDaEX6pi7vwyhEcrXT5W92G1Q8MvQsQh	325864801	2025-07-01T21:42:31.000Z	GS4CU59F31iL7aR2Q8zVS8DRrcRnXX1yjQ66TqNVQnaR	Buy	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	2	178	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	HUJe6pLBeqrD4Jk4BG2MmnfCdMrUECkQsrqWSNhBqYmJ	326705859994	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	GbHsh1R9Jfg7ykMn2su7NFLs3pUdAapo4hSyTyKdWCmS	JCRGumoE9Qi5BBgULTgdgTLjSgkCMSbF62ZZfGs84JeU	FxYWenSeZqpnCMozNkrKV5sZ8NGzQyqm7ZZPC7pPMt9Z	sUcYCPSLNqU4pqzyWGugnrDfzKuheSDa4pHbW1XhsNf	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL	3L5uzYGe9fhmayVMXhPHYbsiorA4yzJUA8VfLMZ2rEkg	FiiWF7kxF1DEBFD6vFtbTaV1mJcrR1nAVXzNhhpznDiH	8N3GDaZ2iwN65oxVatKTLPNooAVUJTbfiVJ1ahyqwjSk	TAnYHT1PMkcbe5nmbbgJeCUubU3HRKiwJanrfHguLFU

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pumpfun_v1_solana.AMM_Buy_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AMM_BuyEvent_event

Buy transactions from PumpFun automated market maker (AMM) pools on Solana, capturing token swaps where users purchase base tokens with quote tokens (SOL). Includes swap amounts, liquidity pool reserves, fee breakdowns, and user token balances for analyzing trading volume and liquidity dynamics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`base_amount_out`	`BIGNUMERIC`	Amount of base tokens (meme token) received by the buyer from the swap. Denominated in the token’s smallest unit (similar to lamports for SOL).
`coin_creator`	`STRING`	Creator address of the token associated with this liquidity pool. Consistently shows the default Solana system program address (all ones) across all sample transactions.
`coin_creator_fee`	`BIGNUMERIC`	Fee paid to the original token creator on this buy transaction, denominated in the quote token. Typically zero in these samples, indicating creator fees may be optional or configurable per pool.
`coin_creator_fee_basis_points`	`INT64`	Fee rate for token creator expressed in basis points (hundredths of a percent). Always 0 in sample data, indicating no creator fee currently charged on these buy transactions.
`current_sol_volume`	`BIGNUMERIC`	Cumulative SOL volume traded in the pool at the time of this buy event. Always zero in sample data, suggesting this field may be deprecated or calculated differently in PumpFun’s AMM implementation.
`last_update_timestamp`	`BIGNUMERIC`	Unix timestamp of the most recent pool state update before this event. Always zero in the sample data, indicating this field may be unused or set at transaction finalization.
`lp_fee`	`BIGNUMERIC`	Liquidity provider fee charged on this buy transaction, denominated in the quote token’s smallest unit. Typically 25 basis points (0.25%) of the quote amount.
`lp_fee_basis_points`	`INT64`	Liquidity provider fee rate expressed in basis points (1/100th of a percent). Typically 25 basis points (0.25%) in the sample data.
`max_quote_amount_in`	`BIGNUMERIC`	Maximum quote token amount the user authorized to spend for this buy, including slippage tolerance. Acts as a spending limit to protect against unfavorable price movements during transaction execution.
`pool`	`STRING`	Account address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
`pool_base_token_reserves`	`BIGNUMERIC`	Amount of base tokens (token being traded) held in the automated market maker pool reserves at the time of the buy event. Denominated in the smallest unit of the base token.
`pool_quote_token_reserves`	`BIGNUMERIC`	Reserve balance of quote tokens (typically SOL or USDC) currently held in the liquidity pool. Denominated in the smallest unit of the quote token.
`protocol_fee`	`BIGNUMERIC`	Fee amount paid to the Pump.fun protocol from this buy transaction. Denominated in quote token (typically SOL), calculated as 5 basis points of the quote amount.
`protocol_fee_basis_points`	`INT64`	Fee rate charged by the protocol expressed in basis points (hundredths of a percent). Consistently 5 basis points (0.05%) across all sample transactions.
`protocol_fee_recipient`	`STRING`	Account address that receives protocol fees from swap transactions. Base58-encoded Solana public key.
`protocol_fee_recipient_token_account`	`STRING`	Token account address where protocol fees are deposited. Base58-encoded Solana public key.
`quote_amount_in`	`BIGNUMERIC`	Quote amount (SOL) paid by the user before fees are deducted for this buy transaction. Denominated in lamports (1 SOL = 1,000,000,000 lamports), typically ranging from billions to trillions.
`quote_amount_in_with_lp_fee`	`BIGNUMERIC`	Quote amount paid by the user after liquidity provider fee has been applied (pre-protocol and creator fees). Denominated in the smallest unit of the quote token (typically lamports for SOL).
`timestamp`	`BIGNUMERIC`	Unix timestamp when the event occurred. Seconds since epoch, stored as integer.
`total_claimed_tokens`	`BIGNUMERIC`	Total number of tokens that have been claimed from the pool’s bonding curve by users. Typically zero in Pump.fun buy events as claims occur separately from purchases.
`total_unclaimed_tokens`	`BIGNUMERIC`	Total number of tokens that have been allocated but not yet claimed by users. Remains zero in this PumpFun automated market maker (AMM) context where tokens are instantly delivered.
`track_volume`	`BOOL`	Boolean flag indicating whether this transaction should be counted toward cumulative volume metrics. Typically false for internal or excluded transaction types.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`user_base_token_account`	`STRING`	Token account address where the user’s base tokens are held. Base58-encoded Solana public key.
`user_base_token_reserves`	`BIGNUMERIC`	User’s base token balance in their associated token account after the buy transaction. Denominated in the smallest unit of the base token (similar to lamports for SOL).
`user_quote_amount_in`	`BIGNUMERIC`	Quote token amount deposited by the user including all fees (LP, protocol, and creator fees). Represents the gross input before fee deductions, typically denominated in SOL lamports.
`user_quote_token_account`	`STRING`	Token account address where the user’s quote tokens are held. Base58-encoded Solana public key.
`user_quote_token_reserves`	`BIGNUMERIC`	Token account balance of the user’s quote token (typically SOL) after the buy transaction completes. Denominated in the smallest unit of the quote token (lamports for SOL).

Sample Data

pool	user	lp_fee	timestamp	block_slot	coin_creator	protocol_fee	track_volume	surrogate_key	transaction_id	base_amount_out	block_timestamp	quote_amount_in	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	lp_fee_basis_points	max_quote_amount_in	user_quote_amount_in	protocol_fee_recipient	outer_executing_account	outer_instruction_index	user_base_token_account	pool_base_token_reserves	user_quote_token_account	pool_quote_token_reserves	protocol_fee_basis_points	user_quote_token_reserves	quote_amount_in_with_lp_fee	protocol_fee_recipient_token_account
54h9xqUo8tWNammpMMRAAPDdifu5SnmhbbSjfcmor4vq	121VAUZaPfwnrwQYMq2BtjHhLBkNLESdcqhU2dQqGzGV	8751759415	1759058759	369813673	11111111111111111111111111111111	1750351883	false	369813673-41qb8bDk18KS2D1KXH7bS6Eo6w1PLN8PmrUspio51eMkzsEEKsNkNrfH3EznenfDUADrrkBru3K4hWUFSkUttW8F-8-4	41qb8bDk18KS2D1KXH7bS6Eo6w1PLN8PmrUspio51eMkzsEEKsNkNrfH3EznenfDUADrrkBru3K4hWUFSkUttW8F	7586130539	2025-09-28T11:25:59.000Z	3500703765962	event_BuyEvent	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	4	172	CaFxu4gvkaNU4uJ6eTr7vrb7WvqEdSRKLbHtERMYkXv1	25	3574666768633	3511205877260	JCRGumoE9Qi5BBgULTgdgTLjSgkCMSbF62ZZfGs84JeU	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	8	ApoayW64jnRZ18Deizu51sCtjkDw25H8nXaiAGccL6D1	1771824216982	3CF7ioFbU7x694cjJtKJfiCDRGgX7sndU75NGtgAJm3q	814127160284518	5	4530644284705	3509455525377	AwKGcPF5haGuEumxHuGdgGLXG1cvZ2thEPSa3KTfmSg6
54h9xqUo8tWNammpMMRAAPDdifu5SnmhbbSjfcmor4vq	121VAUZaPfwnrwQYMq2BtjHhLBkNLESdcqhU2dQqGzGV	11796246468	1759054433	369802725	11111111111111111111111111111111	2359249294	false	369802725-3m7VKbzxsEDbk8jhMdGWAd9A4wqc3m7riQo4XeYqFu6eDB5wbJfw2u2sQGvRZgGG4fEFBYL3MEipqW3Uvy8q4DTa-8-4	3m7VKbzxsEDbk8jhMdGWAd9A4wqc3m7riQo4XeYqFu6eDB5wbJfw2u2sQGvRZgGG4fEFBYL3MEipqW3Uvy8q4DTa	7311932362	2025-09-28T10:13:53.000Z	4718498586939	event_BuyEvent	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	4	138	B1WM7MwoVgwZfctJxUUSckUt5FJW26Vn7qU16BX8arkf	25	4815326094566	4732654082701	JCRGumoE9Qi5BBgULTgdgTLjSgkCMSbF62ZZfGs84JeU	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	8	ApoayW64jnRZ18Deizu51sCtjkDw25H8nXaiAGccL6D1	1327140342945	3CF7ioFbU7x694cjJtKJfiCDRGgX7sndU75NGtgAJm3q	851704882104950	5	8490242573892	4730294833407	AwKGcPF5haGuEumxHuGdgGLXG1cvZ2thEPSa3KTfmSg6
54h9xqUo8tWNammpMMRAAPDdifu5SnmhbbSjfcmor4vq	121VAUZaPfwnrwQYMq2BtjHhLBkNLESdcqhU2dQqGzGV	7192255350	1759060667	369818511	11111111111111111111111111111111	1438451070	false	369818511-41MCZhm9ywwdpfU1ok7Fpac5PVz9qX4esN1LLnfGkLz8MiZ2BfgPqDYMMbpCE61T7A1RZJTxcXUirocZWhuky5Th-8-4	41MCZhm9ywwdpfU1ok7Fpac5PVz9qX4esN1LLnfGkLz8MiZ2BfgPqDYMMbpCE61T7A1RZJTxcXUirocZWhuky5Th	6884956423	2025-09-28T11:57:47.000Z	2876902139725	event_BuyEvent	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	4	162	6WJMiJXexjDGZNgjqRQEzjNDsDVyMMXbgQHU1K9nfFRu	25	2935589225792	2885532846145	JCRGumoE9Qi5BBgULTgdgTLjSgkCMSbF62ZZfGs84JeU	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	8	ApoayW64jnRZ18Deizu51sCtjkDw25H8nXaiAGccL6D1	1949737014994	3CF7ioFbU7x694cjJtKJfiCDRGgX7sndU75NGtgAJm3q	811827250757623	5	3552956351306	2884094395075	AwKGcPF5haGuEumxHuGdgGLXG1cvZ2thEPSa3KTfmSg6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pumpfun_v1_solana.AMM_BuyEvent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AMM_Sell_instruction

Sell transaction instructions from Pump.fun’s automated market maker (AMM) on Solana, capturing base token amounts sold, minimum quote token output, and associated pool and user accounts. Used for analyzing token sell pressure, slippage tolerance, and trader behavior in meme token markets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`associated_token_program`	`STRING`	Program address of the Associated Token Account (ATA) Program on Solana. Base58-encoded Solana public key, consistently ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL.
`base_mint`	`STRING`	Token mint address of the base asset being sold in this AMM transaction. Typically represents the project token or native SOL wrapped as SPL token (So11111111111111111111111111111111111111112).
`base_token_program`	`STRING`	Program address of the Solana Token Program managing the base token account operations. Base58-encoded Solana public key, consistently TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`coin_creator_vault_ata`	`STRING`	Associated Token Account (ATA) holding the token creator’s SOL or quote token fees/proceeds from the liquidity pool. Controlled by the coin_creator_vault_authority for fee distribution.
`coin_creator_vault_authority`	`STRING`	Token account authority that controls the creator’s vault for collecting initial liquidity fees from the bonding curve. This address has signing rights over the creator’s accumulated SOL from token launches.
`event_authority`	`STRING`	Account address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
`fee_config`	`STRING`	Pump.fun fee configuration account address for this liquidity pool. Null when standard fee structure applies.
`fee_program`	`STRING`	Solana program address responsible for collecting and processing trading fees on this AMM (Automated Market Maker). This field is currently empty in sample data, indicating fees may be handled by a different mechanism.
`global_config`	`STRING`	Account address storing global protocol configuration parameters. Base58-encoded Solana public key.
`pool`	`STRING`	Account address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
`pool_base_token_account`	`STRING`	Token account holding the pool’s reserves of the base asset (SOL in these samples). This account’s balance changes as users trade against the liquidity pool.
`pool_quote_token_account`	`STRING`	Token account address holding the pool’s quote token (e.g., USDC, SOL) reserves for the AMM. Used to receive quote tokens from sellers in exchange for base tokens.
`program`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`protocol_fee_recipient`	`STRING`	Account address that receives protocol fees from swap transactions. Base58-encoded Solana public key.
`protocol_fee_recipient_token_account`	`STRING`	Token account address where protocol fees are deposited. Base58-encoded Solana public key.
`quote_mint`	`STRING`	Mint address of the quote token (typically SOL or USDC) in the trading pair. This is the token received when selling the base token in this AMM transaction.
`quote_token_program`	`STRING`	Program address of the Solana Token Program managing the quote token account operations. Base58-encoded Solana public key, consistently TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`system_program`	`STRING`	Program address of the Solana System Program. 32-character string of ones representing the native system program identifier.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`user_base_token_account`	`STRING`	Token account address where the user’s base tokens are held. Base58-encoded Solana public key.
`user_quote_token_account`	`STRING`	Token account address where the user’s quote tokens are held. Base58-encoded Solana public key.
`base_amount_in`	`BIGNUMERIC`	Amount of base tokens (SOL) being sold by the user in this transaction. Represented in lamports, the smallest unit of SOL (1 SOL = 1 billion lamports).
`min_quote_amount_out`	`BIGNUMERIC`	Minimum amount of quote token the user is willing to receive from selling base tokens, denominated in quote token’s smallest unit. Acts as slippage protection to prevent unfavorable trades due to price movement.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

pool	user	program	base_mint	block_slot	quote_mint	global_config	surrogate_key	base_amount_in	system_program	transaction_id	block_timestamp	event_authority	instruction_type	executing_account	instruction_index	transaction_index	base_token_program	remaining_accounts	transaction_signer	quote_token_program	min_quote_amount_out	coin_creator_vault_ata	protocol_fee_recipient	pool_base_token_account	user_base_token_account	associated_token_program	pool_quote_token_account	user_quote_token_account	coin_creator_vault_authority	protocol_fee_recipient_token_account
12XWxKaXxiC4W4AcojJbM56ZCMvuaNyihPky274m2PY9	9VvY76xVGWrWMkGsmPnD5QnmuqUuWgCmawtb53mQHwVg	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	So11111111111111111111111111111111111111112	345043101	73XFRMAg31HqvcdSMC4FvJi5ZK8gTWG1RohpTiiwkrCs	ADyA8hdefvWN2dbGGWFotbzWxrAvLW83WG6QCVXvJKqw	345043101-4zcRBNLxJ9R4KFwMx8RjSLSgTZorigVoP3rjCkGrHxV9q6SwM3kQf37mgEwACEEuACMowvXE5fd6xD9fiJoW5GTQ-5	8315943166	11111111111111111111111111111111	4zcRBNLxJ9R4KFwMx8RjSLSgTZorigVoP3rjCkGrHxV9q6SwM3kQf37mgEwACEEuACMowvXE5fd6xD9fiJoW5GTQ	2025-06-06T17:05:35.000Z	GS4CU59F31iL7aR2Q8zVS8DRrcRnXX1yjQ66TqNVQnaR	Sell	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	5	101	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	9VvY76xVGWrWMkGsmPnD5QnmuqUuWgCmawtb53mQHwVg	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	12450883701669	FTtnjEi1zi82ZWBP3abzuS1CKmEWtnmKNbaerk6H3Gbm	7VtfL8fvgNfhz17qKRMjzQEXgbdpnHHHQRh54R9jP2RJ	9C8FyhKttAmNKWMKoCnDNik7shgqrzkCE9gFNmdGkWYQ	Cti6pocSyES9fcCP4fguw33PeZ212rTPo8mWzGq5fHTE	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL	986Kd5E43rhjF4xMc7L5ZNC1CfJ5ipGQ3M8U87tBXuZK	EVaFwMGaB6gWeEYu7i4Pihhgs1KKkjLVx3kWzrZz7a8w	8N3GDaZ2iwN65oxVatKTLPNooAVUJTbfiVJ1ahyqwjSk	92sfKS5XdTZ7hhdYw8ErtSYAPeLAW1SY9o7ENzPypP2X
12XWxKaXxiC4W4AcojJbM56ZCMvuaNyihPky274m2PY9	DqpSarNtnjs38vd8dtDvu6uhydMskQYBG3PuGKJAVCAR	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	So11111111111111111111111111111111111111112	345040722	73XFRMAg31HqvcdSMC4FvJi5ZK8gTWG1RohpTiiwkrCs	ADyA8hdefvWN2dbGGWFotbzWxrAvLW83WG6QCVXvJKqw	345040722-4QbRJVpurg7o1sfzYAkkoGUjkEES419nHdGS7eFEdNkyXt7WyF1VLCkBUC3YjRbxjRoMErfsnnar6GXfEBcHZJbF-5	315380210	11111111111111111111111111111111	4QbRJVpurg7o1sfzYAkkoGUjkEES419nHdGS7eFEdNkyXt7WyF1VLCkBUC3YjRbxjRoMErfsnnar6GXfEBcHZJbF	2025-06-06T16:50:00.000Z	GS4CU59F31iL7aR2Q8zVS8DRrcRnXX1yjQ66TqNVQnaR	Sell	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	5	87	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	DqpSarNtnjs38vd8dtDvu6uhydMskQYBG3PuGKJAVCAR	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	604774065078	FTtnjEi1zi82ZWBP3abzuS1CKmEWtnmKNbaerk6H3Gbm	7VtfL8fvgNfhz17qKRMjzQEXgbdpnHHHQRh54R9jP2RJ	9C8FyhKttAmNKWMKoCnDNik7shgqrzkCE9gFNmdGkWYQ	3VuAPxtDDRLjSh9PxWhEJp9iZPENRzF5ar8koYYjaYqj	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL	986Kd5E43rhjF4xMc7L5ZNC1CfJ5ipGQ3M8U87tBXuZK	FewiEoEjPYHEpUdz8PJgh4kBtg7x9JGs8Wxu2fRRnQjg	8N3GDaZ2iwN65oxVatKTLPNooAVUJTbfiVJ1ahyqwjSk	92sfKS5XdTZ7hhdYw8ErtSYAPeLAW1SY9o7ENzPypP2X
12XWxKaXxiC4W4AcojJbM56ZCMvuaNyihPky274m2PY9	574Vqjzyg1yxmX8L8CYXNjCCapBm9DupN35nBHAGvTHH	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	So11111111111111111111111111111111111111112	345040784	73XFRMAg31HqvcdSMC4FvJi5ZK8gTWG1RohpTiiwkrCs	ADyA8hdefvWN2dbGGWFotbzWxrAvLW83WG6QCVXvJKqw	345040784-ayC5xFKj85eP7LyzCsPBcFVXv27qkEoew9fzkv3MRUAQFpP23aMnKJr24P68aA5r2z6J7K6bhb8A3SrmfX2k8EP-5	7610588475	11111111111111111111111111111111	ayC5xFKj85eP7LyzCsPBcFVXv27qkEoew9fzkv3MRUAQFpP23aMnKJr24P68aA5r2z6J7K6bhb8A3SrmfX2k8EP	2025-06-06T16:50:24.000Z	GS4CU59F31iL7aR2Q8zVS8DRrcRnXX1yjQ66TqNVQnaR	Sell	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	5	73	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	574Vqjzyg1yxmX8L8CYXNjCCapBm9DupN35nBHAGvTHH	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	15204480793727	FTtnjEi1zi82ZWBP3abzuS1CKmEWtnmKNbaerk6H3Gbm	7VtfL8fvgNfhz17qKRMjzQEXgbdpnHHHQRh54R9jP2RJ	9C8FyhKttAmNKWMKoCnDNik7shgqrzkCE9gFNmdGkWYQ	6M4mb4XUpuPrsEJJJQpAkP2z1z7kWXbpcz5qg5h4ArWw	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL	986Kd5E43rhjF4xMc7L5ZNC1CfJ5ipGQ3M8U87tBXuZK	GcR1CMwy1oowaEHnc5MHUGduXDLia8GgRv4Wv31XrVVd	8N3GDaZ2iwN65oxVatKTLPNooAVUJTbfiVJ1ahyqwjSk	92sfKS5XdTZ7hhdYw8ErtSYAPeLAW1SY9o7ENzPypP2X

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pumpfun_v1_solana.AMM_Sell_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AMM_SellEvent_event

Sell transaction events from Pump.fun’s automated market maker (AMM) on Solana, capturing base token sales for quote tokens with amounts, fees (LP, protocol, and creator), pool reserves, and user account details. Used for analyzing trading volume, fee distribution, and liquidity dynamics across Pump.fun token pools.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`base_amount_in`	`BIGNUMERIC`	Amount of base tokens (pool’s primary token) sold by the user in this transaction. Denominated in the token’s smallest unit (similar to lamports for SOL).
`coin_creator`	`STRING`	Creator address of the token being sold in this transaction. Solana base58-encoded public key that receives creator fees from this sell event.
`coin_creator_fee`	`BIGNUMERIC`	Protocol fee paid to the coin creator on this sell transaction, denominated in the quote token. Typically 5 basis points (0.05%) of the total transaction value.
`coin_creator_fee_basis_points`	`INT64`	Fee percentage allocated to token creator, expressed in basis points (1 basis point = 0.01%). Consistently 5 basis points (0.05%) across all sample transactions.
`lp_fee`	`BIGNUMERIC`	Liquidity provider fee collected from this sell transaction. Denominated in the quote token (typically SOL), calculated as 20 basis points of the output amount.
`lp_fee_basis_points`	`INT64`	Liquidity provider fee rate expressed in basis points (1/100th of a percent). Typically 20 basis points (0.20%) on PumpFun AMM sell transactions.
`min_quote_amount_out`	`BIGNUMERIC`	Minimum acceptable quote token amount the user specifies for the sell transaction, acting as slippage protection. Set to zero to accept any output amount.
`pool`	`STRING`	Account address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
`pool_base_token_reserves`	`BIGNUMERIC`	Pool’s base token balance after the sell transaction. Represents the updated reserve amount used for automated market maker pricing calculations.
`pool_quote_token_reserves`	`BIGNUMERIC`	Amount of quote token (typically SOL) held in the pool’s reserves after this sell transaction. Denominated in the token’s smallest unit (lamports for SOL).
`protocol_fee`	`BIGNUMERIC`	Protocol fee amount deducted from the sell transaction and sent to the platform. Expressed in base token units (lamports for SOL).
`protocol_fee_basis_points`	`INT64`	Fee charged by the Pumpfun protocol expressed in basis points (1/100th of a percent). Consistently 5 basis points (0.05%) across all sample transactions.
`protocol_fee_recipient`	`STRING`	Account address that receives protocol fees from swap transactions. Base58-encoded Solana public key.
`protocol_fee_recipient_token_account`	`STRING`	Token account address where protocol fees are deposited. Base58-encoded Solana public key.
`quote_amount_out`	`BIGNUMERIC`	Amount of quote tokens (typically SOL) received from the sell transaction before protocol and creator fees. Includes liquidity provider fee deduction but excludes the additional 10 basis points split between protocol and creator.
`quote_amount_out_without_lp_fee`	`BIGNUMERIC`	Total quote tokens output before deducting liquidity provider fees, used to calculate the LP fee amount. Represents the gross swap proceeds in the quote currency before fee application.
`timestamp`	`BIGNUMERIC`	Unix timestamp when the event occurred. Seconds since epoch, stored as integer.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`user_base_token_account`	`STRING`	Token account address where the user’s base tokens are held. Base58-encoded Solana public key.
`user_base_token_reserves`	`BIGNUMERIC`	User’s balance of the base token in their associated token account after the sell transaction completes. Denominated in base token’s smallest unit (lamports for SOL-based tokens).
`user_quote_amount_out`	`BIGNUMERIC`	Actual quote tokens (typically SOL or USDC) received by the seller after deducting liquidity provider fees. Excludes protocol and creator fees, representing net proceeds to the user from the token sale.
`user_quote_token_account`	`STRING`	Token account address where the user’s quote tokens are held. Base58-encoded Solana public key.
`user_quote_token_reserves`	`BIGNUMERIC`	User’s balance of the quote token (typically SOL) in their token account after the sell transaction completes. Denominated in the quote token’s smallest units (lamports for SOL).

Sample Data

pool	user	lp_fee	timestamp	block_slot	coin_creator	protocol_fee	surrogate_key	base_amount_in	transaction_id	block_timestamp	coin_creator_fee	instruction_type	quote_amount_out	executing_account	instruction_index	transaction_index	transaction_signer	lp_fee_basis_points	min_quote_amount_out	user_quote_amount_out	protocol_fee_recipient	outer_executing_account	user_base_token_account	pool_base_token_reserves	user_base_token_reserves	user_quote_token_account	pool_quote_token_reserves	protocol_fee_basis_points	user_quote_token_reserves	coin_creator_fee_basis_points	quote_amount_out_without_lp_fee	protocol_fee_recipient_token_account
2bcNyyaWr837HEYNR845YyPDuFmEcREUh1quGJjretrk	5JewENBbfKu23TLEhfXxzL4VRHwJvcLf9BCPHAuB5Rmh	22672526	1756411049	363140346	2JEKeooin45zJUXTg2v6HmRYG54R6dgoUJNsr49hkDAx	5668132	363140346-VmxZfwQy45QWf1Npd4fMFc1P3SN64DbbWtnwCtyaSVdRCh2NJRKSLigyZqXpbSb3t6BmZy3MLWqjWtyi445gdaE-0-5	22677578455115	VmxZfwQy45QWf1Npd4fMFc1P3SN64DbbWtnwCtyaSVdRCh2NJRKSLigyZqXpbSb3t6BmZy3MLWqjWtyi445gdaE	2025-08-28T19:57:29.000Z	5668132	event_SellEvent	11336262782	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	5	132	5JewENBbfKu23TLEhfXxzL4VRHwJvcLf9BCPHAuB5Rmh	20	0	11302253992	FWsW1xNtWscwNmKv6wVsU1iTzRN6wmmk3MjxRP5tT7hz	inf69quFVZyuHEsrUXq3APtYLr4iqsNiQdCh5ArGcUp	GQuUEi8dLz2hzKtAfdJ84QdvSSftM9yuT414Wbi2hJc9	181550211058358	22677578455115	EUjxwLwjo5PgiFaGAUdhdqU3foXFWAF6J2zY2qjf3Hin	102091142316	5	0	5	11313590256	7xQYoUjUJF1Kg6WVczoTAkaNhn5syQYcbvjmFrhjWpx
2qbkoBs4Y5XJVyxZrb42b6r4MvS3L8ngdkLFn146MJeT	3Zu3VPnTRbDMoRF6tcBpfmgXfjAp7sFz8LLcddm9sPvw	148322	1756412350	363143646	79QyhseDHEy1GtZjrEiScbihnMeZWyhBpyKMz9Ajc7s	37081	363143646-HhAEzi684qTCNvSyBE6eyvAA9fJQtp9ooWKKcVhpwJuhP6Yfa9gGDn3cdusco3iEXyVxLghfynLvXDcFz8DWVdC-0-4	39367050000	HhAEzi684qTCNvSyBE6eyvAA9fJQtp9ooWKKcVhpwJuhP6Yfa9gGDn3cdusco3iEXyVxLghfynLvXDcFz8DWVdC	2025-08-28T20:19:10.000Z	37081	event_SellEvent	74160848	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	4	49	4HbdHw8GjdygunYYVJYzRRnfGNgWE9AwhnTifhimxSb3	20	73489691	73938364	7VtfL8fvgNfhz17qKRMjzQEXgbdpnHHHQRh54R9jP2RJ	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	7dMr4fD6Jwu2kfMCptpsbjhnLj8gif1NZpZGdSSUtomh	128557290605760	345134818036	EsxDjXsNwht7mEGpWaRQ2LghaZWyufyWNL9Jm2ougJFm	242254302532	5	583262586	5	74012526	7GFUN3bWzJMKMRZ34JLsvcqdssDbXnp589SiE33KVwcC
2qbkoBs4Y5XJVyxZrb42b6r4MvS3L8ngdkLFn146MJeT	3Zu3VPnTRbDMoRF6tcBpfmgXfjAp7sFz8LLcddm9sPvw	183358	1756340122	362960524	79QyhseDHEy1GtZjrEiScbihnMeZWyhBpyKMz9Ajc7s	45840	362960524-5WBZUmpJkJ1Yz9phN8YPdquoNLSmzfDPDdooM5qauSBTsdhDy6SLubJUcGGSdC5jzfuUoGX6Ku6HJQg8XbSyGdcK-0-4	49028745400	5WBZUmpJkJ1Yz9phN8YPdquoNLSmzfDPDdooM5qauSBTsdhDy6SLubJUcGGSdC5jzfuUoGX6Ku6HJQg8XbSyGdcK	2025-08-28T00:15:22.000Z	45840	event_SellEvent	91678959	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	4	54	91KL5K5qPAeaEtQomGtV9XUA1W9WGZCciPHWsNiEm8aa	20	90995024	91403921	FWsW1xNtWscwNmKv6wVsU1iTzRN6wmmk3MjxRP5tT7hz	pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA	7dMr4fD6Jwu2kfMCptpsbjhnLj8gif1NZpZGdSSUtomh	128945071619508	371995183480	EsxDjXsNwht7mEGpWaRQ2LghaZWyufyWNL9Jm2ougJFm	241206352659	5	978769105	5	91495601	7xQYoUjUJF1Kg6WVczoTAkaNhn5syQYcbvjmFrhjWpx

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pumpfun_v1_solana.AMM_SellEvent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

CompleteEvent_event

Token bonding curve completion events from Pump.fun on Solana, emitted when a token graduates from its bonding curve. Used to identify successful token launches and track which mints have completed their initial distribution phase.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`bonding_curve`	`STRING`	Account address of the bonding curve program data account tracking token pricing and liquidity. Base58-encoded Solana public key.
`mint`	`STRING`	Token address of the SPL token being operated on. Base58-encoded Solana public key.
`timestamp`	`BIGNUMERIC`	Unix timestamp when the event occurred. Seconds since epoch, stored as integer.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.

Sample Data

mint	user	timestamp	block_slot	bonding_curve	surrogate_key	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index
C6EtVpuEmXNNUJQw36cHUSNNd8T14pJMwvBqWgpuisxU	97983cozqMHEDhp9hCefs8y3dEF1Am3yM1bPhpkTJQuL	1714841512	263859369	J4vofqRqYckRKhXnv7A5hwUVNoaKQmCis5LWrUQwLdBT	263859369-Z89CVESFz4eqPngfyeAXYEAVUtBZDZ7eo7kmLNBPUG4iNHjtF28vVd133rWefM6vzriFy9txmGojUizxGHGq8LB-0-1	Z89CVESFz4eqPngfyeAXYEAVUtBZDZ7eo7kmLNBPUG4iNHjtF28vVd133rWefM6vzriFy9txmGojUizxGHGq8LB	2024-05-04T16:51:52.000Z	event_CompleteEvent	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	1	79	97983cozqMHEDhp9hCefs8y3dEF1Am3yM1bPhpkTJQuL	BSfD6SHZigAfDWSjzD5Q41jw8LmKwtmjskPH9XW1mrRW	0
8ReXvwM4Cr9QdYyx4gvFxFYQQ7aK5iz1HsdexBKNHtYA	7s2DQCUS8wP1WFaeS6mCSDBQGp8rUFTxZ33QaiSPKbd1	1714783829	263734734	8q6ghYW1NLKJmDbtYwQrHb7qVtmMgmUThXtRhstPBipd	263734734-4cSszeAsTiKJShUymfhAVrENBsys2YBPQFFb4vL6Ng7VRwmduP7hGv3bz8X3Qgd9mpaVA9gZeiRkpY85AszTRTLD-2-0	4cSszeAsTiKJShUymfhAVrENBsys2YBPQFFb4vL6Ng7VRwmduP7hGv3bz8X3Qgd9mpaVA9gZeiRkpY85AszTRTLD	2024-05-04T00:50:29.000Z	event_CompleteEvent	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	0	1	7s2DQCUS8wP1WFaeS6mCSDBQGp8rUFTxZ33QaiSPKbd1	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	2
GaBrvJ44ZjUtpy8LNWBo8eH9ic8hcXkUjxjZLsusaukg	4TzX3XfgCpNTKyFuEQQtW6L51AaPAwYutzPSEHotmRHo	1714791831	263752068	BT4mC3kh9YfZ6jdZ8TzCxQEZRwRHHWFZofnLZoU8MRoR	263752068-3PMy4NxfnueGmf5WQ9nEEePhFzBY3tUf13kAcfjeW4NECogYqYmniu24FuJhp9a7f2JWbKWH578CZsQ4MRShSoxM-2-0	3PMy4NxfnueGmf5WQ9nEEePhFzBY3tUf13kAcfjeW4NECogYqYmniu24FuJhp9a7f2JWbKWH578CZsQ4MRShSoxM	2024-05-04T03:03:51.000Z	event_CompleteEvent	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	0	4	4TzX3XfgCpNTKyFuEQQtW6L51AaPAwYutzPSEHotmRHo	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pumpfun_v1_solana.CompleteEvent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

CreateEvent_event

Token creation events from Pump.fun memecoin launchpad on Solana. Records new token deployments with metadata (name, symbol, URI), creator address, mint address, and associated bonding curve for tracking launch activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`bonding_curve`	`STRING`	Account address of the bonding curve program data account tracking token pricing and liquidity. Base58-encoded Solana public key.
`mint`	`STRING`	Token address of the SPL token being operated on. Base58-encoded Solana public key.
`name`	`STRING`	Name of the instruction or event type being executed. Identifies the specific operation performed within the smart contract or program.
`symbol`	`STRING`	Token ticker symbol used to identify this asset on the Pump.fun platform. Typically all-caps text representation, may include spaces or special characters as shown in sample values.
`uri`	`STRING`	URL pointing to the token’s off-chain metadata, typically hosted on IPFS or web servers. Contains JSON with token details like name, symbol, image, and description.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.

Sample Data

uri	mint	name	user	symbol	block_slot	bonding_curve	surrogate_key	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	outer_executing_account
https://ipfs.memeturbo.fun/2prZkQNAWY5kvNcWSW3kKLtCiEiz3pXR2PURx8Z7hqtf	2prZkQNAWY5kvNcWSW3kKLtCiEiz3pXR2PURx8Z7hqtf	JUST DOGE IT	13fWr6YzTfFRijkzfQG79qu1akXw2a42dQMRofUYp2pw	DOGE IT	362846660	8DnZbNHSxunUy7S3LEo9NyL8kEbc7QBG3BfR3E5VJDRv	362846660-eqYf2WtHC81NbaKUQ3Mnh8KqgiPF6b7cwWC3BCq3BCRGdzFHtk5gECwEsZzP6z1EXcfsUrTrFaVizpvmyN9dNNL-0-14	eqYf2WtHC81NbaKUQ3Mnh8KqgiPF6b7cwWC3BCq3BCRGdzFHtk5gECwEsZzP6z1EXcfsUrTrFaVizpvmyN9dNNL	2025-08-27T11:48:21.000Z	event_CreateEvent	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	14	358	13fWr6YzTfFRijkzfQG79qu1akXw2a42dQMRofUYp2pw	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P
https://ipfs.memeturbo.fun/BH6UGwG3uUWjiG5qbktJE8bEsMYeUgwAh54PNfmsAK6a	BH6UGwG3uUWjiG5qbktJE8bEsMYeUgwAh54PNfmsAK6a	JUST DOGE IT	13fWr6YzTfFRijkzfQG79qu1akXw2a42dQMRofUYp2pw	DOGE IT	362846065	CyojrgAuBkz7EUzpjD2oMhmuEFUwYeHbtyjgvZhA7i6W	362846065-5fDsh28GqGVVKEJywbFvHuy8okKZhRBQUH4w2Y2ovw6vntzQBfLkB4FwoedGN7L6Csi6hBsZqensi5GSLh2PW4CL-0-14	5fDsh28GqGVVKEJywbFvHuy8okKZhRBQUH4w2Y2ovw6vntzQBfLkB4FwoedGN7L6Csi6hBsZqensi5GSLh2PW4CL	2025-08-27T11:44:28.000Z	event_CreateEvent	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	14	63	13fWr6YzTfFRijkzfQG79qu1akXw2a42dQMRofUYp2pw	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P
https://ipfs.io/ipfs/bafkreic6udtlxyr25vg63w7xpve7vo6jhy2q5tht4ndvufwn2yediwgyf4	2u7zkqVxfW4nhF6Ens1q4sE9MyXg5nLeqqmHhUYFvrSM	Clifford	13fWr6YzTfFRijkzfQG79qu1akXw2a42dQMRofUYp2pw	CLIFFORD	362845072	FtBcwySwWD2tuggDiNnfap4n4WccnVERCsU1AD214puJ	362845072-4ChrH51PFAUZBaTkcdbqa4yytz5qbmuCZfwsVkXcaDrE4tyicXyUeXyxfBnuam2Z2HXsLPPerkebeGv4dDvLrKCF-0-14	4ChrH51PFAUZBaTkcdbqa4yytz5qbmuCZfwsVkXcaDrE4tyicXyUeXyxfBnuam2Z2HXsLPPerkebeGv4dDvLrKCF	2025-08-27T11:37:55.000Z	event_CreateEvent	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	14	329	13fWr6YzTfFRijkzfQG79qu1akXw2a42dQMRofUYp2pw	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pumpfun_v1_solana.CreateEvent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pumpfun_Buy_instruction

Buy order instructions from Pump.fun token launch platform on Solana, including token amounts, SOL costs, and bonding curve references. Used for analyzing meme coin launch trading activity and early-stage token price discovery.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`associated_bonding_curve`	`STRING`	Token account (ATA) holding the bonding curve’s token reserves for this specific mint. Created per-mint to manage the Pump.fun automated market maker liquidity pool.
`associated_user`	`STRING`	Token account address owned by the buyer that receives the purchased tokens. This is the user’s Associated Token Account (ATA) for the specific mint being purchased.
`bonding_curve`	`STRING`	Account address of the bonding curve program data account tracking token pricing and liquidity. Base58-encoded Solana public key.
`event_authority`	`STRING`	Account address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
`fee_recipient`	`STRING`	Solana account address that receives trading fees for this buy transaction. Typically set to the Pumpfun platform fee collection account (CebN5WGQ4jvEPvsVU4EoHEpgzq1VV7AbicfhtW4xC9iM).
`global`	`STRING`	Global state account address for the Pumpfun protocol containing system-wide configuration and parameters. Consistent value across all transactions indicates a singleton contract instance managing protocol state.
`mint`	`STRING`	Token address of the SPL token being operated on. Base58-encoded Solana public key.
`program`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`rent`	`STRING`	Program address of the Solana Rent Sysvar. Base58-encoded string, consistently SysvarRent111111111111111111111111111111111.
`system_program`	`STRING`	Program address of the Solana System Program. 32-character string of ones representing the native system program identifier.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`amount`	`BIGNUMERIC`	Quantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
`max_sol_cost`	`BIGNUMERIC`	Maximum amount of SOL (in lamports) the buyer is willing to spend for this token purchase. Serves as slippage protection; transaction fails if actual cost exceeds this limit.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

mint	rent	user	amount	global	program	block_slot	max_sol_cost	bonding_curve	fee_recipient	surrogate_key	token_program	system_program	transaction_id	associated_user	block_timestamp	event_authority	instruction_type	executing_account	instruction_index	transaction_index	remaining_accounts	transaction_signer	associated_bonding_curve
6sfLomsWQEHL8vXSp8CWANzoJ5GPS9B2H7Z1AqCDX5pg	SysvarRent111111111111111111111111111111111	4tsycCv1nf3aZ2rd5vYhRBTM3NGA1jbUsxXcLNeTJ8CR	500000000000	4wTV1YmiEkRvAtNtsSGPtUrqRYQMe5SKy2uB4Jjaxnjf	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	265143745	100000000	6cnB3nLb9DTACJ481aJ9KHQW3ZLreLbZ9sXYq2GELQRy	CebN5WGQ4jvEPvsVU4EoHEpgzq1VV7AbicfhtW4xC9iM	265143745-3cdGgtXT3iuiqTKDUZbqSYBFDtzeU6c83uBnq1py71qocCc5TRfCydSxy8u8TfYD8Ns7Ph7fqnFGKxjknKR8J3xs-7	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	11111111111111111111111111111111	3cdGgtXT3iuiqTKDUZbqSYBFDtzeU6c83uBnq1py71qocCc5TRfCydSxy8u8TfYD8Ns7Ph7fqnFGKxjknKR8J3xs	3FG4Y4oxC8CdxAszRFfGDjzyGhWJxB1GRP31bS7zE2ob	2024-05-11T12:05:03.000Z	Ce6TQqeHC9p8KetsN6JsjHK7UTZk7nasjjnr7XxXp9F1	Buy	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	7	92	[]	4fNv8agbWvSM8vLAHHJunEBS7SHb4HMDf23Ms1dDFWA8	DEJnxpbMYm3SSXfhqcabQsc2kErV8MFSkbjBBnPfJCDQ
9GvvMpfy37SJ66DZKpTTfVGxjTvaLz1vf5usYfLRS8Du	SysvarRent111111111111111111111111111111111	7yZDnTXdfbihEkuiqviitvkwijcygRbu6Y1hRr7FNniG	4696196448	4wTV1YmiEkRvAtNtsSGPtUrqRYQMe5SKy2uB4Jjaxnjf	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	265133518	992500	z67SvAyHXp8kw9jFSwyb1TU24qGjAquVJevJaKU3BtT	CebN5WGQ4jvEPvsVU4EoHEpgzq1VV7AbicfhtW4xC9iM	265133518-2femBcLC4i9UG8priDMjik9cybyw9eny6xpCeweVrXeuYyqBL4ouQjGnz7GbmWqV6zLGtFEydyUNHKZ5wuQxazvF-8	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	11111111111111111111111111111111	2femBcLC4i9UG8priDMjik9cybyw9eny6xpCeweVrXeuYyqBL4ouQjGnz7GbmWqV6zLGtFEydyUNHKZ5wuQxazvF	7KgKzN1vAqJ9dffTduz5yLU1i8j6Ch7ebW5zEinUksYU	2024-05-11T10:50:06.000Z	Ce6TQqeHC9p8KetsN6JsjHK7UTZk7nasjjnr7XxXp9F1	Buy	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	8	90	[]	7yZDnTXdfbihEkuiqviitvkwijcygRbu6Y1hRr7FNniG	8WmQWSKNpTHzcDcaa8f3NQxJoGXf6pfGRsATvLhUSKL1
CepCGLcEzw7g5RcQbHeyHquzY2p5DSXvqqHYdXMtvDGh	SysvarRent111111111111111111111111111111111	2nzgpDHUcpEEwdzVsMob26bWW2PnYypzSdAj9TjQTw3b	860925132503	4wTV1YmiEkRvAtNtsSGPtUrqRYQMe5SKy2uB4Jjaxnjf	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	265056786	2380000000000	Ej8dZr9PHy7hVK7jrGhFTJ8xJrggYR11FM1yZ2JuUsRy	CebN5WGQ4jvEPvsVU4EoHEpgzq1VV7AbicfhtW4xC9iM	265056786-33B1NFMe2VCnqAxTNK5ZjqZEAAdZXAoSPtwt7mTEyw1wu9sHpazB4A7qYgv4hRf3yXFKKqvgX6NKgGdSzt8Vi4Se-11	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	11111111111111111111111111111111	33B1NFMe2VCnqAxTNK5ZjqZEAAdZXAoSPtwt7mTEyw1wu9sHpazB4A7qYgv4hRf3yXFKKqvgX6NKgGdSzt8Vi4Se	6mDH9g1VvzSur1CmEm2TZauDXhYCekznLxuFV2ffUB3E	2024-05-11T01:19:19.000Z	Ce6TQqeHC9p8KetsN6JsjHK7UTZk7nasjjnr7XxXp9F1	Buy	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	11	8	[]	5YZ6cXZyx468Zi7piaHNDJGz3ifiUGWDexB48aZJbM6p	BHYmrLkPu5n1vRqqzDhg14YApdb5A7A4SGRdC3yaugVm

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pumpfun_v1_solana.Pumpfun_Buy_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pumpfun_Sell_instruction

Sell transactions from Pump.fun token bonding curve protocol on Solana, capturing token amounts sold, SOL received, and associated user accounts. Used for analyzing trading patterns, price impact, and bonding curve liquidity dynamics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`associated_bonding_curve`	`STRING`	Solana address of the associated token account that holds the bonding curve’s token balance for this specific mint. Base58-encoded public key managed by the Associated Token Program.
`associated_token_program`	`STRING`	Program address of the Associated Token Account (ATA) Program on Solana. Base58-encoded Solana public key, consistently ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL.
`associated_user`	`STRING`	Associated token account that holds the user’s token balance being sold in this transaction. Base58-encoded Solana account address derived from the user’s wallet and token mint.
`bonding_curve`	`STRING`	Account address of the bonding curve program data account tracking token pricing and liquidity. Base58-encoded Solana public key.
`event_authority`	`STRING`	Account address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
`fee_recipient`	`STRING`	Solana address receiving protocol fees from this sell transaction on Pump.fun. Consistent across all transactions, indicating a platform-level fee collector account.
`global`	`STRING`	Global configuration account address for the Pumpfun protocol. Constant across all transactions (4wTV1YmiEkRvAtNtsSGPtUrqRYQMe5SKy2uB4Jjaxnjf).
`mint`	`STRING`	Token address of the SPL token being operated on. Base58-encoded Solana public key.
`program`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`system_program`	`STRING`	Program address of the Solana System Program. 32-character string of ones representing the native system program identifier.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`amount`	`BIGNUMERIC`	Quantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
`min_sol_output`	`BIGNUMERIC`	Minimum amount of SOL (in lamports) the user is willing to receive from selling their tokens. Functions as slippage protection, with zero indicating no minimum threshold set.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

mint	user	amount	global	block_slot	bonding_curve	fee_recipient	surrogate_key	token_program	min_sol_output	system_program	transaction_id	associated_user	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	remaining_accounts	transaction_signer	associated_bonding_curve	associated_token_program
C4dDZodmR9sc5u3uY4mx8WU6Kc1bFTUMTQ7LZAxaSifb	4JQ8QvwwLD5m9H95X6afJhfneRb9YvgLaT4xg9HAAFyv	13693000000000	4wTV1YmiEkRvAtNtsSGPtUrqRYQMe5SKy2uB4Jjaxnjf	260577963	35H9hLDoycy2DBAnan9LMFBMM4z4VvcyFUhjQ8AygMp7	CebN5WGQ4jvEPvsVU4EoHEpgzq1VV7AbicfhtW4xC9iM	260577963-4cf9TEZ4JruByJ7w4LR3iF6sQKF34odKHC4j71nok5gtrnfkQepmJdRhvgBHkmFWTr7YUnTLuj5ADZ1kCYe4sFb4-1	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	0	11111111111111111111111111111111	4cf9TEZ4JruByJ7w4LR3iF6sQKF34odKHC4j71nok5gtrnfkQepmJdRhvgBHkmFWTr7YUnTLuj5ADZ1kCYe4sFb4	5HxtHWtT1RTiKzMyLjCXSALzy6nKTgzyYCiNNKGCAa6V	2024-04-17T03:23:15.000Z	Sell	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	1	5	[]	4JQ8QvwwLD5m9H95X6afJhfneRb9YvgLaT4xg9HAAFyv	12F1He7X5Df7yLPazhQqf4yZA5Cen7neg3Jru3SKKkMb	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL
EntsaeteFcMmMeXhoiYCydvoriZqGiwFsdKVrKpuAGbW	3ZggDsbL8KNsyn2Zc5PyGBEGsxFakbGvfuMKyrcPEZTd	1470683331413	4wTV1YmiEkRvAtNtsSGPtUrqRYQMe5SKy2uB4Jjaxnjf	260703099	F4wPEP7by7sEEqf3ebrsmqMxESahUfqjg6uaeXQgq4R9	CebN5WGQ4jvEPvsVU4EoHEpgzq1VV7AbicfhtW4xC9iM	260703099-62SVBnZM6cAvmHnGqvwVadYEnvsqfpoA9f2SY2JE9XXi7wtmhTDTquJH4EEihGvHAJsheTUYkWvDgPtaPXUJCAxb-2	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	38772665	11111111111111111111111111111111	62SVBnZM6cAvmHnGqvwVadYEnvsqfpoA9f2SY2JE9XXi7wtmhTDTquJH4EEihGvHAJsheTUYkWvDgPtaPXUJCAxb	Fto8jjYe9Cjtay2Lzan4Zy8US9Dg4nR2td97cH2xSqhs	2024-04-17T18:36:38.000Z	Sell	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	2	48	[]	3ZggDsbL8KNsyn2Zc5PyGBEGsxFakbGvfuMKyrcPEZTd	12JbvYJB7x63pqm2q1R7dNTJsAghZfWugD6PWmPwVSx	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL
FSLMHXF9h734MUYJHAKTYxv6xKZk7WDKXhqbMNnTzLzh	2SWjhYtqWnWJR9iCeXngZaFyBqVtLWMHdXRyYjHuZzcP	17590163913466	4wTV1YmiEkRvAtNtsSGPtUrqRYQMe5SKy2uB4Jjaxnjf	260698086	5qzNKyt3NYamVMperq44aqmWZ8fU6Kn7cZ8CApWmgUQz	CebN5WGQ4jvEPvsVU4EoHEpgzq1VV7AbicfhtW4xC9iM	260698086-288EvaMPnucUB2ugFSmBZrziNDUJnwXYhHy2Az5gQUNv1G3gv7kM8bXF1tJxLvmZ3JccCaPk7TAsxKJuDwjisf7w-2	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	245000000	11111111111111111111111111111111	288EvaMPnucUB2ugFSmBZrziNDUJnwXYhHy2Az5gQUNv1G3gv7kM8bXF1tJxLvmZ3JccCaPk7TAsxKJuDwjisf7w	G5CVDivCuYUDpgdEDiEyqWkvZU6eg4KXPCa2y1L7hFWR	2024-04-17T18:00:03.000Z	Sell	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	2	4	[]	2SWjhYtqWnWJR9iCeXngZaFyBqVtLWMHdXRyYjHuZzcP	12LvAXReAhD2jNVnYJA6efw3mUBzD9L65EirBWFLQ3kL	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pumpfun_v1_solana.Pumpfun_Sell_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

TradeEvent_event

Trade execution events from Pump.fun token launches on Solana, tracking buys and sells with SOL/token amounts, bonding curve reserves (virtual and real), and creator fee distribution. Used for analyzing trading dynamics and liquidity mechanics of newly launched meme tokens.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`accounts_0`	`STRING`	Account address at index 0 in the instruction’s account array for this Pump.fun trade event. Typically represents a program-specific account used during trade execution.
`creator`	`STRING`	Token creator’s wallet address who will receive creator fees from trades. Base58-encoded Solana address; null when creator fees are not applicable to the trade.
`creator_fee`	`BIGNUMERIC`	Fee amount paid to the token creator on this trade, denominated in lamports (1 SOL = 1 billion lamports). This field is null in all sample records, suggesting creator fees may not be enabled for these tokens or the feature is optional.
`creator_fee_basis_points`	`BIGNUMERIC`	Fee percentage charged to the token creator on this trade, expressed in basis points (1/100th of a percent). Null values indicate no creator fee was applied to the transaction.
`fee`	`BIGNUMERIC`	Platform trading fee collected on this transaction in lamports (base SOL units). Typically null for Pump.fun trades as fees may be bundled differently or collected through other mechanisms.
`fee_basis_points`	`BIGNUMERIC`	Protocol fee expressed in basis points (hundredths of a percent) for this trade. Currently null across all samples, suggesting fees may be calculated differently or embedded in reserves.
`fee_recipient`	`STRING`	Account address receiving protocol or platform fees from the trade transaction. Typically null in Pump.fun trades as fees may be handled differently in the contract structure.
`is_buy`	`BOOL`	Boolean flag indicating whether the trade is a buy (true) or sell (false) of the token. Determines the direction of the swap between SOL and the token.
`mint`	`STRING`	Token address of the SPL token being operated on. Base58-encoded Solana public key.
`real_sol_reserves`	`BIGNUMERIC`	Actual SOL reserves held in the bonding curve contract after accounting for virtual liquidity. Denominated in lamports (1 SOL = 1 billion lamports).
`real_token_reserves`	`BIGNUMERIC`	Actual quantity of tokens held in the bonding curve reserves at trade execution time, denominated in the token’s smallest unit. This value excludes virtual liquidity and represents the protocol’s true token position.
`sol_amount`	`BIGNUMERIC`	SOL amount exchanged in this trade event, denominated in lamports (1 SOL = 1,000,000,000 lamports). Sample values range from 0 to hundreds of millions of lamports, representing the Solana token side of pump.fun trades.
`timestamp`	`BIGNUMERIC`	Unix timestamp when the event occurred. Seconds since epoch, stored as integer.
`token_amount`	`BIGNUMERIC`	Amount of tokens exchanged in this trade, denominated in the token’s smallest unit. Typically represents hundreds of thousands to trillions of base units depending on token decimals.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`virtual_sol_reserves`	`BIGNUMERIC`	Reserve quantity of SOL (Solana native token) used for virtual liquidity calculations in Pump.fun’s bonding curve. Denominated in lamports (1 SOL = 1,000,000,000 lamports), typically higher than real_sol_reserves to set initial pricing.
`virtual_token_reserves`	`BIGNUMERIC`	Virtual token reserves in the bonding curve including the initial virtual liquidity offset. This represents the sum of real_token_reserves plus a fixed virtual amount used for price calculation in the automated market maker.

Sample Data

mint	user	is_buy	timestamp	accounts_0	block_slot	sol_amount	token_amount	surrogate_key	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	real_sol_reserves	transaction_index	transaction_signer	real_token_reserves	virtual_sol_reserves	virtual_token_reserves	outer_executing_account	outer_instruction_index
Dkupwy45oejQYSBV8LahZWD3AoKHs9jz71vnEDeEpump	123456aTXn4SimCu8REioNZxqTgunBGqbABgKGv3XkEx	false	1723996197	Ce6TQqeHC9p8KetsN6JsjHK7UTZk7nasjjnr7XxXp9F1	284378295	4814	167000000	284378295-aqdaGsjc8UHRRvA6jrQiJXkJzXXwWu8Rj7tWjHtKYtTXaYXmaGaVzURsmQTqJBqvwYQhYcVvr1uSSosU3bKJXbR-3-1	aqdaGsjc8UHRRvA6jrQiJXkJzXXwWu8Rj7tWjHtKYtTXaYXmaGaVzURsmQTqJBqvwYQhYcVvr1uSSosU3bKJXbR	2024-08-18T15:49:57.000Z	event_TradeEvent	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	1	462500496	26	123456aTXn4SimCu8REioNZxqTgunBGqbABgKGv3XkEx	776809052614634	30462500496	1056709052614634	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	3
GQCgKWBFqJdjG4TNMFFXQJQbzSWihYERum33xjhvpump	123456aTXn4SimCu8REioNZxqTgunBGqbABgKGv3XkEx	false	1723977205	Ce6TQqeHC9p8KetsN6JsjHK7UTZk7nasjjnr7XxXp9F1	284334910	0	0	284334910-5Wb5DDXaPbwRQE7DDBEt4X6GQmAWzjtN4sQk3jSEg9mYgbkcH5LBWL4ZKLmZiSgbrNxWWq1MamzzLGKHG1yhkum2-3-1	5Wb5DDXaPbwRQE7DDBEt4X6GQmAWzjtN4sQk3jSEg9mYgbkcH5LBWL4ZKLmZiSgbrNxWWq1MamzzLGKHG1yhkum2	2024-08-18T10:33:25.000Z	event_TradeEvent	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	1	2902757	145	123456aTXn4SimCu8REioNZxqTgunBGqbABgKGv3XkEx	792996188339856	30002902757	1072896188339856	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	3
GjqAxy7BCcHspp6b8GJtGiEDfKVHmAg2TCVkN8m9QhWE	1252LMqU54AqjUE2wf7ZUg2iVhXgma5NvKRW85uRCYqo	false	1723970475	Ce6TQqeHC9p8KetsN6JsjHK7UTZk7nasjjnr7XxXp9F1	284319337	114159747	1047865423493	284319337-2GKUUoQ1MTCGwQi3bpnSvWNK1t9cTT2aXJxHddNd2k6qp44Qq8ia9jMgyRizZwaiaU4a3iudcoo8NTUpJkvQSvXP-2-1	2GKUUoQ1MTCGwQi3bpnSvWNK1t9cTT2aXJxHddNd2k6qp44Qq8ia9jMgyRizZwaiaU4a3iudcoo8NTUpJkvQSvXP	2024-08-18T08:41:15.000Z	event_TradeEvent	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	1	29162379078	99	1252LMqU54AqjUE2wf7ZUg2iVhXgma5NvKRW85uRCYqo	264195767934325	59162379078	544095767934325	6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pumpfun_v1_solana.TradeEvent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

AMM_Buy_instruction

AMM_BuyEvent_event

AMM_Sell_instruction

AMM_SellEvent_event

CompleteEvent_event

CreateEvent_event

Pumpfun_Buy_instruction

Pumpfun_Sell_instruction

TradeEvent_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AMM_Buy_instruction

​AMM_BuyEvent_event

​AMM_Sell_instruction

​AMM_SellEvent_event

​CompleteEvent_event

​CreateEvent_event

​Pumpfun_Buy_instruction

​Pumpfun_Sell_instruction

​TradeEvent_event

Tables

AMM_Buy_instruction

AMM_BuyEvent_event

AMM_Sell_instruction

AMM_SellEvent_event

CompleteEvent_event

CreateEvent_event

Pumpfun_Buy_instruction

Pumpfun_Sell_instruction

TradeEvent_event