dex_solana.trades

The dex_solana.trades table captures detailed data on decentralized exchange (DEX) trades on the Solana blockchain, recording all raw trade events across various protocols.

Table Description

The dex_solana.trades table captures detailed data on trades executed via decentralized exchanges (DEXs) on the Solana blockchain. This table records all raw trade events that occur across all liquidity pools on Solana DEXs, providing a comprehensive view of the entire trade execution process and detailing the specific paths and liquidity sources utilized.

Functional Overview

The dex_solana.trades table provides an in-depth view of trades on Solana-based decentralized exchanges like Raydium, Orca, or Serum. This table includes entries for each segment of a trade that passes through different liquidity pools, as well as single-step trades. For example, a user may initiate a trade to swap USDC for RAY. If this trade is executed through multiple liquidity pools, such as USDC-SOL and SOL-RAY, the dex_solana.trades table will record each segment of the trade as a separate entry. Conversely, a single-step trade, such as directly swapping USDC for SOL, will be recorded as a single entry.

This detailed approach allows for granular analysis of trade execution paths on Solana, enabling users to:

• Analyze Liquidity Sources: Understand which liquidity pools are used and how they interact in both single-step and multi-step trades on Solana DEXs.
• Track Trade Execution Paths: Follow the exact route a trade takes across different Solana DEXs and liquidity pools.
• Assess Slippage and Execution Quality: Evaluate the impact of each step on the overall trade execution, including slippage and price changes in the Solana ecosystem.
• Monitor Market Dynamics: Gain insights into the behavior and dynamics of different liquidity pools and DEXs over time on the Solana blockchain.

By providing comprehensive trade details, the dex_solana.trades table supports advanced analytics and research into DEX trading behavior and liquidity management specific to the Solana ecosystem.

Coverage

Table Schema

Column	Type	Description
blockchain	VARCHAR	Blockchain (always solana)
project	VARCHAR	Name of the DEX protocol
version	INTEGER	Version of the contract
version_name	VARCHAR	Version name
block_month	DATE	UTC event block month (partition key)
block_date	DATE	UTC event block date
block_time	TIMESTAMP	UTC event block time
block_slot	BIGINT	Block slot number
trade_source	VARCHAR	Whether the trade was a direct call or routed through an aggregator like Jupiter
token_bought_symbol	VARCHAR	Symbol of the token bought
token_sold_symbol	VARCHAR	Symbol of the token sold
token_pair	VARCHAR	Token symbol pair
token_bought_amount	DOUBLE	Amount of the token bought in display units
token_sold_amount	DOUBLE	Amount of the token sold in display units
token_bought_amount_raw	UINT256	Raw amount of the token bought
token_sold_amount_raw	UINT256	Raw amount of the token sold
amount_usd	DOUBLE	USD value of the trade at time of execution
fee_tier	DOUBLE	Pool fee tier (fee percentage)
fee_usd	DOUBLE	Fee paid on swap in USD
token_bought_mint_address	VARCHAR	Mint address of the token bought
token_sold_mint_address	VARCHAR	Mint address of the token sold
token_bought_vault	VARCHAR	Token vault address for the pool, of the token bought
token_sold_vault	VARCHAR	Token vault address for the pool, of the token sold
project_program_id	VARCHAR	Pool program ID of the DEX project
project_main_id	VARCHAR	Project main ID
trader_id	VARCHAR	Address of the trader who initiated the swap
tx_id	VARCHAR	Transaction ID
outer_instruction_index	INTEGER	Top-level instruction index for the transaction
inner_instruction_index	INTEGER	Inner instruction index for the transaction
tx_index	INTEGER	Index of the transaction in the block slot

Table Sample

Examples

The following query demonstrates how to use the dex_solana.trades table to calculate the total volume of trades on a weekly basis for Solana DEXs.

SELECT
  DATE_TRUNC('week', block_time) AS week,
  SUM(CAST(amount_usd AS DOUBLE)) AS usd_volume
FROM
  dex_solana.trades
WHERE
  block_time > NOW() - INTERVAL '365' day
GROUP BY 1
ORDER BY 1

DEX Dashboard

For more examples of how to use the dex_solana.trades table, check out this dashboard.