jake-wolf
Airdrop Claims
Oct 18, 2021 - The first graph is showing you how many different people actually went out and claimed these airdrops. There were a lot of people. Some claimed over 100, while others only claimed 1. This being said there were still a lot of different people that claimed these airdrops that were made available to them. There were 57,671 different terra addresses that have actually gone and claimed these. Of course like I said before some people claimed many more, but in terms of people who participated in these airdrops, it was quite a large number of the terra population. The second graph is showing you the amount of people that were given the opportunity to claim an airdrop. Staking is the main way that you would be able to claim airdrops. There were 101587 distinct terra addresses that had the ability to claim the airdrops. This means that roughly 56% of the people that had the ability to claim these different airdrops, actually did so.
frETH Holders
Jul 29, 2022 - How many address's hold frETH. What are their actions? Exclude big name labels like LP's etc.
Thorchain Swap Size Distribution
Dec 6, 2021 - This dashboard is going to show you information on the swap size and distribution of that on Thorchain itself. The first graph is going to show you the distribution of swaps in relation to the amount being swapped. This means that BNB, Thor, and ETH have the most amount of money being swapped. The next graph is going to show you the frequency of swaps. You can see that BNB, Thor, and ETH are still the top three blockchains that are being traded on, however, it is quite clear that BNB has more than any other blockchain, by far. It is important to note that the average swap on BNB is going to be far less than that of Thor or ETH because their frequency of swaps are significantly higher than any other blockchain on Thorchain. The final graph is going to show you swap amounts over time, by each of the different blockchains. What you can see is that BNB tends to be on the lower ends of swap amounts everyday, yet their frequency, which can be seen from the pie charts, are very high. You can also see that the Thorchain was doing very well and has since been dropping quite heavily.
Total Metamask Users
Jun 25, 2022 - How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
Thorchain On-Ramping Stats
Nov 3, 2021 - The first two graphs that I would like to talk about are going to the ones that are showing where people were switching from, and how much they were spending. You can see that the graphs are nearly identical meaning people were spending similar amounts when they were switching over and there were major spenders. If you also look at the two graphs that are to they look identical to those talking about the from, but if you look over the graphs and their numbers you can see they are actually different. These two graphs together give you the perfect view of how much was going to and from which assets. By comparing these you will have the ability to know how much was swapped to and from the different people whose assets were involved. The third graph and the sixth graph show you people's first transactions on the network and what they were getting out of and going into. You can see that most of the first transactions were happening on either BNB or RUNE, meaning most of the transactions were most likely moving out of those two blockchains. That being said when you look at the different graphs for the to addresses it is easy to see that where they are going to is much more even. However, when looking at the scales you can see there is a massive issue. One scale goes up to 150 while another goes up to 8000, which can only mean that people are moving off of this network onto others. Although there was a major spike there has also been a major slow down in terms of network activity, meaning people are sending money to other wallets that are not on this platform.
Bridge Volume Hop Protocol
Jun 22, 2022 - How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
On Boarding with Solana NFT's
Jun 16, 2022 - It has been said that Solana NFTs have become a powerful onboarding tool into the Solana ecosystem. Is this narrative true? Which NFTs have captured the most first time users of the Solana blockchain? What kinds of activities do these wallets tend to do after buying their first NFT? Do you think the NFT growth on Solana will spill over into Defi?
Thorchain Terra LP-ers: Aftermath
Jun 21, 2022 - What did people that were LP-ing in the Terra pools do? Are they just holding onto their $RUNE now or are they back in the arena LP-ing somewhere? Or did they sell their $RUNE and leave the ecosystem completely.
Governance Participation (Address)
Oct 12, 2021 - The graphs on this dashboard will show the individual governance participation. I think it is important to first see what a graph would look like without the top participators. There is a large group of people that are participating, however, the power they have may not compare to those with the most, in fact it does not even compare. If you look at another graph that I included labeled governance power it is quite obvious that one address has the most power. They have 25 million in terms of total voting power, which blows everybody else to the side. I also added a time graph that will show you when each individual voted. You can go to any day and on that day you will be able to find who voted, their address, and also how much voting power they had. This information is useful especially if you want to look at certain votes. The last graph I wanted to use would show the voting power used over time. This graph will be very helpful when looking for the major votes. You have the ability to go and look at the specific dates on the previous graph I spoke about based on this final graph. I also included a graph without the top 100 so it is easier to see most of the people that had voted because the scale makes it more difficult to see the lower spectrum of voters. In this graph that shows the voting power over time without the top 100, it is much easier to see that many people do actually vote, it is just difficult to see when looking at scale.
Osmosis Governance Participation
Jun 21, 2022 - Create a dashboard that maps community participation in governance. On average, how long does it take for a new wallet to become active in Osmosis governance? Do wallets that are active in governance vote on every proposal? Or do they only vote on select proposals?
Terra Who Validates The Validators
Dec 15, 2021 - These are the top 3 validators and they are far from the rest of the validators. I have found that consistency is the most important thing when it comes to validators. As you can see the top validator is doing more validations than anybody else. This means they are also making the most money as well. It also can be seen that the best validator is putting extra money into their validation work, which means either investing in extra machines so they can validate more times and/or they are getting clients as well to let them validate, which has become a big market as well.
Polygon vs Ethereum Fees
Sep 14, 2021 - This first graph shows the Ethereum fees and the second graph shows the polygon fees. It does look like there is a correlation going into September, because if you add up all the numbers than they are close to the same as the polygon. There are no real divergent, but there are many big differences along the history of the two. Ethereum has more consistency, where as Polygon has skyrocketed recently. Based on my research there has been a lot of people considering Uniswap Polygon to be one of the most likely coins to become stable. It has done very well recently, but is expected to flatline and median out around $35-40 a coin. This would explain why there is a similarity between Ethereum and Polygon because Ethereum is one of the most well known and stable considered coins.
Thorchain Net Liquidity
Dec 18, 2021 - This dashboard is going to give you information on the net liquidity of Thorchain and how it has changed overtime. The first graph will show that more has been put into the network than taken out and the difference is 20%. This is obvious as the RUNE still has value, but more has been removed recently than has been added. The second graph is going to show the different pools and how much is added or removed during the time. The next two graphs are going to show information on the total liquidity added and the total removed during over time. You can see that more has been added over the total existence of the network, which is where the value of RUNE comes from, but since November, there has been no liquidity added to this network, which is most likely due to the crashing of the network for a second time. This would make people less likely to put there money into it as they want to make sure the network is stable before they put there money in.
Thorchain Network Shutdown
Dec 1, 2021 - This dashboard is going to show what the behavior of users has been since the restart of Thorchain and also how it compares to the actions before the shut down. This will give a deeper analysis on whether the shut down has changed people’s behaviors or if the shut down did not affect the actions of users in this environment. Before the shutdown there was a pretty even give and take of people adding and removing liquidity from the different pools. There were different spikes when the liquidity removed was drastically larger than that of what was being added, but in general they were pretty even. Some weeks would be up and some weeks would be down. Since the crash and restart it seems that people are removing much of their liquidity. Very few people are adding to the pools and this could be because this is the second time that the environment has crashed in its existence leading people to not trust the stability. This being said, people are still putting their money into RUNE. Not nearly as much in comparison to before, but also the time passed has been significantly less. What this says is that people are still wanting to have money in RUNE, believing that it will rise, and hoping that they won’t have an impermanent loss. Overall, people are a bit hesitant to get back into the LP’s on this network, but do believe in the currency. This leads me to believe that most likely people are going to want to have RUNE, and are hoping that as time goes on the network will get more reliant.
Thorchain Pool Stats
Nov 2, 2021 - There are 5 graphs that are being shown on this dashboard. The first graph will you show you the amount swap amount by the fees. The x-axis has the swap volume in USD, while the y-axis has the total swap fees. You can see that the amount of swap volume does not necessarily correlate to the amount of the fees. The second graph is showing the liquidity in terms of USD. Liquidity has been steadily rising and is now roughly consistent and seems as it will stay so. The third graph is showing the swap volume for rune. You can see that unsurprisingly swap volume completely falls off after the issues that the network had. However, as it has come back on there have been more swaps, which correlates to the resurgence of the network. The fourth graph is showing the swap count. You can see there are definitely ups and downs, realistically if it were to be looked at on a weekly instead of daily basis, it would look significantly more consistent. There was also a major drop during the times that the network was down, but now in mid to late September and moving forward it has become more active and consistent. The final graph shows the total swap fees, which peaked and then dropped in the middle of the graph. This also correlates to the reactivation of the network. Although it might look like there is not a lot of activity, that is because the scale makes it seem as such.
Scanner Sweep Terra Ecosystem Summar
Apr 6, 2022 - Q175. Bounty question #157 was to create a dashboard to show the health of the Terra ecosystem. For this bounty, your job is to write a succinct one-page summary or summary dashboard assessing a submission of your choice for the Acme of Skill bounty (#157). Grand prize winners will compare at least two of these submissions.
Lock Curve Why
Jan 12, 2022 - This dashboard is going to show why it is best to lock curve and show how many people are doing this. The first graph are people that are locking their curve and the second graph is people that are moving their curve from curve. As you can see there are more people that are moving their money to curve instead of taking it out. By locking your cryptocurrency you strengthen the blockchain itself, but can also earn rewards based on the cryptocurrency that you lock. For a growing crypto currency having people lock it helps to provide stability to the new coin, which is why it happens quite often when a coin is new. As the value grows so will your rewards and the desire of others to get into the currency itself as it is on the rise.
New Node Operators
Jan 19, 2022 - These are all the distinct node address's that are being used on thorchain. I got this from the new node event tables, which would show the new nodes operators address's. This graph is going to show the new node's that are being used, however, this will not show the count of nodes that are being operated on a daily basis. As you can see there are new nodes that are being operated almost every day. As you can also see since the beginning of January many more new nodes are being used everyday. This indicates that the growth of the network is continuing. This is backed up by the information that there are new currency's being added to the network.
Volume To Centralized Exchanges
Jan 18, 2022 - There was a recent spike in people using centralized exchanges, but for the most part it has stayed steady. The reason for that there has not been much change is probably because of the crash that has been occurring in crypto over the last month. As the prices have not increased we are seeing that there has not been an increase in people getting into crypto. It would actually make sense that they have slightly decreased because people are holding onto their assets and hoping that they will increase in value over time instead of taking a loss. This could also be due to the high volatility of the crypto market.
Humble Swap Launch
Jun 23, 2022 - A new dex has launched on Algorand built by the reach team: humbleswap(humble.sh). Let’s look at how its launched: -Total number of swaps by day over time -total number of wallets swapping by day -What are the most popular asset pairs to swap from and too -Top 10 assets swapping from -top 10 assets to swap to
Tracking USDC & USDT on Solana
Jun 16, 2022 - What's the current market share for USDC and USDT on Solana relative to other stablecoins in the ecosystem (look into USDC, USDT, UXD, USDH, PAI, NIRV, UST, DAI, FRAX)? Create a visualization showing the amount of transaction volume for USDC vs. USDT etc. do display popularity within Solana. For USDC and USDT specifically, breakdown the transaction activity by contract and exchange flows (i.e. which dapps and addresses hold the majority of USDC and USDT and what do cumulative flows to and from exchanges look like over time)?
$Rune Upgrades
Jun 27, 2022 - Have you seen an uptick in the amount of $RUNE being upgraded recently? Look at both the $RUNE volume + number of wallets. What is the trend over time + also how much is ETH vs BNB?
Thorchain Volume Swapped
Oct 27, 2021 - This dashboard is going to show the volume swapped on the different pools broken down over time. The first pool is the Ethereum pool. There were many different Ethereum pools and you can see which ones are active or not based on the line graph that I have created. Some are relatively inactive, but some are very active. After that graph is the activity and volume on the BCH pool. There is not as much activity and there is only one pool. The following graph is shows the pool for LTC and there is barely any activity compared to the first 2. The fourth graph shows the pool for BTC and has one of the most active pools except for the ETH pool. The fifth and final group of pools is for BNB and it has 7 different pools represented on the graph.
Gas Prices and Deposit/Borrow Amounts
Nov 8, 2021 - The borrow graph is going to show you how borrowing has been affected by the increase in gas prices. You might assume that the amount borrowed would drop, however, this is not the case. The gas prices have increased because the volume of transactions have drastically increased and there is only so much to go around. It is a simple supply and demand problem. It also makes sense because the valuation of many crypto currencies have been on the rise, so more people have been trying to get into the market. The deposit graph is going to show you something similar as well. Although there are some negatives, which can be seen by scrolling through the data, it is overwhelmingly positive, which is not a surprise either. As stated before the market has been steadily on the rise and just like any other stock as it increases, people will invest into them. Some might assume that the increasing gas prices would be a deterrent to entering the market, but because of the high possibility for rewards it is starting to be seen as a very lucrative market. It is important to also point out how similar the graphs are. The amount of activity that is going on increases when people are borrowing and depositing which is influencing the price and overall increase in value of the crypto currency world.
Whale Activity
Nov 10, 2021 - This is the graph that contains all of the different Liquidity Pools that are involved on the chain. It is also important to note that there are people who are entering and leaving the different liquidity pools. I thought it was important to note which of the LP's were having more money removed than added, as they represent opposite actions. As you can see there are many Ethereum LP's that are having just money added instead of being taken away. That also goes for some in BNB as well.
Largest Tokemak DEX Pools
Jun 22, 2022 - What are the largest dex pools for TOKE (UNI, SUSHI, etc.)? What is the behavior of TOKE holders on these token pools currently?
Liquidity And Volume
Jan 19, 2022 - The first graph is going to show you the volume that is added to the liquidity pools by which the top 10 most are added. As you can see USDC WETH has the most added to it by far. The third graph is going to show you the daily volume that is also added to these pools, but in total without separation. The second graph is going to connect with the fourth graph regarding liquidity. It is no surprise that sushi has found itself in the same position as many other currencies. With the major drop is crypto it is no surprise that liquidity has also taken a hit. This can be seen as for much of the time table it is completely negative, meaning more money is being withdrawn then added in terms of liquidity. However, there is been a major increase in the amount of liquidity that has been input, very recently. Many people would take their money out because of the drop, however, as the popularity increases and the assumption of valuation increases continues, there is no surprise that many people decided it was a great time to invest a lot of money into the platform itself.
ETH Staked
Jun 15, 2022 - What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Most Popular ASA
Jan 13, 2022 - These two graphs are going to show you the most popular assets. It will show you how many people are holding the different assets by comparison to each other. The other graph will show you how many transactions are taking place between the top ten transactions. As you can see the transactions started off quite plentiful, but fell off quite recently. Although it is not in the database, there are more transactions going on recently than it shows towards the end of the graph.
Optimistic Bears
Aug 11, 2022 - Q9. Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth.
Impact of Price Changes Sushi
Dec 25, 2021 - The impacts of the price changes based on Sushi's drop is very interesting. Although people would have expected it to go up it has actually gone down. The amount sent in and out, and the volume of transactions are almost completely equal. This means we have to look at everything overtime to see how it has changed. Since April the amount going into Sushi has stayed very consistent. The amount going in has stayed very consistent as well. The bottom two graphs are going to also show you the same information, but when people are taking their money out. As you can see almost everything has stayed fairly consistent even with the price drops.
Sushi Top 10 Pool Analytics
Jan 10, 2022 - These different graphs are going to give you all of the information requested based on the top 10 liquidity pools. The first graph is going to show you a comparison between the top 10 LP. The second graph is going to show you the amount put into each LP every single day and how it changes. The 3rd graph is going to show you the fees per day and how they compare to each of the other LP's. The 4th graph is going to show you the pools and how much is added per week. The last 3 graphs are going to give you information on the fees. The first will show you that the most fees by far is WETH-DOGE, which are holding nearly 80% of the fees from the top 10. The next graph is going to show you the fees based on each week. The final graph is going to show you how much in total each LP has in fees, Definitions : LP is Liquidity Pool