Flipside Docs
Search…
Osmosis Fact Swaps

Table Schema

osmosis.fact_swaps
Field
Type
Description
block_id
integer
Unique sequential number that identifies the current block. Called "height" on block explorers.
block_timestamp
timestamp
The time the block began.
blockchain
string
Cross-chain identifier. In this table, blockchain will always be Osmosis.
chain_id
string
ID of the blockchain to connect to, i.e. Osmosis-1.
tx_id
string
A unique key that identifies a transaction. Called "TxHash" on block explorers.
tx_status
string
"SUCCEEDED" if the transaction went through, "FALSE" if the transaction failed.
trader
string
The wallet address of the user who initiated the swap.
from_amount
integer
The quantity of cryptocurrency to be swapped.
from_currency
string
A string identifying the cryptocurrency to be swapped.
from_decimal
integer
Divide from_amount by POW(10, decimal) to get the actual from_amount.
to_amount
integer
The quantity of cryptocurrency received in the swap.
to_currency
string
string identifying the cryptocurrency received in the swap.
to_decimal
integer
Divide to_amount by POW(10, decimal) to get the actual to_amount.
pool_ids
array
An array containing integers corresponding to the pools the swap went through.
Copy link