![IL Protection By Pool IL Protection By Pool](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 Onboarding with Solana NFTs](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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? CowSwap - Market Mover?](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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) Distinct Wallets (Optimism Bridge)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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) Forefront Treasury (Forefront Bounties)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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) Layer 2 Blocks (StarkWare)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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) Hot Ball of Money (Solana NFTs)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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) In The Stars (Osmosis Bounties)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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) Swap Increase on May 11 + 12 (Algorand Bounties)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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) Forefront Curators (Forefront Bounties)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 Yet Another Acme Question - Terra Bounty](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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) Pact.fi LP Pool Actions (Algorand Bounties)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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? When Do Transactions Fail?](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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) Sushiswap Bentobox Borrowing Scavenger Hunt (Farsi)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Sushiswap Bentobox Borrowing Scavenger Hunt (Farsi)
Mar 31, 2022 - به Sushiswap و اکوسیستم Bentobox خوش آمدید! ما امیدواریم این هانت یک نقطه ورود لذت بخش به Bentobox باشه.
![USDC Deposits USDC Deposits](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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) How Many Times was Hop used? (Hot on ETH Week Day 2)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 Solana Outages](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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) Does Time of Day Affect Price? (Algorand Bounties)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 Top Kashi Pairs III](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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) Fuse Pool DAI Allocation (Rari Capital Bounties)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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)
CowSwap Sushi Activity (Hot on ETH Week)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 Voting Activity](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 Transaction Fees](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 Fault Tolerant Staking](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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)
Rug Pull? (Algorand Bounties)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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) Transactional Nature (Terra Bounties)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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 Gas Efficiency](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Gas Efficiency
Jun 5, 2022 - Q88. Which one of the sushi services consumes the most gas per transaction?
![Successful Bids on Kujira Successful Bids on Kujira](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Successful Bids on Kujira
Apr 10, 2022 - Q179. 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?
![New Addresses New Addresses](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
New Addresses
Jun 1, 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.
![Sushi Financial Ecosystem Sushi Financial Ecosystem](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Sushi Financial Ecosystem
Mar 19, 2022 - What are the financial services offered by Sushi? Are they offered on all the chains? prepare a document illustrating sushi ecosystem of financial services on each chain and explain each service briefly.
![Cosmic Champs Token Launch (Algorand Bounties) Cosmic Champs Token Launch (Algorand Bounties)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Cosmic Champs Token Launch (Algorand Bounties)
Apr 28, 2022 - Use the swaps table to look at $COSG and show daily swap to and swap from volume for the asset. Note any trends. 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?