jackguy
Getting Your Feet Wet, Part 1
Mar 5, 2022 - Question 160: Make a table containing wallet addresses whose first transaction was 90 days ago or less. Analyze how active they have been since that first transaction, based on either 1) the number of transactions; 2) the number of protocols interacted with, or 3) the number of different types of transactions undertaken. (deposit, delegate, vote)
Wallet Amounts By Pool
Feb 5, 2022 - Question 36: Show the average USD wallet value for users in one liquidity pool on Sushiswap. Do the same for users in two, and three liquidity pools. Are there any trends?
Was the ENS airdrop a secret?
Dec 11, 2021 - look at ENS registrations before and after the cutoff date for the airdrop. Do you notice anything suspicious that makes you think that some people knew the airdrop was coming?
Wealth Equality
Dec 4, 2021 - What is the wealth distribution for UST? Relying on at least two metrics* of your choice, how equal/unequal is this distribution? Good answers will go a step beyond balance summaries. In other words: don’t just tell us how much UST a given pool contains, e.g. $PSI-UST, but assess UST’s distribution by staking address.
Staking GARD on Algostake
May 22, 2022 - Let’s look at how many wallets have staked GARD to earn GARDIAN. The average amount staked by wallet. And the amount of Gardian redeemed each day through the staking pool. Do we see any of the wallets that received the Gardian from the referral airdrop also staking GARD on Algostake? If so, what percent of wallet's received the Gardian airdrop and staked GARD on algostake? Note any other interesting findings!
Astroport Rewards Analysis
Apr 19, 2022 - How much ASTRO is allocated for rewards? What percent is currently being used and how is this changing over time? Focusing on users with a large amount of ASTRO rewards, what are these users doing with their rewards? Are these same users providing liquidity to Astroport pools?
Will I actually get liquidated though?
Nov 6, 2021 - Because of high gas prices, positions that could be liquidated are sometimes not as the expense to do so would not cover the return for doing so. Is there a safe zone for where liquidation happens? How is this related to gas prices?
The Next Big Thing
Dec 11, 2021 - What is the fastest growing pool in the last 30 days? Define any metrics that you use to determine what the “fastest growing pool” means.
The OHMies Voting Power
May 13, 2022 - Find the addresses that voted on governance proposal TP-11. Seperate the addresses by voting power. You may group addresses into different levels of voting powers. Present the data in a histogram.
Tax Rate
Jul 17, 2021 - How has the tax rate changed over the past 10 epochs (weeks)? What dynamics in the other macroeconomic factors in Terra including Seignorage Rewards and Total Staked Luna may have informed these changes?
Stability Fee
May 16, 2022 - How impactful is the stability fee (the interest rate) on DAI loans in terms of the impact on volume and dollar amount of loans taken out? How does activity with DAI tokens change when the stability fee is different?
Who Validates the Validators
Dec 11, 2021 - what makes an excellent validator, listing two or three validators as examples. Provide at least one visualization, using Flipside data, to support your assessment.
StETH-ETH Pool
Sep 11, 2021 - Analyze the stETH-ETH pool over the past 30 days. What trends can you identify? What might be causing them?
Curve & Convex Volume and Liquidity
Feb 11, 2022 - Are volume and liquidity of Curve and Convex directly correlated? Why or why not?
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.
Terra -> Osmosis
May 22, 2022 - Are Terra projects interested in migrating over to Osmosis? What is most important to Terra developers when looking for a chain to migrate to and why might Osmosis be a good choice?
Stargate TVL Metrics
Apr 27, 2022 - Show how the Total Value Locked (TVL) of Stargate on Ethereum has changed since its inception. What percentage of the TVL is made up by each token staked on Stargate?
New User Activity
Jul 17, 2021 - Using the answer to this bounty as reference material, map the inflows of new users to Terra against inflows of assets to different projects in the ecosystem like Mirror, TerraSwap, and Anchor. When people come to Terra, what is the first thing that they do? Has that stayed the same or does it change with, say, new product releases?
What are the most popular tokens on Harmony?
Mar 11, 2022 - Find the most interesting tokens on harmony and explain why they are most used tokens by providing insights.
Folks Finance Deposits and Redeems
May 18, 2022 - Graph the number of deposits vs redeems by day over time. -Graph the number of depositors vs redeemers over time time -Graph the total amount of each asset deposited vs the total amount of each asset redeemed each day. -Graph the total amount of each asset that has been deposited over time(factoring in when the asset is redeemed). -Create a table charting the average deposit volume of each asset, the average deposit time in days of each asset(look at when a user deposits an asset then removes it), using the pool look also list how much is currently deposited as a column.
Uniswap Stablecoin Trends
Mar 24, 2022 - What is the most popular stablecoin? Have any stablecoins seen noticeable growth or decline?
Cosmic Champs Token Launch
Apr 28, 2022 - Use the swaps table to look at $COSG and show daily swap to and swap from volume for the asset. Show how many stake actions a day are occurring Yieldly Staking Pool for $COSG.
Fractional.art NFT Sales
Apr 27, 2022 - Using the Ethereum_core schema, analyze the 3 most actively traded fractional NFT vaults on Fractional over the past 3 months. How many NFTs are in these collections? What is the total trading volume? Add any other data points to your analysis that you find valuable.
DAI Volume
Jan 17, 2022 - How does the daily volume of DAI transactions compare to other stablecoins? What is DAI most used for?
Katana wLUNA Pool
Feb 19, 2022 - Create a chart showing the amount of Katana WLUNA Covered Call Vault Shares claimed since February 4th and the number of unique wallets that have claimed shares. What is the average size claim? Does it seem that the wLUNA vault is mainly used by "whales"?
stETH HODL or Sell
Apr 4, 2022 - In a time period of your choice, identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. Have they held or sold their stETH?
Anchor Deposits
Jul 31, 2021 - How have deposits on Anchor changed in the past 2 weeks? Why do you think this is?
CowSwap Sushi Activity
Apr 22, 2022 - Using the Ethereum_core schema, find all transactions that interacted with the CoW settlement contract on ETH Mainnet (0x9008d19f58aabd9ed0d60971565aa8510560ab41) that also used Sushiswap as part of the execution. Why might they have done so?
Algorand Governance Period 2 Voting
Mar 10, 2022 - look at how wallets voted for or against xGovs. Show wallet votes over time Which had more individual wallet votes, A or B? Show the voting result(A vs B) based on the ALGOs committed by wallets for this governance period.
LUNA Price Action
Sep 1, 2021 - Effectively a content bounty: What is driving LUNA price to go so ham?
200K ALGO Donated Toward Tree Planting
Mar 10, 2022 - .Show the donations to the wallet over time. Has the donation wallet sent any of the ALGOs anywhere? If so, what addresses have most of the ALGOs been sent to? Have any of the ALGOs been sent to a centralized exchange(CEX)? If so, how much?