34. UST "Collateralization"
Aug 4, 2021 - These charts show the total terra users over time, the total balance of all wallets on the Terra network in USD, and the total number of transactions on the Terra system over time. The Terra system is highly collateralized.
61. Stablecoin Total Supply
Sep 4, 2021 - This dashboard looks at the three most popular Terra stablecoins and their total circulating supply, in USD, over the last six months. The balance of the UST stablecoin, pegged to the US dollar, has by far the greatest amount in circulation, reaching over 2.5 billion in September 2021. In contrast, the amount of MNT in circulation, pegged to the Mongolian Tughrik, only reached a high of about 1.4 million. The KRT stablecoin, pegged to the Korean Won, reached a high of over 80 million USD in circulation in June 2021, but dropped off soon after to a low of about 60 million USD in August 2021.
4. Flash Loan Prevalence on Aave
Sep 2, 2021 - This dashboard looks at different metrics of Aave flash loans. The first thing I calculated was the percent of flash loans used in pools, which was about 42%. The next metric was the number of loans over time, which peaked around the middle of May and has since dropped off. The final metric was the loan amount over time, which also seems to have peaked in the middle of May and since decreased.
Uniswap - 9. User Participation in Governance.
Mar 19, 2022 - This dashboard looks at statistics regarding governance activity among Uniswap token holders.
43. Uniswap Weekly Volume Breakdown
Aug 4, 2021 - This chart shows the total volume for Uniswap per week and the volume in the top 5 pools by week. The total volume seems to have stabilized since May, hovering at around 5.6 billion uusd. The weekly volume breakdown of the top 5 pools follows the same shape roughly as the total volume chart.
25. Delegator Behavior
Jul 28, 2021 - This chart looks at the behavior of delegators and non delegators in terms of transfers and swaps. The number of transfers conducted by non delegators is far greater than the number of transfers conducted by delegators, while the number of swaps conducted by delegators and non delegators are relatively similar.
60. Average Trade Sizes
Sep 4, 2021 - This dashboard first shows the top 5 assets by volume traded(USD) with native Terra swaps, which are USDC, WETH, FRAX, DAI, and MIR. The y-axis for this chart is a logarithmic scale as the different volumes can be more easily seen this way. The next chart shows the average trade sizes for each of these assets, when they are traded to native Terra swaps, with USDC having the largest average trade size, and MIR having the smallest.
11. Total Liquidity Dashboard
Sep 15, 2021 - This dashboard visualizes two things, firstly the average total liquidity per day in all of Aave's pools, and secondly the change in liquidity in each of Aaves V2 liquidity pools over time. The daily liquidity has increased massively over recent months, and the point of highest liquidity in 2021 is more than 10 fold the highest point in 2020. One of the biggest liquidity increases came at the end of April, where total liquidity jumped from around five billion USD to over fourteen billion USD in a matter of weeks. This jump could be in part to a set of new governance proposals that occured in April, and Curve Finance launched a Polygon pool that is deposited into Aave. Aave's V2 pools have also, in general, increased significantly over the course of the year. The two most popular pools, WETH and USDC, both increased more than 100 fold since December 2020. The only pool which seems to have slightly decreased over time is BUSD, which went from a high of about sixteen million in March 2021 to about 9 million in September. Methodology: Since the liquidity data in Aave's market stats is hourly, I had to get the average since I wanted to find the daily total liquidity. To find the average Aave liquidity per day, I first grouped by day and took the sum of the liquidity from Aave's market stats and divided this sum by 24. For the chart showing the liquidity in Aave's V2 pools over time, I found the average for each day for each pool from Aave's market stats. I made four different tables, with each having the average pool liquidity, and each being on a day three months apart from the others. I then joined them together, allowing me to contrast the data from four different months in three month intervals. The data only goes back to December 2020, as that is when Aave's V2 pools were released. I decided to use a logarithmic scale for the y-axis as the data points were too far apart for a good representation on a linear scale.
49. Node RUNE in/outflows
Feb 3, 2022 - This dashboard looks at the impact recent EMISSIONCURVE changes on THORChain have had on the behaviors of node operators.
Opening Positions
Jun 29, 2022 - This dashboard looks at opening positions activity on Mean Finance (Polygon).
$THOR Staking Distribution
May 25, 2022 - This dashboard looks at the distribution of the THOR tokens currently staked on THORChain.
Anchor Historical APR
Aug 18, 2021 - What has Anchor's historical APR by day and by week been since launch?
Uniswap - 8. Bot Detection.
Mar 19, 2022 - This dashboard looks at how many trades on the Uniswap DEX are conducted by bots.
CowSwap - Market Moover?
Apr 22, 2022 - This dashboard looks at how the CowSwap DEX has been performing compared to other DEX's over the last several months.
Active Addresses
Aug 11, 2021 - Of all addresses that delegated in Q1 2021, how many active on June 30th?
Flow During Market Downturn
Jun 29, 2022 - This dashboard looks at different metrics on Flow during the recent market turbulence in May of 2022.
Voting Records
Jan 19, 2022 - This dashboard looks at the voting records of Terra Bite's and Flipside's validators.
Unique Users
Jun 6, 2022 - This dashboard looks at the number of unique users on Osmosis over time and what events may have caused large influxes of new users.
L1 Outage List
May 6, 2022 - This dashboard is a list of the queries used to find possible outages. All data is from 2021 onward.
29. LUNA to UST Price to Stability Correlation
Jul 28, 2021 - This chart shows the price of LUNA and UST each day compared to it's 3 day lagging moving average, therefore showing the change in price between those two values. When there is a spike in Luna, there is an inverse reaction in the price of UST, and vice versa.
33. Anchor Collateral Ratio
Aug 4, 2021 - This chart shows the Anchor collateral vs borrow per day, the Anchor rewards claimed per day, and the Anchor borrow volume.
15. [Hard] On-ramping
Nov 17, 2021 - This dashboard looks at the breakdown of new THORChain users by blockchain and by pool. THORChain is a protocol that allows for the swapping of assets from one blockchain for assets from another. This is done through the swapping of the users asset for THORChains native token RUNE, and the user then swapping RUNE for their desired asset. Users currently are on-ramping from the Bitcoin Cash, Bitcoin, Binance, Ethereum and Litecoin blockchains. The most popular blockchain thus far for THORChain users to on-ramp from is the Binance blockchain. This could be due in part to it's relative popularity but also its much lower fees compared to blockchains like Ethereum. Bitcoin and Ethereum have a very similar amount of users on-ramping from each, at 1611 and 1570 respectively. Both of the graphs in this dashboard use a logarithmic y-axis due to the large discrepancies in the different x-axis categories. After looking at the number of users from each blockchain, we can narrow our view further to which specific pools are the most popular for users to interact with on their first THORChain transaction. Of course after looking at the breakdown by blockchain, we already know that the Binance pools will be by far the most popular as most users onboard from Binance. The most popular pool is the BNB, or Binance coin pool, meaning that most users start using THORChain by depositing BNB and swapping it for RUNE. The second most popular pool is the BTCB pool, which is a coin on the Binance blockchain pegged to the price of Bitcoin. The least popular pool to onramp with is the SUSHI pool, with only 6 users opting to start using THORChain by depositing SUSHI.
Prizes
Jun 22, 2022 - This dashboard looks at the number of PoolTogether prizes claimed and the USD value of prizes over the past 60 days.
5. Curated vs. Playground vs. Factory
Sep 7, 2021 - This dashboard compares different metrics of the Curated, Playground, and Factory collections of Art Blocks. The first metric is the number of unique tokens in each collection. Factory has by the far the most amount of tokens, with over 10,000 more than Curated. This makes sense as the process for being selected for the Curated collection is much harder and more selective than being selected to make pieces for the Factory collection. The next metric is the total number of transactions in each collection, with Curated having the most at over 1.1 million, and Factory and Playground far behind at about 141,000 and 52,000 each respectively. The final metric looked at in this dashboard is the average sale price of pieces in each collection. Playground has the highest average sale price at $4,396.64, with factory having the lowest at an average of $1,681.04 per piece.
Solend SOL Lending/Borrowing
Feb 17, 2022 - This dashboard looks at Solend USDC lending/borrowing trends in the month January Vs. February, and what factors could be influencing those trends.
Uniswap - 22. Uniswap DEX Dominance
Apr 9, 2022 - This dashboard looks at the dominance of the Uniswap DEX on Ethereum.
RocketPool: User Profile - LIDO vs. RocketPool
Apr 27, 2022 - This dashboard compares activity on Lido and RocketPool and looks at metrics of each user base.
Forefront Participation Incentives
Apr 23, 2022 - This dashboard looks at how contributors to Forefront have been compensated and compares compensation with similar protocols.
113. [Easy] Top 10 Validators - Last 60 Days
Dec 15, 2021 - This dashboard looks at the top 10 Terra validators over the last 60 days. The first visual looks at the amount of LUNA staked to the top 10 validators over the last 60 days. B-Harvest is the only validator that maintaned its position throughout the entire six months, remaining at a respectable third place. The most volatility occurred around the lower ranked of the top 10, with many losing their place to validators on the rise. One such validator was Staked, which went from not making the list to rising to 7th place over the course of a few weeks. Orion.Money and Staking Fund remained neck and neck the entire time, with Staking Fund eventually overtaking Orion.Money. Staking fund currently has the greatest amount of LUNA staked, at about 25 million, only a few hundred thousand more than Orion.Money. The next metric looked at in this dashboard was the proportion of LUNA bonded to the top 10 validators. The amount of LUNA delegated to the top 10 has risen over the last couple months, increasing from about 42% to around 46%. This suggests that smaller validators are having a hard time attracting Terra users over their more well known counterparts.
2. Monthly Swap Volume
Nov 13, 2021 - This dashboard looks at the monthly swap volume in USD over the past year for both the Sushiswap and Uniswap protocols. Over the course of 2021, the monthly swap volume for Sushiswap has gone from a low of 5.86 billion to a high of 29.43 billion. The swap volume trend seems to be increasing after an initial drop in volume from May to June, with each subsequent month from July to October having a higher volume than the last. As for Uniswap, the swap volume also has generally increased over the year, with the first few months having by far the lowest volume. A logarithmic scale had to be used for this graph as the differences in swap volume from month to month were so great. Comparing Uniswap's and Sushiswap's volume is night and day, with the highest volume month for Sushiswap not even reaching the lowest volume month for Uniswap. This may be because Uniswap has been around for longer and is more established than Sushiswap. In addition, Uniswap released Uniswap V3 last year which gives it a leg up over Sushiswap and most likely resulted in more traffic.
Katana Covered Call Vault Popularity
Mar 31, 2022 - This dashboard looks at the popularity of the covered call vaults on Katana.
8. Whale Spotting
Jul 7, 2021 - Here I defined a Whale as having at least $100,000,000 in their account today, 7/7/2021. There were a total of 73 whales that fit this description. I then looked at how many were staking, how many had submitted governance proposals, and how many were voting.
2. Volume of THORChain Bifrost Activity by Asset
Oct 25, 2021 - THORChain users have the option to upgrade non-native RUNE, the governance token of THORChain, to native RUNE. They can do this with either Ethereum or Binance. This dashboard looks at the difference in the amount of Ethereum and Binance RUNE converted to native RUNE. As you can see below, the amount of BNB RUNE converted to native RUNE is far greater than the amount of ETH RUNE converted, with the amount of BNB RUNE converted at a total of almost 940 million USD, while ETH RUNE converted at only about 50 million USD. The graph in this dashboard displays the amount converted from each blockchain over time, in USD and on a logarithmic scale. As you can see, the amount converted varies greatly day by day, with the amount of BNB converted far greater than the amount of ETH. There is a gap from around the end of July 2021 to the middle of October 2021, most likely due to the multiple audits THORChain had undergone.
40. Impermanent Loss Dashboard
Aug 4, 2021 - This dashboard shows the top 8 liquidity providers and both their unrealized and realized impermanent loss, organized by the different liquidity pools they are a part of. The unrealized impermanent loss is far higher on average than the realized impermanent loss.
ETH Staked
Jun 14, 2022 - This dashboard looks at the total amount of ETH that has been staked with Lido and the daily amount of ETH staked with Lido in the past 3 months.
103. [Elite] From Terra, With Love
Dec 1, 2021 - This dashboard looks at different metrics of UST transfers to other blockchains from Terra via Wormhole, after the Columbus-5 update. Wormhole is a bridge that allows for the cross-chain transfer of certain assets, including LUNA and UST from the Terra blockchain. So far, Wormhole allows UST to be sent to the Ethereum, Binance, Solana, and Polygon blockchains. The first metric in this dashboard looks at the total amount of UST being sent out of Terra via Wormhole over time.