kiacrypto
Swap Increase on May 11 + 12
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? What were users swapping from and to? Were users swapping from ALGO to stables? Was the average swap size bigger than normal? Is this tied to the price of ALGO? Help us understand what took place and why the volume and number swaps increased!
Top Kashi Pairs
May 18, 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
Sushi rewards distribution
Apr 27, 2022 - How much in total has been distributed so far? (A daily chart could help too) How much is left to distribute today? What percentage of eligible addresses have not claimed anything so far? How many eligible addresses have not claimed anything so far? What percentage of the eligible addresses are dead addresses (A dead wallet is a wallet that has not executed any transaction in the last 3 months) Hints: Merkle distributor's address: 0xcBE6B83e77cdc011Cc18F6f0Df8444E5783ed982 The table that shows the list of eligible addresses with the amount (in SUSHI) left to claim as of Oct 12th 2021 at 7:10 PM EDT can be found under ethereum_sushi as “dim_distributor_reward_schedule”
Liquidity Activity
Mar 9, 2022 - Which liquidity pools and platforms are users using to acquire BANK tokens? Which tokens are being swapped most to acquire BANK tokens?
Fuse Pool Analysis
Mar 25, 2022 - Q3. Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify?
DEX Popularity: Tinyman, Algofi, Pactfi
May 20, 2022 - Q70. Since the beginning of April, how has the growth of AlgoFi and Pact impacted swaps on Tinyman? Show us how the Algorand DEX ecosystem is changing as each DEX grows. Do we see a change in the number of wallets swapping on these DEXs? Do we see a change in the volume of ALGOs being swapped on Tinyman and the other DEXs? Are ALGO whales swapping on certain DEXs more than others? Have we seen has the recent price change in ALGO impact the number of swaps/wallets/volume on the DEXs? If so, how?
THORChain and $vTHOR Overlap
May 22, 2022 - Q96. Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards. What % of $THOR staking wallets also are currently LP-ing on THORChain?
Getting Started With Solana Bounties (Farsi)
Feb 18, 2022 - در این داشبورد من تراکنش استیک ماریند خودم را به همراه همه تراکنش هایی که در آن روز در ساعات مختلف شبانه روز انجام شده است، نشان می دهم.
My luna flipside deligation (Farsi)
Jan 25, 2022 - میزان استیک لونا بر روی فلیپساید در تاریخ 2022/1/23
Voting Activity
Jun 19, 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.
Centralized Exchange Action Around Algorand Governance
Feb 24, 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.
Al Goannas
May 26, 2022 - Q80. Al Goanna is Algorand’s premier bluechip NFT with a collection of 489 original NFTs. Let’s take a look at the collection. Show the number of Al Goanna’s each wallet holds. Show the amount of fees Al Goanna sales have generated for the DAO over time. Show Al Goanna sales and ALGO volume over time. -Show the distribution of ALGO balances of Al Goanna holders Note any other insights you find about the Al Goanna sales or holders! Tips: Fee Address: D5J7H7PIYKLY2U6A5OFUAC7GQHTHSXXNX65DSD3CJYPBV2MVK6NTNW44CA https://algoanna.com/ https://www.nftexplorer.app/collection/al-goanna/activity
Stargate TVL Metrics
Apr 27, 2022 - Show how the Total Value Locked (TVL) of Stargate on Ethereum has changed since its inception. What percentage of the TVL is made up by each token staked on Stargate? Note: Use the new ethereum_core data
Kashi TVL
Apr 13, 2022 - Q65. What is the Total Value Locked (TVL) by liquidity pool on Kashi? draw a weekly chart for 2022. what are the top 10 pools?
Active Wallets on Terra
May 4, 2022 - Define "Active Wallets" on Terra. Based on your definition, display the active wallets by day, month, and Year-To-Date in 2022.
$RUNE Movement from Crypto.com
Jun 18, 2022 - Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends? Hint: use thorchain.transfers (crypto.com = thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6)
Saber and daoSOL
Feb 18, 2022 - Since the start of February, how much liquidity has been deposited in the daoSOL-SOL pool per day? How many unique wallets have added liquidity to that pool since February 1st? Create a visualization showing liquidity trends with this pool.
When Do Flow Transactions Fail? (Part II)
Jun 4, 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?
Active Daily Wallets
Mar 3, 2022 - Let's look at daily active addresses on Algorand. -Compare the number of active daily wallets for the month of January 2022 to December 2021 and January 2021. What day had the most active number of wallets in January 2022? Was there an event on Algorand associated with this date?
Polygon vs Harmony
May 29, 2022 - Q1. Draw a chart comparing Polygon with Harmony on the following metrics: Average tx_fee Average number of transactions per hour
Seedclub Members
Mar 15, 2022 - How many members have joined the Seedclub? And How many projects have successfully launched and received their CLUB tokens?
Cross-chain Anchor
Mar 30, 2022 - Q7. Compare the Earn sides of Anchor protocol on Terra vs. Avalanche. What does the Earn side look like on Avalanche? In the last week, are people using it more? Is there more volume? Hint: Here's an example deposit transaction from Avalanche, which you can look up in the terra.msgs or terra.msg_events table: F808E26CA0D243AC5E997949EA0861B0209EBEA4E41516CB738B1E3ADB1FD8AB
IL Protection Over Time
May 16, 2022 - Q88. With highly volatile prices recently, more IL protection has been paid out on THORChain. How do recent days or weeks compare to historical amounts? Hint: use thorchain.liquidity_actions
Sushi during Volatile Times II
May 29, 2022 - Q86. During the recent spike in market volatility, which chain saw the most activity in swaps for sushi? Polygon, Ethereum or Harmony? Hint: For harmony and ethereum swap info, you can use the table in the easy swap table in the crosschain schema
Getting Started With Algorand Bounties 3.0
Apr 29, 2022 - We are going to dive into Algo swaps on the Algorand DEXs.
It's the Catalina Whale Mixer
May 18, 2022 - Q73. Catalina Whales are a popular NFT collection on Solana with an experienced team from the entertainment industry. Chart their sales history and unique holder trends over time. The project has a tier system of holders (5 whales gets you tier 2 status and 10 whales gets you tier 3 status), has this noticeably influenced wallet activity? The project recently announced that you had to own a whale before 5/11 at noon EST in order to qualify for the whitelist of an extremely hyped mint Bubblegoose Ballers along with other benefits. How has that influenced sales activity and holder activity over the past few weeks?"