Ali3N
Bridge Transactions (Across Bounty)
Jun 20, 2022 - Q1. Analyze bridge transactions via the Across bridge over the last two weeks. What assets are users bridging from Ethereum, and to what chains?
Al Goannas
May 23, 2022 - Q80. Al Goanna is Algorand’s premier bluechip NFT with a collection of 489 original NFTs. Let’s take a look at the collection. Show the number of Al Goanna’s each wallet holds. Show the amount of fees Al Goanna sales have generated for the DAO over time. Show Al Goanna sales and ALGO volume over time. Show the distribution of ALGO balances of Al Goanna holders.
Lofty AI Platform Dashboard (Algorand Bounty)
Jul 13, 2022 - The goal of this bounty is to create a visually appealing dashboard using the new multicolumn layout or the visualization tool of your choice to illustrate all the properties(assets), the tokenized revenue Lofty has generated through sales, and the total asset value that Lofty AI manages. If you have the ability, set the refresh rate to daily.
Folks Finance Liquidation (Algorand Bounty)
Jul 12, 2022 - Q118. Dig into liquidations on Folks Finance to help us better understand liquidations that have happened on the platform! -Total daily liquidations count over time by asset. Do we see a spike when the markets capitulated in May? -Total daily liquidation volume, by asset. Do we see a spike when the markets capitulated in May? -Total daily liquidators profit (difference between the value of collateral liquidated and the total amount paid by liquidators). -Average and total amount that has been liquidated on Folks Finance for each asset?
Untitled BoardCro
Sep 5, 2022 - Q108. Create a dashboard that shows the crossover between the top Solana NFT projects by market cap (you can reference https://howrare.is/ for a list of the top collections). Which of the strongest projects tend to have the most crossover, and which projects have a wider mix of other communities? Which communities tend to provide the most signal that another NFT project will do well? As in, is there any alpha if you were to see a certain PFP buying another collection? Which communities tend to be most active in minting new collections? Which communities have are the most diamond handed on other projects?"
Just Keep Swimming (Solana Bounty)
Jul 23, 2022 - Swim Protocol provides a simple way to transfer tokens across chains via multi-token liquidity pools. It is built on top of one of the most infamous bridges, Wormhole, which allows users to more seamlessly transfer assets across multiple blockchains Create a dashboard for Swim on Solana including at least the following metrics (add anything else you find interesting): Total Volumes Total unique users Most popular destinations from Solana Most popular stablecoins and non-stablecoins traded over time
Largest Tokemak DEX Pools
Jun 21, 2022 - Q3. What are the largest dex pools for TOKE (UNI, SUSHI, etc.)? What is the behavior of TOKE holders on these token pools currently?
Deposit rate from L1s (Thorchain Bounty)
Jun 10, 2022 - Look at users swapping from native L1 assets to $RUNE. Are there any trends by chain or over time? Careful, you'll have to exclude rows where they swap from one asset to another via $RUNE Here is a sample query to help with that: https://app.flipsidecrypto.com/velocity/queries/41f0216e-bb0e-44f3-8078-34310134642b
AB2 Gallery Wallets
May 20, 2022 - Q78. Let’s look at wallets that buy from AB2 Gallery! How many wallets are buying NFTs on rand gallery. What is the total number of unique wallets that have purchased from AB2? Create a distribution plot of how many NFTs each wallet has purchased from AB2. Are we seeing new wallets purchasing on AB2 or is it only wallets that have purchased from AB2 before? Chart the first purchase on AB2 by wallet over time. Create a table of the top 10 wallets that are purchasing from AB2 by ALGOs and number of NFTs
Untitled BoardETHR
Sep 13, 2022 - Examine user behavior in recent weeks leading up to the merge on at least 3 major protocols. Have there been any changes in the amount of ETH removed from protocols like Uniswap and Aave? Note any trends or outliers you find.
The Great Solana Royalty Debate
Nov 2, 2022 - The most controversial topic on Solana over the past month has been NFT royalties. After platforms like Yawww and Solanart moved to 0% creator royalties, and eventually Magic Eden followed, the market has been in a chaotic state. Magic Eden had cited that almost all funds for a project are coming from the mint, not royalties: https://twitter.com/MagicEden/status/1580367439824826368 Is this accurate, or a misrepresentation of how successful NFT projects have been operating? What projects have been more reliant on NFT royalties than others? What collections were wallets pivoting towards using 0% royalties more frequently? Higher royalty percentages? Higher floor volumes? Are flowing royalties a sign of project health and sustainability? How much volume from 0% royalty sales can be accounted for by wash trading rather than actual user interest? Was this actual user demand, or were decisions made based on inflated data?
Node Churning Events (Thorchain Bounty)
May 6, 2022 - Hello and Welcome! in this submission, we are going to investigate Node Churning in THORChain Ecosystem over time.
NFL All Day (Flow Bounty)
Jun 30, 2022 - What is the total sales volume of NFL All Day? How does it stack up compared to other projects, like NBA Top Shots?
Unique Users (Osmosis Bounty)
Jun 3, 2022 - How many unique wallets are active on Osmosis per day? How has this changed over time? What has been the largest event that has brought the most wallet activity to Osmosis? Hint: Determine events by comparing to news sources as well as on-chain data.
Arbs, Arbs Everywhere! (THORchain Bounty)
Jul 15, 2022 - Q.112 One of the core actors in the THORChain ecosystem are the “Traders” (https://docs.thorchain.org/roles/trading). These traders swap at a high frequency to make a profit and are a key cog to helping balance prices on THORChain Identify the Ethereum arb bots and show their activity over time. How many are there? What is their average swap frequency and volume? Which tokens are they swapping? Are they interacting with synths or non-synths? How much profit are they making?
Celsius Swaps (Sushiswap Bounty)
Jun 18, 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?
Arbitrum Scavenger Hunt: Odyssey Pt. 1
Jun 26, 2022 - Welcome to the Arbitrum Odyssey! Arbitrum has announced the Odyssey initiative to invite users to explore the Arbitrum ecosystem. Users that participate stand to receive exclusive NFTs (and possibly ~fingers crossed~ an airdrop at some point!). We hope this scavenger hunt will help you find an easy and enjoyable entry point into the ecosystem. Each step of this scavenger hunt is aligned with steps required to participate in the Arbitrum Odyssey.
Top TOKE Holders (TokeMak Bounty)
Jun 21, 2022 - Identify the top holders of the TOKE token in January 2022, have they kept their position today?
User Activity (Ethereum NFTX Bounty)
Jun 10, 2022 - Analyze user activity providing and removing liquidity from NFTX vaults. Which three vaults have seen the most activity over the past 60 days? Are there any similarities between these vaults or NFT projects? Explain and visualize your findings. Hint: fact_event_logs is probably the best table to use here.
Transaction Failures (Osmosis Bounty)
May 26, 2022 - Q6. Establish the failed transaction rate for Osmosis over the last 4 months. Make a case for what is causing the failed transaction rate that you assess and provide recommendations to mitigate it. Hint: Look at the msg_types of failed transactions to determine what type of transaction results in the most failures.
$RUNE Flow (Thorchain Bounty)
Apr 28, 2022 - Greetings everyone. in this submission we are going to Chart the amount of daily + weekly volume of transferred $RUNE (THORChain Governance Token)
Solend Demographics (Solana Bounty)
Jul 30, 2022 - Q101.Solend is the leading lending protocol on Solana. What are the demographics of the Solend userbase? What is the user distribution by size of account? (How many have between $1-1,000, 1,000 - 100k, etc). Is the protocol largely influenced by whales, or by average Solana users?
Solend TVL Tracking
Aug 19, 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 nd is it gaining traction in the Solana ecosystem?
True Freeze - 3. Timing the market, or time in the market?
Jul 29, 2022 - Identify addresses that have purchased ETH more than once and have held it for more than two years without selling any. Show the ETH buying and selling history of these addresses following their two year holding period. Is there an association between the price of ETH and the buying and selling activity of these ETH hodlers? The best submissions will compare the transaction history of long term ETH hodlers with that of frequent ETH traders. Are hodlers better at timing the market?
Untitled BoardDUS!
Sep 4, 2022 - Q107. $Dust is the utility token behind the most popular NFT project on Solana - Degods. The team and the community have been building with $DUST. How is $DUST being used in the Solana ecosystem? What are its most popular use cases and where are buyers of $DUST coming from? Highlight at least 3 metrics showing $DUST trends in Solana.
ETH Deposited or Withdrawn (StarkWare Bounty)
Jun 25, 2022 - Q1. 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? Hint: Each deposit/withdrawal on StarkNet is done through the StarkNet proxy contract on Ethereum: 0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419. The logs will tell you more.
Stablecoin Swappers (THORChain Bounty)
Jun 30, 2022 - Compare the behavior of USDC swappers with BUSD swappers. What is their volume and swap rate? Feel free to look at other metrics that you find interesting about swapping behavior. Do those results change if you only include synthetics?
Untitled BoardMATST
Sep 18, 2022 - How many $MATIC have been staked since July 1, 2022? What is the staking ratio of $MATIC (amount of $MATIC staked vs circulating $MATIC) during the same time frame? Has it changed or are there any visible trends? What is the daily amount of $MATIC being staked and unstaked?
Welcome to the City (Near Bounty)
Jul 17, 2022 - Once you’ve bridged to NEAR, what is a user’s first activity? Chart the protocols that users are leveraging after porting tokens through the Rainbow Bridge specifically
Net Synth Amounts (Thorchain Bounty)
Apr 29, 2022 - Hello and Welcome! in this submission, we are going to show the net synth amounts (mints - burns) for each chain and each asset on Thorchain and check if there are there any patterns?
Deep Dive into FLOW Wallets Landscape
May 31, 2023 - an analysis to show the landscape of wallets on Flow.
True Freeze - 7. True Freeze vs Lido
Aug 5, 2022 - How many True Freeze users have staked ETH using the Lido protocol? How many are still staking ETH on LIDO? Do you anticipate that more Lido users will use True Freeze? (Note: Optionally, you may also show the percentage of FRZ token holders having staked ETH now or in the past.)
Net Bonding Flow (Thorchain Bounty)
May 6, 2022 - Hello and Welcome! in this submission, we are going to show THORChain net bonding amount over time.
Tracking Solend cTokens
Jul 30, 2022 - Q102, cTokens on Solend are a yield-bearing deposit receipt. This means you can convert USDC into cUSDC to get a tradeable token that also earns interest on Solend. You can hold this token in your wallet to continue earning interest, or you can send it to someone else, and they'll earn interest. What do users do with their cTokens? In which DeFi platforms are cTokens deposited in after minting on Solend? What are the most popular use cases for cTokens and where have they grown in usage over time? Does cToken behavior seem to be influenced by the size of the receipt?
Metamask vs. Other Platforms
Jun 21, 2022 - Q3. How many users are swapping via MetaMask vs other platforms? How much volume have these users done? Chart a comparison between the two, and show the following metrics over a time period of your choosing: transaction volume, average amount swapped, and a comparison of fees.
Untitled BoardGMXP
Sep 17, 2022 - GMX, a perp protocol, has been attracting attention recently for the massive fee revenue being generated. Examine and compare the protocol over recent days and weeks on Arbitrum. How has the protocol been performing over the past month? Three months? How is it absorbing these massive fees? Note any overarching themes or narratives that you find.
Solana NFT Project Feature
Jul 17, 2022 - Choose a NFT project from the following list and create a dashboard with the new Flipside dashboard layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the project. Note any noticeable trends or current events for the project. Highlight how liquidity is flowing in and out of the project and what types of buyers and sellers are interacting with the project.