Owentell
11. To Farm or Not to Farm?
Dec 16, 2021 - This dashboard looks at multiple metrics of farming on the SushiSwap platform.
MonkeDAO Vote
Apr 7, 2022 - This dashboard looks at metrics surrounding the MonkeDAO vote concerning the Solana Monkey Business Team.
Average Price Shift for Synth Holders
Apr 14, 2022 - This dashboard looks at the average price shift for holders of THORChain's synthetic assets.
6. Peg Variance
Jun 25, 2021 - This dashboard displays how stable the stablecoins on Terra truly are, in comparison with their peg value. It looks at the three most popular stablecoins, TerraUST, TerraKRW, and TerraMNT. The peg values for TerraKRW and TerraMNT were converted into US dollars. The coins have stayed relatively close to their pegs with only small fluctuations over time.
IL Protection By Pool
May 18, 2022 - This dashboard looks at the impermanent loss protection paid out by THORChain over the last week and the last month.
Staking Yield, Mvmt 1: The Basics
Jan 18, 2022 - This dashboard looks at how staking APY is calculated for LUNA, and how fluctuations in LUNA's price have affected staking yield in the past.
26. Biggest Liquidations
Nov 2, 2021 - This dashboard looks at the biggest liquidations over the past year on the Aave platform. Aave allows for users to deposit and borrow at their discretion. A unique feature of Aave is that it allows for under-collateralized loans, in the form of flash loans, which can be used as long as the loan is payed back within one block. If the loan is not payed back within one block, the actions by the borrower are undone. If the borrowers collateral on a regular(not flash) loan ends up not properly covering the loan due to price changes, the borrower can be liquidated. This means that up to 50% of a borrower's debt is repaid and that value plus liquidation fee is taken from the collateral available, so after a liquidation that amount liquidated from the debt is repaid. The largest liquidation on Aave in 2021 so far was about $5,000,000. The next highest liquidations are not far behind, with almost all of them in the 4 million or high 3 million dollar range.
Standardized TVL Over Time (1 Pool)
Apr 27, 2022 - This dashboard looks at the standardized TVL over time in one THORChain pool, asset(non-RUNE) tokens only.
12. [Easy] Wallet population
Nov 4, 2021 - This dashboard looks at the activity of those with THORChain wallets. THORChain is a platform that allows for the swapping of assets from one blockchain to another. The first graph in this dashboard looks at the number of users who made a THORChain wallet versus the number of users that have actually made a transaction on the platform. To find users who have made a previous transaction, I found users who had either engaged in swaps or provided liquidity to the liquidity pools on the platform. The next graph looks at users who only provided liquidity versus the total users, and the final graph looks at users who only swapped on the platform. The difference in number of total users and number of users who have made a transaction was so great that a logarithmic scale had to be used on the graphs. The number of users who have only swapped is much greater than the number of users who have only provided liquidity, suggesting swapping is much more popular on the platform than providing liquidity.
OlympusDAO - 1. Staked Vs Unstaked OHM
Apr 15, 2022 - This dashboard looks at various metrics of staking on OlympusDAO.
Slippery Slippage
Feb 17, 2022 - This dashboard looks at the swap slippage percent in the top 10 pools by greatest TVL on Uniswap versus Sushiswap.
59. LUNA Price Action
Sep 1, 2021 - While they're are many factors causing the price of LUNA to skyrocket, I will focus on three in this dashboard, the first of which is the appealing nature of Terra stablecoins. The stablecoins in the Terra system entice users to invest in cryptocurrency who otherwise may not have, as they entail less risk than other cryptocurrency assets and are pegged to a currency that the user is familiar with. This in turn drives up growth of the LUNA price as an untapped market of people who are wary of the volatility of cryptocurrencies invest in UST and other stablecoins. Another factor is the growing popularity of the Anchor protocol, which currently has a very attractive interest rate of 20%. It now allows users to use ETH as collateral for loans which makes it even more appealing. One final reason the price of Terra is increasing so substantially is that the most anticipated update to Terra thus far, the Columbus-5 update, is coming soon. This update will burn all remaining funds in the community pool, and burn all future seigniorage, which should drive up the price of LUNA. In addition, it will create the new Ozone protocol.
When Do Transactions Fail?
Jan 19, 2022 - This dashboard looks at transaction volume on the Solana blockchain and the rate of failure of transactions during December 2021.
22. Gainers and Losers
Jan 13, 2022 - This dashboard looks at the biggest Sushiswap gainers and losers over the past 24 hours in terms of volume gained/lost, fees gained/lost, and liquidity gained/lost. Looking at the top 10 pools by swap volume gained, we can see that most of the pools are relatively small cap pools, such as SQUID-WETH and DOG-WETH. This is most likely because even a relatively small change in raw volume is a high percentage change. This could also be because these pools are more volatile than more established pools, such as USDC-WETH, and rely on less stable tokens. The pool with the most volume gained was the WETH-DPX pool, gaining over $7 million in 24 hours. In contrast to the top 10 pools, many of the pools that lost the most volume are made up of better established/more stable coins, such as USDC-WETH and USDT-WETH. This is surprising as one would expect tokens with little volatility to lead to a pool with less swap volume volatility. The pool that lost the most volume over 24 hours was the OHM-DAI pool, losing a staggering $96.7 million in swap volume. The charts for fee gainers/losers are unsurprisingly made up of the same pools in the swap volume gainers/losers, as swap fees are a function of swap volume. The pool that gained the highest fees over 24 hours was the WETH-DPX pool, with a gain of $21,000, and the pool that lost the most amount of fees over 24 hours was the OHM-DAI pool, losing almost $300,000. Looking at the largest liquidity changes in 24 hours, the pool that gained the most liquidity was the ILV-WETH pool, gaining almost $2.5 million. ILV-WETH currently sits atop the list of the highest liquidity Sushiswap pools, with a liquidity of about $355 million. The pool that lost the most liquidity was the OHM-LUSD pool, which lost about $5.6 million. This is most likely due to a massive drop in OHM price that occurred on 1/11/22.
8. Trading by time
Nov 3, 2021 - This dashboard looks at what time periods saw the highest interaction with THORChains liquidity pools throughout the month of October. THORChain's liquidity pools allow users to swap assets for their native token RUNE, which can then be swapped for assets from other blockchains. This system makes the usually convoluted process of swapping coins from one blockchain to another much easier. The first metric looked at in this dashboard is the average hourly swap volume in the top four liquidity pools by volume, BTC, ETH, XRUNE and BUSD. As you can see from this graph, the most common times for users to swap are 4, 5, 20 and 21 GMT. In addition, BTC has by far the highest swap volume at all hours of the day. The next metric looked at is average number of liquidity pool deposits by hour. The most common hour by far seems to be 8 GMT, with 9 GMT not far behind. Interestingly enough, the ETH pool seems to be very popular at 8 GMT, with about 90% of the deposits going to that pool. The final metric looked at in this dashboard is the number of withdrawals from liquidity pools by hour. The most common times to withdraw from liquidity pools by far are at 1 and 2 GMT.
116. [Hard] NFTerra, Part 2
Dec 16, 2021 - This dashboard looks at metrics of NFTs on the Terra ecosystem. NFT's have currently experiecned a rapid growth in popularity on Terra, with an explosion in the number of new tokens. The first gamified NFT for Terra was recently released under the name of Derby Stars Horse. The new project allows users to purchase virtual horses that they can pit against others in an online game.
Impact of Adding New Chains/Tokens
Jan 18, 2022 - This dashboard looks at the effect of new chains/tokens being added to the THORChain network on engagement with the protocol. THORChain allows users to swap assets from different blockchains, such as swapping BTC to ETH.
Moonbirds Mint Distribution
Apr 23, 2022 - This dashboard looks at the mint distribution of the Moonbirds NFT project.
12. Metric Dashboard
Sep 15, 2021 - This dashboard looks at many metrics of the Aave platform over the last year, including average liquidity, average utilization, average depositor APY, flashloan amounts, flashloan fees, income collector fees, and total fees. The second graph in this dashboard shows all of the Aave metrics versus time, on a logarithmic scale, as the numbers in each metric vary greatly. The third graph shows the daily flashloan volume versus daily fees, and we can see from this graph that the two are completely correlated, with the daily fees increasing or decreasing proportionally to the amount flashloan volume increases or decreases. This makes sense as the more flashloans that are executed on a day, the more fees will be generated. The last graph looks at the average utilization per day versus the average depositor APY per day. These are also somewhat correlated, although not nearly as much as the previous graph. According to the Aave protocol, the higher the utilization of a pool, meaning the higher proportion of the pool supply being borrowed, the higher the APY, so it also makes sense that as utilization rises so does APY. Although this is not always the case it seems, as the inverse happened multiple times in August 2021.
Avalanche Gas Fees
Mar 28, 2023 - This dashboard will look at gas fees generated by contracts and dApps on Avalanche. We will also analyze other stats regarding the growth of contracts and dApps on Avalanche such as the number of transactions and user activity.
Historic Angel Protocol Delegation
Aug 18, 2021 - What is the full history of delegation (who has staked; how much; and for how long) to Angel Protocol's validator? In other words: provide the information listed in the Delegations tab under Terra Station, and visualize the data since launch.
Fractional.art NFT Sales
Apr 28, 2022 - This dashboard looks at three of the top Fractional.art NFT vaults and their sales volume.
Twitter Links
Mar 25, 2023 - I am submitting multiple bounties tonight(3/24/23) and don't want to clog up my twitter with a bunch of posts at the same time. I will update this with twitter links as I post them. Thanks!
11. [Easy] Liquidity provision
Nov 4, 2021 - This dashboard looks at the liquidity provision to THORChain's liquidity pools. THORChain allows users to swap between assets from different blockchains, utilizing its native coin RUNE. The first graph in this dashboard looks at the daily volume change of each of the top four liquidity pools in October. Although I calculated all of the following metrics for the month of October, there seems to be a gap in liquidity pool data until about October 20th, so this data mostly deals with the end of October. To find the daily volume change I found the deposit amount for each day and then subtracted the withdrawal amount for that day. In general, the pools have been increasing in volume deposited, particularly on October 24th and 31st, where both the ETH and BTC pools had a huge volume of deposits. Despite this trend, there have been a few days where there was more withdrawn than deposited, such as on October 23rd when the XRUNE pool volume dropped by about $1.3 million. The next two graphs look at the number of unique addresses that either deposited or withdrew liquidity form the top four liquidity pools. From this we can see that the number of depositors has generally been a fair amount greater than the number of those withdrawing liquidity, although some days have seen more people withdrawing, such as on October 27th.
46. [Easy] Bonded vs. Unbonded LUNA
Aug 18, 2021 - Compare the quantity of Bonded Luna to unbonded Luna.
Withdraw to my wallet or to my Bentobox?
Apr 28, 2022 - This dashboard looks at the percentage of users that choose to withdraw directly to their wallet rather than withdrawing to Bentobox when they perform a borrow or when they withdraw from lending.
Tracking the Top Saber Lockers
Mar 10, 2022 - This dashboard looks at multiple metrics of locking SBR tokens on the Saber protocol.
The Road So Far, Mvmt. I: Validators
Mar 17, 2022 - This dashboard recaps what we have learned thus far about Terra's validator network through past Flipside Crypto bounty submissions.
48. Governance Proposal Types
Aug 25, 2021 - There does not seem to be a strong correlation between time and a change in the amount of text versus standard governance proposals. The amount of text proposals per month decreased from April to July, while the amount of standard governance proposals remained relatively stable.
Tracking USDC & USDT on Solana
Jun 17, 2022 - This dashboard look at stablecoin activity on Solana over the past six months, specifically regarding USDC and USDT.
2. Free Square: Art Blocks Edition
Sep 1, 2021 - The Art Blocks project this dashboard analyzes is Hideki Tsukamoto's Singularity. It has 1,024 unique tokens. The average price of all of the Singularity tokens over time is shown in the second query, and has increased dramatically over time, to a high of over $117,000 on August 23rd 2021. The third thing analyzed in this dashboard is the number of sales of the Singularity tokens over time. There were over 1000 sales on December 31st of 2020, and since then the number has dropped off dramatically.
Whale Dependency Index
Jan 27, 2022 - This dashboard looks at the balance of Loop pools and the number of liquidity providers in each pool to determine which pools are run by whales.
Examining Loop Liquidity
Jan 27, 2022 - This dashboard looks at different metrics of Loop liquidity pools on the Terra blockchain.
2. Returns on the ‘Generic Leverage Compound Farm’ strategy
Aug 11, 2021 - The USDC yVault has a ‘Generic Leverage Compound Farm’ strategy that earns a return by supplying liquidity to Compound, using flash loans for additional leverage. What return in Comp has it earned over the past 30 days and how much in flash loans has it used to earn this?
96. [Galactic Punks] Where My Punks At?
Oct 20, 2021 - This dashboard looks at metrics of the Galactic Punks NFT holders on the Terra blockchain. 10,921 of these randomly generated NFT's were released on October 2nd of 2021 and sold out in only 8 minutes. The first metric of this dashboard looks at the projects Galactic Punks holders are involved in within the Terra ecosystem. I fist checked if they interacted with the Anchor protocol, which is a complex savings and borrowing platform with a stable savings APR of around 20%. I then checked if they staked LUNA, the governance token of Terra. I finally checked if they staked on Pylon, a protocol allowing users a different way to pay for subscription based services. I found that the highest number of GP holders staked LUNA, with 2,801 of them currently staking or having staked in the past. The next highest was depositing in Anchor, not far behind LUNA staking, with 2,339 of GP holders interacting with the protocol. I next looked at the average balance of GP holders, which was about $33,000 USD. Finally, I looked at the balance of GP holders with the highest balances. It looks like many whales are currently holding Galactic Punks, as 9 out of the 10 highest balances were over 10 million USD.
Butter Delegate Activity
Apr 20, 2023 - This dashboard looks at metrics of users who voted in the Butter'd Aave election and delegated to the winning delegate. The daily time-series graph only includes users who delegated during the Delegation Window, while the bar chart includes users that delegated during the entire Delegation Campaign.