Top Ledger
WebsiteTwitter
  • 👋Welcome to Top Ledger
  • DATA TABLES
    • 📊Solana Data
      • Blocks
      • Transactions
      • Account activity
    • 📊Smart Tables
      • DEX Trades
        • 📊DEX ecosystem on Solana
      • NFT Trades
        • 📊NFT ecosystem on Solana
      • cNFT Trades
        • 📊cNFT ecosystem on Solana
      • Liquid Staking
        • 📊LST ecosystem on Solana
    • ➡️Decoded Instructions Data
      • Metaplex
        • Auction House
        • Token Metadata
        • Candy Machine
          • CM V2
          • CM V1
      • Saber
      • Mercurial Finance
      • Sol Splits
      • Stake Pool
      • Hubble
      • Robox Fi
      • Switchboard V2
      • Drift V2
      • Tulip Protocol
      • AllDomains
      • Whirlpool
      • GooseFX
      • Invariant
      • Squads Protocol
      • xNFT Backpack
      • Sharky
      • Frakt
      • Flash
      • Helium
  • USE CASES
    • 📊Sample Dashboard
  • Developer docs
    • Integrate Topledger dashboards
    • Supported DBs
Powered by GitBook
On this page
  1. DATA TABLES
  2. Smart Tables

DEX Trades

The respective table contains all the dex trades on Solana since February 2021.

PreviousSmart TablesNextDEX ecosystem on Solana

Last updated 1 year ago

How we are indexing our dex_trades table?

We have written a Substreams to index this data. Substreams is a powerful blockchain indexing technology developed by . You can take a look at our indexing code .

The table below contains the project names and their respective program addresses that we have included in our dex_trades table.

Platform Name
DAPP
Instructions

Pheonix

Swap

Saros

Swap

Stepn

Swap

Crema

SwapWithPartner

Meteora

Swap

Openbook

Serum3PlaceOrder

Openbook V2

Symmetry

SwapFundTokens

Invariant

Swap

Orca Liquidity Pools

Swap

Lifinity v1

Swap

Lifinity v2

Swap

Saber

Swap

Raydium v4

SwapBaseIn

Raydium v3

SwapBaseIn

Raydium CLMM

Swap

Orca legacy

Swap

Aldrin AMM

Swap

Aldrin AMM v2

Swap

Cropper

Swap

Cykura

ExactInputSingle

GooseFX

Swap

GooseFX V2

Swap

BonkSwap

Swap

FluxBeam

Swap

Penguin

Swap

Balansol

Swap

Step Finance

Swap

Sencha

Swap

Dradex

CreateOrder

Oasis

Swap

Mercurial

Exchange

Orca v1

Swap

Crema

Swap

dex_trades

The table below contains all the dex_trades table columns , such as signer, pool_address, base_mint, quote_mint, amount, etc.

Column Name
Column Type
Description

block_time

timestamp

The time this block was produced

block_slot

bigint

This block’s slot index in the ledger

tx_id

string

The first signature in the transaction

signer

string

The first value from the account_keys array that initiates the transaction and pays the transaction fee

pool_address

string

The address of the pool

base_mint

string

Mint of the base token

quote_mint

string

Mint of the quote token

base_vault

string

Vault address of the base token

quote_vault

string

Vault address of the quote token

base_amount

double

Amount of the base token that is traded in the transaction

quote_amount

double

Amount of the quote token that is traded in the transaction

is_inner_instruction

boolean

Tells whether there is any inner instruction in the transaction or not

instruction_index

int

Instruction index of various instructions in a transaction

instruction_type

string

Name of the function of a Solana program invoked via an instruction

inner_instruxtion_index

int

Index of various inner instructions in a instruction

outer_program

string

The main program of an instruction

inner_program

string

The inner programs under the main/outer program

txn_fee

big_int

Fee this transaction was charged, as paid signer

signer_sol_change

bigint

Sol balance change of signer

partition_0

string

The date on which the block was produced

📊
StreamingFast
here
PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY
SSwapUtytfBdBn1b9NUGG6foMVPtcWgpRU32HToDUZr
Dooar9JkhdZ7J3LHN3A7YCuoGRUggXhQaG4kijfLGU2j
CLMM9tUoggJu2wagPkkqs9eFG4BWhVBZWkP1qv3Sp7tR
Eo7WjKq67rjJQSZxS6z3YkapzY3eMj6Xy8X5EQVn5UaB
srmqPvymJeFKQ4zGQed1GFppgkRHL9kaELCbyksJtPX
opnb2LAfJYbRMAHHvqjCwQxanZn7ReEHp1k81EohpZb
2KehYt3KsEQR53jYcxjbQp2d2kCp4AkuQW68atufRwSr
HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt
whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc
EewxydAPCCVuNEyrVN68PuSYdQ7wKn27V9Gjeoi8dy3S
2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c
SSwpkEEcbUqx4vtoEByFjSkhKdCT862DNVb52nZg1UZ
675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8
27haf8L6oxUeXrHrgEgsexjSY5hbVUWEmvv9Nyxg8vQv
CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK
9W959DqEETiGZocYWCQPaJ6sBmUzgfxXfqGeTEdp3aQP
AMM55ShdkoGRB5jVYPjWziwk8m5MpwyDgsMWHaMSQWH6
CURVGoZn8zycx6FXwwevgBTB2gVvdbGTEpvMJDbgs2t4
CTMAxxk34HjKWxQ3QLZK1HpaLXmBveao3ESePXbiyfzh
cysPXAjehMpVKUapzbMCCnpFxUFFryEWEaLgnb9NrR8
7WduLbRfYhTJktjLw5FDEyrqoEv61aTTCuGAetgLjzN5
GFXsSL5sSaDfNFQUYsHekbWBW1TsFdjDYzACh62tEHxn
BSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p
FLUXubRmkEi2q6K3Y9kBPg9248ggaZVsoSFhtJHSrm1X
PSwapMdSai8tjrEXcxFeQth87xC4rRsa4VA5mhGhXkP
D3BBjqUdCYuP18fNvvMbPAZ8DpcRi4io2EsYHQawJDag
SSwpMgqNDsyV7mAgN9ady4bDVu5ySjmmXejXvy2vLt1
SCHAtsf8mbjyjiv4LkhLKutTf6JnZAbdJKFkXQNMFHZ
dp2waEWSBy5yKmq65ergoU3G6qRLmqa6K7We4rZSKph
9tKE7Mbmj4mxDjWatikzGAtkoWosiiZX9y6J4Hfm2R8H
MERLuDFBMmsHnsBPZw2sDQZHvXFMwp8EdjudcU2HKky
DjVE6JNiYqPL2QXyCUUh8rNjHrbz9hXHNYt99MQ59qw1
6MLxLqiXaaSUpkgMnWDTuejNZEz3kE7k2woyHGVFw319