Owentell
DAI Volume
Jan 18, 2022 - This dashboard looks at the volume of DAI used in transactions compared to other popular stablecoins.
83. Airdrop Summary
Oct 13, 2021 - This dashboard looks at several metrics of airdrops on the Terra ecosystem over the past 90 days, such as how many were claimed, how much money was claimed, how much money was claimed daily, and how often the airdrops were claimed. Over 500,000 airdrops were claimed on the Terra ecosystem over the past 90 days, and over $152 million worth of airdrops were claimed in total. The daily amount of money claimed spiked significantly on October 10th 2021, with over $45 million claimed on that single day, more than triple the second highest amount claimed over the past 90 days. Interestingly enough, the amount of airdrops claimed that day was not the highest over the past 90 days, which suggests one or more whales were responsible for the spike in amount of money claimed. The amount of airdrops claimed daily varied significantly, with the most being claimed on October 6th and 7th of 2021.
1. CRV Token Uses
Sep 20, 2021 - The CRV token is a token created by Curve Finance, which allows for users to swap between different ERC-20 tokens and stablecoins. While the CRV token was created with the purpose of governance, as it can be locked to vote on protocols and earn a staking reward, owners of the token do other things with it as well. The main other use of the token looked at in this dashboard is to supply liquidity to liquidity pools, which earn the depositor rewards over time. One pool that people with the CRV token supply liquidity to is Uniswap's WETH/CRV V2 pool, which converts wrapped Ethereum to CRV and vice versa. The visualization below looks at the difference in deposits and withdrawals of the CRV token from this pool daily. The amount of withdrawals and deposits to this pool were much more volatile from around February to May of 2021, and have somewhat stabilized since, with less days with a large difference in withdrawal and deposit amounts. A second thing CRV holders do with their CRV is deposit it into Uniswap's USDN/CRV pool, which the second visualization in this dashboard looks at. The discrepancy between withdrawals and deposits into this pool is much less than that of the previous pool, with almost all data points being less than 50,000 USD, compared to many being over 1,000,000 USD in the WETH/CRV pool. Methodology: Data for the following visualizations was extracted from the ethereum.udm_events table. To find which pools CRV was deposited into, and how much, I filtered for transactions that had a contract_address equal to the CRV token's address, and then filtered by specific pools from Uniswap that had a large number of transactions. I then looked at if the CRV was coming in or out of the pool, and subtracted the amount withdrawn in USD from the amount deposited in USD by day.
$RUNE Upgrades
Jun 24, 2022 - This dashboard looks at ETH.RUNE and BNB.RUNE upgrades on THORChain over the past six months.
49. Anchor Impact on UST
Aug 25, 2021 - This dashboard looks at the growth in supply of UST before and after the introduction of the Anchor protocol in March of 2021. The growth in the supply of UST from two months before the release date of Anchor to it's release date was about 931,000,000. In comparison, the growth of UST from Anchors release date to two months after was about 1,032,000,000. While these numbers are relatively close, the introduction of Anchor could have led to a slight increase in the growth of UST, as the supply did grow slightly faster after Anchor was released. I think Anchor has solidified itself as an essential foundation protocol of the Terra ecosystem, as almost half of all UST is currently deposited in Anchor. In addition, it provides a relatively stable way of earning interest through cryptocurrency and DeFi.
44. [Hard] Pool Positions Dashboard
Aug 11, 2021 - Is there a way to see all active positions from all LPs for a given Uniswap V3 pool? What are 3 ways to visualize this effectively?
Flow Speed
Jun 3, 2022 - This dashboard compares speed on the Flow blockchain to speed on the Ethereum and Solana blockchains.
Fractionalized Dragons
Mar 17, 2022 - This dashboard looks at the volume of $DRGNZ traded, and the volume deposited into the DRGNZ-SOL liquidity pool.
Redemption Arc
Apr 7, 2022 - This dashboard looks at the minting and burning mechanism on Terra and when the demand for minting and burning has come close to exceeding the redemption caps.
Uniswap - 12. DEX Usage Patterns
Mar 26, 2022 - This dashboard compares different metrics of the Uniswap and Sushiswap DEXs.
It's Raining $RUNE!
Jan 18, 2022 - This dashboard looks at which THORChain node operators have received the most rewards, and what factors could affect this number.
63. Terra Swap Pool Fee Performance
Sep 4, 2021 - This dashboard shows the average fee APR for the top 5 liquidity pools on the Terra ecosystem. This APR was calculated by dividing the fee per transaction by the amount of the transaction, and averaging those numbers with each other transaction in the pool from the last six months. The pool with the highest APR, around 25%, is the CNT to GBT pool.
Sushimaker
Apr 28, 2022 - This dashboard looks at the role of Sushimaker on Sushiswap and compares the amount of SUSHI that is being staked by users with the amount of SUSHI that is being served by Sushimaker.
17. [Hard] Pool Depth
Nov 17, 2021 - This dashboard looks at the pool depth of the top 4 liquidity pools on THORChain by volume. THORChain is a protocol that allows for the swapping of assets from different blockchains. It does so through its native token RUNE. A user swaps their asset for RUNE, and then swaps that RUNE for their desired asset, for example swap BTC to RUNE and then RUNE to ETH. In this dashboard, the term 'pool depth' refers to the number of users providing liquidity at any given time. In general, the number of users providing liquidity to the top four pools has increased over time, especially in the BTC, THOR and ETH pools. The BTC and ETH pools, two of the first ones on the platform, follow a similar evolution over time, with a steady increase of users from April to July 2021. There is a gap in data for both of these charts from the middle of July to the end of September, most likely due to the multiple audits THORChain underwent in that time period. The BTC pool continues to generally increase in depositors, with a slight downturn at the end of October. One of THORChains most recent pools, the THOR pool, has steadily increased in the number of user depositing since its inception in November. It has almost quadrupled from a starting number of around 1000 depositors to almost 4000 depositors currently. The XRUNE pool is a bit of an exception as it has not increased much over time but has instead remained relatively stable, hovering around 1200 depositors.
37. [Elite] Address Tagging
Dec 24, 2021 - This dashboard categorizes users of the THORChain protocol into different clusters based on their swap volume, and then looks at the metrics of these different categories. Swap volume in this dashboard is in terms of the amount of swaps a user conducts, and only active users are included(users who have conducted a swap in the past month).
24. [Easy] Swap Size Distribution
Dec 6, 2021 - This dashboard looks at the swap size distribution on THORChain. The THORChain protocol allows users to swap assets from different blockchains, utilizing its native token RUNE. To minimize the number of swap size bins, I decided to use a logarithmic scale. The first visualization in this dashboard looks at the proportion of THORChain trade sizes. By far the highest number of trades are in the ranges of $100 and $1,000 and $1,000 and $10,000. The highest number of trades are within the range of $1 00 and $1000, with a total of over 500,000 trades in this category and making up 52% of total trades. The least number of trades occurred at a size of great than $1,000,000. The next metric in this dashboard looks at the average trade sizes across all of the THORChain pools. The pool with the highest average trade size was the FOX pool, while one with the lowest average trade size was the AVA pool.
0. Art Blocks Predictive Analytics
Sep 8, 2021 - To estimate which art blocks would have a resale in August 2021, I decided to look at the change in average sale price of a collection from June to July. I first found the average sale price of art blocks collections created before August 2021. I then calculated the average sale price of each collection in the month of June and then the average sale price of each collection in the month of July. I found the growth between these different averages and selected for a growth of over 1000%. The collections that fit this criteria were "Fidenza by Tyler Hobbs", "The Blocks of Art by Shvembldr", and "Space Debris [maider] by WhaleStreet x pxlq". I then found individual pieces in each collection that had not yet sold in July, despite the inflation in their collection, and selected these as the pieces most likely to have a resale in August. Unfortunately this method did not have great accuracy in predicting which Art Blocks would have a resale. For the Fidenza collection, 12.29% of the pieces predicted had a resale in August, 6.15% of the pieces predicted had a resale for the Blocks of Art collection, and 3.66% for the Space Debris Collection. Although the accuracy for the projected pieces actually being resold in August was very low, looking at the growth in average sale price of the collection does indeed provide some insight into predicting resale probability. The collection with the highest growth rate looked at here, Fidenza, had the highest accuracy, and the collection with the lowest growth rate, Space Debris, had the lowest accuracy. More research has to be done on the topic, but it seems growth rate could still be a predicator of resale, at the very least comparatively to other collections.
$RUNE Movement from Crypto.com
Jun 22, 2022 - This dashboard looks at the inflow and outflow from Crypto.com to native THORChain wallets over time.
Sushi Rewards Distribution
Apr 28, 2022 - This dashboard examines SUSHI rewards, specifically how much in total has been distributed so far, how much is left to distribute today, the percentage of eligible addresses that have not claimed anything so far, the number of eligible addresses that have not claimed anything so far.
Increasing Positions
Jun 29, 2022 - This dashboard looks at the number of users increasing versus terminating their positions on Mean Finance over the past month.
Wallet Statistics
Feb 8, 2022 - This dashboard looks at the wallet statistics of Sushiswap liquidity providers. Only users who provided liquidity to Sushiswap in the past month are included in the below graphs and metrics.
20. Sushi Token Activity
Jan 13, 2022 - This dashboard looks at token activity, specifically native tokens, on the Sushiswap platform over time. There are two main native tokens to the Sushiswap platform. SUSHI and xSUSHI. When SUSHI tokens are staked to Sushiswap's governance protocol, xSUSHI tokens are minted, which appreciate in value over time and can be burned to receive SUSHI tokens. SUSHI tokens can also be earned from staking SLP, Sushiswap Liquidity Pool, tokens, otherwise known as 'harvesting' them. The first graph looks at the daily volume of SUSHI tokens staked, xSUSHI minted, xSUSHI burned, and SUSHI harvested. The second graph look at the same metrics but in terms of USD. The amount of xSUSHI burned has been especially volatile over time, and is mostly responsible for the day with the highest total volume, July 7th of 2021, where over $6,000,000 xSUSHI was burned. Unsurprisingly, the amount of SUSHI staked and xSUSHI minted are very close in volume each day, as a similar amount of xSUSHI is minted for each amount of SUSHI staked to governance.
Active Wallet Addresses
Jun 22, 2022 - This dashboard examines how many users are currently in the THORChain ecosystem.
Terra LP-ers: Aftermath
Jun 22, 2022 - This dashboard looks at what users LP-ing in the Terra THORCHain pools did after Terra's collapse.
26. Unique Users
Jul 28, 2021 - This charts shows the number of unique users onboarding on to Terra over the past year. The number of unique users has risen steadily over time from a low of around one million users in July of 2020 to a high of about 2.5 million in July of 2021.
14. [Hard] Pool Stats
Nov 7, 2021 - This dashboard looks at multiple metrics of THORChain's top five liquidity pools. THORChain is a revolutionary new protocol that allows for users to easily swap assets from different blockchains. This is done utilizing its native token RUNE. Users swap their asset, such as BTC, for RUNE, and can then swap that RUNE for assets from other blockchains. The first graph is this dashboard looks at the daily total liquidity in the top five liquidity pools on THORChain, throughout the month of October. The total liquidity in these pools has in general risen throughout October, from a total of around $100,000,000 at the beginning to about $200,000,000 towards the end of October. The next two graphs look at the daily total swap volume and the daily total swap count. In general it seems among all the top 5 pools, both swap count and volume has risen. Looking at the daily fees and daily fees per $1000 in each of the top 5 pools, it seems that fees have risen over time, with the ETH pool having by far the largest daily fees.
9. RUNE price vs Swapper activity
Nov 3, 2021 - This dashboard looks at the price of RUNEs effect on THORChain activity. RUNE is a native token on THORChain, and is the token that enables users to swap assets from one blockchain to another. Users swap one asset for RUNE, and then can use that RUNE to swap for an asset from another blockchain. The first graph in this dashboard looks at the daily swap volume on across all of THORCHain's pools versus the price of RUNE, over the month of October. As you can see from this graph, the price of RUNE does indeed seem correlated to the swap volume. When the price of RUNE was lower towards the beginning of October, at about $8, the swap volume hit a max of about $10,000,000. The price of RUNE steadily climbed towards the end of October, and with it swap volume has generally increased as well, hitting a high of about $36,000,000 on a single day. The next metric looked at is the daily number of withdraws and deposits to liquidity pools versus the price of RUNE. This follows a similar pattern as the previous, and as the price of RUNE rose at the end of October, so did the number of withdraws and deposits to liquidity pools. This suggests that the higher the price of RUNE, the more often users will interact with the protocol.
Solana NFT Project Feature
Jul 21, 2022 - Choose a NFT project from the following list and create a dashboard with the new Flipside dashboard layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the project. Note any noticeable trends or current events for the project. Highlight how liquidity is flowing in and out of the project and what types of buyers and sellers are interacting with the project. Note: A tip will be given out for the best dashboard of each unique project (assuming it is deserving) along with a grand prize for the overall best dashboard among all projects. Projects to choose from: -Degods -Solana Monkey Business -Shadowy Super Coders -Okay Bears -Degen Ape Academy -Aurory -Cets on Creck -Taiyo Robotics -Blocksmith Labs -Famous Fox Federation -Communi3: Mad Scientists -Portals -Primates -Catalina Whales -Bubblegoose Ballers -Trippin' Ape Tribe -SolGods -Stoned Ape Crew -Boryoku Dragonz -Galactic Geckos -Atadians -Thugbirdz -Pesky Penguins -Genopets -Nyan Heroes
New User Onboarding
Jun 29, 2022 - This dashboard looks at where THORChain users are getting their RUNE for the first time.
Interactive Users
May 7, 2022 - This dashboard looks at active and passive users on the Terra blockchain.
Member Roles
Mar 10, 2022 - This dashboard looks at members and whales of Bankless DAO. A member is a user that is holding 35,000 or more BANK tokens, while a whale is a user with more than 150,000 BANK tokens. For this analysis, I did not count a whale as both a member and a whale, and so any user between 35,000 and 350,000 tokens is a member, and any user above 350,000 tokens is a whale.
Getting Your Feet Wet, Part 2
Mar 9, 2022 - This dashboard looks at how many new users are interacting with protocols on Terra.
84. Governance Participation
Oct 13, 2021 - This dashboard looks at different metrics of governance in the Terra ecosystem. Governance is a system whereby the community can propose and vote on amendments to the Terra protocol. I first looked at the proposal side of governance, where members of the community propose new ideas which other members vote on. The top proposer had 8 different proposals, and the number dropped off sharply after, with the next highest proposer having only 4, and 6 of the top 10 only having 2 proposals each. The next thing I looked at was the average balance that these addresses had, to see if there was a correlation between the balance of a wallet and their number of proposals. Interestingly enough, the top proposer only had an average balance of about $300, which I would have thought would be higher. Although the second highest proposer, with 4 proposals, had the highest average balance of about 41.5 million. I hypothesized that those with the most proposals would have the highest balances, although this does not seem to be the case, with a mix of high and low balances in the top proposers. I next looked at the top 10 voters over the past six months and their average voting power. I hypothesized that those with the highest voting power would have the highest number of votes. The average voting power over the past six months over all Terra addresses was about 4,300, and all but two addresses had well above that number, which suggests those who have more voting power are more likely to vote on Terra governance proposals.
Solana NFT Growth
Apr 28, 2022 - This dashboard tracks multiple metrics of NFT growth on the Solana blockchain and compares them to NFT metrics on Ethereum.
Uniswap - 13. UNI token distribution
Mar 26, 2022 - This dashboard looks at the UNI token distribution of both active UNI holders and all UNI holders.
Do Whales Have Diamond Hands?
Jun 22, 2022 - This dashboard looks at how the swap activity of Osmosis whales differs from everyday users.
41. Active LP-ers
Jan 12, 2022 - This dashboard looks at the top 10 most active THORChain addresses in terms of updating their liquidity positions. Two addresses are far above the rest in number updates, with one updating their liquidity position over 16,000 times, and another updating their position over 11,000 times. The rest of the top 10 addresses are leagues below this amount, with the next highest having only 1,225 updates. I next looked at the amount of liquidity each address in the top 10 was supplying to each pool over time, in order to gain insight on what pools the top 10 addresses were attracted to. The volume in RUNE the top 10 addresses provided to the BTC pool rose steadily over time, which is most likely to due to its relatively low volatility in comparison to other coins. This same trend also occurred for both the ETH, BNB, and BUSD pools. One of the largest increases in volume was in the THOR pool, where over 7 million RUNE was added in a single week. In conclusion, the top 10 most active addresses seem to value safety of investment and low volatility over higher percentage yields.
Standardized TVL over time (all pools)
Apr 23, 2022 - This dashboard looks at the standardized TVL of all pools on THORChain.
19. [Easy] Whale activity
Nov 9, 2021 - This dashboard analyzes the activity of whales on the THORChain platform. Here a whale is defined as a user that is holding more than 10,000 RUNE tokens. RUNE is THORChain's native token that facilitates the trading of assets from different blockchains. The first graph looks at every liquidity pool on THORChain and how many whales are providing liquidity to each one. From this we can see that there is at least one whale invested in each pool. The two pools with the lowest amount of whales invested in them, at one each, are the NEXO and FRM pools. The next chart looks at the top five pools whales are currently providing liquidity to, which are the BTC, ETH, BUSD, THOR and XRUNE pools. The pool with the highest number of whales investing in is the THOR pool, with 102 whales providing liquidity. Unsurprisingly, these five pools are the pools with the most liquidity on THORChain as of now.