Osmosis Fact Swaps

Table Schema

osmosis.core.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.