0xHaM-d
Rolling with Rollbit
Apr 25, 2023 - Welcome to the Rollbit KPI Dashboard - your one-stop-shop for tracking the key performance indicators of this popular degens' hub. Explore the dashboard to gain insights into the number of active wallets interacting with Rollbit, the popularity of leverage trading and sports betting, and the volume of deposits and withdrawals on both Solana and Ethereum. Additionally, you can analyze the usage of on-chain programs by wallets, bot activity, and the purchase of RLB tokens on Solana.
Bridge Transactions (Across)
Jun 20, 2022 - Q1. Analyze bridge transactions via the Across bridge over the last two weeks. What assets are users bridging from Ethereum, and to what chains?
SUSHI Noobs
Jun 19, 2022 - Q93. From which address do users acquire their first $SUSHI token ? is it CEX ? DEX ? Dual LP Staking Rewards ? Airdrop ?
Sei Network Health Check
Aug 31, 2023 - This dashboard was designed to monitor the health of the Sei network, particularly in relation to events surrounding the Token Generation Event (TGE). The analysis of data covers the period from August 15th, the date of the TGE, up to the current date of August 31st.
Single-Sided Liquidity Pools
Jun 19, 2022 - Q2. Across uses single-sided liquidity pools to execute transactions between chains. How are Ethereum mainnet users interacting with these pools? How do these pool rewards compare to other liquidity pools?
Chain Swaps
Apr 26, 2023 - Squid Protocol has seen an increase in user activity since its announcement on February 23rd. Osmosis is the most popular destination chain for transfers, with Polygon being the primary source chain. USDC is the most popular asset transferred through Squid Protocol, and stablecoins make up the majority of transferred volume.
Joepegs, the top Avalanche's NFT Marketplace
Mar 19, 2023 - Use Flipside’s new fact_decoded_event_logs and ez_decoded_event_logs tables and build a dashboard covering either: one of the top 15 Avalanche projects by TVL featured on Defi Llama (https://defillama.com/chain/Avalanche), a bridge into Avalanche, or a popular NFT marketplace. Show the activity and usage of the protocol through the events. Some of the things to consider are the number of unique wallets, asset volumes, swaps, LP actions, or fees. Build a dashboard you think the protocol and the ecosystem would find useful to use and monitor the usage of the protocol.
The Typical Minter
Jun 9, 2022 - Analyze the Ethereum profile of those who minted during the first hour after launch.
Secondary Sales Activity
Jun 18, 2022 - Q2. How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings.
Arbitrum Network Health Check
Mar 30, 2023 - The Arbitrum token is officially in the hands of the broader crypto economy. Over 900M $ARB tokens have been claimed thus far, representing a vast majority of the total airdrop supply. Let's check in how the network is behaving and see what's going on in the Arbitrum economy. What are users doing with $ARB? Selling, bridging, holding? How's bridging activity? Are airdrop claimers bridging out? Are there non-airdrop allocated users entering the ecosystem - if yes, what are they mostly doing? What is the general network activity? Are certain platforms experiencing more or less volume? What is trading activity looking like? Are certain tokens being trading most? Are token prices depressed?
NEAR - 11. Insight of the Week
Feb 4, 2023 - The NEAR Foundation is running an "Insight of the Week" series. Keeping your analysis short and focused on excellent-quality visualization - provide the most fascinating or illuminating fact or insight that you can about the NEAR ecosystem, or any of the projects building on NEAR, over the past 7 to 14 days. When you tweet about the insight, don't just describe it - do your best to explain "why" what you chose is unusual, valuable, or noteworthy. If you're stumped, don't worry - we'll be running this type of bounty again in the future, so feel free to use this as a "test case" to begin thinking creatively and searching out clever insights.
Tensorswap Affected by Tensorian
Aug 27, 2023 - Tensor is the young upstart that has overtaken Magic Eden as the top NFT marketplace on Solana in less than a year. It allows users to buy, sell, and trade NFTs in a permissionless and trustless manner, without the need for intermediaries like centralized exchanges or auction houses. One of the unique features of Tensorswap is its focus on providing rewards to liquidity providers. Users who provide liquidity to the top 100 collections on the marketplace, based on market capitalization, are eligible for rewards through a liquidity mining program. This is similar to the reward mechanics used by other successful NFT marketplaces like Blur on Ethereum.
EVM - 8. Up The Mountain
Feb 17, 2023 - Avalanche has been building up steam as of late — the price of __[AVAX](https://coinmarketcap.com/currencies/avalanche/)__ rose by nearly 100% in the month of January and __[BTC hodlers](https://www.coindesk.com/markets/2023/01/19/bitcoin-bridged-to-avalanche-surpasses-btc-locked-in-lightning-network/)__ have been moving holdings to the Avalanche chain. hat’s been fueling this growth over the past month — and what does the future hold for Avalanche? Will this growth continue into the new year? Or will growth stagnate as 2023 continues to progress? \
Bridge Volume (Hop Protocol)
Jun 21, 2022 - Q2. How much volume has Hop bridged to Polygon, Optimism, and Arbitrum compared to those protocols’ native bridges? What is Hop’s total TVL? Create an analysis on the Hop’s TVL and how it’s changed over a time period of your choosing.
RaceDay NFTs
Feb 25, 2023 - The Addressed issues in this dashboard are include: How does Speedway Motorsports RaceDay NFTs stack up to sports NFT collections in the FLOW ecosystem? What other projects are RaceDay fans buying? The assessed Metrics: Average Sales volume Total Sales Volume Secondary Sales vs. Mint Sales Daily Average Sales Price and 7-day moving average Total Unique Buyers Average Buyers/Day Social Mentions/Shares Cross-Project comparative assessed metrics: Other collections RaceDay fans are buying Purchase frequency, or the distribution of tokens owned per wallet Average Number of NFTs held per wallet Average Purchase Price of NFTs held by RaceDay fans BONUS: Find free redemption buyers to future buyers, i.e., were first time purchasers someone that claimed a free NFT previously, or, was their first experience with RaceDay an actual purchase.
User Behavior
Jun 21, 2022 - Q11. What are users swapping for? What activities are the most common for users on Flow right now? Create a visualization on what’s causing spikes in swapping behavior.
Osmosis - 4. WAVAX Activity
Feb 5, 2023 - Last week, wrapped AVAX (WAVAX) was listed on Osmosis and seeded with liquidity via Pool 899 (OSMO/WAVAX). Analyze WAVAX activity over its first week of trading on Osmosis. How does WAVAX trading on Osmosis compare to native swaps on Avalanche? Hint: leverage Flipside's Avalanche tables to complement your analysis.
Squid Competitive Analysis
Apr 19, 2023 - Key takeaways: 1. Hop Protocol is the most popular in terms of transaction count and active users, followed by Bungee and LiFi. 2. The Ethereum network is the most popular blockchain for all the analyzed platforms in terms of volume and the number of interactions. 3. Bungee has the highest total volume with $2 billion, followed by LiFi with $1.33 billion, and Hop Protocol with $863 million. 4. Squid is a newer platform compared to its competitors and has a long way to go to catch up with the other platforms in terms of user and transaction count. 5. March 2023 was the most volatile month for Squid, with the highest number of users and transactions recorded during that period.
Flash Bounty - 17. Blur Analysis
Feb 22, 2023 - Recently, Blur launched its native ERC-20 governance token, $BLUR, with a maximum supply of three billion. The token's launch has been eagerly anticipated, with airdrops given to platform users who traded NFTs on Ethereum in the months before Blur's launch and users who listed NFTs on Blur. Why was the airdrop so successful? How did it affect the NFT activity? Did the recipients sell the token? Create a dashboard that captures activity across metrics such as: Post-airdrop activity - Are top airdrop receivers dumping or accumulating? Is new capital entering? What volumes of $BLUR were purchased before/after the airdrop? Tokenomics - How concentrated is the current supply of $BLUR? How does activity on Blur compare to other marketplaces before and after the airdrop? What trends can you identify in royalty payments on Blur, as compared to other marketplaces? Did the airdrop seem to affect NFT project floor prices? Did buying/selling increase after the airdrop?