Owentell
Token Reactor Rankings
Jun 22, 2022 - This dashboard looks at the Tokemak token reactors by their TVL and analyzes the pattern of liquidity deposits and withdrawals in the most popular ones.
Active Wallet Addresses
Jun 22, 2022 - This dashboard examined how many users are currently in the THORChain ecosystem.
Market Volatility
May 26, 2022 - This dashboard looks at the volume on DEXs and the most popular assets to buy/sell during the second week of May.
18. [Easy] Wealth distribution
Nov 9, 2021 - This dashboard looks at the wealth distribution among THORChain addresses. THORChain is a protocol that allows for the swapping of assets from different blockchains. The first query in this dashboard looks at the current balance of all THORChain users. The account with the highest balance currently has about $630 million. I then grouped the users into buckets using a logarithmic scale. Due to an issue with adding images to Velocity, the graph created can be viewed through this link, https://imgur.com/a/MJNDOmy. The highest number of users have $0 to $100 in their wallet. After users with $10,000 to $100,000 in their wallet, the number of users starts to steeply drop off. The number of users who have $100,000,000 to $1,000,000,000 is unsurprisingly the fewest out of the balance categories, with only 3 addresses currently holding more than $100,000,000.
Top TOKE Holders
Jun 22, 2022 - This dashboard looks at the top holders of the TOKE token in January 2022, and if they have kept their position to today.
stETH Most Common Pools
Apr 28, 2022 - This dashboard looks at the pools most commonly used to swap in and out of stETH.
Pool Ranks
Apr 14, 2022 - This dashboard looks at the TVL of THORChain's liquidity pools over time, specifically the newly introduced LUNA and UST pools.
2. Visualize governance staking of $MINE over time
Nov 10, 2021 - This dashboard looks at MINE and LUNA staking over time versus the price of LUNA. MINE is the governance token of the Pylon protocol, and can be staked to earn more MINE tokens. Pylon protocol is a platform on the Terra ecosystem which allows users a new way to pay for subscription based services. Rather than pay every month/year, the user deposits an amount up front for a predetermined amount of time, and receives the full value of the funds once the subscription ends. The service provider is paid through the interest those funds accrue over the lock up period. The first graph in this dashboard look at the sum of MINE tokens staked and unstaked daily, versus the price of LUNA. It seems that as the price of LUNA has risen, MINE staking has somewhat increased, although there have been an increased amount of days where large amounts of MINE were unstaked as well. The day with the highest difference in staking, July 25, 2021, had a net amount of 138.5 million staked. The day with the highest net amount of MINE unstaked, September 30, 2021, had about 94 million unstaked. Looking at the LUNA staking versus LUNA price, it seems as though staking and unstaking has decreased as LUNA price has risen, suggesting less interaction with staking over time. When LUNA first released, large amounts of LUNA were staked and unstaked, but over time this difference has lessened.
Prep for Flight
Jan 20, 2022 - This dashboard looks at the length of time it takes for Terra users to utilize the Wormhole after using the Shuttle, and if they continue using the Shuttle after Wormhole.
Stability Fee
Jan 20, 2022 - This dashboard looks at stability fee changes on MakerDAO over the last six months and how these changes impact DAI loans taken out.
Monthly Swap Volume
May 12, 2022 - This dashboard looks at the total monthly swap volume on ParaSwap over the past year, and how the swap volume has changed over time.
Price + Circulating Supply
Jun 6, 2022 - This dashboard looks at the daily circulating supply of the MATIC token versus its price.
18. [Hard] Stalking Whales
Dec 24, 2021 - This dashboard looks at whales on the Sushiswap platform. Whales here are defined as the top 10 current highest liquidity providing users. The largest whale is currently providing over $43 million to Sushiswap pools.
1. Daily Reward Distribution
Oct 25, 2021 - This dashboard shows the daily block rewards per day on the THORCHain network. THORCHain is a revolutionary new protocol which allows for the transfer of assets across different blockchains, through the use of cross-chain liquidity pools. This means one can exchange Bitcoin for Ethereum, without having to use a wrapped version of either token. The number of block rewards daily grew exponentially over the first few months, from May 2021 to June of 2021, and have since leveled off to a relatively consistent daily amount. The gap in the block rewards from the end of July to the beginning of August was due to an audit that was underway, which stopped the production of additional blocks. Looking at the daily bonding vs. liquidity awards, the daily bonding awards tend to be much more stable, with the liquidity awards varying drastically day by day. There was a recent spike in the amount of bonding and liquidity awards since October 20th 2021.
Uniswap - 11. Stablecoin Trends
Mar 26, 2022 - This dashboard looks at stablecoin swap trends on Uniswap over the past six months.
122. [Hard] What Happens to the Loot
Dec 22, 2021 - This dashboard looks at user activity on Anchor Protocol regarding claiming rewards/taking profit. On Anchor, there are two main ways to stake ANC tokens, LP pools and governance. When supplying ANC to LP pools, rewards accrue gradually and can be withdrawn at any time while leaving the supplied liquidity in the pool. As for staking ANC to governance, the rewards can only be withdrawn by removing all of the staked tokens, as rewards are automatically re-invested. I hypothesized that price changes of the ANC or LUNA tokens may cause a shift in users taking profit, so I first created a graph looking at the daily number of LP rewards claims versus the price of ANC and LUNA.
Synth Mints + Burns
Apr 14, 2022 - This dashboard looks at synth mints and burns on THORChain.
2. Aave Liquidity Concentration
Aug 20, 2021 - The top 10 liquidity providers on Aave provided about 83% of the liquidity on the platform.
Uniswap - 23. CEX to DEX and DEX to CEX
Apr 9, 2022 - This dashboard looks at UNI volume sent to centralized exchanges and sent out of centralized exchanges.
Hackathon Results
Mar 25, 2023 - This dashboard looks at new contract metrics over the past month and if those contracts were due to the Flow Hackathon.
Apollo Sunchaser Hunt
Oct 13, 2021 - Here is my transaction on the Terra blockchain for depositing UST into the Apollo MINE-UST vault. I connected my Terra wallet to the Apollo web app and then deposited my existing UST.
1. Art Blocks Overview
Sep 1, 2021 - This dashboard looks at multiple metrics of the Art Blocks NFT project. The first is the average sale price since December of 2020, which is $4,103.52. The second was the total number of Art Blocks tokens in circulation, which is 103,509. The last metric looked at was the number of Art Blocks sales per day since December of 2020. The amount of sales has gone up substantially since the middle of June 2021 and saw two extreme spikes on July 30th and August 1st.
Bot Swappers
Apr 28, 2022 - This dashboard looks at bots on the Terra ecosystem and how their behavior differs from average swappers. We will also look at what percentage of swaps were executed by bots in the past 30 days and what pools and what pairs were most popular among bot swappers in the past 30 days.
BONKz Sales Metrics
Jan 13, 2023 - This dashboard looks at metrics of the most popular(greatest number of sales) Solana NFT collections in their first 24 hours after mint.
Solana Fees
Feb 10, 2022 - This dashboard looks at the fees paid on Solana over the month of January and the average transaction fee per day.
Liquidity and Volume
Jan 20, 2022 - This dashboard looks at the volume of swaps and liquidity actions on Sushiswap over the past month, and what pools have contributed most to these statistics.
Metamask vs. Other Platforms
Jun 24, 2022 - This dashboard looks at swapping metrics on Metamask versus competing platforms.
74. [Easy] Airdrop Price Impact
Oct 5, 2021 - Mirror Protocol is a DeFi platform on the Terra network which allows users to trade synthetic versions of real world stocks, which are pegged to the stocks actual price. Mirror Protocol's token, MIR, is airdropped to LUNA stakers. This dashboard looks at the impact of MIR airdrops on its token price. To determine the effect of airdrops on the price, I first looked at MIR's token price over the last nine months, by week. I then looked at the number of MIR airdrops claimed weekly over the last nine months, and the total amount of tokens claimed weekly over the past nine months. The amount of airdrops claimed appears to have a negative correlation with the price of MIR, as the amount of airdrops has increased significantly since February 2021, while the price of MIR has dropped from a high of around $10 in May to about $3 currently. The amount of MIR tokens claimed does not seem to have a significant effect on the price of MIR. Credit: Part of the code for the MIR airdrop data was sourced from brian_#3619's '55. [Hard] Terra-UNI Airdrop Recipients' submission
THORChain and $vTHOR Overlap
May 25, 2022 - This dashboard looks at the percent of $THOR staking wallets that are also are currently LP-ing on THORChain.
Anchor Emissions (Hard Mode)
Feb 24, 2022 - This dashboard looks at the number of users selling Anchor emissions and what volume of Anchor emissions are being sold.
MonkeDAO Whale Voters
Apr 14, 2022 - This dashboard looks at the amount of MonkeDAO voters that are whales.
Uniswap V3 vs SushiSwap
Feb 3, 2022 - This dashboard looks at different metrics comparing and finding correlations between activity on Uniswap versus Sushiswap.