Flipside Docs
Search…
Osmosis Fact Liquidity Provider Actions

Table Schema

osmosis.fact_liquidity_provider_actions
Field
Type
Description
block_id
intger
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
ransaction status is "SUCCEEDED" if the transaction went through, "FALSE" if the transaction failed.
liquidity_provider_address
string
The address of the user interacting with the liquidity pool.
action
string
Whether the user is joining or exiting the liquidity pool.
pool_id
integer
A numeric ID that corresponds to the liquidity pool.
amount
integer
The quantity of cryptocurrency in the transaction.
currency
string
A string identifying the cryptocurrency used in the transaction.
decimal
integer
Divide amount by POW(10, decimal) to get the actual amount.
​
Copy link