![KowalskiDeFi | Flipside Analyst KowalskiDeFi | Flipside Analyst](https://res.cloudinary.com/dsr37ut2z/image/upload/w_1200,f_auto/v1677184713/g1jvkpfu4f18z2wwmyih.jpg)
KowalskiDeFi
StarkWare Scavenger Hunt (July 16)
Jul 17, 2022 - Overview By the end of this tutorial, you should be able to… 1. Install a StarkNet wallet 2. Acquire GETH 3. Swap tokens via myswap
![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
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
Active Wallets on Terra
May 1, 2022 - Define "Active Wallets" on Terra. Based on your definition, display the active wallets by day, month, and Year-To-Date in 2022.
![USDC Transfer Volumes USDC Transfer Volumes](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
USDC Transfer Volumes
Apr 12, 2022 - Compare USDC transfer volumes on Algorand, Solana, Ethereum in 2022.
![Where’s The Pot of Gold? Where’s The Pot of Gold?](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Where’s The Pot of Gold?
Mar 22, 2022 - Question: 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.
LUNA Total Supply
May 8, 2022 - Display the LUNA Total Supply and LUNA non-circulating supply over 30, 60, 90 days and one year. Compare your solution to at least one other data benchmark, e.g. Smart Stake, Terra Station, CoinMarketCap. Hint: Make reference to [TerraDash](https://terradash.vercel.app/) for the latest circulating supply figures to aid your analysis). Hint #2: Feel free to rely on the Discover page to draw on past analysis to inform your answer.
LUNA Market Cap
May 7, 2022 - Back to basics! Display the LUNA price and market cap trend over 30, 60, 90 days; the past year; and all time.
Distinct Wallets (Optimism Bridge)
Jun 15, 2022 - How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days?
USDC Deposits
Jun 22, 2022 - In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
![Deposit rate from L1s Deposit rate from L1s](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Deposit rate from L1s
Jun 13, 2022 - Look at users swapping from native L1 assets to $RUNE. Are there any trends by each chain or over time?
Highest Sales Volume | NFTx
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.
Daily stETH Metrics
Jun 6, 2022 - Find the following stETH metrics: - Daily volume of stETH? - Average stake size? - Number of stakers over time? - Average time staked? - Staking/unstaking per day?
$THOR Staking
May 21, 2022 - This Investigation contains 2 bounties: 1. $THOR Staking Wallets 2. Net $THOR Staked
![Kujira Hunt Kujira Hunt](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Kujira Hunt
Jan 28, 2022 - https://finder.terra.money/mainnet/address/terra1n75w4sv2nzja9ex3y3h3hzr4kuukrwzmlnjkmw
Thorchain: Distribution of Swaps in $RUNE and $ Values
Sep 2, 2022 - Show the distribution of swap sizes in both $RUNE and $, both for all pools as well as broken down by pool
![Transaction Failure Transaction Failure](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Transaction Failure
Mar 23, 2022 - Question: 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.
Pooly NFTs
Jun 22, 2022 - How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
![UST Competitive Advantages UST Competitive Advantages](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
UST Competitive Advantages
Apr 29, 2022 - Why would a user choose to transact using $UST over $DAI (and vice versa)?
![Fuse Pool - Rari Capital Fuse Pool - Rari Capital](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Fuse Pool - Rari Capital
May 23, 2022 - In this investigation, we'll look at the USDC and DAI PoolAllocation in the Fuse Pools of Rari Capital. We will be looking at # of Transactions as well as the Total and Average amount in $ allocated. NOTE: This investigation looks at the Allocation all time and does not take into account withdrawals
Bad Actors and "Growth Hacks"
Mar 9, 2023 - In this investigation, we'll look at how a "bad actor" looks, typical schemes employed by such actors and why dApps like these should be weeded out as quickly as possible, so real innovators in the space can get recognised instead and in a more timely manner!
![Swaps to $THOR Swaps to $THOR](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Swaps to $THOR
May 28, 2022 - On May 4th, $THOR staking was enabled that yielded rewards for stakers based on THORSwap volume. 1. Did we see a spike of swaps to $THOR around that time? 2. Has there been any noticeable change in $THOR swapping since that event?
![The Rainbow Bridge The Rainbow Bridge](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
The Rainbow Bridge
Jul 13, 2022 - Q2: Every city has its monuments, as well as its transit systems. In the City of NEAR, the legendary Rainbow Bridge is an object of great importance to the people: a wondrous object that enables passage to and from other cities. Visualize the Bridge’s activity over the past 90 days, using an activity metric of your choice (in your Methodology section, clearly define your chosen metric). As well, analyze the Bridge usage via at least 3 clearly defined metrics of your choosing (examples: volume, TVL, change in TVL over time, number of repeated trips vs. one-time users, origin and destination).
![Validator Pageant Validator Pageant](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Validator Pageant
Mar 11, 2022 - Question: Select one validator outside the top 10 and make a case for why newcomers to Terra should delegate to that validator. Define any metric of your choosing that marks a good validator (airdrops, voting, community benefits, uptime); assess the average for the full set of ~130 validators (i.e. if you pick airdrops, assess how many of them offer an airdrop); and assess how your chosen validator performs based on that metric.
![Market Volatility II Market Volatility II](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Market Volatility II
May 24, 2022 - Analyze the effects of the recent spike in market volatility on the sushi token. 1. What was the supply and demand dynamic for it? 2. What did the liquidity of SUSHI on uniswap and sushiswap look like? 3. How about the staking situation for SUSHI? - Did many SUSHI’s get unstaked?
![How Relevant is Justin Sun? How Relevant is Justin Sun?](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
How Relevant is Justin Sun?
May 2, 2022 - Justin Sun has recently announced an algorithmic stablecoin, USDD, with a 30% yield. Sun has announced plans to backstop USDD with $10B of crypto as collateral, matching the Luna Foundation Guard (LFG). Do a deep dive, conduct research, and provide a well-researched conclusion to the burning question: - Is Justin Sun for real? - Is USDD likely to accrue significant backing? - How will its 30% offering fare over time?
![Lido's stETH: Use cases in DeFi & stETH vs ETH Lido's stETH: Use cases in DeFi & stETH vs ETH](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Lido's stETH: Use cases in DeFi & stETH vs ETH
Jun 3, 2022 - What are users doing with stETH from Lido? How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
![Bot Activity Bot Activity](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Bot Activity
May 17, 2022 - Create a way of identifying bots within THORChain (could be something like a certain number of swaps/day made). - What % of the swaps and swap volume are made by bots? - Are there certain strategies you can see them employing (most of them are likely arbitrage bots)? - Are there many bots or mainly just a few that conduct a high % of bot activity?
![Sushiswap DEX Loyal Users Sushiswap DEX Loyal Users](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Sushiswap DEX Loyal Users
May 11, 2022 - Rank wallets that used SushiSwap based on the number of trades and the number of days they used the DEX. How many users keep coming back to the platform? Use different frequencies for the ranking: Last month, Year to date and since inception
![Avalanche Block and Transaction Performance Avalanche Block and Transaction Performance](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Avalanche Block and Transaction Performance
Jun 26, 2022 - Flipside has Avalanche data! It's now time to start digging into the blockchain's performance at a high level. Avalanche supports quick block finality and high TPS, can we see this in block and transaction performance since 6/20?
![Total Metamask Users Total Metamask Users](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Total Metamask Users
Jun 25, 2022 - How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher-order activity, like staking?
!["Small" LP Actions "Small" LP Actions](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
"Small" LP Actions
Apr 7, 2022 - Q55. What per cent of LP adds to each pool is small (<$1k USD)? Is there a relationship between the chain and the proportion of “small” LPs? We're particularly curious to know if chains with low gas fees (like Terra) have a larger proportion of small LPs than chains with high gas fees (like Ethereum). Hint: use thorchain.liquidity_actions