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.