OSMO on Coinbase

    This dashboard analyzes the impact of the recent listing of OSMO on Coinbase. The findings indicate that the listing had a limited effect on the token's price, with a continued downward trend observed. Swapping activity remained consistent, with a slight increase in swapped volume after the listing. Staking and delegation metrics showed stability, while transfer metrics experienced a slight impact on the listing date. Overall, the Coinbase listing had a modest immediate impact on OSMO, and further analysis is required to assess long-term implications.

    ✨Introduction
    🛠 Methodology

    The OSMO Listing Impact Dashboard provides a comprehensive analysis of the effects of OSMO token's listing on Coinbase. It assesses the impact on token price, trading activity on DEXs, liquidity on Osmosis, and staking/delegation within the Osmo ecosystem. By examining key metrics such as trading volume, liquidity, transfers, price volatility, staking participation, and delegation volume, this dashboard offers valuable insights into the implications of the listing for OSMO token holders, traders, and the overall ecosystem. It aims to help stakeholders and enthusiasts understand the effects of this significant milestone on OSMO's market dynamics and ecosystem engagement.

    The dashboard is divided into three sections: "DEX Activities and Price," "OSMO Transfers," and "Staking and Delegation." In the DEX Activities section, the focus is on analyzing the trading volume and liquidity of OSMO token on DEXs pre and post-listing. The OSMO Transfers and Price section examines token transfers, price volatility, and overall price trend to gauge market sentiment and response. The Staking and Delegation section evaluates staking participation and delegation volume providing insights into the level of engagement and confidence in the Osmo ecosystem following the listing. Overall, this dashboard serves as a valuable tool for understanding the impact of OSMO's Coinbase listing on various aspects of the token's market performance and ecosystem dynamics.

    To create this dashboard, we utilized data from several tables within the Osmosis database. The primary tables used were osmosis.core.fact_swaps and osmosis.core.ez_prices, which allowed us to track and evaluate transactions on Osmosis during three distinct time periods. These time periods were categorized as "Pre listing" for dates before '2023-05-25', "Listing Date" for the specific date '2023-05-25', and "Post listing" for dates after the listing.

    Additionally, we leveraged data from the osmosis.core.fact_staking and osmosis.core.fact_liquidity_provider_actions tables to monitor staking and delegation activities throughout the specified time period. These tables provided valuable insights into the engagement and participation of OSMO token holders in the network.

    Furthermore, we analyzed swapping metrics using data from the osmosis.core.fact_swaps and osmosis.core.dim_tokens tables over the past month. This allowed us to evaluate the swapping activities and patterns related to OSMO token.

    Lastly, we utilized the osmosis.core.fact_transfers table to examine the volume of OSMO tokens transferred and the number of transactions performed over the past month.

    By combining data from these tables and utilizing the defined time periods, we were able to create a comprehensive dashboard that provides insights into OSMO token's trading, liquidity, staking, delegation, swapping metrics, and transfer activities on Osmosis.