mattkstew
Hackathon Results
Mar 22, 2023 - Flow is hosting a hackathon to bolster the development activity on the Flow blockchain. How many new projects have been created so far? Track new contracts on Flow and any user activity on these new projects. How many users have tried a new contract that has been created in the past month? How much volume have these projects generated?
Active Wallet Growth
Jan 28, 2022 - What is the number of unique active wallets (signers) over the past 7 days? Create a visualization showing the number of active wallets per day since the start of 2022. What trends do you see?
Opensea Fees
Aug 24, 2021 - d the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Whale Watching With Deebs
May 30, 2023 - Deebs Defi recently won Flipside's analytics tournament. Find at least 15 Avalanche whales using Deebs Whale Finder tool. Then, analyze the balance sheet of these whales across chains. How much is each wallet worth in total, and what are the proportions of their assets across different Ethereum compatible chains? Which chains have the most assets from these whales? Finally, explore the Defi activity of these whales on Avalanche. Are they lending, borrowing, staking, farming, LP'ing or trading?
Solana Fees
Feb 5, 2022 - One of the main advantages for a user of Solana is the extremely low fees relative to other blockchains. Create a visualization showing transaction fees per day accumulated since the beginning of January. Also create a visualization that shows transaction fees per transaction on each day. Do fees ever seem to spike or is it consistent.
NFT Buying Behavior on Flow
Jun 11, 2022 - Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to on Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains? What do "whales" tend to focus on in Flow? How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? Are wallets more interested in new projects, or already existing projects on Flow?
AAVE and stAAVE movements
Aug 9, 2022 - Create visualizations showing daily AAVE supplied and withdrawn on Aave protocol and daily AAVE staked and unstaked.
Bubblegoose Ballers Mint
Jun 15, 2022 - How many unique wallets minted a Bubblegoose Baller NFT and how many NFTs did these wallets purchase on average? How many NFTs were purchased with ETH using Crossmint? Identify any notable trends in minting activity and secondary market sales in the days following the launch. Which group(s) was most likely to "diamond fin" their NFTs?
USDC Deposits
Jun 21, 2022 - In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Distribution of Swaps in $RUNE and USD Values
Sep 4, 2022 - Show the distribution of swap sizes in both $RUNE and USD, both for all pools as well as broken down by pool.
Active Wallet Addresses
Jun 16, 2022 - . We are interested in knowing how many users are currently in the ecosystem. In this case, how many are holding $RUNE in their wallet or have an open LP position. What is this number currently, and how has it trended over time?
Spill the (USD)T
Jun 4, 2023 - The what: USDT usage on NEAR. “Why” and “how”? That’s what we’d like you to show us. Your mission is to provide a crisp, compelling narrative about USDT usage on NEAR. Define at least three metrics and analyze them over the past 7, 14, and 30 days. Using your analysis, make a case for what may be causing the developments you’ve identified. Additionally, theorize how market conditions or external research may be impacting USDT adoption, usage, and exchange in the NEAR ecosystem. Provide up to 15 effective, high-impact visualizations to support your case. Link your methodology and any external research in a separate tab on your dashboard.
Solana Health in Bear Market
May 27, 2022 - Create a dashboard with at least 5 different metrics of your choosing showing Solana's health and adoption as a blockchain as market conditions have soured.
Stable Coins Lent on Kashi
Jun 14, 2022 - Draw a chart showing the TVL of Stable coins on kashi pairs across all markets.
Celsius Swaps
Jun 17, 2022 - Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps?
Stablecoin Dominance
Jun 24, 2022 - Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer?
ETH Deposited or Withdrawn
Jun 27, 2022 - StarkNet is a layer 2 chain, that ensures interoperability with the Ethereum mainnet. People are using it to move real ETH to StarkNet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?
Sushi on Polygon
Mar 23, 2022 - Q57. What are the 10 largest sushi liquidity pools on Polygon? What is their volume and TVL?
Genopets Staking
Jun 1, 2022 - Create a visualization showing the amount of staked GENE over time. How many unique wallets have staked $GENE since its inception on May 18th? What percentage of those stakers have previously purchased a Genopets NFT? What trends are you seeing with the Genopets NFT collection?
Are NFT Creators Minting Money?
Jun 19, 2022 - What is the average and median return on investment for candy machine NFT creators? As in how much revenue are NFT creators making off mint and then off royalties? How has that trended over time and how do you see this shaping the NFT landscape on Solana?
Flow vs Other L1s
Jun 16, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum
DimensionX NFT Traders and Strategies
May 25, 2023 - In this dashboard we are going to be looking at DimensionX NFT Traders. We are going to start by looking at general trading metrics across all traders. Next we are going to focus on the top 10 traders and their trading activity. Finally we are going to look at the trading strategies of the top 100 traders in order to see what the optimal timing and assets to trade are.
The Solana Smart Money
Jan 31, 2023 - Create a dashboard that tracks the most profitable traders on Solana (both in terms of token swaps and with NFTs). Use parameters to help define who falls under the category of most profitable and over what timeframe.
Net Bonding Flow
May 6, 2022 - Show the net bonding amount over time. You can show a line chart with the cumulative amount bonded over time or a chart showing weekly or monthly net changes (or a visualization of your choice!)
Gas Efficiency
Jun 9, 2022 - Which one of the sushi services consumes the most gas per transaction? The services to include in your comparison are : -Adding liquidity -Removing liquidity -Adding an asset for lending -Borrowing -Removing an asset from lending -Repaying a loan -Swapping
The Whales of NEAR
Feb 12, 2023 - Where in the ocean of NEAR do the whales hang out? Examine the top 20 addresses by amount of NEAR held - excluding any custodial or exchange addresses that you can. Can you identify any “power players” or wallets of interest? What behaviors do these whales exhibit?
Decentralization Progress
Apr 17, 2023 - The path for Flow has always been progressive decentralization over time. In the last year, various upgrades have enabled network participants to stake Flow, run nodes & validators, and more to drive the chain toward decentralization. Visualize that progress; how many nodes or validators are run on the network, & how does that compare with other chains? How much FLOW is staked, and by how many users? What else can you add to visualize the progress?
Ecosystem or Project Analysis
Feb 11, 2023 - Pick your favorite ecosystem or project and tell us why it’s your favorite using data! Compare or analyze any standard metrics, like activity (developers, users, trading etc), volumes (TVL, trading, mint, etc), active users, projects and more. Demonstrate the value of your choice by sharing any standard metrics you find interesting.
My Next Purchase
Jul 28, 2022 - What is the most common transaction (any transaction) users make after minting frETH?
A Surge of Optimism
Dec 20, 2022 - Analyze the network and diagnose some of the possible reasons for the sudden drop, and slow climb, of OP price in recent weeks. Are there any notable trends in users, transactions, or any other metrics that could explain these events? Note any patterns or outliers you see.
Metrics on True Freeze
Jul 28, 2022 - Produce a dashboard showing metrics on True Freeze. At a minimum, visualize: the daily volume of ETH frozen, the daily number of transactions to freeze ETH, and daily early redemptions.
Ethereum NFT Traders and Strategies
Apr 4, 2023 - In this dashboard I am going to be looking at NFT traders on Ethereum over the last 90 days. I will start by looking at all NFT traders on the platform across a handful of different metrics and then focus my outlook to the top 10 NFT traders on Ethereum to see how they differ from the rest of the traders. Finally I will look at the top 500 traders and focus on what projects they are trading and at what times they tend to trade in order to get insights into potential trading strategies of these users.
Back to Basics I: Deposits and Borrows
Jan 14, 2022 - Select a time period (minimum 1 month). Using visuals, compare borrow volume and deposit volume over that time period.
Bridge Users (Hop Protocol)
Jun 17, 2022 - How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
Euro Stablecoin on Avalanche
May 26, 2023 - We are seeking talented data analysts to provide insights and metrics regarding the newly launched Euro stablecoin on the Avalanche blockchain. The stablecoin, developed by Circle, aims to provide a reliable and secure digital representation of the Euro. Determine the total supply of the Euro stablecoin on the Avalanche blockchain, analyze adoption metrics such as the number of transactions conducted with the stablecoin on Avalanche, and evaluate the number of unique holders of the Euro stablecoin on Avalanche. Add any other topic you think may be useful/relevant
NFL AllDay NFT Traders
May 14, 2023 - In this dashboard we are going to be looking at NFL AllDay NFT Traders. We are going to start by looking at general trading metrics across all traders. Next we are going to focus on the top 10 traders and their trading activity. Finally we are going to look at the trading strategies of the top 100 traders in order to see what the optimal timing and assets to trade are.
Aurora Contract Users
Apr 24, 2023 - Let's dig into users that have interacted with the Aurora contract on NEAR. Let's look at how many distinct users have interacted with the contract. Additionally, break out contract interactions, user interactions, and unique user interactions by day. Include any additional insights about the usage of the Aurora contract on NEAR.