Flipside Docs
Search…
Solana Fact Swaps
solana.fact_swaps
Field
Type
Description
swap_program
string
The DEX or program used to make the swap
block_timestamp
timestamp
The time the block began
block_id
integer
Unique sequential number that identifies the current block
tx_id
string
A unique key that identifies a transaction
succeeded
boolean
TRUE when transaction succeeded. Otherwise this column is FALSE
swapper
string
Address that initiated the swap
swap_from_amount
integer
Total amount of the token sent in to initiate the swap
swap_from_mint
string
Token being sent or swapped from
swap_to_amount
integer
Total amount of the token received in the swap
swap_to_mint
string
Token being received or swapped for
Currently the swaps table only contains swap transactions completed on the Jupiter Aggregator and Orca Swaps. Coverage of swaps is estimated to be 95-98%. Swaps completed on Serum and Raydium are in the works and will arrive soon.
Swaps contained in this table are unique on block_id and transaction_id. Additional SQL logic to find distinct entries or to dedupe the table is unnecessary.
Copy link