Owentell
Base Testnet Analytics
Mar 24, 2023 - This dashboard will look at an overview of general metrics on the newly released Base testnet and then do a deeper look into users and contracts on the platform.
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
11. To Farm or Not to Farm?
Dec 16, 2021 - This dashboard looks at multiple metrics of farming on the SushiSwap platform.
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.
Tracking top Solana NFT Collections
Apr 28, 2022 - This dashboard tracks sales volume and average sales price across marketplaces for various Solana NFT collections.
96. [Galactic Punks] Where My Punks At?
Oct 20, 2021 - This dashboard looks at metrics of the Galactic Punks NFT holders on the Terra blockchain. 10,921 of these randomly generated NFT's were released on October 2nd of 2021 and sold out in only 8 minutes. The first metric of this dashboard looks at the projects Galactic Punks holders are involved in within the Terra ecosystem. I fist checked if they interacted with the Anchor protocol, which is a complex savings and borrowing platform with a stable savings APR of around 20%. I then checked if they staked LUNA, the governance token of Terra. I finally checked if they staked on Pylon, a protocol allowing users a different way to pay for subscription based services. I found that the highest number of GP holders staked LUNA, with 2,801 of them currently staking or having staked in the past. The next highest was depositing in Anchor, not far behind LUNA staking, with 2,339 of GP holders interacting with the protocol. I next looked at the average balance of GP holders, which was about $33,000 USD. Finally, I looked at the balance of GP holders with the highest balances. It looks like many whales are currently holding Galactic Punks, as 9 out of the 10 highest balances were over 10 million USD.
12. [Easy] Guzzling Gas
Dec 21, 2021 - This dashboard looks at different metrics of users withdrawing liquidity from SushiSwap liquidity pools. SushiSwap is a hard fork of Uniswap, and is a decentralized exchange on the Ethereum network. The first metric looks at the daily gas fees paid by users withdrawing liquidity. The amount of fees has varied widely over time, and recently peaked on November 10th, 2021, where about $46,000 of fees were paid. Interestingly, the days where a higher amount of fees were paid do not usually coincide with a higher number of withdrawals, suggesting that large LP removals with high gas costs are the cause of most spikes in fees paid. The next metric looked at is the daily number of LP withdrawals. Besides a massive spike in the middle of September 2020, the number of removals has remained largely stable, at around 200 to 400 daily. This is a good sign for SushiSwap, as it means there have not been recent events that have cause liquidity providers to lose confidence in the protocol and remove LP en masse. This was not the case in September of 2020, when users made over 2000 withdrawals on a single day. This was due to a rug pull by SushiSwap's anonymous founder, Chef Nomi, causing users to panic. He later returned the money and continues to work with SushiSwap to this day. The last metric looked at in this dashboard is the daily average gas price versus the daily number of withdrawals. In general, it seems that gas price spikes cause a decrease in the number of LP withdrawals.
116. [Hard] NFTerra, Part 2
Dec 16, 2021 - This dashboard looks at metrics of NFTs on the Terra ecosystem. NFT's have currently experiecned a rapid growth in popularity on Terra, with an explosion in the number of new tokens. The first gamified NFT for Terra was recently released under the name of Derby Stars Horse. The new project allows users to purchase virtual horses that they can pit against others in an online game.
DRiP Collection Analysis
Sep 1, 2023 - DRiP is an innovative platform that democratizes access to the world of Non-Fungible Tokens (NFTs) by offering them for free, directly from creators to fans. Serving a dual purpose, DRiP acts as an introductory gateway for those new to the crypto and NFT landscape, while simultaneously providing creators an avenue to engage with and give back to their community.
Flow vs Other L1s
Jun 22, 2022 - This dashboard looks at user retention on the Flow blockchain versus other L1s.
Swap Sizes
Feb 8, 2022 - This dashboard looks at the swap size over time in the top 10 largest liquidity pools on Sushiswap by value locked. The top 10 currently are the BIT-WETH, TOKE-WETH, DAI-WETH, ILV-WETH, OHM-LUSD, WETH-ALCX, OHM-DAI, USDC-WETH, WBTC-WETH, and OHM-WETH pools.
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.
Active Wallet Addresses
Jun 22, 2022 - This dashboard examines how many users are currently in the THORChain ecosystem.
Whale Swaps
May 5, 2022 - This dashboard looks at metrics analyzing large swaps on the Sushiswap DEX.
When Do Transactions Fail?
Jan 19, 2022 - This dashboard looks at transaction volume on the Solana blockchain and the rate of failure of transactions during December 2021.
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
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.
The Road So Far, Mvmt. I: Validators
Mar 17, 2022 - This dashboard recaps what we have learned thus far about Terra's validator network through past Flipside Crypto bounty submissions.
Do Whales Have Diamond Hands?
Jun 22, 2022 - This dashboard looks at how the swap activity of Osmosis whales differs from everyday users.
Optimism Bridge Comparison
Mar 28, 2023 - This dashboard will analyze compare/contrast the Across and Synapse bridges on Optimism.
95. [Galactic Punks] Traders & Collectors
Oct 27, 2021 - This dashboard looks at multiple metrics of the new Galactic Punks NFT's and their owners. Galactic Punks are a series of space themed NFT's on the Terra Blockchain. In fact, they are the first collection of NFT's to be minted on Terra. The collection has a total of 10,921 randomly generated NFT's. They were released on October 2nd 2021 and sold out in only 8 minutes. As of 10/29/21 there are 4,926 distinct owners of the Galactic Punk collection, meaning each person has an average of about 2 of the NFT's. The next metric looked at was the number of NFT's owned by the addresses with the most NFT's. The address currently holding the most has a whopping 141 of them, more than 10% of the entire collection. The next highest has 100 of the NFTs, and then it begins to drop sharply from there, with the third highest holding 47 of them. The final metric I looked at was who the highest frequency traders of Galactic Punks are. To calculate this, I first found the count of the number of transfers of the NFT's they have completed so far, and then added to that count the number of times they ordered Galactic Punks from RandomEarth, a NFT marketplace on Terra. The address with the highest number of transactions had 720, and the second highest had 496. Unsurprisingly, many of the addresses with the highest number of NFT's were also on the list of addresses with the highest number of transactions. Interestingly enough, the address currently holding 141 NFT's was not on the list of those with the highest transactions, suggesting they have not sold many if at all of them and seem to solely be adding to their collection. Credit: Some of the code for finding the addresses currently holding GP NFT's was sourced from brian_#3619 on Discord
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.
Sablier Top 10 Users
Apr 23, 2022 - This dashboard looks at the top 10 Sablier users who sent the most funds and the top 10 who received the most funds.
Average Price Shift for Synth Holders
Apr 14, 2022 - This dashboard looks at the average price shift for holders of THORChain's synthetic assets.
Terra Seigniorage
May 6, 2022 - This dashboard analyzes multiple metrics of seigniorage on Terra and its relation to the Anchor Yield Reserve.
New Contract Usage on NEAR
Mar 23, 2023 - This dashboard examines which new contracts that were introduced at the end of 2022 and in 2023 are gaining the most users and expanding the NEAR ecosystem. We will first look at an overview of new contracts created since November of 2022 and then take a deep dive into the metrics of three of those contracts.
Voting Activity
Jun 21, 2022 - This dashboard will examine the voting activity of Lil Nouns NFT holders.
$THOR Staking Reward + APY
May 25, 2022 - This dashboard looks at the daily / weekly staking rewards and the daily / weekly APR for $THOR stakers.
Solana Flash Bounty: Saga
Jun 23, 2022 - This dashboard looks at metrics involving pre-orders of the Solana Saga phone.
Flow During Market Downturn
Jun 29, 2022 - This dashboard looks at different metrics on Flow during the recent market turbulence in May of 2022.
An Odyessy of Congestion
Jun 30, 2022 - This dashboard looks at network congestion on Arbitrum in relation to the recent Odyssey marketing event.
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.