Flipside Crypto Terra Bounty Monthly Recap

Fynn
14 min readAug 1, 2021

--

Here we go through ALL of the winning Flipside Crypto Bounty submissions from the first 5 weeks of bounties. Thank you to everyone who participated. It’s awesome to see such an engaged and driven community. This month we explored dashboards for the following topics:

  1. New User Inflow- scottincrypto + Shreyash + Hawk
  2. Best Yield-Farming Opportunities for Terra assets on Ethereum- Forports
  3. Transaction Fees- scottincrypto + Shreyash
  4. Decentralization of Validator System- Crypgoat
  5. Who should you delegate to?
  6. Peg Variance- Shreyash + XYZ
  7. Liquidity Pools on TerraSwap- iamnone
  8. Whale Spotting- lejimmy
  9. Rewards Analysis- Crypgoat
  10. How is UST being used?- Shreyash
  11. burn bLUNA burn- Crypgoat
  12. Liquidations on Anchor- Shreyash
  13. Validator Slashing- lejimmy
  14. Validator Ranking- scottincrypto + 0xFrank
  15. Governance- Shreyash
  16. Who’s that going across my bridge?- Brian + Shreyash
  17. Compare Native Swaps to Terra Swaps- TheZoomer
  18. Anchor Repayments- Shreyash
  19. Assets on Mirror- TheZoomer
  20. Staking Rewards- MARNEESEAWEED
  21. Oracle Prices- Forports
  22. New User Activity- Shreyash
  23. Tax Rate- scottincrypto
  24. Community Treasury- Shreyash
  25. Delegator Behavior- TheZoomer
  26. Unique Users- Forports
  27. UST Dominance-
  28. Terra vs. Ethereum Stablecoin Volatility- XYZ
  29. LUNA to UST Price to Stability Correlation- Sam
  30. Self-Validating- Shreyash + scottincrypto

What is Flipside Crypto? And how are they helping Terra?

Flipside Crypto provides on-chain analytics, including free structured and labeled data that users can use to create helpful dashboards. Flipside rewards analysts with crypto bounties for the insights they create!

Terra activated the Flipside x Terra bounty program by delegating 500K LUNA to their validator, which helps secure the network. The yield generated supports the continuous creation of data analytics by the community, for the whole Terra ecosystem.

YOU can begin today! Sign up for Flipside’s Velocity tool and you will be granted access to their HUGE variety of data. Then explore and improve your SQL skills and create a masterpiece of your own…

I personally have been using Flipside’s data for many different things. From learning and improving my SQL skills to participating in multiple bounties throughout the past few weeks. I truly believe that Flipside enables anyone with any level of skill to create something awesome.

Do you want to complete a Flipside Terra Bounty?

If you would like to participate in the Flipside Terra Bounties, visit this link. There you will find all of the previously completed bounties and the current ones as well!

Also, join the Flipside discord channel for any further questions or guidance: https://discord.com/invite/qjgtStbu2n

The Flipside community is very helpful so even if you are a beginner, don’t be afraid to reach out.

Now let’s dive into the BEST submission from the first month of Terra Flipside bounties!

Week 1:

(Bounty topic- winner (with link to Twitter))

Task #1: New User Inflow

Source: Scottincrypto

Above, we see a dashboard by Scottincrypto where he shows new Terra Accounts, new anchor users, new mirror users, users of Mirror and Anchor, whales on mirror and anchor, and concentration of whale activity. This is all thanks to Flipside’s data. Make sure to check it out:

Link: https://velocity-app.flipsidecrypto.com/dashboard/terra-new-user-inflow-QIakTM

Here we see another great submission by Shreyash, who takes a different approach. Shreyash analyzes Terra address growth, addresses staking Luna, Mirror cumulative daily interactions, Anchor cumulative daily interactions, unique mirror/anchor addresses, and Terra whale count. Nicely put together. Make sure to check it out:

Link: https://velocity-app.flipsidecrypto.com/dashboard/terra-new-user-inflow-d0Mblf

The third and final winner for “New User Inflow” was Hawk. Hawk used the Flipside data to see new Terra user inflow, new mirror user inflow, new anchor user inflow, average terra age of new anchor daily signups, average terra age of new mirror daily signups, daily balances EDA, new daily anchor whales, and lastly new daily mirror whales. Make sure to take a look:

Link: https://app.flipsidecrypto.com/dashboard/terra-new-user-inflow-EmfMmb

Task #2: Best Yield-Farming Opportunities for Terra assets on Ethereum

For this particular task, there was one winner: Forports

Forports analyzed different yield farming opportunities through the Flipside data by showing LP fee over time, LP volume, total fee generated, total fee generated by platform, top pools for wrapped Terra assets by APR, and average daily APR for Terra assets. Great work from Forports! Make sure to check it out!

