Unique sequential number that identifies the current block
A unique key that identifies a transaction
TRUE when transaction succeeded. Otherwise this column is FALSE
Address that initiated the swap
Total amount of the token sent in to initiate the swap
Token being sent or swapped from
Total amount of the token received in the swap
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.