jupiter_solana.aggregator_swaps

The jupiter_solana.aggregator_swaps table captures data on trades executed through the Jupiter aggregator on Solana.

Table Description

The jupiter_solana.aggregator_swaps table captures high-level trade data executed via the Jupiter decentralized exchange (DEX) aggregator on Solana. Jupiter is the most important and only relevant aggregator on Solana, providing users with the best possible trade execution by aggregating liquidity from multiple DEXs.

Functional Overview

Users can expect the jupiter_solana.aggregator_swaps table to provide a comprehensive view of DEX trades facilitated by Jupiter on Solana. This table records each trade as a single entry, showing the user’s intended swap from input token to output token.

For instance, a user might initiate a trade to swap USDC for SOL via Jupiter. The aggregator might route this trade through several liquidity pools, but jupiter_solana.aggregator_swaps will record it as a single USDC -> SOL trade, including details such as the amounts, USD values, and the specific AMM used for the swap.

Coverage

This table covers all trades executed through the Jupiter aggregator on Solana, which includes liquidity from various Solana-based DEXs and AMMs.

Table Schema

Column	Type	Description
amm	VARCHAR	Program ID of the AMM routed through
amm_name	VARCHAR	Name of the AMM routed through
token_pair	VARCHAR	Token pair routed through
input_symbol	VARCHAR	Symbol of the token sold
input_mint	VARCHAR	Mint address of the token sold
input_amount	BIGINT	Raw amount of the token sold
input_decimals	BIGINT	Decimals of the token sold
input_usd	DOUBLE	USD value of the token sold
output_symbol	VARCHAR	Symbol of the token bought
output_mint	VARCHAR	Mint address of the token bought
output_amount	BIGINT	Raw amount of the token bought
output_usd	DOUBLE	USD value of the token bought
output_decimals	BIGINT	Decimals of the token bought
log_index	BIGINT	Ordering of the swap within the transaction
tx_id	VARCHAR	Transaction ID
block_slot	BIGINT	Block slot number
block_time	TIMESTAMP	UTC block time
block_month	DATE	Block month (partition key)
tx_signer	VARCHAR	Signer of the transaction
jup_version	INTEGER	Version of the Jupiter aggregator used

Table Sample