Owentell
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.
12. [Easy] Guzzling Gas
Dec 21, 2021 - This dashboard looks at different metrics of users withdrawing liquidity from SushiSwap liquidity pools. SushiSwap is a hard fork of Uniswap, and is a decentralized exchange on the Ethereum network. The first metric looks at the daily gas fees paid by users withdrawing liquidity. The amount of fees has varied widely over time, and recently peaked on November 10th, 2021, where about $46,000 of fees were paid. Interestingly, the days where a higher amount of fees were paid do not usually coincide with a higher number of withdrawals, suggesting that large LP removals with high gas costs are the cause of most spikes in fees paid. The next metric looked at is the daily number of LP withdrawals. Besides a massive spike in the middle of September 2020, the number of removals has remained largely stable, at around 200 to 400 daily. This is a good sign for SushiSwap, as it means there have not been recent events that have cause liquidity providers to lose confidence in the protocol and remove LP en masse. This was not the case in September of 2020, when users made over 2000 withdrawals on a single day. This was due to a rug pull by SushiSwap's anonymous founder, Chef Nomi, causing users to panic. He later returned the money and continues to work with SushiSwap to this day. The last metric looked at in this dashboard is the daily average gas price versus the daily number of withdrawals. In general, it seems that gas price spikes cause a decrease in the number of LP withdrawals.
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.
Flow vs Other L1s
Jun 22, 2022 - This dashboard looks at user retention on the Flow blockchain versus other L1s.
Most Common Transactions
Jun 24, 2022 - This dashboard looks at the most common transactions for Metamask users.
Collateral Impact
Jan 18, 2022 - This dashboard looks at the effect new collateral tokens on MakerDAO have on the volume of DAI minting, and which tokens have influenced DAI minting the most.
95. [Galactic Punks] Traders & Collectors
Oct 27, 2021 - This dashboard looks at multiple metrics of the new Galactic Punks NFT's and their owners. Galactic Punks are a series of space themed NFT's on the Terra Blockchain. In fact, they are the first collection of NFT's to be minted on Terra. The collection has a total of 10,921 randomly generated NFT's. They were released on October 2nd 2021 and sold out in only 8 minutes. As of 10/29/21 there are 4,926 distinct owners of the Galactic Punk collection, meaning each person has an average of about 2 of the NFT's. The next metric looked at was the number of NFT's owned by the addresses with the most NFT's. The address currently holding the most has a whopping 141 of them, more than 10% of the entire collection. The next highest has 100 of the NFTs, and then it begins to drop sharply from there, with the third highest holding 47 of them. The final metric I looked at was who the highest frequency traders of Galactic Punks are. To calculate this, I first found the count of the number of transfers of the NFT's they have completed so far, and then added to that count the number of times they ordered Galactic Punks from RandomEarth, a NFT marketplace on Terra. The address with the highest number of transactions had 720, and the second highest had 496. Unsurprisingly, many of the addresses with the highest number of NFT's were also on the list of addresses with the highest number of transactions. Interestingly enough, the address currently holding 141 NFT's was not on the list of those with the highest transactions, suggesting they have not sold many if at all of them and seem to solely be adding to their collection. Credit: Some of the code for finding the addresses currently holding GP NFT's was sourced from brian_#3619 on Discord
Uniswap Volume Projections
Aug 18, 2021 - What is going to happen to Uniswap swap volume in the coming quarter?
10. [Easy] Pool Sizes
Nov 3, 2021 - This dashboard looks at the pool sizes of THORChains liquidity pools. THORChain allows users to swap assets from one blockchain to assets from another. This is made possible through its liquidity pools, where users swap one asset for RUNE, THORChain's native token, and then can swap RUNE for an asset from another blockchain. The first metric looked at is the daily total value locked in THORChain's top 4 liquidity pools, BTC, ETH, XRUNE and BUSD. As you can see from this graph, the TVL has increased steadily over October, from a low of about 100 million to a high of almost 200 million. The amount of BTC deposited has also steadily increased in proportion to the other liquidity pools, and is currently the pool with the highest TVL. The next metric looked at is number of unique liquidity providers who have deposited in the pool at one point versus the pool's TVL. This graph uses a logarithmic scale on the Y-axis as the difference between depositors and TVL is so great. As we can see from this graph, the number of providers seems relatively proportional to the pools TVL, with more users depositing meaning a higher TVL. The pool with the highest number of providers at about 1700 is the BTC pool, which also has the highest TVL.
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.
6. Number of LPs
Oct 27, 2021 - This dashboard looks at the number of liquidity providers(LPs) for the THORChain liquidity pools. Liquidity pools allow for users to swap from one asset to another, using the providers deposited assets. The first metric looked at is the number of new providers to all THORChain pools on 10/25/21, which was 456. I next separated the number of new LPs by pool, and found that the pool with the highest amount of new LPs was the ETH.ETH pool with 99 new providers, closely followed by the BTC.BTC pool with 81 new providers. The next metrics included in this dashboard display the same statistics, although over time instead of on a certain date. I chose the top 4 pools by swap volume to look at, and found that the amount of new LPs daily varies greatly. The number of new LPs was also much greater closer to the inception of THORChain and have lessened recently. There are many gaps in new LPs being added daily, and this could be in part to the many audits THORChain has undergone over the past year.
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%.
Contractually Obligated
Mar 10, 2022 - This dashboard looks at the top 20 smart contracts on Terra over the past 30 days.
22. [Elite] Network Shutdown
Dec 1, 2021 - This dashboard looks at user activity before and after the THORChain network shutdown that occurred from November 12th, 2021, to November 17th, 2021. THORChain is a protocol which allows for the conversion of assets from one blockchain to assets from another, through its native token RUNE. For example, a user could swap BTC for RUNE and then swap RUNE for ETH, effectively swapping BTC for ETH, all on the THORChain platform. The November shutdown was due to a consensus halt, meaning the nodes could not agree on the same state. Normal function on the platform resumed on the 18th. The below visuals look at multiple metrics of user activity before and after the network shutdown.
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.
The Eclipse Score
Apr 28, 2022 - This dashboard proposes an easy-to-use 'Eclipse' score, displaying how effective Terra validators are in representing their delegators via voting.
Fractional.art Top NFT Collections
Apr 28, 2022 - This dashboard looks at the most popular NFTs to add to Fractional.art collections, and the effect especially rare NFTs has on trade volume.
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.
Realized APY
May 18, 2022 - This dashboard looks at APYs on THORChain regarding different pools and timing.
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.
Let it burn!
Apr 28, 2022 - This dashboard looks at the week where the greatest volume of LUNA was burned and what effects it had on the Terra ecosystem.
108. [Easy] The Fundamentals
Dec 8, 2021 - This dashboard looks at the LUNA token price in USD versus UST supply. LUNA is the governance token of the Terra ecosystem, and its price has recently risen to all-time highs. One of the factors that effects LUNA's price is the supply of UST, one of the stablecoins on the Terra ecosystem. As can be seen in the graph below, the price of LUNA seems to be heavily correlated to the supply of UST. There have been a couple periods of time where they do not seem to match up, such as from mid-May of 2021 to mid-August 2021, where the supply of UST remained stable while the price of LUNA fell, but for the most part rises in UST supply are correlated to rises in the Terra price. The recent jump in LUNA price from about $40 to about $70 was joined by a large spike in UST supply, suggesting that when UST supply spikes, so does the price of LUNA.
Market Volatility II
May 26, 2022 - This dashboard looks at the effect of the recent market volatility on the SUSHI token.
33. - Price Status Quo
Feb 3, 2022 - This dashboard looks at the correlation between the price of SUSHI, the market in general, and other decentralized exchanges.
29. Gas Prices and Deposit/Borrow Amounts
Nov 6, 2021 - This dashboard looks at the effect of Ethereum gas prices versus deposit and borrow amounts on Aave. Aave is a protocol on the Ethereum blockchain that allows for users to deposit assets, borrow assets, and take out flashloans, a loan that must be paid back within the same block. The first graph looks at the daily gas price versus the daily average deposit amount. The gas price in these graphs has been converted to USD, to account for the change in Ethereum's price over time. It seems that although gas prices have recently risen since the beginning of September, deposits on Aave show no sign of slowing down, as the average daily deposits are among the highest from September to November 2021. Looking at the average gas price versus average daily borrows, we can see that higher gas prices also do not seem to be slowing down borrows from Aave. In fact, the end of October and beginning of November 2021 has seen a high average borrow amount, with multiple days over $1,000,000.