![princefarzam | Flipside Analyst princefarzam | Flipside Analyst](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/backgrounds/analyst-bg.png)
princefarzam
Open Analytics Bounty: Avalanche (August 8)
Aug 12, 2022 - In this dashboard, I take deep dive into BENQI's Liquid Staking Protocol on Avalanche
![Privacy Coins + Politics Privacy Coins + Politics](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Privacy Coins + Politics
Jun 11, 2022 - Q10. Do major news events result in more people swapping to SCRT? :Look at the volume of swaps to SCRT over the past three months. Do periods of high volume swaps into SCRT line up with major international news events? Or is there a pattern in SCRT swap volume?
![Hot Contracts on Osmosis Hot Contracts on Osmosis](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Hot Contracts on Osmosis
Jul 12, 2022 - A lot of new contracts are being deployed on Osmosis lately. Since the beginning of May, What are the top ten most popular contracts on Osmosis? What is the cumulative total of contracts launched on Osmosis, and have there been any spikes since the Terra crash or other noteworthy events?
![ERC20 Tokens (zkSync) ERC20 Tokens (zkSync)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
ERC20 Tokens (zkSync)
Jun 17, 2022 - Q2. Users can also deposit ERC20 tokens into ZkSync. Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings.
New Wallets In May
Jun 16, 2022 - Q101. How many new wallets were created in May? What % of total wallets with more than 1 ALGO is this? Additionally, show the distribution of ALGO holdings for these new wallets. What is the average ALGO holding of these new wallets? What other ASAs do these new wallets from May hold? How many of these wallets have performed a swap? Finally, note anything else interesting about these wallets! Why are these wallets being created and what are they doing on Algorand?"
![Velodrome Locks Velodrome Locks](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Velodrome Locks
Jul 17, 2022 - Analyze new locks created on Velodrome Finance. What durations are most common? Which wallets have locked the most in the last 4 weeks? Which pools are wallets voting for with their locked tokens most often?
Terra - 3. Terradash Part 1: Activity
Dec 7, 2022 - create a dashboard that displays the following metrics. Identify any trends or outliers that you see. Transactions, Average Transaction Fee per txn per week, Total Transaction Fees per week, Total number of transactions per week, Average transactions per second (TPS) per week, Average block time per week, Wallets, Total number of new wallets per week, Total number of active wallets per week, Only include senders who initiate transactions, Cumulative number of new wallets per week.
Orca User Growth
May 21, 2022 - Q76. Orca, a popular decentralized exchange on Solana seems to have been gaining significant adoptions over the last few months, especially compared to other exchanges. Create a visualization showing Orca adoption in terms of swap volume and number of unique wallets compared to at least two other popular Solana exchanges and Uniswap on Ethereum? What can explain this increase in adoption? Provide some insights on this trend and the types of users using Orca (hint look into which popular app on Solana is using Orca).
![Raydium Swaps Raydium Swaps](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Raydium Swaps
Apr 3, 2022 - Q44. Create a visualization comparing the quantity of swaps and number of unique wallets on Rayidum, Jupiter, and Orca since January 1st. What have been the ten most popular tokens to swap and swap for on Raydium during that time period? What tokens have become more popular over time?
![Wildlife Warriors NFT Drop Wildlife Warriors NFT Drop](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Wildlife Warriors NFT Drop
Jun 23, 2022 - -Look at when the wallets were created(created_at) that own a wildlife warrior. Were wallets created recently for the drop or are they more established wallets? -Look at the ALGO balances of wallets that own a wildlife warrior and show the distribution balances -Look at how many Wildlife Warriors each wallet holds. -Is there a correlation between how many Wildlife Warriors a wallet holds and their ALGO balance?
![Solana TPS Solana TPS](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Solana TPS
Feb 22, 2022 - This dashboard aims to measure Solana's TPS in February (non-votes) and 'Successful TPS' per day and create a chart showing how TPS has fluctuated during that period.
![Terra Altcoin Behavior Terra Altcoin Behavior](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Terra Altcoin Behavior
Feb 10, 2022 - In response to: 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?
User Behavior
Jun 20, 2022 - Q11. What are users swapping for? What activities are the most common for users on Flow right now? Create a visualization on what’s causing spikes in swapping behavior.
Smart Money NFT Traders
Jun 8, 2022 - Q81. Which wallets have made the most SOL off NFT mints and NFT trades since the start of the new year? What types of actions have led to being a profitable NFT trader on SOL? Is there a pattern behind their NFT trading strategy and can you define some of these traders as "smart money"? Do you think you need to be a "whale" to do well trading SOL NFTs, or can anyone have success in this market?
![Phantom Wallet Growth Phantom Wallet Growth](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Phantom Wallet Growth
Feb 9, 2022 - In response to: Question 5:This week, Phantom (the most popular wallet in the Solana ecosystem) released its mobile app. There is an expectation that this will gradually increase adoption. Track and visualize at least two metrics to compare growth in Solana activity in the start of February (when Phantom mobile launched) to the month of January.
![Anchor Scavenger Hunt(English) Anchor Scavenger Hunt(English)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Anchor Scavenger Hunt(English)
Jan 28, 2022 - In this Scavenger Hunt, I learned how to work with anchor protocol and how to deposit UST and mint aUST. At the end of this Hunt I Use the Anchor Interest Calculator to see how much interest I've accrued, The Total Interest Earned was 0.03 UST. Thanks to The Flipside team for helping us to grow up in the blockchain field.
Top TOKE Holders
Jun 22, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
![Getting Started With Solana Bounties Getting Started With Solana Bounties](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Getting Started With Solana Bounties
Feb 17, 2022 - Answering to Visualize the number of transactions that staked SOL into Marinade Finance during the hour you staked SOL into Marinade, and also highlight your specific staking transaction.
Swaps to $THOR
May 29, 2022 - Q100. On May 4th, $THOR staking was enabled that yielded rewards for stakers based on THORSwap volume. Did we see a spike of swaps to $THOR around that time? Has there been any noticeable change in $THOR swapping since that event?
![Marinade's Non-fungible Chefs Marinade's Non-fungible Chefs](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Marinade's Non-fungible Chefs
Apr 22, 2022 - Q55. Create a bar chart illustrating the pace of minting activity since the launch on April 4, 2022. Create a pie chart showing the distribution of Chef NFTs by Level (as outlined above). How many whales (L5) are out there, ready to participate in governance?
![Wormhole Hunt Wormhole Hunt](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Wormhole Hunt
Jan 12, 2022 - This Scavenger was so helpful for me. I discover the wormhole from the terra and Solana perspective. I wish to search through it more in the future, esp from polygon and Binance smart chain blockchain.
![Tracking USDH Tracking USDH](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Tracking USDH
Apr 19, 2022 - Q57. Track where USDH is being used the most on other Solana defi protocols. What are the most popular pools where users are depositing USDH? Why do you think wallets are choosing to interact with those protocols with USDH? What tokens is USDH most commonly swapped for? What are some ways that USDH can become more adopted within the Solana ecosystem?
Distinct Wallets (Optimism Bridge)
Jun 17, 2022 - Q1. How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
![LoftyAI Tokenized Real Estate LoftyAI Tokenized Real Estate](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
LoftyAI Tokenized Real Estate
Mar 4, 2022 - Rank the properties listed by LoftyAI based on total token investment price. How many wallets have bought a token for at least one property? What wallet has invested in the most Lofty AI properties? How many properties are they invested in?
StarkWare Scavenger Hunt
Jun 25, 2022 - Install a StarkNet wallet Acquire GETH Swap tokens via myswap
The Battle of the Solana NFT Aggregator
Oct 30, 2022 - A new sector of NFT marketplaces have begun to gain popularity on Solana, the NFT AMM. One of the most notable NFT AMMs on Solana so far is Hadeswap. Hyperspace and Coral Cube are the two most popular NFT aggregators on Solana. This means that they list all NFTs across different marketplaces along with allowing listings on their own marketplace. Create a dashboard comparing KPIs between Hyperspace and Coral Cube. Which marketplace has done more volume? Which collections are popular on each marketplace? Why would I use one marketplace over the other? Are there any noticeable market trends between the marketplaces, especially after Solana marketplaces moved to a 0% creator royalty?
Algorand Free Square [LoftyAI Tokenized Real Estate]
Jun 30, 2022 - Rank the properties listed by LoftyAI based on total token investment price. How many wallets have bought a token for at least one property? What wallet has invested in the most Lofty AI properties? How many properties are they invested in?
![Nebula Scavenger Hunt Nebula Scavenger Hunt](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Nebula Scavenger Hunt
Apr 28, 2022 - Show your transaction of either swapping for NEB or staking your NEB.
![Lockdrops Keep Fallin' On My Head Lockdrops Keep Fallin' On My Head](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Lockdrops Keep Fallin' On My Head
Jan 22, 2022 - In response to: Explain, in your own words, what a “lockdrop” is. Choose a metric for ASTRO tokens (price, circulating supply, amount sold vs. HODL) and display it visually over a time period of your choosing.
Voting Activity
Jun 19, 2022 - Q1. The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
![Sushiswap Bentobox Scavenger Hunt Sushiswap Bentobox Scavenger Hunt](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Sushiswap Bentobox Scavenger Hunt
Mar 24, 2022 - Show us your limit order and trade executing using your txn_hash.
wETH Deposit Rate
Jun 14, 2022 - Q11. Calculate the deposit rate of wETH over time on Osmosis. How does this compare to SushiSwap and Thorchain now? How does the wETH deposit rate compare to when wETH was a relatively new asset (or the protocol was relatively new)? Is Osmosis growing at a faster rate than Thorchain and Sushiswap?
![curve curve](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/project-icons/curve.png)
Osmosis Scavenger Hunt
Jun 20, 2022 - In this dashboard, the below steps were done: 1. Sending ATOM to keplr wallet, then deposit it into Osmosis. 2. Swap Atom to Osmo in OSMOSIS DEX 3. Provide liquidity for ATOM/OSMO Pool 4. Superfluid staking
![Getting Started With Terra Bounties (Vietnamese) (March 24) Getting Started With Terra Bounties (Vietnamese) (March 24)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Getting Started With Terra Bounties (Vietnamese) (March 24)
Mar 25, 2022 - khám phá dữ liệu Terra bằng cách tìm các giao dịch cụ thể, nhóm chúng và trực quan hóa chúng theo thời gian.
![Getting Started with Anchor Bounties Getting Started with Anchor Bounties](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Getting Started with Anchor Bounties
Jan 28, 2022 - In response to how to explore Anchor data by finding specific transactions, grouping them, and visualizing them over time.
![143. Liquidity Space Voyage / Mini-Terra Tutorial 143. Liquidity Space Voyage / Mini-Terra Tutorial](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
143. Liquidity Space Voyage / Mini-Terra Tutorial
Feb 3, 2022 - In response to: Since the launch of Astroport, many have moved their liquidity from Terraswap pools to Astroport pools. Plot the total value of TVL that might have moved from Terraswap to Astroport for the LUNA/bLUNA pair by showing the total withdrawals from Terraswap and deposits to Astroport since Astroport launched.
![Wormhole Scavenger Hunt (Vietnamese) Wormhole Scavenger Hunt (Vietnamese)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Wormhole Scavenger Hunt (Vietnamese)
Jan 13, 2022 - Wormhole is a bridge for sending tokens from one blockchain to the other. In this scavenger hunt I learned how to send Luna from terra station and redeemed in Solana ecosystem.