Mojtaba-Banaei
#16.Folks Finance Deposits and Redeems
May 19, 2022 - Q68. Folks Finance enables borrowing and lending on the Algraond Blockchain. We are going to look at the deposits and redemption of the assets on the protocol. We want to get a better understanding of how wallets are depositing and withdrawing assets over time and how Folks Finance is growing.
OSMOSIS Liquidity Pools - Wallet Composition
Oct 20, 2022 - What type of wallets provide liquidity on Osmosis? Is liquidity concentrated and owned by a small number of whales? Or, are there a diverse range of participants in the LP ecosystem? Do LP composition change based on TVL of the pools themselves?
axlUSDC: Soon to be forgotten?
Oct 29, 2022 - Recently, Circle announced the implementation of an IBC-native USDC, inserting itself into an ecosystem where axlUSDC currently dominates. Let's look at how pervasive axlUSDC is within IBC.
#11. Synth Utilization
Apr 12, 2022 - Q57. THORChain launched synths on the network last month. You can read more about them here - https://docs.thorchain.org/thorchain-finance/synthetic-asset-model Calculate the synth_utilisation of each pool and chart over time. synth_utilisation = synth_supply / balance_asset You can reference this page to look at the current numbers https://app.thorswap.finance/synth
#9. Head to Head (UST Holders)
Mar 30, 2022 - Q172. Excluding the respective foundations, what are the top 10 addresses by amount of UST held? What are the top 10 addresses by amount of DAI held? Do you have any guesses to whom those addresses belong?
Squid Cross-Chain Swaps: Identifying the Top DEXs for Popular Chains
Apr 14, 2023 - Squid offers asset-to-asset cross-chain swaps with the click of a button. For the user, the process is simple; however, behind the scenes Squid leverages DEX swaps in order to transfer these assets. In this analysis, we aim to identify the most popular decentralized exchanges (DEXs) used by Squid cross chain swaps. On a source and destination basis, what are the most popular DEXs used by Squid?
#14.Rare Traits
May 4, 2022 - What Moon Bird traits are rarest? How have different traits performed with buyers and sellers?
OPtimistic or Pessimistic?
Oct 19, 2022 - Are you optimistic or pessimistic about the future of the layer-2 chain known as Optimism? How do you think it will fare going forward compared to other L2s?
#3.TVL Sushi vs. Uni
Feb 16, 2022 - Question 39: Show the daily Total Value Locked (TVL) on Sushiswap over the past 3 months. How does this compare to the daily TVL on Uniswap over the same time period?
#7.200K ALGO Donated Toward Tree Planting
Mar 16, 2022 - Question 32: Algorand is a carbon negative blockchain and the carbon operations produce is often offset by tree planting.
#8. Magic Eden vs OpenSea vs Random Earth
Mar 22, 2022 - Q39. Create a dashboard highlighting at least 3 metrics comparing marketplace performance and adoption between Magic Eden on Solana, OpenSea on Ethereum, and Random Earth on Terra since January.
What makes a Top Shots moment valuable? (Part I)
Jul 25, 2022 - NBA Top Shot is an NFT marketplace on FLOW where sports fans can buy, sell and trade basketball video clips(Top Shots). In this dashboard, using NBA Top Shots data on the FLOW Blockchain, we want to examine the moments of NBA games that have the highest sales volume and we want to see whether or not a particular play type has increased the adoption of these NFTs by users.
#13.stETH Most Common Pools
Apr 27, 2022 - Use the ethereum_core tables to determine the pools most commonly used to swap in and out of stETH. What are the most common pairs? Which pools are most often used?
#14.LP Size Distribution
May 3, 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 still current. Hint: use thorchain.liquidity_actions
Analyzing Bridge Usage on Axelar: Impact of the Arbitrum Airdrop
Apr 4, 2023 - For users claiming the Arbitrum airdrop, we want analyze their bridge use on Axelar. Have these wallets increased transfers into Arbitrum since the announcement of the airdrop? For any wallets who have sold ARB, are they moving their tokens out of Arbitrum? For those bridging out, what bridges are they primarily using?
#1-4. Stable Coin Popularity within January 2022
Feb 3, 2022 - in this bounty, we investigate the usage of three stable coins in daily transactions.
#7. AlgoFi Staking
Mar 13, 2022 - Let's look at how much STBL, Algorand's First Stablecoin, has been staked on AlgoFi.
Hop Protocol Daily Usage on Arbitrum
Aug 7, 2022 - Hop is a protocol for sending tokens across rollups and their shared layer-1 network in a quick and trustless manner.
#11. MonkeDAO Whale Voters
Apr 13, 2022 - A month ago, the MonkeDAO pressed the Solana Monkey Business team for various changes to be made to the royalty and NFT structure to foster growth for the collection. Ultimately this resulted in the first NFT on-chain vote on Solana to accept or reject the SMB team's proposal, with a 'no' likely resulting in a separation of the two groups. In the end, the MonkeDAO voted to unify with the SMB team and to grow their relationship together.
#15.Monthly Swap Volume - ParaSwap
May 8, 2022 - Q2. Show the total monthly swap volume on ParaSwap over the past year. How has the swap volume changed over time? Which DEX’s is most of the swap volume coming from?
#4.Release of AlgoDex
Feb 24, 2022 - AlgoDex launched on Feb 9, 2022, let's look at the performance of AlgoDex's first day: - How many buys and sells occurred in the first 24 hours? - How many orders were fullfilled? How many weren't fullfilled? - What was the total algo volume?
#Terra Builders - Some Notes On Developing Terra dApp
Mar 2, 2022 - Imagine you are a Terra Developer. What are your main pain points? What tooling, services, and resources would make you more productive?
#14.Marinade's Non-Fungible Chefs (Part II)
May 4, 2022 - Marinade Finance Non-fungible Chef NFTs began minting on April 4, 2022. How many unique holders of the NFTs are there? Create a chart showing trading activity and SOL volumes on Magic Eden.
Bridge Analysis
Jul 5, 2022 - Q7. Building off last week's question investigating when transactions fail on Flow, what addresses and contracts are causing the majority of failures? What types of activities and events are these addresses doing that are spamming the network? What types of arbitrage opportunities are they seeking and how profitable are these efforts? Compare these transaction failures to the botting issue that Solana has bene facing causing outages. How do they compare and how could Flow attempt to mitigate these issues?
#14.New Users on Algorand vs. Ethereum vs. Solana vs. Terra
May 4, 2022 - Create a Dashboard for new users on : Algorand, Ethereum, Solana and Terra What trends do you see?
#5-veSBR Analysis
Mar 1, 2022 - What was the total supply of veSBR at the end of each of the last two Epochs (4 & 5)? Create a pie chart showing the distribution of veSBR (top 20 wallets) for Epochs 4 & 5. How did these wallets vote? Did they vote for the same gauges? Or did they choose to send SBR rewards to different pools?
#9. New DEX Users
Mar 31, 2022 - Let's use the algorand.swap table to look at users who are using the new DEXes(Decentralized Exchange): PactFi, AlgoFi, WagmiSwap and whether or not they previously used the Tinyman exchange?
#6.To Be Bankless or not to be ?
Mar 6, 2022 - Why might someone go Bankless? Outline the BED index strategy deployed by Bankless DAO. Show how the BED index strategy has performed over time compared to a more traditional investment route (such as sticking your money into the S&P 500). Use this analysis to suggest why or why not someone should consider going Bankless. BED Index Strategy: https://www.bankless.community/bed-index BED Index Token Address: 0x2aF1dF3AB0ab157e1E2Ad8F88A7D04fbea0c7dc6
Arbitrum NFT Market Analysis
Jun 30, 2022 - In this dashboard, we are going to analyze the daily sales volume of NFTs on Arbitrum and see which collections are the most popular among users, which NFTs are the most sold, and the what is the number of active NFT traders. How much is Fee in this network and has it affected the activity of users or not?
NEAR Performance
Jul 19, 2022 - In this dashboard, we want to review the position of Near blockchain compared to other competitors among layers 1s and compare the number of transactions per minute or TPM of several main blockchains with Near. We also want to compare the number of errors(failure) per minute (FPM) between these blockchains. Stay with us.
#3. Voters VS Non-Voters
Feb 14, 2022 - Question 9: Create a visualization that compares the number of non-vote transactions to vote transactions per block since the start of February (hint, use the block table and the votes_block_agg table). What is the average ratio of votes to non-votes in a block? Have there been any timeframes of noticeable fluctuations of this ratio?
#9. ALGO Transaction Payment Size
Mar 31, 2022 - Let’s look at the quantities of ALGOs being sent in transactions since January 1st 2022 to see if we see any upwards or downwards trends. Group the transactions(algorand.payment_transactions) by size 0-10ALGOs, 10-100ALGOs,100-1000ALGOS, 1,000-10,000ALGOs and 10,000+ ALGOs. Count the number of transaction in each size and chart them by day from January 1st 2022 to current.
#9. Anchor bETH Collateralization
Mar 29, 2022 - Q6. Quantify the amount of bETH provided as collateral in Anchor Protocol. Note any trends or changes in user behavior in the last 90 days. Based on your results, should the bETH borrow limit be raised to 70% LTV? Include relevant data or visualizations to support your claim.
#9. Looking For Swap Arbitrage
Mar 31, 2022 - Q42. Let’s see if we can find any wallets profiting from arbitrage on the Algorand DEXes. We specifically want to see if anyone is conducting arbitrage with USDT or USDC, Asset ID 31566704 or 312769. The period we will want to look at is From January 1st 2022 to current.
#10. Acquiring goBTC and goETH
Apr 7, 2022 - Where are users acquiring goBTC and goETH? Are they acquiring the assets by swapping or by minting? Has this changed over time? Explain the insights you find.
#11.Governance Period 2 Payouts
Apr 14, 2022 - Let's look at the Algorand Period 2 Governance Rewards Payouts
#10. Market Module
Apr 6, 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.
#2.Q18-Algorand New Accounts Per Day
Feb 10, 2022 - 1. Chart how many unique wallets are added each day(Tip: Use the Account Table) 2. Do we see an increase in wallets created during the governance commitment periods compared to non governance commitment times? Governance Commitment Period 2: September 20th 2021 - October 14th 2021 Governance Commitment Period 2: Dec 24th 2021 - January 7th 2022