isam-NuSprf
Liquidation Risks
Dec 27, 2021 - As we know, the worst case scenario for liquidation at Anchor occurs when inaccurate Prices reported by Anchor Oracle Price Feeder lead to incorrect liquidation for 239 users who have open loan positions below the maximum LTV of 60%.
ETH Staked
Jun 14, 2022 - Q9. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Most Popular Jupiter Swaps
Feb 25, 2022 - Jupiter is the best swap aggregator on Solana, meaning that it optimizes the best token swap rate across all decentralized exchanges for users.
stETH vs. ETH
Apr 2, 2022 - How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
200K ALGO Donated Toward Tree Planting
Mar 11, 2022 - Algorand is a carbon negative blockchain and the carbon operations produce is often offset by tree planting. -Show the donations to the wallet over time. Has the donation wallet sent any of the ALGOs anywhere? If so, what addresses have most of the ALGOs been sent to? Have any of the ALGOs been sent to a centralized exchange(CEX)? If so, how much?
Stablecoin Popularity for Swaps
Apr 8, 2022 - Which stablecoin is more popular for a wallet to use in swaps(use algorand.swaps table): USDT, USDC, STBL? Compare volumes and number of swaps for each over the month of March 2022.
Bridge Users (Hop Protocol)
Jun 17, 2022 - Q1. How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
GMT Airdrop
Mar 18, 2022 - Q38. GMT, the governance token of StepN, was airdropped to its 5000 trailblazers (early adopters and supporters of the game) on 3/15. The airdrop amount was calculated from the amount of time played in the game.
Folks Finance TVL
Jun 27, 2022 - Calculate the TVL on Folks Finance- broken out by deposited and borrowed.
Getting Started With Terra Bounties 2.0
Feb 11, 2022 - Continue your journey into Terra data by calculating how much UST is being deposited into Anchor every month, and how those deposits are stacking up cumulatively. Publish your results and submit them to win your second Terra/Anchor bounty! Don’t worry, we’ll walk you though it each step of the way. Please note: this bounty hunt assumes you have completed either the Getting Stared with Terra Bounties or Getting Started with Anchor Bounties activity. It takes the concepts in those activities and adds new wrinkles to grow your knowledge of SQL and the Terra ecosystem. New users who haven’t done one of these previous bounties may find this one challenging!
Cosmic Champs Token Launch
Apr 29, 2022 - Algorand based NFT Game Cosmic Champs have launched their project token $COSG. Let’s look at what users are doing with it. Use the swaps table to look at $COSG and show daily swap to and swap from volume for the asset. Note any trends There is a Yieldly Staking Pool for $COSG (https://app.yieldly.finance/distribution?id=710543830). 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? Tips: $COSG Asset ID: https://algoexplorer.io/asset/571576867 Yieldly Staking $COSG: https://app.yieldly.finance/distribution?id=710543830 Yieldly $COSG staking example: https://algoexplorer.io/tx/group/f4cjqLIntrMR5848ccMcVEPuDcssDcy%2B8seJgF12sVk%3D To identify TRY_BASE64_DECODE_STRING(tx_message :txn :apaa [0] :: STRING) = ’S’ Yieldly App IDs https://app.yieldly.finance/about
Centralized Exchange Action Around Algorand Governance
Feb 22, 2022 - Let's look at how Algorand Governance influenced Centralized Exchange(CEX) action. First, let's look at the first commitment period of Sept 30th, 2021 to Oct 14th, 2021 and compare the previous two weeks Sept 14th, 2021- to Sept 30th, 2021. Did we see more ALGO volume movement from CEXs to wallets by day during the commitment period compared to the previous period? -Next lets zoom out a little, and compare August 14th, 2021 - Sept 13th to Sept 14th, 2021 - Oct 14th. Do we see more ALGO volume movement from CEXs to wallets by day leading up to and during the commitment period than the month before? Finally, lets look at the first governance payout period(Jan 1st, 2022- Jan 5th, 2022). Do we see an increased volume of ALGOs moving TO CEXs from Jan 1st, 2022 - Jan 14th, 2022 compared to the two weeks prior Dec 18th 2021 - Dec 31st 2021? How did the second commitment period Dec 24th 2021 - Jan 7, 2022 impact the ALGO volume movement to and from CEXs during the first governance payout period? Show the volume of ALGOs to and from CEXs during Dec 24th, 2021 to Jan 12th, 2022.
FWBpros
Feb 19, 2022 - Question 1: How many FWBpros have been distributed so far to the community? Create a chart showing FWBpros airdropped per day.
Magic Eden Volume Trends
Mar 15, 2022 - Magic Eden is a community-centric company. We work hard to be responsive, close to the ground, and in service to the best interests of our collections. To prove our commitment to the community, we airdropped Magic Ticket, our own collection, to over 30,000 users. Holding a Magic Ticket gives holders access to our discord-based DAO, MagicDAO, where we deliver interconnectivity via social programs and rewards to the community.
ASA Asset Transfers
Apr 6, 2022 - What have been the most popular assets to transfer since the beginning of February 2022 by the number of asset transfers and number of users who have transferred that asset? What announcements could have lead to these assets being popular?
Top Kashi Pairs
May 19, 2022 - Q79. Find the top 5 Kashi pairs on Ethereum based on TVL. Choose one that you like and describe the following information: How many people are borrowing on this pair at the moment ? How much collateral has each user added to the pair? How many users have already partially paid their loans? Hint: Borrowing generates a “LogAddCollateral” event Repaying generates a “LogRemoveCollateral” event
NFT Wallet Behavior Comparison
Jul 16, 2022 - Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains? What do "whales" tend to focus on in Flow? How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? Are wallets more interested in new projects, or already existing projects on Flow?
Getting Your Feet Wet, Part 1
Mar 4, 2022 - Question 160: Make a table containing wallet addresses whose first transaction was 90 days ago or less. Analyze how active they have been since that first transaction, based on either 1) the number of transactions; 2) the number of protocols interacted with, or 3) the number of different types of transactions undertaken. (deposit, delegate, vote)
Rand Gallery NFT Sales
May 4, 2022 - Rand Gallery is one of the largest NFT marketplaces on Algorand. Let’s take a deeper look into rand gallery’s history and the performance of the marketplace. Show Daily NFT sale volume in # of sales, ALGOs, and USD over time. Show how much Rand Gallery has earned in fees daily and accumulated over time. -How many NFTs have been sold through Rand Gallery and what is the total -volume in ALGOs of NFT sales. What was the biggest NFT sale in both ALGOs and USD. What was the NFT? Tips: NFT Sale Example: https://algoexplorer.io/tx/group/m5Xmjvw60T%2B%2F9%2Bxo15Oi5GjffoRHNRtBkSYDDZBeLgc%3D Fees are sent to: RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE NFT Statistics and Explorer: https://www.nftexplorer.app/stats"
Head to Head
Mar 26, 2022 - 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?
Most Popular Centralized Exchange For Algorand Wallets
Feb 24, 2022 - Let's look at the popularity of centralized exchanges(CEX) when it comes to Algorand. Chart the volume of ALGOs moved to each CEX by day since the beginning of 2021. Chart the volume of ALGOs moved from each CEX by day over time since the beginning of 2021. Are there any notable days of volume for any of the CEXs? What happened?
Free Square
Jun 13, 2022 - Q101. This week we want to try something new. We want you to essentially write your own bounty question and answer it yourself. Pick any topic in THORChain that you find relevant and interesting and analyze it.
Unique Users on Algorand
Apr 8, 2022 - Compare the number of unique wallets that have sent a transaction since February 1st on Algorand vs Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Algorand compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?
Pact.fi LP Pool Actions
Apr 29, 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. Show us total mints and burns by day across all pools. What are the most popular pools wallets are minting LP for? Do we see an increase in mints in the ALGO/GOMint, ALGO/GoBTC, and ALGO/GoETH pools from the AlgoMint incentive? Folks Finance is offering incentive in the ALGO/GoETH starting on April 8th, do we see an increase in mints in this pool from the incentive? Are there any notable days of for an increase of mints? What pool is causing that increase if there is and is there an event tied to the increase? Tips To look at all pool events, we need the app_ids for the pools. We can get these app_ids from when the LP tokens are initially created. We then will look at all application_call_transactions that contain one of these app_ids With pact_app_ids as( SELECT DISTINCT tx_message :txn :apid :: NUMBER AS app_id FROM {{ ref('silver_algorand__transactions') }} WHERE inner_tx = 'FALSE' AND tx_message :dt :itx [0] :txn :type :: STRING = 'acfg' AND tx_message :dt :itx [0] :txn :apar :an :: STRING LIKE '%PACT LP Token' AND tx_message :dt :itx [0] :txn :apar :au :: STRING = 'https://pact.fi/' ) select * from algorand.application_call_transaction where app_id IN ( SELECT app_id FROM pact_app_ids ) And -To decode filter with: TRY_BASE64_DECODE_STRING(tx_message :txn :apaa [0] :: STRING) = ‘ADDLIQ’ OR TRY_BASE64_DECODE_STRING(tx_message :txn :apaa [0] :: STRING) = ‘REMLIQ’ Remove liquidity example txn: https://algoexplorer.io/tx/RDKPQHBLVGQSNP57VHJBTC6YQUWZKB3PF22QRY7OMMPXPMJSDSMQ Add liquidity example: https://algoexplorer.io/tx/N4JZ4S7MH6IN67WUPFAUVBHCFYIAKPJ7L52UW5BEVG6QB4H3O5ZQ To look at examples of add and removing liquidity: https://app.pact.fi/analytics/transactions
Distinct Wallets (zkSync)
Jun 16, 2022 - Q1. ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. You can read more about ZkSync here. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
Staking STBL on AlgoFi
Mar 11, 2022 - Question 33: Let's look at how much STBL, Algorand's First Stablecoin, has been staked on AlgoFi. Show the stake vs unstake actions over time Show the total number wallets that have staked over time Show the total amount of STBL staked(make sure to account for amounts that have been unstaked.
Smart Money NFT Traders
Jun 5, 2022 - Q81. Which wallets have made the most SOL off NFT mints and NFT trades since the start of the new year? What types of actions have led to being a profitable NFT trader on SOL? Is there a pattern behind their NFT trading strategy and can you define some of these traders as "smart money"? Do you think you need to be a "whale" to do well trading SOL NFTs, or can anyone have success in this market?
TVL Sushi vs. Uni
Feb 12, 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?
Compare Anchor liquidations with LUNA price
Dec 25, 2021 - Compare Anchor liquidations with LUNA price over time
Tracking top Solana NFT Collections
Apr 28, 2022 - Track sales volume and average sales price across marketplaces for the following NFT collections: Solana Monkey Business (hint you will need to use the SMB marketplace programId) -DeGods -Degen Ape Academy -Shadowy Super Coders -Aurory -Stoned Ape Crew -Cets on Creck -Taiyo Robotics -SolGods -Portals -Boryoku Dragonz -Catalina Whale Mixer -The Famous Fox Federation -Galactic Geckos -Thugbirdz -Mindfolk -Solsteads -Astrals -Pesky Penguins -Meerkat Millionaires Country Club How much wallet crossover is there between some of the top collections? What is the average time between buying and selling for each each collection? How likely are wallets to buy back into a collection after selling?
ALGO Transaction Payment Size
Mar 31, 2022 - Q43. 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. Do we see any trends of increasing or decreasing payment sizes? What might this indicate for the Algorand network?