You made it to the end💪💪………..here’s some🍨for your efforts😉😂

WRITTEN BY:💤zackmendel💤

DISCORD: Zackmendel#9537

TWITTER: @Samuel72321790

EMAIL: samuelisaac1995@gmail.com

TWEET: Tweet

INTRODUCTION🤝

On the 14th of January 2023, Terra took to their Twitter handle to announce what they've been cooking for quite sometime now. It is the launch of STATION. Station is an interchain wallet that simplifies the often complex processes encountered when interacting with multiple blockchain networks. This new innovation is expected to make staking, voting, sending & receiving tokens, and interacting with users favourite dApps easy across all supported chains. For a detailed info & guide on how to use station.....please visit Medium

KEY FINDINGS🔍

From the analysis done and charts presented , it can be concluded without any doubt that the launch of Station is or has been a complete success.

The timing for it also seems to be a good influencer to the positive reception it got, I’m talking about the crypto market being in the bullish trend right now. Launching Station could not have come at a more perfect time.

AIM🎯

• This dashboard aims to measure the success of the Station after its launch
• To do that, we plan to define and visualize at least 2 metrics for ecosystem activity and analyze them in the week before and after the Station.
• Did the launch have any measurable impact?
• Are there other factors that might be in play affecting the metrics you’ve chosen?
• The questions above are some examples that this dashboard plans to answer.

✅METHODOLOGY

• Flipside tables will be used for this analysis
• The Terra core & crosschain core(for price) tables will be used for this analysis.
• The dashboard shall be divided into the following sections:
  • General Stats (transaction count, new & active users)
  • Staking Stats
  • Swapping Stats
  • Contract Deployment Stats
• The timeframe used is between '2023-01-07' AND '2023-01-27' and the following line of code is used as a clause to get a category of before & after station was launched:

CASE WHEN timespan < '2023-01-14' THEN 'Before Station' ELSE 'After Station' END AS events

1. OVERALL TRANSACTION STATS

✍️COMMENTS

> * The price of LUNA is seen to be on a steady rise since before Station. > * Daily Transaction count & fees, Active & New user count can be seen to have jumped in values since after the launch of Terra. > * From cumulative chart, growth is seen to be rapid. > * Overall, it can be said that a positve and favourable response was received from Station based on this metrics shown.

2. STAKING ACTIVTY REVIEW ON TERRA

> * The terra.core.ez_staking tables shall be used for this segment’s analysis > * To do this, the following actions were discovered on the flipside staking event table and their respective means are attached based on the terra docs on staking management: Delegate = Staking, Undelegating = Unstaking, Redelegation = Restaking with no waiting period and Withdraw Rewards which is exactly what it sounds like.

> There are two(2) subsections in this section,

> * the first records all three(3) actions(stake, unstake & restake) together as staking activity to get an overall view of what’s going on > * the second picks each action and chart its behaviour to get the individual characteristics of each staking action

> ## ✍️COMMENTS > > * Staking transaction, delegators count & amount are all seen to have high values after the launch of Station than before the launch. > * From cumulative distribution, there is a surge in the growth of all metrics. > * Staking on Terra seems to be doing better after Station than before.

3. SWAP STATS ON TERRA

> The terra.core.ez_swaps will be used for analysis in this section. We are only taking a general look at swap activities on Terra so no specific token will be focused on here, just an overall estimate will be made.

> ## ✍️COMMENTS

> * It can be seen from charts that transaction count and swap volume has greatly increased since after the launch of Station than before its launch.

4. DAILY CONTRACT DEPLOYMENT ON TERRA

The message type associated to contract deployment is ‘instantiate’ and shall be used to filter out the required data for contract deployment.

Deployment fees are gotten by joining fact_message to fact_transactions tables of the terra core schema

> ## ✍️COMMENTS

> There were more contracts deployed, deployers & fees generated after the launch of Station than before its launch.

> From cumulative distribution chart, growth is seen to be rapid from after the launch of Station.

> Activities recorded below are the individual stake, unstake and restaking amounts on Terra as recorded in the timeframe. It can be noticed at first glance that the three(3) activities had highest values after the station launch.

5. DAILY CONTRACT MIGRATION ON TERRA

The message type associated to contract migration(i.e reset a contract’s code id to a new one) is the ‘migrate’ filter and shall be used to filter out the required data

> ## ✍️COMMENTS > > * There were more migrations after the launch of Station than before its launch. > * From cumulative curves, growth is seen to be steady before Station and rapid after station.