bababaoyu38
Stablecoins on Kashi
Jul 11, 2022 - Q102. Analyze the behavior of stablecoins on Kashi markets. Which ones are being deposited for lending? Which ones as collateral? Do this for both polygon and Ethereum. You can use the cross-chain sushi ez_lending and ez_borrowing. Note: Currently the polygon data is only showing the recent months. We will back-fill the data in the future. Make sure your dashboard mentions the starting date on polygon data.
Tornado Cash Addresses
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online.
ASA Dex Degens
Mar 22, 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).
Pool Ranks
Apr 9, 2022 - Q56. Visualize the TVL of each pool over time. Feel free to get creative here. Here’s some chart types to check out if you need some inspiration. https://www.google.com/search?q=multi+line+chart https://www.google.com/search?q=bump+chart We are particularly interested in how TERRA.LUNA and TERRA.UST have fared since making their debut on THORChain.
What Are Users Swapping gALGO3 For?
Apr 28, 2022 - gALGO3 is an asset that is pegged to ALGO. Users can lock their ALGO up on Folks.finance for governance and while their ALGO is locked they receive gALGO3 and you can use it for other defi activities. Read more about it here: https://docs.folks.finance/protocol-architecture/algo-liquid-governance Let’s look what users are swapping their gALGO3 for while their ALGO is locked in governance. 1) Show the number of trades to gALGO3 and from gALGO3 by day? Also chart the volume of trades to gALGO3 and from gALGO3 by day? Are there any notable days? If so, what may have caused this? 2) What DEXes are users swapping gALGO3 on? Show the breakout of number of gALGO3 swaps(to or from) by day for each dex. 4) What are the top 10 most popular to swap from to get gALGO3? 5) What are the top 10 most popular to swap to from gALGO3?
Polygon Block Performance
Jul 26, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
Top LDO Holders
Jun 1, 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?
$RUNE Movement from Crypto.com
Jun 20, 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)
What makes a Top Shots moment valuable? (Part I)
Jul 25, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.
Highest Sales Volume
Jun 11, 2022 - Q1. Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? These are transactions where someone redeems their NFTX tokens for a specific NFT. Hint: You can find these sales in ez_nft_sales. Visualize your findings.
Let's look into stablecoin data on Algorand
Jun 2, 2022 - Q96. Chart some metrics on the total supply of stablecoins on Algorand. What is the total monthly transaction volume for stablecoins on Algorand? What are the most popular stablecoins monthly? How much of the total stablecoin supply on Algorand is being lent or borrowed? How has the impact of UST’s depeg affected the flow of funds in and out of various stablecoins on Algorand?
Popular Algorand Assets To Swap On DEXes
Mar 24, 2022 - Q35. Let’s use the new Algorand.Swaps table to look at what ASAs(Algorand Standard Assets) are popular to swap for in 2022. A swap is performed on a decentralized exchange(DEX) such as Tinyman. 1) Count the number of swap_to_asset_id for each asset in 2022. 2) What are the top 10 most popular assets users have swapped to in 2022. 3) Let’s see how popular ASAs are different on each DEX based on what pools they have. Break out the most popular ASAs to swap to by DEX and create a bar chart for each DEX showing the number of swaps for each popular asset.
Open Analyitics Bounty: Arbitrum
Jul 27, 2022 - Flipside Crypto has built pathways and provides the tooling for you to develop deep and thorough crypto analysis. Now, we want to see what you can do with them. Submit any dashboard you think is worthy of being shared with our partners, and with the world. We’ll select the best for payment and amplification through our social and content channels. (Please note that many dashboards submitted to this bounty will not be rewarded with payment — only the best of the best will do here.) As you dive in and work through your analyses, we would love to see what insights you find and dashboards you develop. Feel free to submit your work via this bounty card for internal review. Elite tier work will be shared out on our social channels and to partners highlighting the analyst. Be sure to use the Arbitrum tables, which can be found under the "Arbitrum"
Open Analyitics Bounty: Arbitrum
Aug 4, 2022 - Flipside Crypto has built pathways and provides the tooling for you to develop deep and thorough crypto analysis. Now, we want to see what you can do with them. Submit any dashboard you think is worthy of being shared with our partners, and with the world. We’ll select the best for payment and amplification through our social and content channels. (Please note that many dashboards submitted to this bounty will not be rewarded with payment — only the best of the best will do here.) As you dive in and work through your analyses, we would love to see what insights you find and dashboards you develop. Feel free to submit your work via this bounty card for internal review. Elite tier work will be shared out on our social channels and to partners highlighting the analyst. Be sure to use the Arbitrum tables, which can be found under the "Arbitrum"
Magic Eden Volume Trends
Mar 13, 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?
ALGO Transaction Payment Size
Mar 31, 2022 - Q43. Let’s look at the quantities of ALGOs being sent in transactions since January 1st 2022 to see if we see any upwards or downwards trends. Group the transactions(algorand.payment_transactions) by size 0-10ALGOs, 10-100ALGOs,100-1000ALGOS, 1,000-10,000ALGOs and 10,000+ ALGOs. Count the number of transaction in each size and chart them by day from January 1st 2022 to current. Do we see any trends of increasing or decreasing payment sizes? What might this indicate for the Algorand network?
Stablecoin Pegs
May 13, 2022 - How have USD-pegged stablecoins across different chains, and with different backing mechanisms, fared through the last 5 days? Compare volume, peg stability, and any other metrics you think are relevant, and present a dashboard the summarizes your findings and conclusions.
Impacts of UST on STBL
May 19, 2022 - Q67. This week we saw the depeg of UST(a stablecoin built on Terra) and it sent shockwaves through all blockchain ecosystems causing the crypto market to crash. STBL is a 100% fully collateralized stablecoin created by the AlgoFi protocol. Let’s look at how the circulating supply of STBL was impacted by the events from May 8th to May 14th.
Let it burn!
Apr 23, 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.
Open Analytics Bounty: Avalanche
Jul 28, 2022 - Flipside Crypto has built pathways and provides the tooling for you to develop deep and thorough crypto analysis. Now, we want to see what you can do with them. Submit any dashboard you think is worthy of being shared with our partners, and with the world. We’ll select the best for payment and amplification through our social and content channels. (Please note that many dashboards submitted to this bounty will not be rewarded with payment — only the best of the best will do here.) As you dive in and work through your analyses, we would love to see what insights you find and dashboards you develop. Feel free to submit your work via this bounty card for internal review. Elite tier work will be shared out on our social channels and to partners highlighting the analyst. Be sure to use the Avalanche tables, which can be found under the "Avalanche"
Weighted-Average LP Duration
Apr 29, 2022 - What is the average duration of liquidity held in each pool, weighted by the size of the LP? Hint: use thorchain.liquidity_actions
Let’s look into wallet activity with regards to Algorand NFTs.
Jun 2, 2022 - Q95. How many active wallets are buying/selling/transferring NFTs monthly? What percent of Algo wallets hold an NFT? What’s the number of total wallets that have minted NFTs and put them up for sale, month over month and cumulatively? What projects are the most popular, generating the most transaction volume this month?
Unique Users on Algorand
Apr 7, 2022 - Q46. 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? -Chart daily unique wallets by day since February 1st for each major blockchain(Algorand, Solana, Ethereum, Terra) -Does it appear that market conditions are slowing down growth or activity on the networks?
Governance Period 2 Payouts
Apr 14, 2022 - Q49. Let's look at the Algorand Period 2 Governance Rewards Payouts
Swap Increase on May 11 + 12
Jun 7, 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!
IL Payout vs LP Age
May 8, 2022 - Show a breakdown of the average IL payout by the amount of time spent in the pool
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.
What Are Whales Swapping For?
Apr 14, 2022 - Q48. 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. Describe your methodology of what signifies a whale What percent of whales participate in swaps(use the algorand.swaps table)? Additionally show the distribution of the number of swaps per whale in 2022. What assets are whales swapping from? Display this over time starting at the beginning of 2022. What assets are whales swapping into? Display this over time starting at the beginning of 2022.
Prizes
Jun 23, 2022 - Q3. In the past 60 days, how many PoolTogether prizes have been awarded and claimed? What’s the USD value of these prices?
Bridge Users (Hop Protocol)
Jun 21, 2022 - Q1. How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
Genopets Staking
May 29, 2022 - Q78. Genopets is a move-to-earn game reminiscent of Pokemon Go on Solana. Recently, Genopets launched staking for their $GENE token (read more here https://medium.com/@genopets/announcing-gene-token-staking-1513e08ecbe). Create a visualization showing the amount of staked GENE over time. How many unique wallets have staked $GENE since its inception on May 18th? What percentage of those stakers have previously purchased a Genopets NFT? What trends are you seeing with the Genopets NFT collection?
200K ALGO Donated Toward Tree Planting
Mar 10, 2022 - Question 32: Algorand is a carbon negative blockchain and the carbon operations produce is often offset by tree planting. Gilbert the Goanna(https://algoanna001.com/) is Goanna #001 from the Al Goanna NFT collection and an organization that has planted over 40,000 trees. Recently they reached the benchmark of 200K ALGOs in donations for tree planting(https://twitter.com/Gilbertgoanna01/status/1498135551588769798).
What's going on with Optimism?
Jul 22, 2022 - What's going on with Optimism? This is an open-ended bounty, what we call a Free Square, and it’s an opportunity for you to show us what you’ve got. Any topic is fair game; The goal here is to explore the data in creative ways and show off your explorations with visualizations (or even a tool/frontend if you’ve got eyes on the grand prize).