Osmosis Fact Liquidity Provider Actions

Table Schema

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