Sushiswap: 27. - Most Recent Transactions
Jan 23, 2022 - -- Find the top 10 tokens in terms of liquidity in USD on Sushiswap. -- Show the 10 most recent transactions on Sushiswap for each of those tokens.
[Terra-57] TerraSwap Dominance Dashboard
Aug 30, 2021 - What are the top 5 TerraSwap pools ranked by swap volume? What are the top 5 TerraSwap pools ranked by TVL?
Terra: 136. Whale Dependency Index
Jan 22, 2022 - Create a Bar Chart Graph displaying DEX pool vs total liquidity on Loop - with the number of total wallets holding LP tokens typed on each bar. The goal for this is for us to determine: Which of our pools are highly dependent on whales….because lower number of wallets associated with the highest liquidity pools will tell us this for each pool. This type of info can help us figure out our own “whale dependency” index, which could help guide us on how to best allocate farming rewards. In general, do we want to keep one whale happy or is it better for us to keep a lot of farmers happy?
Terra-176.Market Module
Apr 5, 2022 - -- Q176. Explain in your own words what Terra’s “market module” is, and how it functions. -- Define at least two key metrics for the market module, and demonstrate how it’s performing in its stated goals based on these metrics.
140. Anchor Collateralization
Jan 30, 2022 - How much of the collateral provided on Anchor is bLUNA vs. bETH? How has this changed over the past 90 days?
LP-er Retention
Apr 23, 2022 - -- Take a look at thorchain addresses that have ever added liquidity. -- Group them by the month of their first date of adding liquidity. -- What % are still providing liquidity in the THORChain ecosystem? -- How does it look if you filter those that provided at least $10,000 in liquidity?
$RUNE Distribution
Apr 23, 2022 - -- Calculate the distribution of $RUNE holdings by address. -- Include RUNE that is in liquidity pools. (e.g. if I have 100 $RUNE in my wallet and LP 50, I should still -- be considered to be holding 100).
LP Size Distribution
Apr 30, 2022 - -- What is the current distribution of LP size for each pool? -- You will have to use both 'add_liquidity' and 'remove_liquidity' to determine which LPs are stil current.
APOLLO-106. [Easy] New Money
Dec 8, 2021 - Of the TVL for the community farming event, how much was new money (from outside Apollo’s vault) vs. a transfer from Apollo’s existing vaults? Defend your answer!
Harmony-1. [Easy] Wallets With Balance
Mar 3, 2022 - -- Display the number of wallets with >0 balance (as of current date; show change over a time period of your choice, minimum last 7 days)
THOR-27. LP Participation
Dec 12, 2021 - How many RUNE addresses are currently providing liquidity in 1 pool? 2 pools? 3+ pools? Hint Use thorchain.liquidity_actions
Airdrop Actions
Oct 16, 2021 - tl; dr We'd like a percentage breakdown of what addresses are doing with their airdropped tokens within 90 days after receiving them, to help understand what addresses are the best candidates for airdrops. ------ The Ask: For each token airdrop - LUNA, ANC, MINE, MIR, PSI, LOOP, and STT airdrops - provide a percentage breakdown of the actions taken, by address, within 90 days of receiving the airdrop. We’d like the breakdown to cover the following actions: -Held -Subsequently purchased more of the airdropped token -Transferred -Staked -Swapped Details: We’re looking for science, not presentation magic. Specifically: our data science team would love to turbocharge the airdrops analytics we’re putting together to identify addresses that are prime candidates for Airdropz. So - we’re placing a premium on clean, organized, well-commented SQL. No need to spend time on flair or snazzy presentation - the goal is to create solid SQL building blocks rather than beautiful facades
Cosmic Champs Token Launch
Apr 25, 2022 - -- Use the swaps table to look at $COSG and show daily swap to and swap from volume for the asset. Note any trends -- There is a Yieldly Staking Pool for $COSG (https://app.yieldly.finance/distribution?id=710543830). -- Show how many stake actions a day are occurring. -- Plot the staking amounts(the amount of $COGS staked) by day over time on a scatter plot. -- What types of trends do you see?
Friktion's Crab Strategy
Apr 24, 2022 - -- Track the deposit activity into the Crab Volt. -- How many unique wallets have used the strategy since April 11th? -- What other Friktion Volts have these wallets used since March 1st? -- What is the crossover between the Volt #1 Bitcoin strategy and the Crab Volt? -- Why would a wallet prefer to use this Crab Volt instead of the other products?
7. CRV Deposits Over Time
Feb 17, 2022 - -- Show the deposits of CRV over time by unique wallets; unique users; and total amount
Paraswap-1. New Active Users
May 11, 2022 - Show the number of new unique users (wallets) per day that transacted with ParaSwap over the past two months.
Flipside's Polygon Shapeshifter Hunt
Aug 20, 2021 - The best way to understand a crypto project is to get involved in it yourself. We at Flipside are here to help you do exactly that. This set of steps is your portal into the world of Polygon (and all the data we’ve gathered to help you shine a light on its furthest expanses). Think of it as a “pre-flight checklist” for a space launch. Once you’ve completed these steps, you’ll be successfully immersed in the Polygon ecosystem, familiar with its core token (**MATIC**) and some of its core applications (**Polygon Wallet, Polygon Bridge, and Polygon Staking**). The first 100 participants to successfully complete the **Scavenger Hunt** will receive **$75** and the **Shapeshifter Badge.** To be transparent, we’ll post the Discord handles of all successful entrants on a **Polygon Leaderboard** (if you’d rather not be listed, just let us know). Got questions? Reach out in the **Polygon** or **query-troubleshooting** channels in our [Discord](http://flipsidecrypto.com/discord).
151. Terra-52 Pickup
Feb 27, 2022 - Terra Q151: 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?
THOR-38. Rune Upgrades
Jan 9, 2022 - How many unique addresses have upgraded their rune in first week of 2022? How does that rate compare with the previous 4 weeks? Hint: use thorchain.upgrades
Terra-117. [Hard] Terrarbitage, Part 1
Dec 15, 2021 - Fluctuations in the bLUNA/LUNA pool allow for arbitrage opportunities for users to gain more LUNA. Explore the potential yield (APY) from arbitrage in the pool. -How frequently do these premiums come about? -What strategies yield the best returns (burning on Anchor vs swapping BLUNA back to LUNA)? -At what premium should users swap their LUNA and bLUNA to generate the most yield?
5. Galactic Punks
Nov 10, 2021 - How much UST has been deposited into the lottery since it’s inception? What has been the average UST deposit amount?
10. The call is coming from inside the house
Dec 15, 2021 - The sushi price briefly spiked on December 8th. Determine if the price jump was driven by dex trades (as opposed to off-chain trades) by looking at trades in any SUSHI/WETH, SUSHI/USDC and SUSHI/USDT pools on Uniswap and Sushiswap on that day.
Terra-97. [Galactic Punks] New User Onboarding
Oct 25, 2021 - How many users joined Terra just to get involved with GP? Example - deposited UST/LUNA/asset and one of their only/first transactions was minting/buying/trading GPs? What else have they gotten involved with since?
Polygon-2.New Addresses
May 29, 2022 - -- Q2. Draw a chart showing the number of new addresses every day on polygon(matic) network. -- New addressses are unique addresses that appeared for the first time in a transaction of Matic.
Terra-107. [Hard] $HALO Distribution Analysis
Dec 9, 2021 - Analyze the wallets who used the Apollo/Angel farm. How many wallets participated? How much HALO was farmed during each day over the course of the farming event? How did the total volume change over the course of the farming event? Provide visualizations to support your answers.
THOR-33. [Hard] THORChain Wallet Address Growth by Time Segment
Dec 19, 2021 - What has been the rate of THORChain growth in terms of the number of new THORChain addresses being created? How do the following time periods compare? 1. Pre-hack (before July 16, 2021) 2. Pre-Network Halt (Sep 24 - Nov 11) 3. Post-Network Halt (Nov 18 - present) Hint: use liquidity_actions, swaps, bond_actions, transfers, and upgrades to get all the THORChain addresses
[Terra-56] TerraSwap Liquidity Distribution
Sep 1, 2021 - Among liquidity providers on TerraSwap, how equally distributed is the liquidity? Do just a few LPs provide most of the overall liquidity, or is it more egalitarian?
Stark-1.ETH Deposited or Withdrawn
Jun 29, 2022 - -- 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?
3.Tracer-Tokemak Popularity
Mar 1, 2022 - -- Tracer Q3: Tokemak is a protocol that allows tracer governance token holders (TCR) to seek further ROI by way of yield farming. -- What is the popularity of Tokemak among tracer users? -- Hint: Tokemak_tTracer address: 0x15A629f0665A3Eb97D7aE9A7ce7ABF73AeB79415
SUSHI-32. - Whales Comin’ and Goin’
Jan 30, 2022 - Define a whale. Show the number of whales leaving liquidity pools on Sushiswap each day over the past 2 months. Do the same for the number of whales entering liquidity pools.
Uniswap - 9. User Participation in Governance.
Mar 18, 2022 - What percentage of current UNI holders have voted on a Uniswap governance proposal at least once?
Terra-179.Successful Bids on Kujira
Apr 12, 2022 - Q178. Determine the total unique users placing bids on Kujira since its inception. Compare bids on bLUNA vs bETH. What portion of these users are seeing their bids filled?
Thor-107.$RUNE Upgrades
Jun 27, 2022 - -- Q.107 There has been a big push for users to upgrade their ETH.RUNE + BNB.RUNE -> native RUNE, as the wrapped versions will be depreciated. -- Have you seen an uptick in the amount of $RUNE being upgraded recently? -- Look at both the $RUNE volume + number of wallets. What is the trend over time + also how much is ETH vs BNB? -- Hint: use thorchain.upgrades
[Polygon-7] Polygon Fees
Sep 11, 2021 - Visualize the daily fees on Polygon since June 1, 2021. Compare these to the daily fees on Ethereum over the same time period - are they coorelated? Do they diverge significantly at any points? Provide analysis as to why you think this might be.
Flow-2.When Do Transactions Fail?
May 29, 2022 - -- Q2. Do times of high transaction volume lead to more transaction failures? -- Create a visualization that shows the relationship between transaction volume and success rate of transactions since May 9th. -- Are there any noticeable patterns to when transactions are more likely to fail? -- Were there specific events that seem to cause transaction failures?
[Terra-80] Historic bAssets Price Movements
Oct 17, 2021 - -- What is the most bLuna has dipped in a X second window (based on bLuna price oracle timing)? -- Focus on the events of the Black swan event in mid-May. Make the default size of the window 30 seconds. -- - How much has bLuna drifted from its Luna peg? -- - How much has bEth dipped in a 30-second window -- - How much has bEth drifted from the Ethereum Price
THORChain: 49. Do the DOGE
Jan 22, 2022 - -- How many unique users have made a swap using the $DOGE-$RUNE pool?
Algo-79.Mona Lisa- Lil Pump ft Soulja Boy MFT
May 26, 2022 - -- Q79. Opulous is a launchpad for music NFTs, where you can take ownership in artists’ songs, albums, and artworks -- and earn royalties from them. One of the first songs released was Mona Lisa- Lil Pump ft Soulja Boy -- Show us the distribution of the number of shares each MFT holder has for the asset(725937713). ---Have all the shares been claimed? -- Show the claims of the MFT shares over time so we can understand the effectiveness of the claims process -- Have any wallets exchanged their shares? -- If they did, how much did they exchange them for? -Note any other interesting findings!