CryptoIcicle
Solana - 4. The Solana Smart Money
Feb 4, 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. What has "smart money" been doing on Solana over the past month? Over the past week? Are they active traders or do they hold positions for days at a time? What projects have yielded the most profit for Solana traders? Are there any indicators of what their next trades or strategy will be? How does your dashboard compare to Hellomoon's smart money inflows and outflows?
Near-10.NEAR Distribution
Sep 8, 2022 - -- Q10.Calculate the distribution of $NEAR holdings by address. -- In terms of charts, feel free to create a histogram or whichever visual you think works best!
Rari-2.Fuse Pool USDC Allocation
Mar 19, 2022 - -- Q1. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
Terra - 11. Back to Basics: Account Activity
Jan 29, 2023 - The question of “active wallets” faces every ecosystem. Let’s investigate this question for Terra — and go beyond the “one transaction in 30 days” approach! Define what an active, high quality user looks like and how it can be measured. Assess how many active users exist on Terra, according to your definition. Additionally, provide a few brief, specific ideas to attract additional users, as well as an assessment of what it would cost to implement these ideas. What is the acquisition cost for a high-value user, according to your recommendations?
Liquid Staking ETH Platforms Analysis
Sep 1, 2022 - -- Consider all possible liquid staking ETH platforms. Then, find out the following: -- How much ETH was staked over time? -- How many unique depositors are there? -- How likely are depositors to use multiple platforms vs using a single platform? -- Are depositors Dollar cost averaging their ETH into the platforms? -- What is the avg/median/max/min/distribution of ETH deposits? -- Compare all the metrics above between the various ETH staking methods/platforms
Solend TVL Tracking
Aug 25, 2022 - On August 17th, Solend announced their permissionless pools, where anyone can now create a pool. https://twitter.com/solendprotocol/status/1560003756736925696 How has this influenced user behavior on Solend so far compared to prior user activity? How many users have used a permissionless pool? What is the % of TVL contributed from isolated and permissionless pools, against the main pool over time? What is the amount/% of TVL that comes from PDAs/integrations or DAOs/Realm addresses, instead of normal signers? Overall how healthy does Solend appear as a protocol and is it gaining traction in the Solana ecosystem?
Gains Network vs GMX
Nov 4, 2022 - -- A war of the trading platforms? GMX (native to Arbitrum) - GNS (native to polygon, but announced will be launching on Arbitrum soon). -- Both platform native tokens (GMX - GNS) have seen meteoric price growth during a bear market. -- Since June GNS has gone from $0.68 to $3.68 and GMX has gone from $13.70 to $41.56 -- Observe Trading volume. Has one platform absorbed more volume than the other? -- How impactful is GNS volume to polygon? GMX volume to Arbitrum? Are there any insights that can reveal why Gains Network wants to move into the Arbitrum ecosystem? -- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Axelar Ecosystem Entrances
Oct 28, 2022 - -- Welcome to Axelar! What better to way to get used to Axelar data than to analyze how people enter the ecosystem? -- With that in mind, analyze the activity that occurs on Axelar's Satellite Bridge. -- Since inception, what are the top paths over Satellite. by volume and $ amount? -- What is the most used token to transfer (USDC, wETH, wAXL, etc.)? -- Top analyses will show bridging activity since inception and analyze how that has changed over time.
Hacks, Scandals and Scams - 4. CEL token flows.
Jul 28, 2022 - Celsius Network listed a $1.19 billion deficit on its balance sheet in a bankruptcy court filing a day after the cryptocurrency lender filed for Chapter 11. Currently Celsius owns a large portion of the CEL tokens. What are the top addresses swapping and transferring CEL? How have the CEL swap volumes changed over the past 90 days? How are Celsius wallets interacting with the CEL token? Hint: Here is the list of Celsius Wallets Identified by @lawmaster on twitter: https://app.flipsidecrypto.com/velocity/queries/c5c1ca1b-5299-4105-aed5-7968e2426d94
Toke-1.Top TOKE Holders
Jun 23, 2022 - -- Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
5.Solana-Phantom Wallet Growth
Feb 5, 2022 - -- Question 5:This week, Phantom (the most popular wallet in the Solana ecosystem) released its mobile app. -- There is an expectation that this will gradually increase adoption. -- Track and visualize at least two metrics to compare growth in Solana activity in the start of February -- (when Phantom mobile launched) to the month of January.
44.Sushi-Governance
Feb 20, 2022 - -- Question 44: Explain all the ways that SushiPowah can be obtained using visual aids. -- Are they limited or inflationary? I.e. are the total units of SushiPowah capped?
EVM - 7. Derivative Daze
Feb 6, 2023 - Derivatives DEX Gains Network recently crossed a major milestone, with more than $1.5 million in trading volume on Arbitrum, fueling further interest in derivatives trading on the platform. Building on this Dune dashboard, create a dashboard that shows the following data for Gains Network and any other derivatives trading markets you can find: Total volume Total traders Total trade fees Trade volume over the past day/month/three months Traders over the past day/month/three months
Hot-19.RocketPool: User Profile - LIDO vs. RocketPool
Apr 24, 2022 - -- Lido is another application that also offers ETH2 liquid staking. -- Compare and contrast activity on RocketPool vs. Lido over the past three months. -- Is one growing more quickly than the other? Can we conclude if one of these applications is better for users than the other? -- Are there different types of users using RocketPool compared to Lido, or are the user profiles similar? -- Visualize and explain your conclusions.
Solana-81.Smart Money NFT Traders
Jun 6, 2022 - -- Q81. Which wallets have made the most SOL off NFT mints and NFT trades since the start of the new year? -- What types of actions have led to being a profitable NFT trader on SOL? -- Is there a pattern behind their NFT trading strategy and can you define some of these traders as "smart money"? -- Do you think you need to be a "whale" to do well trading SOL NFTs, or can anyone have success in this market?
Solana TPS
Feb 20, 2022 - One of Solana's main features is its speed compared to other blockchains. Blockchain performance is usually measured in Transactions per Second (TPS). Measure the TPS of Solana in February (non votes) and 'Successful TPS' per day and create a chart showing how TPS has fluctuated during that time period.
[Flash] Solana Swaps
Feb 4, 2022 - -- Analyzing swaps on Solana is difficult because each major DEX uses a slightly different data structure. -- The location of the tokens and amounts swapped can vary in index and between pre and postTokenBalances as well as the Instruction. -- On each of the major Solana DEXes, what 5 tokens have seen the most volume in each week in January? -- What is the volume of each stable coin for each DEX for each week in January? -- Use the Solana events table to solve this problem
[Terra] Voting Records
Jan 18, 2022 - Select two Terra Validators of your choice and compare their voting history (governance votes). Off-chain data can be used to support your answer, but you must also utilize Flipside data in your answer to be eligible for full payment. BONUS: Can you find any proposals where your chosen validators voted differently? Why do you think this might be the case?
Terra-145. Wherefore Art Thou, Rewards?
Feb 9, 2022 - Question 145: What are users doing with their Anchor rewards? Quantify and visualize the differences between how users deploy rewards earned from each of the following: borrowing, staking, liquidity pooling.
Algo-Defly Token Launch
Feb 11, 2022 - Defly(https://defly.blockshake.io/) is a mobile wallet and swapping platform that is currently being developed on the network. They recently had there token presale and liquidity pools have been provided for swaps on Tinyman. Chart the number of Defly Swaps by day on Tinyman What was the biggest swap for Defly on Tinyman? Chart the distribution of Defly among in wallets. Tips: -Defly asset ID is 470842789 Here is a Defly Tinyman swap example: https://algoexplorer.io/tx/group/7fT9AYyUiLqVZGX8sZyRlYrQC8W8VoPysU6Kz%2FasrYs%3D Tinyman Defly Contract Address: XLNMBK3GMC4YEF562DMEOZEYTNDWJLQRN2GFQ3MGLVNIJTOTVGVD75DVKM
Terra - 6. New Year, New LUNA?
Jan 7, 2023 - The holidays and New Year are often chaotic in the crypto and DEFI space, as users make a spree of new transactions and wallets as they receive (and give) some cash and coins as holiday gifts. Has this flurry of winter activity impacted the Terra ecosystem? Are users creating new wallets or buying tokens with their newfound holiday wealth? Are they staking all those new tokens once they get them? Or are they selling tokens to pay for their own gifts and holiday travel? Create a dashboard documenting significant trends in transactions, wallets, supply, staking, development, or other aspects of the Terra ecosystem. Note any changes in metrics such as the average and total transactions per week and the fees associated with them, the total and average number of new wallets created each week, the total and average number of contracts deployed, LUNA staked, and anything else you interesting.
Hot-18.RocketPool Recent Activity
Apr 24, 2022 - -- Using the Ethereum_core schema, analyze inflows and outflows to RocketPool over the past three months. -- As we near the ETH 2 merge, are there any emerging trends? -- What is the average deposit size and how has that changed vs. historical performance?
Flow-4. Flow Speed
Jun 4, 2022 - -- Q4. One of Flow's main features is its speed compared to other blockchains. -- Blockchain performance can be measured as Transactions per minute. -- Measure the transactions per minute of Flow since May 9th and 'Successful transactions per minute' and create a chart showing how that metric -- has fluctuated during that time period. -- What types of events have raised or decreased the blockchain's performance over that time period? -- Are there bursts of transaction volume or interest on the chain? Compare Flow's speed to at least two other blockchains.
stETH/ETH Fluctuation
Jun 11, 2022 - -- Analyze the price of stETH in ETH denomination and find meaningful correlations that explain its fluctuation. -- Possible correlations could be with ETH’s price in USD, ETH’s gas price, volume in the curve pool, -- Curve stETH/ETH pool composition, etc.
NEAR - 7. Weekly Report - Redux
Jan 14, 2023 - Each week, the NEAR Foundation publishes data to help the NEAR community understand the ecosystem's health as part of their Transparency Report. We want your help in making the NEAR ecosystem even more transparent. How can you improve on the existing NEAR Transparency report? Explain which metrics should be taken into consideration and why. Then, analyze those metrics over the last several weeks and draw your own conclusions on the health of the NEAR ecosystem. Grand prize-winning dashboards will go above and beyond the existing report, allowing readers to get the best possible snapshot of NEAR, its users, and its ecosystem.
SUSHI-79.Top Kashi Pairs
May 18, 2022 - -- Q79. Find the top 5 Kashi pairs on Ethereum based on TVL. Choose one that you like and describe the following information: -- How many people are borrowing on this pair at the moment ? -- How much collateral has each user added to the pair? -- How many users have already partially paid their loans?
Open Analytics Bounty: ETH vs Solana - Battle of the NFT Marketplaces
Sep 15, 2022 - Open analytics bounties are all about deep dive dashboards into one specific topic. For this bounty, submissions should compare ETH + Solana in some way.
Yield Maximization 2
Mar 8, 2022 - Question 51: Of the people who have used Sushi's lending service on ethereum, show the top 50 addresses that have realized the most profit (ROI) considering gas fees. what where they lending? for how long?
Terra-175.Scanner Sweep
Apr 5, 2022 - Q175. Bounty question #157 was to create a dashboard to show the health of the Terra ecosystem. For this bounty, your job is to write a succinct one-page summary or summary dashboard assessing a submission of your choice for the Acme of Skill bounty (#157). Grand prize winners will compare at least two of these submissions. What is effective about these metrics of the Terra ecosystem? What would you add or change to make your chosen submission(s) an even better resource for LUNAtics?
Solana Flash Bounty: Saga
Jun 24, 2022 - -- How many wallets have pre ordered Saga (the new solana phone) so far? -- Note: the preorder is a NFT purchase on-chain. -- Who is preordering the phone? Provide a breakdown of the type of wallets ordering so far. -- Example metrics to investigate: what other programs are these wallets interacting with, how active have these wallets been on Solana, are they average users or whales?
[FLASH-Delphi] Number of daily active wallets
Nov 10, 2021 - -- The ask: We’re working on giving Delphi insights on some Terra data. -- A DappRadar report had mentioned that 2M daily unique active wallets interact with dapps, -- we want to see that stats on Terra alone. -- tl;dr: Query on-chain data to find the number of daily active wallets on Terra from the past 90 days -- and give an analysis on findings.
Solana-103.Going Down The Wormhole
Aug 9, 2022 - -- Q103. Create a dashboard that can refresh daily with metrics that provide a detailed picture of Wormhole activity -- both from Ethereum to Solana and from Solana to Ethereum. -- How are tokens being bridged from chain to chain and which actions seem to be popular among users of Wormhole? -- What actions seem to influence bridging behavior? -- What are users doing before and after bridging? -- Do users seem to think that bridging is safe or more risky relative to transfers to centralized exchanges?
EVM - 8. Up The Mountain
Feb 16, 2023 - An Avalanche has been building up steam as of late — the price of AVAX rose by nearly 100% in the month of January and BTC hodlers have been moving holdings to the Avalanche chain. What’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?
[Terra] Staking Yield, Mvmt 1: The Basics
Jan 18, 2022 - Explain in your own words (i.e. don't copy the documentations) how Terra's staking yield is calculated. Provide a graph that compares LUNA staking yield to LUNA price over a time period that you define.
Tornado Cash Addresses
Aug 10, 2022 - -- 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)
Algo-76.Algorand NFTs
May 26, 2022 - Q76. Let’s look at the Algorand NFT scene from a high level How many wallets(distinct) currently hold an NFT? How many wallets(distinct) have created an NFT?(Tip: Look at the creator Address on the asset) Create a distribution of the number of NFTs held per wallet for wallets that hold at least 1 NFT. What’s the average amount of ALGOs NFT holders have, is this more or less than non NFT holders? How many active wallets/what percent of wallets hold at least 1 NFT? Do we see new wallets joining algorand and buying NFTs or is it mostly older wallets buying/holding NFTs? How many total, non-closed NFTs are on the algorand network? Show their creation over time using asset created_at. How many NFTs use the ARC3 vs ARC69 standard? Make sure to write an analysis based on each of the findings above! Note any other interesting findings about wallets that hold NFTs! Tip: 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 try_base64_decode_string(tx_message:txn:note::string). Tou will find in the note the asset has been configured to the arc69 community standard: https://github.com/algokittens/arc69. For assets configured to the arc3 standard look for transactions who’s asset url ends with #arc3 https://github.com/algorandfoundation/ARCs/blob/main/ARCs/arc-0003.md
Algo-108.Humble Swap Launch
Jun 24, 2022 - Q108. A new dex has launched on Algorand built by the reach team: humbleswap(humble.sh). Let’s look at how its launched
Terra - 10. Light as a Feather
Jan 25, 2023 - -- The announcement of Station has generated hype in the Terra community. -- Has this type translated to an increase in activity? -- Define and visualize at least 2 metrics for ecosystem activity and analyze them in the week before and after the Station. -- Did the launch have any measurable impact? Are there other factors that might be in play affecting the metrics you’ve chosen?
BendDAO Metrics
Sep 8, 2022 - -- Q1. Analyze deposits and withdrawals into BendDAO over the past month. Provide metrics such as total ETH volume and unique wallets, and explain any interesting findings
33.Algo-Staking STBL on AlgoFi
Mar 10, 2022 - -- Question 33: Let's look at how much STBL, Algorand's First Stablecoin, has been staked on AlgoFi. -- Show the stake vs unstake actions over time -- Show the total number wallets that have staked over time -- Show the total amount of STBL staked(make sure to account for amounts that have been unstaked.
Hot-12.How Many Times was Hop used?
Apr 23, 2022 - -- Q12. How many times was the hop protocol used in 2022 in order to bridge funds to layer2? -- Use Ethereum_core schema. -- Hints: -- contract address for ethereum bridge for Matic : 0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2 -- MATIC contract address on ethereum: 0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0 -- Event name that sends token from user's wallet to the bridge is 'Transfer' -- Event name that sends token from the bridge to the layer 2 wallet is 'TransferSentToL2'
148.Terra-Anchor Dominance
Feb 14, 2022 - Question 148: What is the “Anchor dominance” for wallets on Terra? For active Terra wallets*, how much of their total asset value is held in Anchor at the time of analysis? *Select your own definition for “active wallets”; for example, wallets with at least 1 transaction in the last 30 days