Owentell
26. [Hard] Network Load
Dec 8, 2021 - This dashboard looks at network load on the THORChain network, which allows for the transfer of assets from differing blockchains, for example, a swap of BTC for ETH. THORChain has experienced several network shutdowns since its inception, some due to audits while others due to hacks or other network issues. The first metric in this dashboard looks at the volume of swaps per minute on the network. The minute with the highest number of swaps was on October 22nd at 3:44 AM, where 149 swaps were made. The month with the highest number of minutes in the top 10 was June, which had the highest swaps per minute four times. The next metric looks at the maximum daily swaps per minute, which as mentioned earlier belongs to October 22nd 2021, by a wide margin. The second highest has almost 40 swaps less. The maximum one-minute swap number seems to remain relatively stable from about mid-June 2021 to now, with mid-April to mid-June 2021 having a significantly lower one-minute number of swaps. The final metric in this dashboard looks at the minutes with the highest swap volume in USD. By far the greatest swap volume occurred on July 15th, 2021, at 7:36 AM, with a swap volume of almost $3.5 million. Interestingly enough, none of the top ten minutes with the highest number of swaps were in the top ten minutes by swap volume. This suggests that a few large trades are more likely to make up most of a high-volume minute than a large number of smaller trades.
THOR-versary!
Apr 23, 2022 - THORChain just hit its one-year anniversary! This dashboard will look at multiple metrics of the THORchain protocol in its first 30 days compared to its last 30 days.
Anchor Poll 18 Investigation
Mar 12, 2022 - This dashboard looks into voter activity for Anchor poll 18, specifically regarding the age of 'Yes' voter's ANC holdings.
Gain or Lose
Jun 16, 2022 - This dashboard looks at the amount of ETH users have lost swapping from stETH to ETH, and vice versa.
1. Comparing Yearn Vault Strategies
Aug 11, 2021 - Select two of the available strategies; define and visualize the returns each has generated over the past 30 and 90 days; and compare their performance.
35. [Hard] Mirror & Anchor TVLs
Aug 4, 2021 - This chart shows the ANCH and MIR locked value per hour. The total value locked of ANCH and MIR does not seem to have changed significantly over the past month.
Market Module
Apr 7, 2022 - This dashboard explores the inner working of Terra's Market Module and looks at how well it has been performing its stated goals.
Mind Your Ps and Ys
Mar 31, 2022 - This dashboard looks at the prices of pLUNA and yLUNA and what factors could contribute to their relative value.
Sablier Cash Streams
Apr 23, 2022 - This dashboard looks at how many Sablier cash streams have been cancelled before their stop time.
6. Playground Collections
Sep 7, 2021 - So far, 15 artists have taken the opportunity to transition from the Curated collection of Art Blocks to the Playground collection. I chose 5 artists who I thought had interesting projects, and looked at the average sale price in USD of projects in their Curated collection, versus the average sale price of projects in their Playground collection. Surprisingly, 2 of the 5 artists had a higher average sale price in their Playground collection, which I had thought would have a lower sale price as they were not projects specifically chosen by the board of the Art Blocks team. Kjetil Golid had the highest difference in average sale prices, with his Curated projects netting an average of $12,206.25 more than his Playground projects.
Foundation Fees vs Others
Apr 23, 2022 - This dashboard looks at fees on the Foundation NFT marketplace and compares them to fees on Opensea.
13. [Easy] Combinations
Nov 4, 2021 - This dashboard looks at different metrics of swap pairs on the THORChain protocol. To find the most popular swap pairs, I found the total number of swaps and the total swap volume for each one. The first graph in this dashboard looks at the top five swap pairs by total number of swaps. By far the top two pairs are BUSD to RUNE and RUNE to BUSD, each about three times the number of swaps of the next highest pair. Looking at the next graph, the top 5 pairs by swap volume, we can see that BUSD to RUNE and RUNE to BUSD are again by far the most popular. This suggests that the RUNE-BUSD pool is the most widely used pool for swapping, although interestingly enough it does not have the highest liquidity. Currently as of 11/4/21, the RUNE-BTC pool has the highest liquidity at about $77 million. This suggests that just because a pool is popular for swapping, that doesn't mean it is the most popular for depositing assets into.
$THOR Staking Wallets
May 24, 2022 - This dashboard looks at how many wallets have staked THOR since the release of THOR Staking 2.0 in May.
How Many Times was Hop used?
Apr 23, 2022 - This dashboard looks at how many times was the hop protocol used in 2022 to bridge funds to layer 2.
2. Pool Players
Jan 12, 2022 - Anchor is a borrowing, lending, and savings protocol on the Terra blockchain. Users have many ways to increase their investment on the platform, including providing liquidity to its ANC-UST LP. This dashboard looks at different metrics of users providing liquidity to Anchor's ANC-UST pool. Looking at the first graph, the number of users providing liquidity has remain relatively consistent over time, with a sharp spike at its inception in March of 2021. There has also been an increase in users depositing funds over the last few months, with a large spike in mid-December of 2021. The wealth distribution of those who have deposited is largely skewed toward the lower end, with by far the most users having an account balance under $1000. Surprisingly few whales have deposited into the liquidity pool, with only 12 users with a balance higher than $100,000. I next looked at the change in the wealth distribution of users who deposited in November of 2021 versus December of 2021. The difference in distribution between the two months is negligible, although many more users provided liquidity in December compared to November. The last metric I looked at was whether more users who deposited in November or December were LUNA stakers. About 60% of users in November and December were LUNA stakers, suggesting that the makeup of depositors in Anchor's ANC-UST LP does not change substantially month to month.
Bots and Success Rate
Apr 28, 2022 - This dashboard compares the success rate of transactions executed by bots in the past 60 days with average users' transactions in the same time period
Net $THOR Staked
May 25, 2022 - This dashboard looks at the net amount of THOR tokens staked since the release of THOR Staking 2.0.
4. Total volume swapped by pool and over time
Oct 25, 2021 - This dashboard looks at the total volume swapped by pool and the volume swapped by pool over time using the THORChain protocol. The THORChain platform allows for assets from different blockchains to be swapped, for example BTC to ETH. Looking at the pools with the highest swap volume, we can see that BNB.BUSD is far ahead of the others, with a total swap volume of almost 500 million. The pool with the lowest swap volume is ETH.RAZE, with a swap volume of only 63,588.25. The graph in this dashboard looks at the volume of the top 5 highest volume pools over time. BNB.BUSD has had the highest swap volume almost the entire time since THORChains inception, although the ETH.ETH pool has been catching up in the past few days of October. In fact, on October 23rd, the ETH.ETH pool had a swap volume of about 20 million while the BNB.BUSD pool only had a volume of about 13.5 million. There is a gap in swap volume from the middle of July to the middle of September, most likely due to halt in swapping because of multiple audits THORChain had undergone in that time period.
Top Delegator Overlap
Aug 18, 2021 - Which validators do the top 25 delegators (by volume) delegate to? Do they tend to delegate to the same validators, or to different ones?
79. [Hard] Liquidation Response
Oct 6, 2021 - This dashboard looks at the activity of borrowers on Terra after they have been liquidated. Terra allows users to borrow stablecoins with the Anchor protocol, by providing collateral. According to the Anchor protocol website, "borrows can be made until the loan's loan-to-value (LTV) ratio reaches the MAX LTV, calculated based on collateral types, their prices, and deposit amount". If this LTV ratio goes over the MAX LTV, the borrowers position can be liquidated. Here I looked at five borrowers on Anchor who were liquidated, and if they decided to take out further loans after. Of the five borrowers, only two decided to take out more loans, and took out 57 and 58 respectively. It seems that many do not continue to borrow after they have been liquidated, which makes sense as it could scare some from trying again. Although it seems if they do continue to borrow, they borrow in high amounts, which is interesting. Extrapolating from this small sample size, it seems borrowers, "go big or go home" after being liquidated.
Foundation Mint and Sales
Apr 21, 2022 - This dashboard looks at NFT mints and sales on the Foundation platform.
28. Terra vs. Ethereum Stablecoin Volatility
Jul 28, 2021 - The UST oracle price on Terra has been much more volatile compared to the UST tether pool on Uniswap V3.
3. Number of Users of THORChain Bridges by Asset
Oct 25, 2021 - This dashboard looks at the number of users interacting with THORChain by asset, either Ethereum or Binance. The first display looks at the number of unique users of THORChain from the Binance and Ethereum blockchains, interacting with THORChain. The number of unique users from Binance far exceeds the number of users from Ethereum, by more than 10 times in fact, with the number of users from Binance at 9,439, and the number of users from Ethereum at only 720. The graph shows the number of users from Binance and Ethereum interacting with THORChain by day. As you can see in this graph, the number of users from Binance has far outweighed those from Ethereum every day. The day thus far with the highest user activity was July 1st, with 652 users from Binance, and 52 Ethereum users, interacting with THORChain. The gap in users interacting with THORChain from mid July to October is most likely due to the multiple audits THORChain has undergone in that time.
Most Common Transactions
Jun 24, 2022 - This dashboard looks at the most common transactions for Metamask users.
Uniswap Volume Projections
Aug 18, 2021 - What is going to happen to Uniswap swap volume in the coming quarter?
The Nightmare Scenario
Apr 23, 2022 - In what circumstances would the price and supply of LUNA and the supply of UST constitute a serious threat to UST redemption, i.e. create an imbalance wherein the UST-LUNA exchange mechanism would no longer function properly? What is the likelihood of such a scenario, and how might it be mitigated?
Swing and a Miss
Feb 17, 2022 - This dashboard looks at the rate of transaction failures on the Terra wormhole by what blockchain transactions are being sent to.
21. [Elite] THORSwap Airdrop
Dec 1, 2021 - This dashboard looks at multiple metrics of the THORSwap airdrop, which airdropped the newly created THOR token to community members who wished to purchase it. Each address was limited to $300 worth of the token, in an attempt to lessen the effect of whales. THOR acts as a governance token, utility token, and proof of membership token for THORSwap. The airdrop began on November 1st, 2021, and the first graphic below looks at the different amounts of THOR users opted to purchase.
$RUNE Distribution
Apr 27, 2022 - This dashboard looks at the distribution of RUNE holdings by address.
117. [Hard] Terrarbitage, Part 1
Dec 16, 2021 - This dashboard looks at arbitrage opportunities in respect to bLUNA and LUNA price fluctuations over time. bLUNA, or bonded LUNA, is LUNA that has been bonded utilizing the Anchor protocol, and in theory should be worth almost the same as LUNA, despite a small discount accounting for the fact that it is bonded for 21 days. In reality, this is not the case, as increases in LUNA's price can lead to a larger price difference than intended. This opens the door for arbitrage opportunities, as users can swap their LUNA for the cheaper bonded LUNA, and then swap back once the exchange rate stabilizes. The first graph in this dashboard looks at the daily LUNA and bLUNA prices in USD. While we can see that there's a miniscule difference, it's hard to see much from tis graph as the prices are so similar. Since there's usually only very small price differences between LUNA and bLUNA, the next graph looks the daily price difference between the two. While most days have little difference, some days stand out, such as September 23rd of 2021, where the price of bLUNA was about $1.40 higher than LUNA. In this case, only someone already holding bLUNA could take advantage of the opportunity, as swapping from bLUNA to LUNA would yield a higher amount of LUNA than normal. The next graph looks at the percent difference in LUNA and bLUNa price. The price difference on September 23rd was a staggering 7%, with the next highest differences only around 4%. Interestingly, looking at both of these graphs, we can see that the largest arbitrage opportunities involve a higher bLUNA price compared to LUNA. This means that users can earn the most by swapping from bLUNA to LUNA, so when swapping from LUNA to bLUNA, it may make sense to hold the bLUNA until a high arbitrage opportunity occurs. The average daily percent difference in bLUNA and LUNA price is .2426%. The possible APR scenarios from arbitrage depend on the amount of compounding over the year, or how often advantageous trades from bLUNA to LUNA are made. Using the average price difference, we can assume each trade would net an increase of about .2426% of the LUNA traded. If a user made an advantageous trade every month, the APR would be ((1 + .002426)^12 - 1), or about 3%. Now if we change that to every week, the APR would be ((1 + .002426)^52 - 1), 13%, or every day, (1 + .002426)^365 - 1, 142%. This is assuming the trader started with a certain amount of LUNA, let's say 50, and then used that amount plus the gain from each previous trade on each subsequent trade. Looking at these numbers, we can see that if arbitrage opportunities in the bLUNA and LUNA price difference are taken often, a large amount of LUNA can be made.
Forefront Treasury
Apr 23, 2022 - This dashboard analyzes the Forefront treasury over time and payments to Forefront contributors.
9. The Next Big Thing
Dec 14, 2021 - This dashboard looks at the fastest growing pools on the SushiSwap platform over the past 30 days. SushiSwap is a DeFi exchange where users can swap assets on the Ethereum network. To determine the fastest growing pool over the last 30 days, I decided to use number of swaps as the key metric. I first found the number of swaps completed on each SushiSwap pool for the past month, and then the number of swaps completed on each pool for the preceding month. I subtracted the preceding months number of swaps from the past months, and then divided by the preceding months number of swaps to calculate the swap rate growth. The pool that currently has the highest swap rate growth is the GENE-WETH pool with a growth rate of 265%. Not far behind is the USDC-YOKAI pool with a growth rate of 239%. These pools have by far the highest growth rates over the past month, as the next highest is the MANA-DAI pool, with a growth rate of only 50%.
7. Weekly APY
Nov 3, 2021 - This dashboard looks at the weekly average APY earned by liquidity providers to THORChains liquidity pools. THORChain is a protocol that aims to facilitate seamless swaps of tokens from different blockchains, for example swapping BTC for ETH. Liquidity pools are an integral part of this process, as they allow for users to exchange their tokens for THORChains native token, RUNE, which can then be swapped for other tokens. Users who provide liquidity earn a percentage of the fees these pools generate, proportional to the amount of liquidity they provide. The first metric looked at in this dashboard is the average liquidity across all of THORCHains LPs. We can see here that the weekly APY was highest towards the end of June to the middle of July 2021, with the highest average reaching almost 120%. The average weekly APY seems to have dropped off since then, with the highest weekly APY in October 2021 only about 60%. There is a gap from the end of July to September, most likely due to the numerous audits THORChain underwent during that time period. The next graph in this dashboard looks at the weekly APY separated between the current top 3 liquidity pools, the BTC, ETH, and XRUNE pools. We can see from this that the APY of the ETH pools is currently the highest among the three, hitting about 53% in the middle of October 2021. The APY of the ETH pool also spiked in the middle of July 2021, reaching a whopping ~115%.
45. [Easy] Weekly TVL Breakdown
Aug 11, 2021 - For the past 10 weeks, what has been the week over week change in TVL for Uniswap in total? Show this for the top 5 pools by volume.
112. [Easy] Who Validates the Validators
Dec 15, 2021 - This dashboard looks at different metrics of Terra validators, and more specifically, what defines an excellent validator. As one might guess, validators validate transactions on the Terra network, but they also have a major role in governance. LUNA holders can stake their tokens to validators, and the validator gets voting power proportional to the amount of LUNA staked to it. In return, the LUNA staker earns a percentage of the revenue the validator generates. This revenue comes from computing fees, stability fees, seignorage rewards, and swap fees. There are two main metrics that a Terra user can look at to decide which validator to delegate to, uptime and commission. Uptime is the amount of time the validator will be running, ideally 100%, and commission is how much of a commission the validator takes, so the lower the better. Another metric to look at is how much self-bonded LUNA the validator has, as more represents more of a stake in the ecosystem. The top 5 validators in terms of voting power as of now are Staking Fund, Orion.Money, B-Harvest, DokiaCapital, and Certus One. Looking at the graph in this dashboard, we can see that Staking Fund and Orion.Money are far above the others in terms of voting power and are currently head-to-head. So, what makes Terra users delegate to these validators over others? All of these top 5 validators currently have a commission of less than 10%, with Staking Fund and Certus One having a 10% commission, and the others having a 5% commission. In addition, each of them has an uptime of 100%, meaning they are constantly active and earning rewards. Interestingly, self-delegation does not seem to be a contributing factor in choosing validators, as the top validator, Staking Fund, has only .02% self-bonded, and Orion.Money has 0.0% self-bonded. In conclusion, the most important metrics in choosing validators seem to be an exceedingly high uptime, ideally 100%, and a commission of 10% or less, with not much thought given to self-delegation.
Validator Voting vs. Investor Inclinations
Apr 28, 2022 - This dashboard looks at the last five governance proposals on Terra and what percentage of the yes vote voting power came from validators versus retail investors.
New Active Users
May 12, 2022 - This dashboard looks at the number of new users performing swaps on Paraswap for the first time.
19. [Hard] Wen Sushi moon?
Dec 24, 2021 - This graph looks at different metrics of SUSHI price versus other decentralized exchanges, to determine whether SUSHI is a good investment. In my opinion, a good coin to invest in rises in price as the adoption/usage of its protocol increases. I first wanted to look at how the price of SUSHI compared to the volume on Sushiswap and the number of swaps completed. The price of SUSHI did not correlate much with volume on the platform, although it did somewhat correlate to the number of swaps completed. Interestingly, even though the number of swaps has recently increased, the price of SUSHI has decreased. I next looked at how the price of UNI, the token of the Uniswap exchange, compared to the number of swaps competed on the platform. The price of UNI is heavily correlated to the number of swaps on the platform, which is a good sign. However, both the price of UNI and number of swaps has seen a heavy downtrend over the last year, which does not make it an appealing investment. The last coin I looked at was the CRV coin, the price of which has actually been inversely correlated to the number of swaps completed. Even though the number of swaps has been steadily declining, the price of CRV has substantially increased over the last few months. This means that the price may see a correction soon, as it's increase is not actually tied to an increase in number of users on the platform. These factors make me hesitant to recommend any of these coins as a good investment.
3. LUNA Validators
Nov 10, 2021 - This dashboard looks at the LUNA staking activities of those currently staking MINE. MINE is the governance token of the Pylon protocol, which allows users to access content from creators by depositing funds for a fixed period of time. The creator is paid through the interest the funds accrue over time, and at the end of a predetermined period, the depositor receives the original sum deposited. Here I looked at what LUNA validators MINE stakers delegated to. The LUNA validator with by far the highest number of stakers in this category is terravaloper1259cmu5zyklsdkmgstxhwqpe0utfe5hhyty0at, otherwise known as Orion Money's validator. Orion Money is a protocol which allows for users holding stablecoins on blockchains other than Terra to benefit from the gains of Anchor Protocol. It is currently the LUNA validator with the most voting power, at 7.91%. The validator with the second highest number of stakers, at less than half of Orion Money's, is terravaloper1qd0uk3wrw73x662y2gx4kaulrzlcky6275gl5s, also known as Talis Protocol. Talis protocol is an artist centered protocol, which aims to protect the interest of artists on the blockchain. Flipside Crypto's validator currently has 85 stakers who are also staking MINE.
1. Active Weekly Users
Nov 13, 2021 - This dashboard looks at user interaction with the Uniswap protocol versus that of the Sushiswap protocol. Uniswap and Sushiswap are both decentralized exchanges on the Ethereum network, and allow users to swap assets and provide liquidity to their liquidity pools. The first graph in this dashboard looks at the weekly number of distinct users who are swapping using each protocol. Each week Uniswap has had a higher number of users than Sushiswap, and many weeks has had almost double. Although, over the course of 2021 it seems the gap has been bridging, with the number of Uniswap and Sushiswap users getting closer than ever from around August to November 2021. As for the weekly volume of swaps on each exchange, Uniswap has been far ahead of Sushiswap over the course of 2021, in some cases astronomically so, as was the case for the week of July 18th. While the number of users for each seem to be getting closer, the swap volume is not following this trend. One of the reasons Uniswap may have more users and swap volume compared to Sushiswap is that it has been around longer and is more established. In fact, Sushiswap is modeled after Uniswap and contains many similarities.