Link: https://app.flipsidecrypto.com/dashboard/best-yield-farming-opportunity-for-terra-assets-on-eth-Z8Bzux

Task #3: Transaction Fees

For the transactions fees task, there were two winners. Both submissions were great and well deserved. Let’s see their varying approaches.

Shreyash was the first winner with a very nicely put together dashboard encompassing all of the necessary data. Shreyash chose to analyze total terra transactions, fees per stablecoin, UST stablecoin fees, and total fees in USD. Great work from Shreyash. Make sure to check it out!

Link: https://velocity-app.flipsidecrypto.com/dashboard/terra-transaction-fees-EkLmEA

Scottincrypto was the second winner for task 3. His dashboard was also very nicely put together. He features swap fees by day, terra transaction fees detail, swap fees by day without whale, and swap fees last 30 days by token combination/ without whale. Make sure to take a look!

Link: https://velocity-app.flipsidecrypto.com/dashboard/terra-transaction-fees-n2F5wr

Task #4: Decentralization of validator system

For this particular task, there was one winner: Crypgoat

In the dashboard, Crypgoat examines the amount of control held by the top validators on the Terra ecosystem. Crypgoat thoroughly examines Luna staked with top 10 validators, percentage voting control by validator, percentage of voting control (large validators-very large validators), B-Harvest voting share over time, staking fund voting power over time, and hashed voting power over time. Very well done from Crypgoat. Take a look!

Link: https://velocity-app.flipsidecrypto.com/dashboard/decentralization-of-terra-s-validator-system-ChxCOX

Task #6: Peg variance

For the peg variance task, there were two winners. Shreyash and Forg. Both submissions were great and well deserved. Let’s see their varying approaches.

Shreyash displays the peg variance of various stablecoins on Terra and goes into some detail on how their values change over time. He dives deeper into UST peg, UST peg difference, UST peg distribution, UST deviation frequency, other stablecoin pegs, and other stablecoin difference. Nicely done by Shreyash once again. Make sure to check it out!

Link: https://velocity-app.flipsidecrypto.com/dashboard/terra-stablecoin-peg-variance-RwdHUa

XYZ has made a very nice dashboard on the Peg Variance on Terra. Very aesthetically pleasing and well put together. We get to see daily balance across all addresses, UST from $1 peg, MNT value over 6 months, SDT value over 6 months, KRT value over 6 months, UST peg during march drawdown, and UST peg around mayday. Very nicely made. Check It out!

Link: https://app.flipsidecrypto.com/dashboard/terra-stablecoins-are-they-H4uNMJ

Week 2:

(Bounty topic- winner (with link to Twitter))

  • Liquidity pools on TerraSwap- iamnone
  • Whale Spotting- lejimmy
  • Rewards Analysis- Crypgoat
  • How is UST being used?- Shreyash
  • Burn bLuna Burn- Crypgoat
  • Liquidations on Anchor- Shreyash

Task #7: Liquidity Pools on TerraSwap

The dashboard from iamnone shows the volume of swaps in TerraSwap for the period from April to June. You can clearly see the period from mid-May marks a clear upward trend in both the volume of swaps and also the addresses interacting with TerraSwap. The LUNA-UST pair accounts for more than 75% of the swap volume.

Link: https://iamnone6512.github.io/week07jul21/7_Liquidity_pools_Terraswap.html

Task #8: Whale Spotting

For the Whale Spotting bounty, lejimmy has the winning submission. First, he defines what a whale is, then analyzes excluded addresses, after we take a look at the top 300 whales by wallet, and lastly we explore Whale activity, with regards to staking, swapping, and voting.

Link: https://app.flipsidecrypto.com/dashboard/8-easy-whale-spotting-rYJ7PB

Task #9: Rewards Analysis

This dashboard from Crypgoat aims to examine the magnitude and distribution of LUNA-denominated staking rewards in the Terra ecosystem. It uses data from the terra.transitions and ethereum.token_prices_hourly tables on Flipside’s databases, and aims to answer Flipside Terra Bounty #9. All commentary is as of July 2, 2021.

Task #10: How is UST being used?

This dashboard from Shreyash goes through all the possible places users can have their UST to get a sense of how UST is being used most. He explores UST holdings, UST on other chains, cumulative UST in liquidity pools, UST in mirror mint, UST in anchor, Mirror Mint transactions with UST collateral, and finally UST pair transactions. It is a very nice dashboard and is a well-deserved win.

Link: https://velocity-app.flipsidecrypto.com/dashboard/terra-ust-usage-0fZI7s

Task #11: Burn bLuna Burn

