NILOOZH
What Are Whales Swapping For?
Apr 14, 2022 - Let's look at the whales are swapping for on the DEXes. First, identify current whales with the balance field in the algorand.account table.
Whale voters
Feb 16, 2022 - For whale voters*, how many of them have voted in at least one Terra/Anchor/Mirror governance vote in the past 90 days? What is the percentage of whales who have voted?
Voting Records
Jan 20, 2022 - Select two Terra Validators of your choice and compare their voting history (governance votes). BONUS: Can you find any proposals where your chosen validators voted differently? Why do you think this might be the case?
Yet Another Acme Question
Apr 16, 2022 - Refer to submissions for #175 - your own, or those of others. Pick your favorite Terra metric or visualization and recreate your own version. Your SQL can be similar or even identical to the original, but you should put your own narrative and explanation. Why is this metric/visualization your favorite? If you improved it, what changes did you make?
Solana - StepN Growth
Mar 2, 2022 - StepN is a Solana-based ""move-to-earn' game (you earn the game's native token GST by moving around using their NFT sneakers and GPS system). The game has seen steady growth in popularity since it launched at the end of December (transitioned from a private beta mode to its current public mode).
Around & Around We Go (Circulating Supply)
Feb 24, 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.
Deposits vs. Borrows volume
Jan 18, 2022 - question : Select a time period (minimum 1 month). Using visuals, compare borrow volume and deposit volume over that time period. BONUS: What relationship can you identify between borrows and deposits? What might be driving this relationship?
Solana - vote
Feb 17, 2022 - Create a visualization that compares the number of non-vote transactions to vote transactions per block since the start of February. What is the average ratio of votes to non-votes in a block? Have there been any timeframes of noticeable fluctuations of this ratio?
UST Competitive Advantages
May 5, 2022 - Why would a user choose to transact using UST over DAI (and vice versa)?
Getting Started With Solana Bounties (Farsi)
Feb 18, 2022 - . در این دشبورد من تمام استیک ها را در طول روزی که من در مرینید استیک کردم را در یک چارت نشان داده ام
Terra Altcoin Behavior
Feb 7, 2022 - Question 143: Select a Terra “altcoin” (i.e. not LUNA/ANC/MIR) and assess their performance over the past 90 days, using a metric of your choice (examples: price, number of transactions, volatility.) What do you think are the prospects for your chosen altcoin?
Anchor Ecosystem
Mar 21, 2022 - Create a graph to show the token price (over a time period of your choosing) for all the Terra projects that depend on Anchor to create their yield.
Yieldly HDL Distribution Pool Exploit
Mar 25, 2022 - Q37. At the beginning of March, Yieldly announced they had found wallets abusing the HDL Distribution pool (https://twitter.com/YieldlyFinance/status/1500060434296033282?s=20&t=reW0nw6ggkQy5acX540UWA).
Pact Fi Scavenger Hunt
Jun 27, 2022 - I have successfully swapped and created an LP pair on Pact Fi!
Solana Outages
Jun 7, 2022 - Q82. Solana experienced another outage on 6/1 where validators were forced to restart the network. The network experienced a similar problem back on 5/1. After the restart happens during these outages, how do users on the network generally respond?
USDC Deposits
Jun 22, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
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?
Folks Finance: Minting gALGO3 For Governance
Apr 21, 2022 - Q53. Folks Finance is a newly launched lending and borrowing protocol built on Algorand. They offer a unique liquid Algorand governance opportunity which allows you to still utilize your ALGOs in in the form of gALGO3 a token you mint when you deposit your ALGOs into their governance pool.
Anchor Collateralization
Feb 3, 2022 - How much of the collateral provided on Anchor is bLUNA vs. bETH? How has this changed over the past 90 days?
January 2022 New Wallets Created
Feb 14, 2022 - In January 2022, we see a surge in new wallets created. Were these new wallets interacting with any assets in particular? Were there any patterns in the amount of Algos these wallets held?
52 Pickup
Mar 2, 2022 - Terra Q153: 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?
Where’s The Pot of Gold?
Mar 22, 2022 - What % of the bAsset market cap for bLUNA and bETH is locked as collateral on Anchor? Show where else bLUNA/bETH is being held, and explain why you think this is.
SOL Swaps on Jupiter
Feb 20, 2022 - 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 been 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.