![adriaparcerisas | Flipside Analyst adriaparcerisas | Flipside Analyst](https://res.cloudinary.com/dsr37ut2z/image/upload/w_1200,f_auto/v1675969877/b0saffzk027jj6wlpxzs.jpg)
adriaparcerisas
![ALGO Transaction Payment Size ALGO Transaction Payment Size](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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?
![Orca User Growth Orca User Growth](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Orca User Growth
May 25, 2022 - Orca, a popular decentralized exchange on Solana seems to have been gaining significant adoptions over the last few months, especially compared to other exchanges. In this dashboard we are gonna analyze the activity on it over the past months.
![Angel Protocol Validator Rewards Angel Protocol Validator Rewards](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Angel Protocol Validator Rewards
Dec 23, 2021 - Assess the US dollar value of rewards generated from the Angel Protocol validator, over time and cumulative. Provide your assessment of the donations sent from Angel's validator, and forecast what additional validator-driven donations might look like over the next year.
![When Do Flow Transactions Fail? (Part II) When Do Flow Transactions Fail? (Part II)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
When Do Flow Transactions Fail? (Part II)
Jun 7, 2022 - 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?
![Unique Programs Unique Programs](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Unique Programs
Feb 10, 2022 - One way to track developer growth in an ecosystem is through the number of unique contracts used. Create a visualization of the number of unique programs used per day since the beginning of January. What are the 5 most commonly used programs over that timeframe? What do those programs do and why do you think they are so popular?
![RUNE price vs Swapper activity RUNE price vs Swapper activity](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
RUNE price vs Swapper activity
Oct 29, 2021 - We are gonna analyze if there is a relationship between rune price and trade volume.
![FLOW Usage During the NBA Playoffs FLOW Usage During the NBA Playoffs](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
FLOW Usage During the NBA Playoffs
Jul 10, 2022 - Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume. What about NBA Top Shots?
![The most bLUNA drifted vs LUNA price in a 30 second window The most bLUNA drifted vs LUNA price in a 30 second window](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
The most bLUNA drifted vs LUNA price in a 30 second window
Oct 21, 2021 - Today we will solve the task about what is the most bLuna has dipped in a X second window (based on bLuna price oracle timing), focusing on the events of the Black swan event in mid-May.
![Inflows and outflows to and from Flipside's Terra validator address
Inflows and outflows to and from Flipside's Terra validator address](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Inflows and outflows to and from Flipside's Terra validator address
Oct 26, 2021 - In this dashboard, we will visualize the in and outflows to and from Flipside's Terra validator address.
![Sushimaker Sushimaker](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Sushimaker
Apr 27, 2022 - Ever wondered why you generate yield by parking your SUSHI's in the sushibar? Then, this post is of your interest because we are gonna analyze the role of Sushimaker serving tokens to Sushibar to being used for the users Sushi staked on Sushibar.
![Weighted-Average LP Duration Weighted-Average LP Duration](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Weighted-Average LP Duration
May 3, 2022 - What is the average duration of liquidity held in each pool, weighted by the size of the LP?
![wETH & wBTC On- and Off- Ramps wETH & wBTC On- and Off- Ramps](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
wETH & wBTC On- and Off- Ramps
Jun 7, 2022 - On the Osmosis Frontier, there are pools for wETH and wBTC. How do users respond and change their position in these pools in response to governance proposals involving extra incentives for these pools? Do their deposits and withdrawals of wBTC and wETH onto Osmosis change as well?
![DIY Algorand New User Bounty DIY Algorand New User Bounty](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
DIY Algorand New User Bounty
Mar 24, 2022 - Q39. Build a step by step guide for beginner analysts to teach them about sql and how to make visualizations in the Flipside Velocity app. The documentation should have the sql code explaining the functions used and also explain the crypto currency terms and why they are important. Incorporating how to use the tips given in data exploration is encouraged. The questions to be answered are: Let's look at the popularity of centralized exchanges(CEX) when it comes to Algorand. Chart the volume of ALGOs moved to each CEX by day since the beginning of 2021. Chart the volume of ALGOs moved from each CEX by day over time since the beginning of 2021. Tips: Use the Algorand Labels Table to identify CEXs Use the payment transaction table to identify ALGOs being sent to CEXs and from CEX The two questions above have been bountied. Here are some of the top scored submissions. https://app.flipsidecrypto.com/dashboard/most-popular-centralized-exchange-for-algorand-wallets-t097TI https://app.flipsidecrypto.com/dashboard/most-popular-centralized-exchange-for-algorand-wallets-mWNnP- https://app.flipsidecrypto.com/dashboard/most-popular-centralized-exchange-for-algorand-wallets-HyePVX https://app.flipsidecrypto.com/dashboard/most-popular-centralized-exchange-for-algorand-wallets-PiSI-I Example Step by Step Guides: https://www.notion.so/teamflipside/Terra-New-User-Bounty-Walkthrough-310a3597050542d2b15de82c63fb9683 https://www.notion.so/teamflipside/ALGO-New-User-Bounty-Walkthrough-4f73a2aaa33c41938d3d499a170b6cb5
![47. DOGE Debut 47. DOGE Debut](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
47. DOGE Debut
Feb 1, 2022 - Dogecoin was added to the THORChain network last week. What was the $DOGE swap volume in the first 24 hours after it was added? How does that compare to other tokens in their first 24 hours listed on THORChain? Which token had the highest swap volume in its first 24 hours on THORChain?
![Stargate TVL Metrics Stargate TVL Metrics](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Stargate TVL Metrics
Apr 27, 2022 - In this dashboard we are gonna see the total value locked (TVL) on Stargate platform in Ethereum network and what percentage of the TVL is made up by each token staked.
![Wen SUSHI moon? Wen SUSHI moon?](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Wen SUSHI moon?
Dec 25, 2021 - Explain to someone with little knowledge of the crypto world whether the Sushi token is a good investment or not.
Active Daily Wallets
Mar 3, 2022 - Algorand Q30: 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?
![Distinct Wallets (Optimism Bridge) Distinct Wallets (Optimism Bridge)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Distinct Wallets (Optimism Bridge)
Jun 17, 2022 - Many blockchain bridges exist allowing users to move assets between different blockchains. One of the blockchains currently receiving a lot of bridge volume is Optimism. There are several bridges you can use to move tokens to Optimism, but for this bounty we are particularly interested in Optimism’s bridge. In this dashboard we are gonna track the number of deposits and removers over the past 60 days on Optimism.
WETH/THOR Pool
Sep 12, 2022 - ThorSwap just recently partnered with Sushiswap to create an Onsen farm for ETH-THOR LP providers to stake their liquidity to earn extra rewards. Previously ThorSwap offered their own contract for the same purpose but this switch allows for higher rewards as well as lower slippage for the users.
![16. Algorand Assets Using Account Asset Table 16. Algorand Assets Using Account Asset Table](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
16. Algorand Assets Using Account Asset Table
Feb 4, 2022 - Lets explore the Account Asset Table and look at popular ASAs(assets) being held in the Algorand ecosystem: Using the Account Assets Table what are currently the top 10 most popular assets to hold outside of Algos?(Do not include any assets that include Pending Props in the name) For these top 10 assets lets map when they were added to users wallets over time? Create wallet holding distribution charts for 3 of the biggest projects in the Algorand Ecosystem: Yieldly, Opulus, SmileCoin.
![Terrarbitage, Part 1 Terrarbitage, Part 1](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Terrarbitage, Part 1
Dec 14, 2021 - Fluctuations in the bLUNA/LUNA pool allow for arbitrage opportunities for users to gain more LUNA. Explore the potential yield (APY) from arbitrage in the pool.
![Governance Period 1 Breakdown Governance Period 1 Breakdown](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Governance Period 1 Breakdown
Jan 13, 2022 - For governance period one, what was the voting breakdown? How did this change by the size of the algo wallet? How does this change by number of algos committed?
![Impacts of UST on STBL Impacts of UST on STBL](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Impacts of UST on STBL
May 19, 2022 - 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’s look at how much STBL was borrowed and how much repaid during the volatile week? What assets were swapped for STBL? Was there more swap volume into or out of STBL? Did we see a one to one swap swap volume with USDC? If not, why not? Were there certain trades causing this discrepancy? Look at actions regarding STBL such as staking on AlgoFi.
![Levana analysis: NFTerra Continued Levana analysis: NFTerra Continued](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Levana analysis: NFTerra Continued
Dec 18, 2021 - Using at least one data visualization and one metric of choice, analyze your favorite Terra NFT project over a time period of your choice. Using on-chain data to support your answer, explain why you think this project has strong potential in 2022.
![Solana Secondary NFT Market Dashboard Solana Secondary NFT Market Dashboard](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Solana Secondary NFT Market Dashboard
Mar 1, 2022 - This dashboard intends to provide an overview of the current market for NFTs in Solana. The idea is that readers can have at their disposal a tool to see the current volume of NFT sales, which are the most popular secondary markets, as well as to see other metrics such as the number of users, the average price per sale of NFTs, etc.