This dashboard from Crypgoat examines trends in bLuna burning over time, specifically focusing on the split between users who use “Instant Burn” and those who use “Protocol Burn.” It aims to answer Flipside Terra Bounty #11. All commentary is as of July 6th, 2020. This is a very well-put-together dashboard from Crypgoat. Make sure to check it out!

Link: https://velocity-app.flipsidecrypto.com/dashboard/analysis-of-b-luna-burning-methods-o63epj

Task #12: Liquidations on Anchor

This dashboard from Shreyash looks into liquidations on Anchor and how the price of LUNA impacted these liquidations over the last 90 days. Shreyash takes a deeper dive into liquidations per day, anchor liquidations vs. Luna price, accounts liquidated per day, total number of accounts liquidated on anchor, total anchor liquidations, anchor’s largest liquidations, accounts with most liquidations, and Anchor’s top liquidators. Great dashboard Shreyash! Take a look:

Link: https://velocity-app.flipsidecrypto.com/dashboard/terra-anchor-liquidations-QZgnX2

Week 3:

(Bounty topic- winner (with link to Twitter))

Task #13: Validator Slashing

The winner for this bounty was lejimmy. For this bounty he explores the following questions:

  • How many times has slashing of validators occurred on Terra in the past year?
  • What was the portion of funds that were slashed/jailed?

Link: https://colab.research.google.com/drive/1c8KiNhz82ggXnGqZAS81E-E706hfnqnR?usp=sharing

Task #14: Validator Ranking

The winner for bounty #14 is scottincrypto. He explores the following questions:
- Are the same validators that were in the top 10 (by rewards received) last month in the top 10 this month? Top 5? Break this down by change over the weeks in the past 2 months as well.

Link: https://colab.research.google.com/drive/1Doq9pqbA5LmdE-WZ8vNv-7uSVMTgzMPS?usp=sharing#scrollTo=QgsdIVlTIv5e

In this dashboard, 0xFrank takes a look at the change in Validator ranking based on Reward Received over 1 month and their Voting Power. He dives into daily reward distribution over 30 days, current validator by reward, daily validator ranking by voting power, and current validator ranking by voting power. Super aesthetically pleasing dashboard. Take a look:

Link: https://velocity-app.flipsidecrypto.com/dashboard/validator-ranking-a3yIfp

Task #15: Governance

This dashboard from Shreyash goes through different accounts, their voting power and also looks for discernable trends in how accounts with different sizes vote and take part in the governance of Terra. Shreyash looks into the number of accounts by size, Time-Series account binning over the last 30 days, voting power into 2 bins, proposals in the last month, voting for proposal 98/100/106/108, and voting splits for proposal 98/100/106/108.

Link: https://velocity-app.flipsidecrypto.com/dashboard/terra-governance-dXb0GL

Task #16: Who’s that going across my bridge?

Here we see Brian’s “Ultimate Bridge Dashboard”. Brian analyzes many different aspects when analyzing the bridge. Make sure to take a look at his large dashboard on everything you need to know regarding the Bridge.

Link: https://app.flipsidecrypto.com/dashboard/16-ultimate-bridge-dashboard-UuVEzm

This dashboard from Shreyash goes through various statistics around the movement of funds between Ethereum and Terra using the ETH Shuttle on Terra. We focus on the movement of UST and LUNA to keep things simple and also because they are the majority of funds moved across the ETH bridge.

Task #17: Compare Native Swaps to Terra Swaps

Here we see a deep dive into the Terra swapping system from TheZoomer. TheZoomer looks into Native Swaps volume, Terra Swaps volume, Swaps comparison, Transactions volume history, Whales use of swaps, smaller wallets use of swaps, and finally Swap Volumes per wallet activity. This is very nicely put together. Make sure to check it out!

Link: https://app.flipsidecrypto.com/dashboard/analysis-of-terra-swaps-s9x7DZ

Task #18: Anchor Repayments

This dashboard from Shreyash goes through loans and repayments on Anchor. It tries to look at trends in borrowing and repayments. Shreyash looks into daily borrowing on Anchor, weekly borrowing on Anchor, monthly Anchor borrowing, daily repayment amounts, weekly repayment amounts, monthly repayments on Anchor, total borrowing on Anchor, total repayments on Anchor, total borrows liquidated, and daily/weekly/hourly borrows, repayments, and liquidations. This is a great dashboard from Shreyash. Take a look!

Link: https://velocity-app.flipsidecrypto.com/dashboard/terra-anchor-repayments-r8TDeM

Week 4:

  • Assets on Mirror
  • Staking Rewards
  • Oracle Prices
  • New User Activity
  • Tax Rate
  • Community Treasury

Task #19: Assets on Mirror

