jake-wolf
Minimum Liquidity for Slippage Prevention
Sep 7, 2021 - This shows all amount of liquidity in all tokens that have money in them. The reason you will find that there are not all coins in this graph is because many of them had either nothing liquid or the a null balance. This information would not be helpful in this situation. As you can see LUNA is one of the only coins that is consistently moving up or down. The other coins I have found are much more steady.
Thorchain Wallet Growth Over Time
Dec 18, 2021 - The time three periods that we are going to be looking into are before July 16th, pre-hack, September 24th - November 11th, Pre-Network Halt, and then finally November 18th - present day, which was the post network halt. Before the hack there was a very solid flow of people joining. There were many spikes but overall, they were having a solid number join every week. This changed drastically after the first hack. Before the network halt, they were having nearly nobody join, but they around mid October - late November there were two major spikes as thorchain began to seemingly make a comeback. However, this was followed by a shutdown and after that shutdown the number of people joining has dropped significantly from where it was. Overall, the continuous shutdowns have proven to be a major issue for thorchain as it breeds a disbelief of stability, but if they are able to stay active for a couple of months and prove their stability, I believe they will find themselves having more people join again!
Stablecoin Interest Rate
Aug 28, 2021 - This shows the volume and use of the two most stable coins. They are USDC and USDT. The volume is significantly higher than any other coin that has been used.
USDC Deposits
Jun 22, 2022 - In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Thorchain Weekly APY
Nov 1, 2021 - These two graphs are going to show you the Weekly APY in the different pools. It is important to note that many of these had the same APY because of the links between the different LP, but you can also see which ones are more active than the others. The first one is without the pool and the second shows you the same information split up by pool.
StETH-ETH Pool
Sep 17, 2021 - This graph shows the progression and amount of money that is in the stETH-ETH pool. I decided to keep the past months because it shows the decline in the pool, which i Think is very important to recognize. If you look at the pattern of development it looks like there is about to be a huge spike in the pool. After the spikes in February and May, there were initial crashes. Based on the aftermath of both spikes and the spikes that came a couple months after leads me to believe there is about to be a major spike in the pool.
FLOW NBA Playoff Usage
Jun 25, 2022 - Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume. What about NBA Top Shots?
Liquidation Response
Oct 8, 2021 - These are the responses to owners who had their collateral liquidated. For 5 random users I will show you whether they borrowed again, when they borrowed again, and how many times they borrowed again if they decided to. For some of these people they will not have borrowed again, meaning that after they had their collateral liquidated, they decided to not spend anymore money on the platform. These tables are showing you the patterns of how people are borrowing after their first liquidation. It seems that most people will take out a large amount of loans that end up being liquidated once. After those loans, whether at the beginning or end of the graph, they do not go big again. Some people will take out nearly 40 different loans and have them all liquidated on the same day, user 1, and afterwards did not take more out like that. On the contrast user 5 had 3 loans liquidated, and that was his biggest loss.
Daily Reward Distribution
Oct 26, 2021 - The two graphs that are provided show the rewards distributed to either nodes, liquidity pools, and block rewards per day. You can see that the nodes are significantly less in number than block rewards and liquidity pools because they are looking at the average count of nodes not the actual amount.
Staking Yield
Jan 18, 2022 - These two graphs are going to show you the comparison of price of Luna to the average staking yields that are earned through different places you could stake. I wanted to show the major price increase over time and how staking the Luna would now be getting you more than before. As you can see even though the price has been going down a little you can still see that the value you will get from staking is still very high, although very recently it has dropped dramatically. This is probably linked to the heavy drop in crypto currency on all blockchains.
Pool Depth on Thorchain
Nov 10, 2021 - The first graph is going to show the actual liquidity that is in each of the different pools on thorchain. The different liquidity depths can be seen by which of the pools has the most. It is interesting to compare them to the amount of Rune in each, which is the second graph, because it will show which are most popular. Although most of the LP's that have the most depth tend to have the most rune there are some differences. For instance if you look to the right side of the graph the ETH.THOR, is has much more rune in it than the amount of liquidity.
Uniswap TVL Projections
Sep 8, 2021 - The first graph is showing the token price variation, which we can see has been affected quite a lot since middle of the year. The time locked value will be altered of course because the price dropped as much as it did people will lose faith in the currency itself. This being said Uniswap has been a very useful tool and will continue to be as well. Recently there has been a huge crypto crash after El Salvidoor accepted Bitcoin as a national currency. I personally believe this is just a little bump, and will slowly make its way back up. Crypto currency runs on liquidity. Ticks are essentially boundaries between areas in the market. One tick is equal to .0001% of an increase or decrease in price point. The ticks act as a boundary for liquidity. If you want to sell something you need someone to be willing to buy it at your price. Each pool has the same amount of ticks, but only some of them are able to be active at any given moment. There is a high correlation between lower fees and the allowance of potentially active ticks, whereas more fees tend to have longer intervals between ticks. What does this mean for Uniswap? Uniswap has been relatively consistent, but I believe they will continue to grow. As you can see less ticks means that there are higher fees, tending to mean the value is greater. These are all good things for Uniswap. As the amount of ticks decreases, the fees will most likely increase.
Sushi Swap Volume
Dec 7, 2021 - This is the sum of the top 10 pools on the sushiswap platform. As you can see these pools seem to all have WETH, which is wrapped Ethereum as a major part of the pool. The best stable coin pool is SHIB-WETH LP as nearly all of the money has been used in that. WETH is the best stable coin.
Cryptopunks Sales and Traders
Aug 30, 2022 - Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings.
Preferred C-Ratio
Oct 11, 2021 - On this dashboard I am showing the average for all of the loans combined overtime, and the average C-Ratio for the top 50 loans and the bottom 50 loans. The first graph shows the average C-Ratio for the biggest loans. As you can see depending on the coin used as collateral it will change the amount used as collateral. The range is from 1.05 - 1.11. This shows that the average for the biggest loans are actually very close together. The X-axis is off so instead to actually get the correct information from the graph slide over the different coin to get the C-Ratio. The other graph shows the largest amount that was in total used as coverage for the loans in USD. The other graphs shows for the smallest 50 loans what the average for each debt coverage token what it was. The range was for 1.04 - 1.11. I find this data very interesting because it shows that the C-Ratio is relatively even across the entire range of loans that are being taken out.
pLUNA vs yLUNA
Mar 30, 2022 - This dashboard is going to answer the questions : Make your case for the relative value of pLUNA or yLUNA! Define the key inputs to the relative valuation for each; various methods of valuation (discounted flows, comparables, growth-based models) will be accepted as long as you make a reasonable case for them and support them with evidence.. Over a time period of your choosing, how has pLUNA or yLUNA’s price changed as these key inputs have changed?
Sushi Swap Seasonal Analysis
Feb 23, 2022 - This dashboard is going to show how much has been going in and out per day and month. The different graphs are based into months and days showing the major occasions that are happening.
Thorchain LP's
Oct 27, 2021 - I for this dashboard I have created 3 different graphs to give you the information that you will need on the specific users in total and on the different liquidity pools. There are a total of 3,994 different address's in swaps and also 39 different pools as well. The first graph is showing you a timeline of specific users in swaps. It is on a daily timeline, but will not show you what specific users are on it, just a total count over time. The second graph shows you a breakdown of the same information, but by pool. The first graph gives you an overview of the information, and the second graph dives in to the liquidity pools and their activity. The final graph is showing the different liquidity pool totals. You can see there are many different liquidity pools and this is how many distinct address's they have.
Thorchain New User Onboarding
Jun 27, 2022 - When a new wallet gets created, where are they first getting their $RUNE? Is it from a direct transfer? Or from a centralized exchange? From a $RUNE upgrade from BNB.RUNE or ETH.RUNE? Or from a swap from another chain's asset to $RUNE? If it's a swap, which chain / asset are they coming from? Are there any trends over time you can see?
Thorchain_Swap_Size
Dec 6, 2021 - These two graphs are going to show the average size of each swap on Thorchain. The difference between the two graphs is the first one is going to show you the average of each asset that is being sent from. The second graph is showing you to which asset it went. The graph numbers are going to be identical, the information provided is where the amount is coming from and where it is going. This can be used to determine, which assets are of higher value or popularity throughout the last 7 months.
Airdrop Summary
Oct 13, 2021 - The next three graphs will summarize the what has been happening with airdrops. The first graph will show you how often airdrops were claimed. Over time it is quite easy to see that more airdrops were being claimed. It shows you how many were claimed every day and what day they were claimed between January and September. The second graph will show you the total amount borrowed per ID. The most amount borrowed from one ID was 51,000. The least amount borrowed from one account was 8400. The total amount that was airdropped was 476032513.24. If you total up the last graph over time you will find that to be the total amount. The last graph shows the total amount air dropped over time.
Stable Coin Supply
Sep 5, 2021 - This is the total supply of the stable coins over the past couple of weeks. When using the date_trunc argument I was not able to get any more results. I used this same argument many times last week and it worked well. What you can see is the balance of UST has sky rocketed, during this time.
Bonded vs Unbonded
Sep 1, 2021 - The LUNA market seems volatile. When a Luna is Bonded, it is staked, meaning it will generate rewards for the validator and the delegator it is bonded to. Until it is fully unbonded, it cannot be traded. The graph shows that Luna has been going up and down. It stays at those high or low points for around 2 months before either going back down or going up. You could argue in that case that it is stable, however, because of how drastic the changes tend to be, I would argue that LUNA is not consistent, but it is stable.
TerraSwap Pool Fee Performance
Sep 7, 2021 - This shows the top 5 by fee APR over the last 6 months. I decided to include all of the different currencies for reference. Luna and UST have been the top and will most likely stay as such. The others vary based on the timing, but you will normally see MNT, KRT, and SDT also at the top of the fee performance.
Flashloan Prevalence on AAVE
Sep 1, 2021 - I started the analysis by figuring out which coins were used most, in terms of US dollars. They came out to be WETH, DAI, USDC, USDT, WBTC in that order. Flashloans are commonly used for arbitrage, which is buying and selling the same asset at the different prices the market makers put it at. They offer an unlimited amount of funds, which means that you can make as much money off arbitrage at one point, unlike the centralized system of currency. The rate is significantly cheaper because the amount borrowed is paid back with the additional amount in the same transaction, if the transaction does not go through, than you never borrowed the money. The second graph shows how often flashloans were used and for how much. The month of May had flashloan amounts sky rocket. They have not been the same since and have actually been decreasing. In May there was one major attack that occurred using flashloans. To being the person responsible borrowed $270 million of Eth, which they used to manipulate kyber network oracle. The function of KNO is to connect the block chain to the real world. Through the process they were able to mint many xSNXa tokens, which were sold for ETH and SNX. They than found a weakness in the xBNTa contracts because as a wrapped token, it could only be minted using the BNT currency. The smart contract failed to check this, therefore they could use different tokens to mint xBNTa tokens, which they than sold, making a killing. On May 20th another one flashloan attack was launched. Although there were definitely many alternative purposes for these flashloans, these specific ones were used during attacks. One use of a flashloan is swapping debt and collateral at the same time. If you borrow coin1, and use coin2 as collateral, but coin2 crashes, than you could lose your loan. A flashloan would allow you to trade coin2, for a more stable coin.
Galactic Punks: Traders and Collectors
Oct 20, 2021 - The first graph shows you all of the people who are holding Galactic Punks. These are not all distinct people some may be repeated, but I felt that it was important to show this because it is very clear that this has become very popular. Yes there is a major drop, but to be fair if you look at the timeline that is over the course of 16 days. It is impossible to read too much into this without realistically seeing the major spike. Although the spike has been dropping it is important to note the major crypto currency boost. Even though it may seem that these are inversely correlated, it makes sense that as crypto currency continues to rise so will the amount of Traders and collectors. Although you can't see this in the graph there have been nearly 90,000 unique holders. This includes buying and selling of the Galactic Punks.
Algorand Governance Breakdown
Jan 13, 2022 - These two graphs are going to show how people voted and how much people have in their accounts in terms of ALGO. Overall Algorand users decided to keep the same system. They voted 56.58% A to 43.42% B. This article will go more in depth on the information that was not available through the database. https://governance.algorand.foundation/governance-period-1/committing-commitments-slashing
Thorchain Active Wallet Addresses
Jun 29, 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?
Borrow And Supply
Aug 31, 2021 - I chose 5 assets and analyzed their variable and stable rates over the past 6 months. I analyzed for up to 9 months instead of 6 because for most of the assets that I chose they were active. I chose ENX, ZRX, UNI, CRV, and REN. Of these 5 different assets only ZRX was active for the entire time. The second graph shows the variable rates for the same 5 assets as well. I chose to use logarithmic instead of linear because on the linear graph it was difficult to read because the assets were not on the same scale. This gives a better view and understanding of how the rates are working. For the variable rate graph I did not used linear because the axes because they were on a similar scale. Unlike the stable rates, the variable rates, for all except CRV, seemed to be around the same. This is based on an averaging of the daily variable rates. Just like the other graph, I chose to do 9 months because some of the currencies are not active for the whole graph.
Apollo's Treasure
Dec 8, 2021 - This is going to show you the amount percent wise that had entered into the vault based on the different times. The first graph is going to show you that the trend is that nearly 40% of all people who participated in the farming did so in the first day. This is astounding because that means that people were very well aware of the farming event, but also that only a quarter of the people that participated did in the last 3 days. The second graph is showing you by hour the most that people participated. I found this interesting because it points to the trend of most likely the biggest players participating immediately. Much like other events in crypto the people who are most involved know about these different events, so it is no surprise they would want to participate first. The final number is showing you the total apollo that was farmed for charity.
Wormhole Users Persona
Jan 13, 2022 - These graphs are going to show you the persona of the users of wormhole. The first graph is going to show how much each account is spending in general. As you can see there are some accounts that are being used significantly more. If you look across the graph you can see that many people spend much less, but there is a still a lot going through these different accounts. The second graph will show how many different uses are happening per day for these different accounts. As you can see there has been a major increase in the amount of people using the wormhole since it got popular. The third graph is going to show you the amount of times each individual account is using wormhole. This will show that some accounts have used it once, whereas other accounts are using wormhole more frequently, sometimes up to 300-400 times.
Optimism Vs Layer 1
Jun 24, 2022 - How is user behavior different on Optimism compared to L1?
Solana When Do Transactions Fail
Jan 20, 2022 - These two graphs are going to show the amount of money and times that people have made transactions and how many of them have gone through. For most of the spikes there tends to be a correlation between the amount that fail to go through and the amount that do. There also tends to be a consistent amount of transactions that will fail at any time regardless of the volume that is going. This can be seen in the first graph as there is a constant amount of transaction amounts that are failing everyday.
Rekt Dashboard
Nov 4, 2021 - The first graph is going to show you the most amount of liquidations by address. This is the sum of many people who have been liquidated, but only the people whos liquidations reach the top 20, which is not a good thing. For the second graph it is important to ignore the x-axis as I was having technical issues any other time that I tried something else as the x-axis. What you can see is that many people were putting a lot as their collateral which is a safety mechanism that is used in the physical world. Much of the time a good collateralization ratio will range between 1-1.6, which is where most of these ratios found themselves taking place. The final graph will show the total amount from each address that was actually liquidated. To find the value now you can simply multiply the value of the token to the amount that was liquidated. DAI = $1 USDC = $1 WETH = $4358.22 LINK = $31.94 USDT = $1 MANA = $2.85