strawbetty
Most Popular ASA To Swap From ALGOs
Apr 14, 2022 - Let’s look at what ASAs(Algorand Standard Assets) are most popular to swap into from ALGOs in 2022 using the swaps table
52 Pickup
Mar 2, 2022 - 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?
AB2 Gallery Wallets
May 25, 2022 - Q78. Let’s look at wallets that buy from AB2 Gallery! How many wallets are buying NFTs on AB2 gallery. What is the total number of unique wallets that have purchased from AB2? Create a distribution plot of how many NFTs each wallet has purchased from AB2. Are we seeing new wallets purchasing on AB2 or is it only wallets that have purchased from AB2 before? Chart the first purchase on AB2 by wallet over time. Create a table of the top 10 wallets that are purchasing from AB2 by ALGOs and number of NFTs Tips: Check out this analysis for some inspiration on how to write your queries: https://app.flipsidecrypto.com/dashboard/15-ab-2-gallery-nf-ts-77b-ew https://ab2.gallery/ Here is an asset transfer example of an asset being purchased from AB2 Gallery tx_group_id = 'wWE2i1LDwQBpKv+RGPNGcNvKm7VrmskGUyV4snkFS1w=' -To look at transfer transactions in involving AB2 Gallery use: where try_base64_decode_string(tx_message:txn:note::string) = 'ab2.gallery' NFT Statistics and Explorer: https://www.nftexplorer.app/stats
Distinct Wallets (zkSync)
Jun 17, 2022 - Q1. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
New to the Menu
Apr 9, 2022 - Q64. What are the 10 most recent assets (coins) supported by sushi?
Staking STBL on AlgoFi
Mar 10, 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
Reactor Scavenger Hunt
Apr 29, 2022 - Welcome to Reactor! We hope this Reactor Hunt is an enjoyable entry into Reactor.
Votes, Votes, Votes
Apr 21, 2022 - Q185. On average, how much voting power (in Luna) was used to vote 'YES' for governance proposals? Out of this, how much Luna comes from validators vs regular wallets?
Gain or Lose
Jun 15, 2022 - 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?
Rand Gallery Wallets
May 25, 2022 - Q77. Let’s look at wallets that buy from Rand Gallery to get a better understanding of purchasing behavior. How many wallets are buying NFTs on rand gallery. What is the total number of unique wallets that have purchased from rand gallery? Create a distribution plot of how many NFTs each wallet has purchased from Rand Gallery Are we seeing new wallets purchasing on Rand Gallery or is it only wallets that have purchased from Rand Gallery before? Chart the first purchase on Rand Gallery by wallet over time. Create a table of the top 10 wallets that are purchasing from rand gallery by ALGOs and number of NFTs Tips: Check out these analyses for some inspiration on how to write your queries: https://app.flipsidecrypto.com/dashboard/algo-rand-gallery-nft-sales-Fdtzb6 and https://app.flipsidecrypto.com/dashboard/rand-gallery-nft-sales-SYCxCf 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
Price + Circulating Supply
Jun 4, 2022 - Q3. Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
Orca + Jupiter Volumes
Mar 16, 2022 - Compare the 5 most popular swaps SOL -> coin swaps (SOL swapped for another coin) on Orca and on Jupiter since January 1st. Create a visualization showing the total volume per day on Orca and Jupiter since January 1st for SOL to another coin swaps. What has been the historical swap success rate since January 1st on Orca and on Jupiter?
Getting Started With Marinade Finance Bounties
Mar 11, 2022 - 1-How many unique wallet addresses were stake on the Marinade in March? 2-How much mSOL was deposited in the MNDE one-side pool in March?
Most Popular Jupiter Swaps
Mar 2, 2022 - Since February 1st, what have been the 10 most popular tokens to swap away? Over that same timeframe, what have been the 10 most popular tokens to swap for? What are the 10 most popular swapping pairs (combination of swap away to swap for)? Define 'popular' as the number of swaps and create a visualization showing total number of swaps over that time frame, highlighting these most popular tokens.
Tinyman Dex Popularity
Mar 23, 2022 - Q36. Tinyman was Algorand’s first DEX(decentralized exchange) and in 2022 we’ve seen the launch of three other DEXes: pactFi, algoFi, and Wagmiswap. Let’s look at the launch of these other DEXes and see how they have impacted the number of swaps on Tinyman. Chart the number of swaps by day for each DEX in 2022. Note when the swaps started for each PactFi, AlgoFi, and Wagmiswap and describe whether we see a change in the number of swaps on TInyman after the launch of the other DEXs. Tips: Make sure the swap_from_amount is greater than 0 to make sure it is a swap and not a slippage transfer from a swap
Kujira Scavenger Hunt (April 8)
Apr 9, 2022 - navigate the liquidation seas through Kujira.
Algorand NFT Shuffle Hunt
Jun 30, 2022 - opportunity to experience the Algorand NFT space by participating in two NFT shuffles
"Small" LP Actions
Apr 8, 2022 - What percent of LP adds to each pool are small (<$1k USD)? Is there a relationship between the chain and the proportion of “small” LPs?
Gas as a proxy of activity
Jun 4, 2022 - Q89. How much did sushi users pay for gas in 2022? Is there a correlation with the price of ETH? Can you comment on the spikes in the chart?
L1 Unique Users
Mar 16, 2022 - Question 37: Compare the number of unique wallets that have sent a transaction since February 1st on Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Solana compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?
Transaction Failure
Mar 19, 2022 - Q169. Make reference to this tweet: https://twitter.com/alphaDefi_/status/1504522066674003972/photo/1 Establish the failed transaction rate for Terra over a time period of your choosing. Is this analysis correct? Additionally, make a case for what is causing the failure transaction rate you assess, and provide recommendations to mitigate it.
ETH Staked
Jun 15, 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?
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.
Ecosystem Anchor
Mar 16, 2022 - Create a graph to show either: a) the token price (over a time period of your choosing) OR b) a bubble chart with total value locked, for all the Terra projects that depend on Anchor to create their yield.
GMT Airdrop
Mar 19, 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.
ASA Dex Degens
Mar 23, 2022 - Q38. Let's look at DEX wallet behavior with the algorand.swaps table to get an idea of how many swaps wallets are being conducted and see how many ASAs wallets are trading. Chart the distribution of the number of swaps wallets have conducted in 2022(Count the number of swaps a wallet has performed create a distribution of these wallets). Chart the distribution of the number of ASAs a wallet has swapped for (Count the number of assets a wallet swapped for and create a distribution of the number of assets per wallet). Tips: Make sure the swap_from_amount is greater than 0 to make sure it is a swap and not a slippage transfer from a swap.
Uniswap on Polygon Scavenger Hunt
Feb 12, 2022 - swap MATIC to WETH and Show my transaction adding MATIC and WETH into the MATIC/WETH liquidity pool
The Road So Far, Mvmt. I: Validators
Mar 16, 2022 - As the bounty program nears its one year anniversary, it's time for a recap. We'll start with a handful of the most important topics in crypto: decentralization, network security, and governance. Review all the Terra submissions to date that discuss validators and delegators. Provide a brief summary of what we have learned so far, via various bounties, about Terra's validator network. Definition: Select at least 3 metrics or charts (your own, or those belonging to past submissions); credit the original source; and update any charts or queries you use to cover the present day.
Monthly Swap Volume
May 7, 2022 - Show the total monthly swap volume on ParaSwap over the past year. How has the swap volume changed over time? Which DEX’s is most of the swap volume coming from?
Unique Users on Algorand
Apr 7, 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?
Terra Scavenger Hunt (Farsi)
Feb 11, 2022 - در این داشبورد من تراکنش های دلیگیت کردن خود به فلیپساید را نمایش می دهم
Where’s The Pot of Gold?
Mar 18, 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.
Magic Eden Volume Trends
Mar 16, 2022 - Create a visualization of Magic Eden total sales volume per day since January 1st. How has sales volume trended over time? Are there any trends to when sales volume seems to go up or down on certain days of the week or during certain times of the day? Are users more likely to trade a NFT during the week or the weekend?