CoinConverse
Swapping goBTC and goETH on DEXs
May 21, 2022 - Q72. goETH and goBTC are wrapped forms of ETH and BTC minted by algoMint. Let's look at goBTC and goETH swaps across the DEXs since the beginning of April and get a better understanding of how wallets are swapping goETH and goBTC - especially during the price crash in May. -Track the volume and the number of wallets that are buying and selling goETH and goBTC on DEXs. Are more users acquiring goETH and goBTC or are they selling it? How does each DEX compare? -Are wallets swapping goBTC and goETH for just ALGO? If not, what other ASAs are wallets swapping goETH and goBTC for? -Did the price crash in May impact the number or volume of goBTC and goETH trades? -Are there any notable days of trade for goBTC or goETH? What may have caused this? Note anything else interesting you find in your analysis on goBTC and goETH swaps!
Forefront Treasury
Apr 18, 2022 - Q3. Create a visualization showing Forefront's treasury holdings over time. How have they allocated funds over time between FF holdings, USDC holdings, and ETH holdings? Has the structure of holdings changed as Forefront has transitioned to "Season 2"? Provide some insight on Forefront's new structure of incentivizing contributions and how the treasury can best be set up to do this. What percentage of payments made by the treasury are in USDC vs FF?
Synth Utilization
Apr 12, 2022 - Q57. THORChain launched synths on the network last month. Calculate the synth_utilisation of each pool and chart over time. synth_utilisation = synth_supply / balance_asset
AlgoMint goMint Token Release
May 4, 2022 - goMint was launched on Algofi, Tinyman, and Pact on March 30th, 2022. goMINT, is the first Algorand-native three-way listing so let's look at the performance of the goMint release between the 3 DEXs. - Show us the volume of ALGOs swapped for goMint by day on each DEX since the token release - Show us the number of swaps and the number of wallets by day by DEX for goMINT/algo swaps in the first week of the token release. - In the first 24 hours of the token release- chart the average swap price in ALGOs for goMint across each DEX(AlgoFi Tinyman Pact). Do we see a higher average price for goMint on any of the DEXes? - Note any other interesting findings between the DEXes related to the release of the goMint and the goMint/algopools, such as volume, number of swaps, or number of wallets swapping.
3. Active Wallet Growth
Jan 31, 2022 - In this query, we aim to visualize the number of unique active wallets (signers) over the past 7 days and since the start of 2022?
Gasless Polygon Scavenger Hunt
Dec 9, 2021 - The below table illustrates the transaction based Polygon chain of the wallet of 0x3085ed07180e8A052346BEbD8385e2c4F4fB8035.
Symmetric vs Asymmetric LPs
May 27, 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?
The number of unique users who made a swap using the DOGE-RUNE pool
Jan 23, 2022 - This analysis aims to demonstrate unique users who have made a swap using the $DOGE-$RUNE pool. We also show the number of unique users who swapped their tokens to DOGE tokens (buying DOGE) versus the number of unique users who swapped out of DOGE tokens (selling DOGE).
ASA Asset Transfers
Apr 7, 2022 - Q41. 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? Create a table using the asset_transfer_transaction table that show the top 10 assets by number of transfers since February 2022. Chart these transfers over time by day as well. Create a table using the asset_transfer_transaction table that show the top 10 assets by number of wallets that initiated a transfer since February 2022. What announcements and events could have led to the popularity of some of these assets?
Total Value Locked
Jun 30, 2022 - Q1. What is the total value locked in the Opyn Squeeth (osQETH) contract? And where does osqeth draw its value from?
Whale Swaps
May 4, 2022 - How many swaps are above x$ and how much total amounts were swapped in such transactions? Hint: you should use parameters. you can set X as $150,000 by default.
Forefront Participation Incentives
Apr 18, 2022 - Q4. Compare the incentives for participating in Forefront with at least two other social tokens/DAOs of your choice citing two metrics of your choice. In terms of payout opportunities and upside, does the S2 Forefront seem optimal for encouraging development? Create a dashboard showing payouts aggregated for each role type and if each role has influenced what contributors do with their payments? What are some methods that would encourage payments to be reinvested into Forefront besides just time?
1M New Algorand Wallets In May
May 19, 2022 - Q66. From May 4th to May 10 we saw over a million wallets being created. What are these new wallets doing on Algorand? Some things to look at: -Using the account table, show the distribution of ALGOs these wallets have? -Are these wallets swapping assets? If so, what assets are these wallets swapping for? -What assets do these wallets hold using the account_asset table? -Do we see any commonalities our patterns across these wallets?
Token Activity
May 11, 2022 - Q3. What do people do with their PSP tokens? Once people acquire PSP tokens what do they do with them? Do they stake them? How long do they hold them for? Show the journey of PSP tokens.
Gain or Lose
Jun 13, 2022 - Q10. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap? Repeat the same analysis for stakers who have swapped stETH to ETH; how much ETH did they gain or lose?
Successful Bids on Kujira
Apr 11, 2022 - 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?
Average Solana Portfolio
Jun 29, 2022 - Q91. What does the average Solana user's portfolio look like and how has that changed over time? What % of a user's activity (in SOL terms) is staked, unstaked, in liquidity pools/farms, in NFTs? How has this trend changed since the start of 2022?
Neeeded Swap Volume
Oct 4, 2022 - Dashboard by PM...$6566 Question: Swap/economics: How much swap volume does THORChain need to offset emissions? (maybe a tool?) E.g if we 10x swap volume, the current block emissions can be offset by the additional fees generated from the swaps.
Overtime Markets - Volume
Aug 24, 2022 - Dashboard by PM...#6566 Question: Analyze the total volume on Overtime Markets over the past two weeks. Which games received the most activity, both in total users and total $ volume? Which sports are receiving the most bets in total dollar volume on a daily basis? Explain your findings.
Polygon vs Harmony
Jun 1, 2022 - Q1. Draw a chart comparing Polygon with Harmony on the following metrics: - Average tx_fee - Average number of transactions per hour
Do Whales Have Diamond Hands?
Jun 21, 2022 - Q12. Does the swap behavior of OSMO whales differ from everyday users? How does it differ? Create visuals showing what whales swap to and from compared to a normal Osmosis user.
Applications on Algorand
Jun 30, 2022 - Q108. How have the number of application calls changed in the first 6 months of 2022 compared to the last 6 months of 2021? Start off by looking at: -Average number of TX calls per block, day -Number of wallets making application calls Then do your own analysis that shows whether there is more or less application usage on Algorand in the first half of 2022 compared to the 2nd half of 2021.
Flow Speed
Jun 7, 2022 - Q4. One of Flow's main features is its speed compared to other blockchains. Blockchain performance can be measured as Transactions per minute. Measure the transactions per minute of Flow since May 9th and 'Successful transactions per minute' and create a chart showing how that metric has fluctuated during that time period. What types of events have raised or decreased the blockchain's performance over that time period? Are there bursts of transaction volume or interest on the chain? Compare Flow's speed to at least two other blockchains.
LP on Sushi and the Merge
Oct 3, 2022 - Dashboard by PM...#6566 Question: Analyze the behavior of Sushi MMs 2 weeks prior to and after the merge. How much capital did they withdraw? which pools/chains got affected the most? Have they redeployed back their capital? Can we say anything about their identity (Tokemak, etc)?
Solana Stables
May 18, 2022 - Track stablecoin activity on Solana since April 1st (not limited to but look into USDC, USDT, UST, USDH, UXD, PAI). What have been the flows between coins and what was the result of the UST depegging in the Solana ecosystem? What types of wallets hold a USDH, UXD, or PAI compared to a USDC and what are users doing with those coins?
USDC Transfer Volumes
Apr 14, 2022 - Q51. Compare USDC transfer volumes on Algorand, Solana, Ethereum in 2022. Chart the daily volume of USDC that is sent between wallets on each blockchain for 2022. Chart the daily # of USDC transactions that are sent between wallets on each blockchain for 2022. Find the average USDC transfer size for each blockchain in 2022. Compare the trends of USDC transfers on each chain and note your findings.