jake-wolf
BentoBox Stats 2021-2022 Ethereum + Polygon
May 11, 2022 - This dashboard is going to give you information on the stats of Bentobox. We will investigate BentoBox on both Polygon and Ethereum between the years of 2021 and 2022. We will look into the total, sum, and count of the deposits from the different years on Ethereum and Polygon. We will compare the data to try and find the any insights possible.
The Fundamentals
Dec 8, 2021 - These two graph show the relationship between supply of UST and the price of LUNA. It seems that they have a positive correlation meaning that the more UST in supply there is the higher the price of LUNA. This makes complete sense especially after 10% of LUNA was burned into UST. That would drastically increase the value of LUNA because the supply is going to drop very quickly. That also means the supply of UST would increase greatly as well.
Active Wallet Addresses
Jun 21, 2022 - We are interested in knowing how many users are currently in the ecosystem. In this case, how many are holding $RUNE in their wallet or have an open LP position. What is this number currently, and how has it trended over time?
Tinyman Pool Scores
Jun 9, 2022 - Create a dashboard/table that lists the Tinyman pools and a composite score illustrating the health of each active Tinyman pool. This score should help the public understand the health composition of the pool and whether or not its safe to create an LP for.
Algorand New Wallets
Jun 16, 2022 - Q101. How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May?
What Are Users Doing After Deposits
Jan 12, 2022 - These 3 graphs are going to show you what people are doing after they deposit their money into the curve ecosystem along with all of the different options they have to do with their money. The first graph is going to show you that many people are actually withdrawing, sweeping, or transferring their money after they put it into the curve ecosystem. The second graph will show you that a lot of money has been deposited very recently. The third graph is going to show you what people are using the get into the ecosystem itself. As Curve has grown you can see that many people want to get into it. These graphs are going to show you how people are getting into curve, how much, and what they are doing once in.
Liquidation vs Luna Price
Dec 24, 2021 - As you can see the price of Luna has been going up very steadily since January is hitting all time highs. The average liquidations have been growing, and if you look at the spikes they have been growing as well. The total has been very inconsistent, but is currently starting to go up again. There tend to be major spikes in liquidations, so to see the trends you need to analyze the different spikes to notice if there have been increases or decreases in the total amount liquidated. All liquidations have been put into USD, not the native currency.
Whale Activities
Oct 25, 2021 - The first graph is going to show you the transaction volumes of those that are the biggest players, whales, on AAVE. You can that the transaction volume is pretty constant, but spikes very heavily occasionally. For instance on February 3rd there is a major spike in transaction volume. After that day is crashes back and then continues to rise and fall. However, when looking at the frequency of trading from the biggest players it seems much more active. This is because the range is different. You can see realistically that there is always a lot of movement on AAVE, between all of the biggest players. On the graph labeled Polygon Event count, we are able to see the frequency of people using the network. It is important to notice that there is either a lot of action or none going on at a certain time. These event times are mirrored by the gas used in the other graph. Although it does not completely mirror the first graph, all of the gas being used is on the same dates. This makes sense because the events do not talk about the amount being used on each event. Many event could occur on the same day and have very small amounts of gas used or the price could be lower at a certain time. The next two graphs are referring to the leverage that is being used on the AAVE network. I am showing this through the amount of voting power that is being used on a daily basis, which can related to different protocols and voting events that have occurred on the network. The next graph is showing you who is using their power and when. These are going to be the big players and what their actual address is.
Celsius Swaps
Jun 23, 2022 - Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps?
Polygon Block Performance
Jul 27, 2022 - What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
Algorand 11+12
Jun 9, 2022 - This dashboard is going to look into the events of the 11th and 12th on the Algorand blockchain and help make sense of the increase in swaps.
LUNA PRICE ACTION
Sep 1, 2021 - Why is Luna doing so well? It is very simple. In order to mine UST, you have to burn equivalent in Luna. This means that essentially to get UST you have to have Luna. Now when both LUNA and UST are the same price this is a 1/1 deal. When there is a difference in price there is suddenly a chance to make A LOT of money. Now when UST trades for above 1 suddenly having LUNA means that you can make a lot of money. If UST begins trading at 1.5, and LUNA still costs 1, the ratio is now different. 1 LUNA, which was the same price, can now get you 1.5 UST which is a lot more money. If you buy a lot of LUNA and then use it to get more UST, suddenly you've made a lot of money. This is known as arbitrage. Terra form labs announced the launch of their first protocol, which would need a lot of UST. As you have probably realized, that means a lot of LUNA will be in demand. Basic economics states that when demand increases and supply remains the same, price will be driven up. This is why LUNA has become so valuable.
Anchor Borrows and Deposits
Dec 24, 2021 - The first two graphs are going to show the total deposited. As you can see the total deposited into anchor has been growing consistently and has recently spiked. The average has also been on a somewhat upward trend. As it goes up and down each day the highest spikes have been getting higher as time goes on, after a brief crash. The second two graphs are going to show you the average borrows and the total borrows. As you can see the average has consistently grown and in all likelihood will not slow down. This is because the total has also continued to go up as well. This mixed with the sky rocketing of the price of Luna it would make sense that this would continue to grow.
Unique User Dashboard Comparison
Apr 5, 2022 - This dashboard is going to answer the question about Comparing the number of unique wallets that have sent a transaction since February 1st on Algorand vs Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Algorand compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?
Sushi Gainers and Losers
Jan 10, 2022 - The two graph's are going to show the top 10 pool feels for the pools that have had the most transactions fees in the last 24-hours. The second graph is going to give you a total USD amount, while the first will give you a percentage comparison. The next two graphs are going to show you the other side of the fees for the LP that had the least amount over the last 24-hours. The third graph will show you the total amount and the fourth graph is going to show the comparison based on how much in fees were actually spent. The 5th and 6th graphs are going to show you the top 10 LP's that had volume added vs the worst 10 LP's in terms of volume added in USD. You can see there is a major difference as the USDC-WETH had nearly 60 million added vs the lowest amount added in less than $5 in total. These graphs are also going to show you the amount of liquidity added as well in USD.
Luna $100 When?
Dec 8, 2021 - These graphs are going to show you that Luna has never been at a higher amount before. Luna itself will reach $100 very soon. Since the Luna burn Terra has been at an all time high. 10% of all Luna was burned, which meant that supply dropped and in anticipation of that demand for the coin skyrocketed. When supply drops and demand increases, that means the value will increase drastically. That is what the first graph is going to show you. The next two graphs are showing how people are more likely to be staking their Luna to receive money on it. As more Luna is staked it provides support for the Terra ecosystem and makes sure it is more secure against attacks. Different networks such as Thorchain have really struggled with this issue which looks to be something that Terra will not need to deal with. With the value of Luna going up, and more money being staked, it means that Terra is going to be more secure and efficient than ever before. This will lead people to believing that it is a better place to invest their money for crypto. This cycle will continue, and that means that the TVL of Terra will increase. All of these will lead to the value of LUNA increasing. I would assume that within the next month or two based on current increases LUNA will be in touching distance of $100.
Thorchain Network Load
Dec 7, 2021 - These two graphs are going to show you the most amount of transactions that have happened in a minute on Thorchain. The second graph is showing the most amount per minute ever, and the first is going to show you the most amount that has happened in any single minute on any given day. As you can see it tends to be close to around 80 transactions per minute as the average, but does sway above and below. It makes sense that the average has dropped dramatically as Thorchain crashed for a second time, which will make users feel uncomfortable storing money on that network.
LP Duration
Dec 18, 2021 - The two graphs are going to give you information on how long and when people decided to add liquidity to the thorchain network. The first graph is showing you information on how many people were specifically adding to any liquidity pool on the thorchain network. As you can see the numbers are higher than those for the second graph. The second graph is going to look similar, but this is going to remove any address's that appear more than once. Interestingly what this means is that there are many individuals who have added liquidity only once and that most that do add only have done it once. The drastic difference in spikes would mean that some people who were counted multiple times before are only being counted once now.
Sushiswap gas effeciency
Jun 8, 2022 - Which one of the sushi services consumes the most gas per transaction? The services to include in your comparison are : -Adding liquidity -Removing liquidity -Adding an asset for lending -Borrowing -Removing an asset from lending -Repaying a loan -Swapping
Terra Fees Vs Others
Jan 13, 2022 - These two graphs are going to show you the difference on terra wormhole fees vs other fees. As you can see the ethereum fees are much higher, which makes a lot of sense because if you try to transfer on the blockchain then you know that much of the time the fees can be close to $200 or even more depending on the time. When looking at the terra fees much of the time to complete a transaction will be no more than 1-2 UST.
Applications on Algorand
Jun 29, 2022 - How have the number of application calls changed in the first 6 months of 2022 compared to the last 6 months of 2021?
CRV Token Use
Sep 20, 2021 - One interesting insight that I was able to find was the amount of money that are being put into the USDT Liquidity Pool. This pool is known for being stable and also helping to stabilize the market. It makes sense that people would be moving money out into this pool because it is a more sound investment. However, you can see that it spikes and drops very consistently. This is most likely going to be based on how the coin is doing. While CRV is down people will be worried about their investment and are going to probably decide to move their money into a more stable liquidity pool. Another interesting thing that people are doing with their tokens is starting to invest in sushiswap. What is this platform? It is a major online player and is even starting to rival some centralized financial systems. How are they managing to do this? It has become increasingly popular due to the selection of liquidity pools. It is one of the few exchanges that really has the ability to compete with centralized trading platforms. The value of one sushi is expected to grow by over 100% making it a good looking investment. This being said it is very important to remember that before investing in any crypto currency you should only put in what you are willing and ABLE to lose.
Sushi swap vs Uniswap Monthly Activity
Nov 15, 2021 - The first graph is going to show the amount of activity going on per month on Sushiswap. It continues to spike and drop, but throughout the summer it dropped heavily. This was the exact opposite from Uniswap who saw nearly 58,000 new users add to the network. This was more than double the average, which was closer to 24,000. There are three graphs for Uniswap. One of them will seem like July was the only active month, however, it was just the biggest spike. With all of the new additions it makes sense that there would be such a high number of activities compared to other times. This being said it is a little interesting the volume comparison between the other months. Another graph is going to show you the monthly activity in a logarithmic method so you can actually see the comparisons between the months for uniswap instead of seeing it as blank. It seems that Sushi is very active, however, there continues to be spikes and then activity dies down every couple of months. It seems that Sushi is on the downward trend, and will most likely be spiking very soon. It seems that Uniswap is either very active or very inactive, so in terms of consistency I would argue that Sushi is more active. However, when there is a lot of activity on Uniswap, it is very active and crazy.
New Unique Address's
Oct 25, 2021 - Here is a visualization of the new unique address's that are coming up in the borrows table. These are the people who are beginning to borrow for the first time from the mainnet. I also wanted to query to see how similar it would be visually between the deposits table as I figured those two tables would be able to cover nearly the entire mainnet activity. This is exactly what happened. If you compare the two graphs it is clear that they are both nearly exactly the same. There is a small difference between numbers, but visually you can see when and how many new people are participating on the platform.
$RUNE Movement from Crypto.com
Jun 20, 2022 - Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
Loan Analysis Tool
Sep 15, 2021 - Here is all of the information needed for anybody to see the loans. You can see the total amount for all loans under any currency along with the amount of money that has been made off of the total. This is information that I decided to include because of the background information you will receive. The other two graphs give you the dates and you can move through to specific dates that you would like to find specific loans for. If you want to find a certain loan that was given on a certain date you can travel on both graphs to that specific spot. It will give you daily amount for that specific coin. You can also move on the premiums graph and see the total that was earned based on those certain loans.
Thorchain Swaps
Nov 1, 2021 - These two graphs give you the information where you can see the biggest add and withdrawal's by volume based on the asset and the time periods that had the heaviest swaps. The first graph is going to show you the largest swapping periods and what LP. You can see that certain days had significantly more than the others. The next graph breaks it down by the asset that was involved in the swaps. The scale is significantly lower and that is because LP's and assets tend to have much different amounts of volume. Pools are normally significantly larger than assets, which tend to be in the LP.
Sushi Activity On Ethereum
Jun 29, 2022 - How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
Flow NFT Data Since May 9th
Jun 11, 2022 - Create a visualization showing NFT sales volume on Flow since May 9th. Which NFT projects are trending on Flow right now and what is the general trend of NFT sales over the last month? Do the projects that are trending seem to have common wallets or is there not much crossover between buyers/sellers?
Sushi Token Activity
Jan 12, 2022 - These two graphs are going to show the sushi staked minted and burned over time and in total. Over time you can see that there is not a lot of activity for sushi. There was a lot that was staked last year, which is when sushi was originally created, meaning that staking would get you better rewards and would also make sure that it was more sustainable.