janan
Hop Bridge Volume
Apr 23, 2022 - Q11. How many Matic tokens were bridged in 2022 per day from ethereum to layer2 using Hop?
Quixotic NFT Dashboard
Aug 3, 2022 - Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism!
Catalina Whale Mixers
May 17, 2022 - Q73. Catalina Whales are a popular NFT collection on Solana with an experienced team from the entertainment industry. Chart their sales history and unique holder trends over time. The project has a tier system of holders (5 whales gets you tier 2 status and 10 whales gets you tier 3 status), has this noticeably influenced wallet activity? The project recently announced that you had to own a whale before 5/11 at noon EST in order to qualify for the whitelist of an extremely hyped mint Bubblegoose Ballers along with other benefits. How has that influenced sales activity and holder activity over the past few weeks?"
Monthly Swap Volume
Dec 4, 2021 - Show the total monthly swap volume of Orbs over the past year. How has the swap volume changed over time? Which DEX’s is most of the swap volume coming from?
Solana NFT Purchasing Behavior
Apr 27, 2022 - Show the distribution of all Solana NFT sales on Solana. What percentage of all sales have been above 1 SOL? Above 10 sol? How many unique wallets have made a NFT purchase that was above 10 SOL? Above 100 SOL? Do you think that there is a limit to how high a floor for a NFT collection on Solana can reach compared to on Ethereum?
Algorand Foundation New CEO Staci Warden
Mar 9, 2022 - Question 31: Algorand Foundation appointed a new CEO Staci Warden on February 10th 2022. How did this impact the Algorand ecosystem? The week following announcement did we see an increase of ALGOs being moved from CEXs(centralized exchanges) to wallets? Or did we see an increase of ALGOs being moved from wallets back to CEXs?
Thorchain Wealth Distribution
Nov 6, 2021 - What is the distribution of wealth within the THORChain ecosystem? Show a histogram of the breakdown Hint: use transfers
1. Liquidity Pool Popularity
Feb 2, 2022 - What are the most popular Gamma liquidity pools by number of wallets and also by TVL? Which pool has seen the most growth this week? Provide a visualization to display these metrics.
LP Participation
Dec 11, 2021 - How many RUNE addresses are currently providing liquidity in 1 pool? 2 pools? 3+ pools? Hint Use thorchain.liquidity_actions
Let it Burn
Apr 27, 2022 - Find the week that the most volume of Luna burning happened. What caused this event? Show some effects of this burning had on Terra ecosystem by your opinion.
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 visualization of your choice!)
Tracer Voters
Mar 2, 2022 - Tracer Q2: How many people (addresses) have voting rights in tracer? How much of that has been deposited in major decentralized exchanges(DEX)? what is the breakdown per DEX
New DEX Users
Mar 31, 2022 - Let's use the algorand.swap table to look at users who are using the new DEXes(Decentralized Exchange): PactFi, AlgoFi, WagmiSwap and whether or not they previously used the Tinyman exchange? What percent of wallets for each of the new DEXes(swap_programs:PactFi, AlgoFi, Wagmiswap) had previously used Tinyman to perform a swap?
Sablier Top 10 Users
Apr 23, 2022 - Q10. List 10 users who received the most funds and 10 users who sent the most funds through cash streams.
Net THOR Staked
May 20, 2022 - Q91. Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards. Show the net amount of $THOR staked over time.You will need to calculate the net amount staked + unstaked to get the net amount.
52 Pickup
Feb 28, 2022 - Terra Q153: Recently, a deal was announced wherein LUNA was sold for BTC at a price of about $52/LUNA. Some commentators on crypto-Twitter are contending that this represents the new floor price for LUNA. Over a time period of your choosing, how many days has LUNA closed above this price? How many days has it closed below this price?
ForeFront Curators
Apr 16, 2022 - Forefront has token-permissioned governance and curation channels that require holders owning at least 1000 FF tokens. Create a visualization of the number of curator roles in Forefront over time. Are more curators being added over time? In your own words, how could Forefront incentivize growth in curator roles?
Popular Contracts on Flow
May 31, 2022 - Q1. What are the 10 most popular contracts that have been used on Flow since May 9th? What do each of those contracts do and why do you think they are so popular? Are there any contracts that seem to be trending and growing in popularity?
Biggest Liquidations
Oct 30, 2021 - What are the top 10 liquidation events that have occurred in the past year?
Distinct Wallets (zkSync)
Jun 15, 2022 - How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
Stablecoin Popularity for Swaps
Apr 4, 2022 - Which stablecoin is more popular for a wallet to use in swaps(use algorand.swaps table): USDT, USDC, STBL? Compare volumes and number of swaps for each over the month of March 2022.
Monthly Swap Volume
May 12, 2022 - Q2. Show the total monthly swap volume on ParaSwap over the past year. How has the swap volume changed over time? Which DEX’s is most of the swap volume coming from?
On-ramping
Nov 14, 2021 - What is the breakdown of new users on-ramping onto thorchain by chain? Show a breakdown of each wallet’s first thorchain transaction. Which chain are they coming from? Are they swapping for RUNE or for an asset on another chain? Hint: use swaps + transfers
Fuse Pool DAI Allocation
Mar 24, 2022 - How are the tokens in the DAI Vault being allocated into the various Fuse Pools?
Whale Activity
Nov 7, 2021 - Among the wallets that own 10k+ RUNE, which pools are they currently LP-ing to? Hint: use transfers and liquidity_actions
Distinct Wallets (Optimism Bridge)
Jun 15, 2022 - How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
How Many Times Hop Bridge Used
Apr 23, 2022 - Q12. How many times was the hop protocol used in 2022 in order to bridge funds to layer2?
Active Weekly Users
Dec 4, 2021 - Show the number of unique users (wallets) per week that transacted with Orbs over the past year.
DAI Volume
May 16, 2022 - Q1. How does the daily volume of DAI transactions compare to other stablecoins? What is DAI most used for?
IL Insurance
Apr 11, 2022 - Q54. What % of users that are removing liquidity are receiving IL insurance? Hint: use thorchain.liquidity_actions
Song That Own Itself(STOI) Airdrop #3
Apr 4, 2022 - Q44. Let's look at how many wallets have claimed the STOI Song #3 “Million Scars” Airdrop. How many users have claimed the airdrop? Chart the STOI Song #3 airdrop token distribution by day.
Bridge Users (Hop Protocol)
Jun 20, 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.
USDC Deposits
Jun 22, 2022 - In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
2. Algorand Governance
Jan 12, 2022 - What percentage of non-closed wallets have committed to Algorand governance? How many wallets total is this? What percent of wallets committed to period 1? What percent of wallets committed to period 2? What percent of wallets committed to period 1 and period 2?