kiacrypto
New DEX Users
Mar 31, 2022 - Q40. 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? What percent of wallets for each of the new DEXes(swap_programs:PactFi, AlgoFi, Wagmiswap) had previously used Tinyman to perform a swap?
Standardized TVL Over Time (1 Pool)
Apr 22, 2022 - Select one pool of your choice and show the total number of asset tokens (non-RUNE tokens) in that pool over time
Hop Bridge Volume
Apr 23, 2022 - Q11. How many Matic token were bridged in 2022 per day from ethereum to layer2 using Hop? Use Ethereum_core schema. Hints: contract address for ethereum bridge for Matic : 0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2 MATIC contract address on ethereum: 0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0 Event name that sends token from user's wallet to the bridge is 'Transfer' Event name that sends token from the bridge to the layer 2 wallet is 'TransferSentToL2'
MonkeDAO Validator
Feb 18, 2022 - The MonkeDAO was the first NFT DAO on Solana and also was the first NFT DAO to set up a validator in an effort to help decentralize and secure the network. When a user decides to stake their Solana, they delegate which validator to support with their staked Solana. How many unique wallets since February 1st have decided to delegate their staked Solana to the MonkeDAO validator? Create a visualization showing delegations per day.
Sushi During Volatile Times
May 28, 2022 - Q85. How did the recent spike in market volatility affect the overall activity of sushi on ethereum? Analyze both swaps and lendings?
Let it burn!
Apr 27, 2022 - Find the week that the most volume of Luna burning happened. What caused this event? Show some effects of this burning had on Terra ecosystem by your opinion.
Top Kashi Pairs III
May 25, 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)
Top LDO Holders
Jun 2, 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?
Daily stETH Metrics
Jun 5, 2022 - Q3. Find the following stETH metrics: -Daily volume of stETH? -Average stake size? -Number of stakers over time? -Average time staked? -Staking/unstaking per day?
Top Kashi Pairs (II)
May 18, 2022 - Q80. Find the top 5 Kashi pairs on Ethereum based on the number of loans they have given out so far. Choose one that you like, and describe the following information: How many people are lending on this pair at the moment? How much each user is lending at the moment? Hints: -Adding asset for loan generates a “LogAddAsset” event -removing capital from kashi generates a “LogRemoveAsset” event
Getting Started With Algorand Bounties
May 19, 2022 - In this analysis, we are looking at the most popular ASAs that are held by wallets created in 2022.
Deposit rate from L1s
Jun 11, 2022 - Q105. Look at users swapping from native L1 assets to $RUNE. Are there any trends by chain or over time? Careful, you'll have to exclude rows where they swap from one asset to another via $RUNE Here is a sample query to help with that: https://app.flipsidecrypto.com/velocity/queries/41f0216e-bb0e-44f3-8078-34310134642b Hint: use thorchain.swaps
SOL Swaps on Jupiter
Feb 19, 2022 - Jupiter is the best swap aggregator on Solana, meaning that it optimizes the best token swap rate across all decentralized exchanges for users. Since January 1st, how much SOL has been swapped for other tokens using Jupiter per day? Over the same time period, how much SOL has added from swaps using Jupiter per day? Create a visualization showing the flow of SOL from swaps on Jupiter since January 1st per day and provide insights around any spikes you see.
Liquidity Space Voyage / Mini-Terra Tutorial
Feb 3, 2022 - In this bounty, we want to calculate the total value of TVL that might have moved from Terraswap to Astroport for the LUNA/bLUNA pair.
IL Protection By Pool
May 16, 2022 - Q89. Which pools have paid out the most IL protection in the last week? Month? Hint: use thorchain.liquidity_actions
Forefront Holder Distribution
Mar 30, 2022 - Q1. Forefront has ownership tiers based on the number of tokens that you hold. These tiers provide access to different tools and community features. One example of an exclusive access is https://signal.forefront.club/ Create a histogram of token ownership amounts to understand the percentage of holders that buy tokens to provide access to these tiers. Where are token amounts most commonly distributed? In your opinion, does this token model make more or less sense than say gated NFT ownership? Why? Hint: Read more about Forefront from https://www.forefront.club/ and https://forefront.mirror.xyz/
Fault Tolerant Staking
Apr 13, 2022 - Q2. Define Fault Tolerant Staking (FTS). What are the advantages of FTS? What are the disadvantages? Explain what problems FTS might help solve.
Around & Around We Go (Circulating Supply)
Feb 23, 2022 - Display the circulating supply of LUNA over the past 3 months. Use on-chain data for your calculation, but you are welcome to reference outside sources to support and validate your answer.
Symmetric vs Asymmetric LPs
May 30, 2022 - Q99. On THORChain, you are allowed to add liquidity in 1 of 3 ways: Rune-only, asset-only, or symmetric (both Rune + asset). What is the breakdown of liquidity being added, according to those categories? Are there any trends over time or by pool? Hint: use thorchain.liquidity_actions
Bots and success rate
Apr 27, 2022 - Compare the success rate of transactions executed by bots in the past 60 days with average users' transactions in the same time period. Is there any difference and any trends identifiable?
Market Volatility
May 25, 2022 - Q82. The second week of May saw some huge volatility in the market and prompted many to sell their volatile assets and take a flight to safety. What did the volume look like in decentralized exchanges on Ethereum during that period? Which assets were being sold/bought the most?
Getting Your Feet Wet, Part 2
Mar 10, 2022 - Assess the extent to which new users interact with each of the following projects. For Definition, clearly define what “interact with” means, e.g. “at least 1 transaction”, “at least 5 transactions”, etc. Anchor, Mirror, Pylon, Astroport, Terraswap, Prism, Mars Bonus: to be eligible for the grand prize, complete at least one of the following: Display at least one visualization to demonstrate project participation, e.g.. “total # of users who have used each project”, “total # of transactions by project”, “TVL by project”. Include Randomearth, Knowhere and your analysis.
52 Pickup
Feb 27, 2022 - Recently, a deal was announced wherein LUNA was sold for BTC at a price of about $52/LUNA. Some commentators on crypto-Twitter are contending that this represents the new floor price for LUNA. Over a time period of your choosing, how many days has LUNA closed above this price? How many days has it closed below this price?
Algorand Stablecoin Popularity USDC vs USDT
Feb 9, 2022 - comparison USDC and USDT in Algorand network.
LP-er Retention
Apr 26, 2022 - Take a look at thorchain addresses that have ever added liquidity. Group them by the month of their first date of adding liquidity. What % are still providing liquidity in the THORChain ecosystem? How does it look if you filter those that provided at least $10,000 in liquidity? Hint: use thorchain.liquidity_actions
UST-LUNA Highway
Apr 22, 2022 - Q182. Over a time period of your choosing, display the following: -daily minted UST and burned LUNA -daily burned UST and minted LUNA What are some trends you can observe for each of the charts above?