Teeefz
Understanding the Average Trade Sizes of Top 5 Assets on Terra
Sep 4, 2021 - This dashboard aims to examine the top 5 traded assets on TerraSwap by total volume and average volume. Hypotheses include discerning whether the top 5 assets by trade volume are corresponded by having higher averages in trade volume. This dashboard uses data from the terra.swaps tables provided on Flipside’s databases, and aims to answer Flipside Terra Bounty #60 Average Trade Sizes. All commentary is as of 4th Sep, 2021.
$LUNA's price v.s. $UST Supply
Dec 4, 2021 - Enjoyed the recent ride folks? There's been a debate recently about burning $LUNA v.s. $LUNA price action. Let's take a closer look at how the two are correlated. This is kleppyz (T,T)#5805's submission for 108. [Easy] The Fundamentals.
Anchor Liquidation & Price Action
Dec 26, 2021 - A look into the correlation of $LUNA price action against the number of liquidations per day.
Weighing Anchor Users
Jan 8, 2022 - Understanding the makeup of top anchor users on Terra's anchor protocol!
An analysis of TerraSwap Dominance
Aug 29, 2021 - This dashboard aims to examine the top 5 pool pairs on TerraSwap by swap volume & by total locked volume; hypotheses include whether the top 5 pool pairs by swap volume and total locked volume are the same. This dashboard uses data from the terra tables provided on Flipside’s databases, and aims to answer Flipside Terra Bounty #57 TerraSwap Dominance Dashboards. All commentary is as of Aug 29, 2021.
An analysis of Terra Whales 🐳
Dec 21, 2021 - kleppyz (T,T)#5805's analysis of TerraWhales - one of my favourite NFT projects on the Terra ecosystem! :)
Finding the gas (or absence of it!) on the polygon network
Dec 9, 2021 - kleppyz (T,T)#5805's submission for the gasless polygon scavenger hunt!
Apollo-2021 hunt
Oct 9, 2021 - That's one small step for me, and one giant leap for the Terra ecosystem.
Polygon Shapeshifter Hunt
Aug 21, 2021 - My first exploration of the Polygon Network and SQL at the same time. Went to buy some $MATIC using my USDT in Binance Exchange. Following which, I sent my $MATIC to my Metamask wallet, and went to deposit my $MATIC into AAVE for APY of 0.59%. I've also explored the fees incurred from depositing my $MATIC into AAVE.
Depositing & Borrowing on Anchor
Dec 25, 2021 - Anchor has been one of the hallmark protocols catapulting Luna & UST's success. Today, let's take a look at deposit and borrow trends for $UST over a period of 6 months.
Mariner Hunt - Tapping into Anchor's delicious 19.5% APY!
Sep 18, 2021 - teeefz#5805's submission for the Mariner Hunt :) Thanks Flipside Crypto fam <3
An Overview of Terra's Stablecoin Supply
Sep 4, 2021 - This dashboard aims to examine the total supply of circulating stable coins on Terra, excluding Luna. This dashboard uses data from the terra.daily_balances tables provided on Flipside’s databases, and aims to answer Flipside Terra Bounty #60 TerraSwap Dominance Dashboards. All commentary is as of 5th Sep, 2021.
Understanding Delegator Churn Rates
Sep 1, 2021 - By far one of the most trickiest analysis I’ve tried since I’ve started a few weeks back on SQL! This dashboard attempts to answer bounty #54: Delegator Churn, whereby we shall examine what’s the average frequency of delegators changing a validator, and also understand the delegator churn rate over a 6-month period.
Exploring Trends in Delegator Delegation Distribution
Aug 22, 2021 - This dashboard aims to examine the average and median number of unique validators per delegator in the Terra ecosystem. It uses data from the terra.staking on Flipside’s databases, and aims to answer Flipside Terra Bounty #51. All commentary is as of Aug 22, 2021.
Understanding trends in bonded v.s. unbonded $LUNA
Aug 30, 2021 - This dashboard aims to understand the movement of Bonded Luna (BLuna) v.s. Unbonded Luna (Luna) over the past 6 months (from Mar to Aug 2021). This dashboard uses data from the terra tables provided on Flipside’s databases, and aims to answer Flipside Terra Bounty #58 Bonded vs. Unbonded LUNA Amount. All commentary is as of Aug 30, 2021.
An analysis of mirror asset transaction volume in the past 90 days
Nov 23, 2021 - An analysis of transaction volume by UST amount transacted by mAsset in the past 90 days. For this study, $MIR was not included into the analysis. As submitted by kleppyz#5805 (previously teeefz) for 1. [Easy] Asset Transaction Volume.
Mirror, Mirror on the wall; Who's the farm-iest of them all?
Sep 28, 2021 - teeefz#5805's submission for the Magic Mirror Hunt :-)
An Overview of Chai Transaction Volume over the Past 6 Months
Sep 10, 2021 - This dashboard aims to provide an overview of Chai transaction volume over the past 6 months. This dashboard uses data from the terra tables provided on Flipside’s databases, and aims to answer Flipside Terra Bounty #68. Chai Volume. All commentary is as of Sep 11, 2021.