Flipside Docs
Search…
What is Flipside?
Our Data
Data Updates
Data Model Overview
Tables
Arbitrum Tables
AAVE Tables
Avalanche Tables
Algorand Tables
Astroport Tables
BSC Tables
Compound Tables
Ethereum Tables
Ethereum_Core Tables
Ethereum_Sushi Tables
FLOW Tables
Optimism Tables
Osmosis Tables
Osmosis Fact Airdrops
Osmosis Fact Blocks Table
Osmosis Fact Daily Balances
Osmosis Fact Governance Proposal Deposits
Osmosis Fact Governance Submit Proposal
Osmosis Fact Governance Votes
Osmosis Dim Labels
Osmosis Fact Liquidity Provider Actions
Osmosis Fact Msg Attributes Table
Osmosis Fact Msgs Table
Osmosis Dim Prices
Osmosis Fact Staking Rewards
Osmosis Fact Staking
Osmosis Fact Swaps
Osmosis Fact Transactions Table
Osmosis Fact Transfers
Osmosis Dim Vote Options
Osmosis Fact Superfluid Staking
Polygon Tables
Polygon 2.0 Tables
Solana Tables
Terra Tables
Terraswap Tables
THORChain Tables
Uniswap V3 Tables
Data Tutorials
Flipside App
Getting Started with the Flipside App
Parameterized Queries
Query Editor Shortcuts
ShroomDK (SDK)
🍄
Getting Started
🛠
SDKS
🔗
RestAPI
🛑
Rate Limits
Powered By GitBook
Osmosis Tables

Background of Osmosis

Blockchain: Osmosis​
Osmosis is a proof-of-stake IBC blockchain with a decentralized exchange application enabling users to provide liquidity, swap, and stake tokens from across the Cosmos ecosystem. The Osmosis Frontier application, which is a full permissionless listing and curation of bridged ETH and CW20 assets, exists alongside the main Osmosis application.
The native token of Osmosis, Osmo, is used for governance and paying transaction fees for actions performed on the DEX. There are a few points that make Osmosis a unique DEX:
  • Self-Governing Liquidity Pools: In Osmosis, the LP shares are used to calculate the fractional ownership of a LP, as well as the right to participate in the strategic decision making of the LP via governance. To incentivize long-term liquidity commitment, shares must be locked up for an extended period. Longer-term commitments are awarded by additional voting power and additional liquidity mining revenue.
  • Superfluid Staking: A method of staking the OSMO tokens that underlie your LP positions to earn additional rewards. Superfluid staking is at time of writing only available on certain OSMO pools on Osmosis.
  • MEV Resistance: Osmosis was conceived with the goal of Maximal Extractable Value (MEV) resistance at its core and includes several unique solutions to help limit MEV.

Current Osmosis Tables

The Osmosis table schema builds on the concepts in Flipside's event data model and exist in Velocity as the osmosis schema. The tables are built on the Osmosis transaction and messages information.
​Fact Msgs​

What we have:

  • All on-chain Osmosis events dating back to the genesis block in June 2021.
  • Labels for all available tokens on the Osmosis app and Osmosis validators.

What we don't have:

  • Data related to pool APY, as this is not available on chain.
  • Some labels & decimals for LP tokens and low market cap tokens.
  • The raw transaction log and information only available in the raw transaction log, including:
    • Superfluid Staking
    • Transaction Types for failed transactions
    Note: We are currently backfilling the raw transaction logs into our tables and will include this information as it becomes available.

What is in the works:

  • A balances table.
  • Additional labels sourcing for pools, etc.
Previous
Optimism Tables
Next
Osmosis Fact Airdrops
Last modified 14d ago
Copy link
Contents
Background of Osmosis
Current Osmosis Tables