![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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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,w_300/assets/backgrounds/dashboard-bg.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?
![Folks Finance: Minting gALGO3 For Governance - Algorand Bounties Folks Finance: Minting gALGO3 For Governance - Algorand Bounties](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Folks Finance: Minting gALGO3 For Governance - Algorand Bounties
Apr 23, 2022 - Q53. Folks Finance is a newly launched lending and borrowing protocol built on Algorand. They offer a unique liquid Algorand governance opportunity which allows you to still utilize your ALGOs in in the form of gALGO3 a token you mint when you deposit your ALGOs into their governance pool. An important note is ALGO and gALGO3 are one to one in terms of value. This allows you to still use the value of your ALGOs in the form of gALGO3 and earn governance rewards since your ALGOs will be placed in governance via their protocol and the staking pool. Click here to learn more: https://docs.folks.finance/protocol-architecture/algo-liquid-governance
Avalanche Dex Tools
May 2, 2023 - Welcome to the Avalanche DEX Dashboard, where you can analyze and visualize the performance of various decentralized exchanges (DEXes) on the Avalanche network. Our dashboard provides a comprehensive overview of the top DEXes, including Trader Joe, Platypus, Hashflow, Woofi, KyberSwap, Pangolin, FraxSwap, SushiSwap, Curve, and GMX. With our customizable tool, you can select the specific DEX you want to analyze and view its swap metrics, such as swap transaction count, active and new swappers, swap volume, and more. Join us as we dive into the exciting world of Avalanche DEXes and explore the most popular and rising assets being traded on the network.
![curve curve](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/project-icons/curve.png)
![Top LDO Holders Top LDO Holders](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Top LDO Holders
May 30, 2022 - Q1. Who are the top LDO holders on ethereum and where have their LDO come from? Did they buy it or was it an airdrop?
![What Are Whales Swapping For? What Are Whales Swapping For?](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
What Are Whales Swapping For?
Apr 13, 2022 - Q48. Let's look at the whales are swapping for on the DEXes. First identify current whales with the balance field in the algorand.account table.
![Miso's Competitive Advantage Miso's Competitive Advantage](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Miso's Competitive Advantage
Apr 23, 2022 - Q67. Create a visual document outlining the below facts about Miso, the new addition to the Sushi menu: - What is Miso and what problems does it solve? - Why should users use Miso? - What are the alternatives out there for Miso? - How is Miso going to do it differently from its competitors?
![ETH Deposited or Withdrawn (StarkWare) ETH Deposited or Withdrawn (StarkWare)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
ETH Deposited or Withdrawn (StarkWare)
Jun 29, 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?
![Solport vs. Magic Eden (Solana Bounties) Solport vs. Magic Eden (Solana Bounties)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Solport vs. Magic Eden (Solana Bounties)
Apr 3, 2022 - Q48. Solport - a NFT marketplace on Solana - launched a V2 on March 12th that includes various new features for marketplaces. Beginning on March 12th, compare the NFT sales volume on Solport to Magic Eden's sales volume. How many unique wallets have used Solport over that timeframe compared to Magic Eden?