Ali3N
Impact of "Base" Announcement & The Activity of "Meet Base" NFT on Optimism
Mar 4, 2023 - What Has Happened on Optimism During The Announcement of Coinbase's "Base" Launch on Optimism?
Near's Burrow Protocol
Feb 23, 2024 - an in-depth analysis of Burrow protocol activity within the NEAR chain.
FLOW User Retention vs Other Chains
Dec 16, 2022 - How sticky are the users on Flow? Create a detailed analysis comparing user retention on Flow vs. other L1 chains like Ethereum and Solana. How often do users who make a transaction come back and make another transaction one month later? How do monthly active users compare between chains? Bonus: add a section of your analysis comparing retention specifically with regard to NFT purchases. How often do users who purchase an NFT come back and make another purchase one month later?
Swap Fees (Osmosis Bounty)
Jun 24, 2022 - Q21. Do fees on Osmosis differ when users swap to or from different tokens? On average, which tokens have the highest and lowest swap fees on Osmosis?
True Freeze - 4. My Next Purchase
Jul 27, 2022 - What is the most common transaction (any transaction) users make after minting frETH?
Opensea Fees (Polygon Bounty)
Jul 28, 2022 - Q6. Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Aave User Dashboard
Aug 8, 2022 - Create a dashboard that allows a viewer to input a user address and explore their borrowing and lending activity. Include metrics like total origination, loan revenue, outstanding debt, etc.
Tornado Cash Addresses
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online. (Hint: we also have them in our crosschain address labels table as well). Using those addresses: Which of the Tornado Cash addresses received the most # of transactions in the last month, quarter, year Which addresses received the most transaction volume (worth) in the last month, quarter, year Over all the addresses, group the transactions into buckets by value. How many tx in the 0.01-0.1 ETH range went to Tornado? How many in the 0.1-1ETH range? How many in the 1-10ETH range? How many in the 10-100 ETH range? How many above 100 ETH? (split further if better)
Tracking Realms DAOs
Aug 15, 2022 - Q104. We now have Solana Realms governace data! Their team would love to be able to see a list of DAOs / multisigs built on SPL Governance, and understand their: - Number of Members (assuming unique voters is what he means here) - Total Votes - Number of Proposals - Date of Last Proposal - Date of Creation Track these metrics and any other metrics that you find interesting for the following DAOs: -Mango -Grape -Psy Finance -Solend -MonkeDAO -Metaplex -Jet -Serum -The Imperium of Rain -Synthetify
Algorand Competitive advantages Algorand NFTs Atomic Transfer Sales
Jun 13, 2022 - Q104. On Algorand there is a functionality called the atomic swap(or atomic transfer) which allows you to safely sell an asset to a buyer without the need of a marketplace. One place to perform this is https://www.randswap.com/. Using https://www.asalytic.app/ and https://www.nftexplorer.app/stats as references let's look at atomic transfer volumes for NFTs in 2022. Show the number of NFT atomic transfers and the ALGO volume for these sales by day in 2022. Further breakdown these atomic transfer sales into ARC3 and ARC69 sales. What were the top ten most expensive atomic transfer sales in 2022? What wallets are participating most in atomic transfer sales-both buying and selling? Tips: User NFTexplorer and asalytics stats as a ALGO volume guide for atomic transfer sales NFT Atomic Transfer Example: https://algoexplorer.io/tx/group/GnJpbxk49DN5FOvmR6tzq9WZ7hTaXMP17ryPmHKKsQk%3D https://www.nftexplorer.app/stats https://www.asalytic.app/ All NFTs have a supply of 1 and 0 decimal places For NFTs configured to the arc69 stanard, look at asset_configuration transactions such as 6Z5R47GSIMQC4JDCTRAPLPC5BTNCC5K5DJ2QKSACW4KV5RZFZDQQ and decode the note using
Flow Hackathon Results
Mar 19, 2023 - An overview of created projects within Flow chain on the occasion of Flow Hackathon
Aave - 10. Aave Transaction Explorer
Aug 9, 2022 - Create a transaction explorer similar to Etherscan but for Aave.
Daily Active Flow Users
Apr 13, 2023 - A dashboard to track how the Flow blockchain's daily, monthly, and all-time active users have evolved over time.
axlUSDC: Soon to be forgotten?
Nov 1, 2022 - Recently, Circle announced the implementation of an IBC-native USDC, inserting itself into an ecosystem where axlUSDC currently dominates. Let's look at how pervasive axlUSDC is within IBC. Track Satellite bridge activity strictly related to axlUSDC transfer. Which app-chains have the most/least flows of axlUSDC? Looking at Osmosis specifically, analyze how dominant axlUSDC has become compared to both ATOM and other USDC assets in trading and pools. Hint: You will need to analyze both Axelar tables and Osmosis tables for the second half of this question.
Hadeswap Wash Trading
Oct 20, 2022 - A new sector of NFT marketplaces have begun to gain popularity on Solana, the NFT AMM. One of the most notable NFT AMMs on Solana so far is Hadeswap. It's clear that this new type of marketplace is gaining popularity in the ecosystem. But how much of it is real trading and how much is 'wash trading' to drive up volume numbers? Note there are no fees in the marketplace so it can be easy to swap back and forth. Create a definition for 'wash trading 'and use that to track sales activity on Hadeswap with our newly curated models in the NFT sales table. How much of the volume seems "legit"? Are there certain accounts that seem to be creating the majority of the volume? What collections have had the most activity on Hadeswap, and how much of that was from 'wash trading'? Now that Magic Eden has moved to 0% royalties, compare Hadeswap 'wash trading' to wash trading on Magic Eden. Does an AMM create more wash trading?
Who's Got The Flow?
Nov 25, 2022 - Who is holding the most FLOW? Build a list of rankings to help us find the address with the most FLOW tokens. Identify any trends or outliers you see in this collection of whales. Bonus points if you can identify the wallet holders.
Average Optimism Portfolio
Oct 9, 2022 - What does the average Optimism user's portfolio look like and how has that changed over time? What % of a user's activity (in OP terms) is staked, unstaked, in liquidity pools/farms, in NFTs? How has this trend changed over time?
USDC Activity on Optimism During Binance Conversation Announcement and Circle Announcement
Oct 1, 2022 - Analyse the USDC activity on Optimism network during 2 weeks prior to the Binance Conversation Announcenemnt about delisting this token from its platform and converting it to BUSD and also during Circle announcement to launch USDC natively on Optimism.
Merry $BONK-ing Christmas
Jan 4, 2023 - It's still Christmas for Solana's dog coin $BONK — people all over crypto twitter are giving away billions of $BONK tokens, and its price has risen over 40% in the last day (NFA). Bring the world up to speed on Bonk Inu, with all of our favorite metrics.
Aave Delegates' Gas Usage
Mar 17, 2023 - An analysis of gas used by delegates voting in AAVE protocol during the past 90 and 180 days.
NFT crosschain showdown: y00ts vs Art Gobblers
Nov 23, 2022 - Two freshly launched NFT projects are going viral: the Art Globbers (on Ethereum) and yOOts (on Solana). Create a dashboard that compares the two projects.
SNX, UNI & MKR Borrowing Activity on Aave v2
Mar 8, 2023 - an in-depth analysis of borrowing activity on SNX, UNI, and MKR pools in the AAVE protocol (version 2).
Magic Baby Monsters !
Nov 5, 2022 - Deep analysis of Magic Baby Monsters in honor of its recent partnership with Quix NFT marketplace on Optimism.
Historical APY Search Tool
Aug 8, 2022 - Create a tool that shows historical APY earned/paid on loans over a user-specified date range.
Osmosis Validators' Comparison Tool
Jan 13, 2024 - A comprehensive tool empowering you to compare the voting activity of multiple Osmosis validators within the governance framework of this dynamic blockchain.
Stablecoin Dominance (Osmosis Bounty)
Jun 24, 2022 - Q20. Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer? Extra credit: Is stablecoin dominance the same on Osmosis as it is on Sushiswap and Thorchain? Why might this be or not be the case?
The Eclipse Score (Terra)
Feb 5, 2023 - Invent an easy-to use "Eclipse Score", based on at least 3 metrics, to rank validators who are not effectively representing their delegators via voting. (For example: if you participate in only 5% of votes but are in the top 5% of validators by LUNA delegated, you should have a terrible Eclipse Score!) Provide a table and at least 1 visual that displays validators according to your Eclipse Score, e.g. a bubble chart with LUNA Delegated vs. Votes Attended. Additionally, analyze the top 5 best and top 5 worst validators according to your Eclipse score.
Avalanche vs. Blast: A Comparative Analysis
May 3, 2024 - Compare Avalanche vs. Blast blockchain activity in any timeframe.
Osmosis Prop #466
Mar 22, 2023 - Osmosis Prop #466 was the first ever expedited vote on Osmosis. An expedited governance proposal must exceed 66.6% quorum within the first 24 hours of the voting period in order to succeed.
Sorare Compete With Collectibles
Nov 21, 2022 - Sorare is a digital, playables and collectibles platform where users can compete across futbol, NBA, and MLB in a fantasy sport setting. Build a dashboard that covers the Sorare project: Statistics on Sorare NFTs being sold on Opensea such as buyers, volume, number of NFTs etc Transfers and mints over time Statistics on contract events such as players and clubs added Provide additional insight into the players and clubs added in from the event inputs
Tensor NFT Marketplace on Solana
Aug 28, 2023 - Explore the Tensorswap NFT Analytics Dashboard—a data-driven journey into the world of Solana's second-largest NFT marketplace. Uncover trading insights, user behavior shifts, and the impact of key announcements shaping Tensorswap's dynamic evolution.
Ethereum Name Services (ENS) Retrospective in 2022
Jan 8, 2023 - An Overview of ENS in The Year 2022 and its Comparison vs Other Years.
Aave - 3. AAVE positions in Euro stablecoins around July 13th.
Jul 27, 2022 - On July 13th, for the first time in 20 years the Euro reached 1:1 parity with the U.S. Dollar. Show daily or hourly positions (supply and borrow) of Euro stablecoins on AAVE before and after July 13th.
Staking goBTC and goETH for Rewards
May 18, 2022 - Hello and Welcome! AlgoMint launch rewards programs with multiple protocols throughout the Algorand ecosystem so we want to understand where is the best place to stake goBTC and goETH to earn rewards? Let’s look at where other wallets are staking their goETH and goBTC to get an understanding where we should stake ours. Look at items such as mint and burn actions over time as well as the amount of goBTC and goETH being staked over time to help us determine where the most popular place to stake your goETH and goBTC. Additionally, are there any places not listed that you can stake your goETH and goBTC for rewards and are users staking them there?
The Law Offices of NEAR
Jul 30, 2022 - Q7. Provide your best assessment of the number of contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms). Visualize how the number of contracts has changed over a time period of your choosing. How many of those addresses are smart contracts?
Opti Azuki Club NFT Collection
Oct 29, 2022 - One of the most trending NFT collections on Optimism during recent days is Opti Azuki Club. This collection is currently among the most hyped NFT collections on both Opensea and Quixotic marketplaces. Make a deep analysis of this collection and note any interesting trends or notes.
Avalanche Gas Fees
Mar 6, 2024 - A dynamic dashboard to analyze gas usage on the Avalanche network, breakdown by contracts and dApps.
Axelar Bridge
Nov 22, 2022 - let's take that a step further and plot out user types and their behavior leveraging Axelar's bridge. How often are people using Satellite - one-time transfers into IBC or more consistent/steady streams? Does this vary based on wallet size? Does this vary based on the ecosystem they are bridging from/to?