0xHaM-d
Highest Sales Volume
Jun 12, 2022 - Q1. Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? These are transactions where someone redeems their NFTX tokens for a specific NFT.
Friktion Liquidity (Solana Bounties)
Jun 8, 2022 - Q83. Friktion now has many different Volt offerings for all types of market conditions (bear, bull, crab). How is liquidity flowing into and out of their different Volt offerings? Create a chart highlighting incoming / outgoing liquidity as well as liquidity flowing from one pool to another. How have market conditions and new offerings changed how users have handled liquidity on Friktion? How do you think user behavior will change when we get into a bull market?
Raydium Swaps (Solana Bounties)
Apr 3, 2022 - Q44. Raydium is an automated market maker (AMM) built on the Solana blockchain that shares liquidity with the Serum decentralized exchange. Create a visualization comparing the quantity of swaps and number of unique wallets on Rayidum, Jupiter, and Orca since January 1st. What have been the ten most popular tokens to swap and swap for on Raydium during that time period? What tokens have become more popular over time?
IL Protection By Pool
May 17, 2022 - Q89. Which pools have paid out the most IL protection in the last week? Month?
Onboarding with Solana NFTs
Jun 14, 2022 - Q85. It has been said that Solana NFTs have become a powerful onboarding tool into the Solana ecosystem. Is this narrative true?
CowSwap - Market Mover?
Apr 20, 2022 - Q2. Use the Ethereum_core scheme. Has CowSwap shifted the token exchange market? Show the number of swaps that are done on CowSwap compared to other DEXs over the past several months. What DEXs are the users of CowSwap coming from?
Distinct Wallets (Optimism Bridge)
Jun 17, 2022 - Q1. Many blockchain bridges exist allowing users to move assets between different blockchains. One of the blockchains currently receiving a lot of bridge volume is Optimism. There are several bridges you can use to move tokens to Optimism, but for this bounty we are particularly interested in Optimism’s bridge. How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
Decentralization Progress
Apr 20, 2023 - key takeaways: The network has 457 validators, with over 95% of staked tokens delegated to the top 10 validators. 655.8M FLOW tokens have been staked by 41.1K unique delegators, with increasing trends in the count of delegations and unique delegators. Comparisons to other chains, such as Near protocol, provide context on market potential and adoption for the Flow network.
Forefront Treasury (Forefront Bounties)
Mar 28, 2022 - Q3. Create a visualization showing Forefront's treasury holdings over time. How have they allocated funds over time between FF holdings, USDC holdings and ETH holdings? Has the structure of holdings changed as Forefront has transitioned to "Season 2"? Provide some insight on Forefront's new structure of incentivizing contributions and how the treasury can best be set up to do this. What percentage of payments made by the treasury are in USDC vs FF?
Layer 2 Blocks (StarkWare)
Jun 29, 2022 - Q2. How many layer2 StarkNet blocks have been accepted on Ethereum (L1) chain so far? How much fees have been paid(generated) to Ethereum network? Has StarkNet contributed to saving in transaction fees for its users?
Hot Ball of Money (Solana NFTs)
Jun 15, 2022 - Q84. Compare Solana NFT sales activity on "new" collections to the activity on more established collections within the ecosystem.
In The Stars (Osmosis Bounties)
May 28, 2022 - Q7. Stargaze Zone is an IBC NFT launchpad and marketplace, and new launchpad projects drop on mint every Friday at 4:00 PM EST. Does the volume of swaps involving Stars change around this time? Analyze the volume of swaps involving STARS from March 20th until present.
Swap Increase on May 11 + 12 (Algorand Bounties)
Jun 9, 2022 - Q98. On May 11th and 12th we saw a spike in number of swaps and volume across the DEXs. Breakdown what happened?
Forefront Curators (Forefront Bounties)
Mar 28, 2022 - Q2. 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?
Yet Another Acme Question - Terra Bounty
Apr 26, 2022 - Q184. Refer to submissions for #175 - your own, or those of others. Pick your favorite Terra metric or visualization and recreate your own version. Your SQL can be similar or even identical to the original, but you should put your own narrative and explanation. Why is this metric/visualization your favorite? If you improved it, what changes did you make?
Pact.fi LP Pool Actions (Algorand Bounties)
Apr 28, 2022 - Let’s look at mint and burns for the Pact.Fi pools to see what pools users are most interested to stake their assets in.
When Do Transactions Fail?
Jun 1, 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?
Sushiswap Bentobox Borrowing Scavenger Hunt (Farsi)
Mar 31, 2022 - به Sushiswap و اکوسیستم Bentobox خوش آمدید! ما امیدواریم این هانت یک نقطه ورود لذت بخش به Bentobox باشه.
USDC Deposits
Jun 20, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
How Many Times was Hop used? (Hot on ETH Week Day 2)
Apr 21, 2022 - Q12. How many times was the hop protocol used in 2022 in order to bridge funds to layer2?
Solana Outages
Jun 8, 2022 - Q82. Solana experienced another outage on 6/1 where validators were forced to restart the network. The network experienced a similar problem back on 5/1. After the restart happens during these outages, how do users on the network generally respond? Does the price of SOL drop because users lose confidence in the network? Is there more swapping behavior and more stablecoin activity? What protocols seem to have more activity after these types of events that on the average day in the Solana ecosystem? Is there more fear from defi Solana users than NFT enjoyers?
Does Time of Day Affect Price? (Algorand Bounties)
May 12, 2022 - Crypto does not follow a 9-5 schedule, but some traders may take advantage of different time zones. Using the Prices Swap table is there an hour (or hours) of the day that more frequently exceeds or falls short of the average of the day. Find the top 10 assets that are swapped to, then use the prices swap table to see if the hour of the day has an affect on the price Create a visualization that shows the impact on price based on hour of the day
Top Kashi Pairs III
May 24, 2022 - Q81. Find the top 5 kashi pairs based on: A- The number of loans they have generated, B- The total available for lending (in USD), C- Total collateral deposited (in USD)
Fuse Pool DAI Allocation (Rari Capital Bounties)
Mar 21, 2022 - Q1. How are the tokens in the DAI Vault being allocated into the various Fuse Pools?
CowSwap Sushi Activity (Hot on ETH Week)
Apr 19, 2022 - Using the Ethereum_core schema, find all transactions that interacted with the CoW settlement contract on ETH Mainnet that also used Sushiswap as part of the execution. Why might they have done so?
Voting Activity
Jun 18, 2022 - Q1. The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
Transaction Fees
May 22, 2022 - How many transaction fees are being paid out each day for the past 30 days? Does a certain type of transaction result in a greater amount of fees being collected?
Fault Tolerant Staking
Apr 18, 2022 - Q2. Define Fault Tolerant Staking (FTS). What are the advantages of FTS? What are the disadvantages? Explain what problems FTS might help solve.
Rug Pull? (Algorand Bounties)
May 12, 2022 - Crypto assets can have high volatility. On March 28th 2022, the price of ANIRAND (604643747) dropped when 99% of the liquidity was removed from the ANIRAND/ALGO pool on Tinyman.
Transactional Nature (Terra Bounties)
Mar 26, 2022 - Q171. In your own words, briefly explain how UST transaction volume relates to fees paid to stakers. Then, create a graph to show the fees derived from UST transactions and native swaps.
Gas Efficiency
Jun 5, 2022 - Q88. Which one of the sushi services consumes the most gas per transaction?