The winner for task #19 was TheZoomer. We see a great overview on everything you need to know about mirrored assets, including top 10 mAssets in the last 30 days, top 10 mAssets in the last quarter, asset history 2021, and finally transaction history 2021. Very nice and simple analysis by TheZoomer! Make sure to check it out!

Link: https://app.flipsidecrypto.com/dashboard/mirror-assets-gCri5k

Task #20: Staking Rewards

Above, we see a dashboard from MARNEESEAWEED. In this dashboard, marnee explores the relationship between the amount of Luna staked versus the number of rewards received. We get to see a deeper dive into average luna staked per month, the sum of rewards claimed on Terra station daily, average rewards claimed on a daily basis for each month, the volume of MIR token claimed each month, average MIR price for each month, the volume of ANC tokens claimed each month, and average ANC price for each month. Great dashboard and analysis by Marneeseaweed. Take a look!

Link: https://velocity-app.flipsidecrypto.com/dashboard/how-much-do-we-earn-from-staking-luna-ORwbI9

Task #21: Oracle Prices

This dashboard from Forports analyzes the Terra Oracle Price voting mechanism. Stats like if validators are voting within the reward band are discussed. Forports dives into the oracle reward band change proposal, abstain oracle votes, oracle votes 2 months ago, oracle price votes for UST, rate difference, frequency of voting out of bounds, and finally average voting power. Make sure to check it out!

Link: https://app.flipsidecrypto.com/dashboard/terra-oracle-price-votes-ogM_Zu

Task #22: New User Activity

In this dashboard from Shreyash, he explores the growth of new users on Terra, the flow of users and assets to different dApps on Terra, and maps the early activities of new users to different protocols/dApps on Terra. Make sure to check it out!

Link: https://amusing-sky-b53.notion.site/Terra-New-User-Activity-968c66bc25df4783ac687490141631e2

Task #23: Tax Rate

Here we see a dashboard from scottincrypto where he analyzes Tax Rate %, long term vs. short term unit rewards, and also staked Luna. Very nicely put-together dashboard by Scott. Take a look!

Link: https://velocity-app.flipsidecrypto.com/dashboard/terra-tax-rate-d-P7iA

Task #24: Community Treasury

In this dashboard from Shreyash, he tries to find the Terra Community Treasury Wallet. He also looks into the activity of this wallet to understand how the funds are being used. Nicely done.

Link: https://www.notion.so/Terra-Community-Treasury-66d8e3015d1c4988993f69f5916e776f

Week 5:

Task #25: Delegator Behavior

Here is an analysis of behavioral patterns amongst delegators’ wallets vs non-delegators from TheZoomer. TheZoomer takes a deeper dive into the importance of delegators, an overview of Terra wallets, interactions with the ecosystem, anchor, mirror, pylon, swaps, and transactions. Great dashboard!

Link: https://app.flipsidecrypto.com/dashboard/terra-wallets-behavior-lTgdKj

Task #26: Unique Users

Each day there are new users who discovered and onboarded the Terra ecosystem. However, do we see gradual increase or spikes whenever there are new protocols launching on Terra? This is what forports answers in this dashboard. Make sure to check it out!

Link: https://app.flipsidecrypto.com/dashboard/unique-users-Pt5bxZ

Task #27: UST Dominance

This dashboard from Lostarious analyses the transaction counts and USD volumes for native swaps and terraswaps. Then examines the UST dominance for these metrics over time. Very well put together dashboard.

Link: https://app.flipsidecrypto.com/dashboard/ust-dominance-in-native-swaps-vs-terraswaps-y7JTgT

Task #28: Terra vs. Ethereum Stablecoin Volatility

XYZ compares the price of the UST-Tether pool on Uniswap V3 against the UST oracle price on Terra in a nice looking dashboard. Check it out!

Link: https://app.flipsidecrypto.com/dashboard/ethereum-ust-peg-uniswap-liquidity-vs-volatility-aBtxcH

Task #29: LUNA to UST Price to Stability Correlation

In this dashboard, Sam explores the volatility of Luna prices and how it affects the prices of UST, KRT and MNT. Besides UST, Sam looks at KRT and MNT because they are currently being used in real world applications, namely Chai in Korea and MemePay in Mongolia respectively. Take a look!

Link: https://velocity-app.flipsidecrypto.com/dashboard/does-lunas-changes-in-prices-impact-the-price-of-ust-krt-and-mnt-e4dGqc

Task #30: Self-Validating

This dashboard from Shreyash looks through the top validators on Terra with a focus on how much of their voting power is self-delegated. Shreyash takes a look at the top 20 instead of the top 5 since the top 5 changes all the time the top 20 gives us a bit of a buffer against these changes in validator rankings.

--

--