ValiMohammadi
MakerDAO Bounties Stability Fee (May 13)
May 15, 2022 - Q4. 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?
Algorand Bounties (Governance Period 2 Payouts)
Apr 14, 2022 - Let's look at the Algorand Period 2 Governance Rewards Payouts How many reward payments were sent? And what was the total amount of ALGO rewards paid out? How much time elapsed from the first to the last rewards payment? What wallet had the largest rewards payout and how much did they receive? Create a plot to show the distribution of rewards payouts.
ZK Sync Bounties Distinct Wallets (zkSync)
Jun 18, 2022 - Q1. ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. You can read more about ZkSync here. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both. Hint: use the ethereum.core.ez_eth_transfers table https://etherscan.io/txs?a=0xabea9132b05a70803a4e85094fd0e1800777fbef&p=1
NEAR Performance
Jul 21, 2022 - How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
Terra Bounties (Active Wallets on Terra)
May 4, 2022 - Define "Active Wallets" on Terra. Based on your definition, display the active wallets by day, month, and Year-To-Date in 2022.
THORChain Bounties Synth Mints + Burns
Apr 8, 2022 - Description of work: First we have the number of mints that we got in the table thorchain.swaps and we have calculated the number of mints based on the specific days when the mint happened and we did the same thing to get the number of burns on the specified day. We have given. And we have shown the graph of each separately. Finally, we get the sum of Mints and Burns and show the diagram.
Terra Bounties UST-LUNA Highway
Apr 18, 2022 - Q182. Over a time period of your choosing, display the following: -daily minted UST and burned LUNA -daily burned UST and minted LUNA What are some trends you can observe for each of the charts above? credit to: JP12
Hot on ETH Week Day 4 (Stargate User Growth)
Apr 22, 2022 - How many unique users are staking capital on Stargate on Ethereum each day since its inception? What might this suggest about the protocol's growth?
THORChain Bounties (RUNE bonded + slashed amounts)
Jun 11, 2022 - How much RUNE is bonded, how much RUNE has been slashed from those bonds (total and or over time)?
Sushiswap Bounties (Withdraw to my wallet or to my Bentobox?)
Apr 23, 2022 - What percentage of users choose to withdraw directly to their wallet rather than withdrawing to bentobox when they perform a borrowing or when they withdraw from lending?
RaceDay NFTs
Oct 22, 2022 - How does Speedway Motorsports RaceDay NFTs stack up to sports NFT collections in the FLOW ecosystem? What other projects are RaceDay fans buying?
THORChain Bounties (IL insurance)
Apr 8, 2022 - What percentage (%) of users who eliminate liquidity receive IL insurance?
MakerDAO Bounties DAI on the Market (May 13)
May 16, 2022 - Q3. Analyze large shifts in the amount of DAI on the market over the past year. What might have caused these shifts? Are these events related to Maker directly? Are they related to the crypto ecosystem as a whole? Provide metrics to support your analysis.
Algorand Week: Gard + Yieldly 2022 Yieldly Staking Pool Analysis
May 23, 2022 - Q75. Let's get a better understanding of the YLDY staking pool usage in 2022.
Hot on ETH Week Day 3 (Top Lido Stakers)
Apr 21, 2022 - Use the ethereum_core tables to identify the top stakers using Lido. Do research on these addresses, can you identify any of these accounts using a mix of off and on-chain data?
Nebula Scavenger Hunt
Apr 28, 2022 - Now I have gotten some UST it is now time to provide liquidity for the Nebula Bootstrapping Pool.
FLOW's Path To Decentralization
Nov 12, 2022 - Flow is becoming more permissionless! Flow’s long-term vision is to optimize for security and scalability and move toward decentralization over time. With the release of permissionless contract deployment and new nodes for staking, build an analysis around the state of staking on Flow. Display the progress toward decentralization, answering questions like (but not limited to): how much total $FLOW is staked? How much $FLOW is staked/unstaked per day? How many unique stakers there are? What is the amount of $FLOW staked vs. $FLOW circulating?
THORChain Bounties (Weighted-Average LP Duration)
Apr 28, 2022 - What is the average duration of liquidity held in each pool, weighted by the size of the LP?
Optimism Velodrome Health
Aug 16, 2022 - Q10. Create at least 3 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner. Most importantly, your insights should help our readers answer the question "How healthy is this project?"
Forefront Bounties (Forefront Curators)
Apr 16, 2022 - Q2. Forefront has token-permissioned governance and curation channels that require holders owning at least 1000 FF tokens. Create a visualization of the number of curator roles in Forefront over time. Are more curators being added over time? How could Forefront incentivize growth in curator roles? Hint: Read more about Forefront from https://www.forefront.club/ and https://forefront.mirror.xyz/ Payout will be in the Ethereum network.
Algorand Bounties (What Are Users Swapping gALGO3 For?)
Apr 25, 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. 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? What DEXes are users swapping gALGO3 on? Show the breakout of number of gALGO3 swaps(to or from) by day for each dex. What are the top 10 most popular to swap from to get gALGO3? What are the top 10 most popular to swap to from gALGO3?
Axelar $AXL Token Recap
Nov 26, 2022 - Since the $AXL token launch, how have wallets that bought $AXL used it? Are most wallets hodling or trading? What is the average holding period for wallets buying $AXL in the last month? Generally speaking, have users kept $AXL on exchange (in their Osmosis wallet) or have they bridge to other places? Analyze $AXL balances on Osmosis as compared to native on Axelar. How have these balances changed over time? https://flipsidecrypto.xyz/drops/axl-token-recap-7508d5
Algorand Bounties The Octorand Universe
May 26, 2022 - Q81. Octorand is a virtual world of opportunity built on top of the Algorand blockchain. Octo Primes are the only form of life existing in the world of Octorand. You can collect these Octo Primes, transform them to increase their value and trade them through the inbuilt marketplace. Show the number of Octo Primes Gen1 and Octo Primes Gen2 each wallet holds. -nHow many unique holders are there for Gen1 and Gen2? How many Gen2 holders hold an Oct Prime Gen1? Show Octo Primes Gen1 and Octo Primes Gen2 sales and ALGO volume over time. Note any other insights you find about the Octo Prime sales or holders! Tips: https://www.nftexplorer.app/stats https://octorand.com/track/statistics https://octorand.com/track/sales https://octorand.com/
Anchor Flash Bounties (Lost Anchor Funds)
May 4, 2022 - There has been an increase in reports of new Anchor users losing funds to fraud or scam copies. Analyze the following transactions, noting any suspicious user behavior. How did these new users lose their funds? How can this be prevented? Example transactions: 1878ABBCD9B56B87E3F985F32C9DF123CDD0461769D11C30AE6184DDBF3CA957 4CD70119C3511BD1E32E257922D3FC7EAB1FF49676D55E74ADD227B51FD312D7 42DDF088E005419E79E08A3A01321684B15542A727FBF7D9A17DBE7C38BD148B A98CB31B1C2E5FFB0A05AF070E9CCC5C4D07C873E8890DF85A4CE3CF5A3ABFDA 08B5CA181537A4137512B0B632383F3E18696E0A600BBDB658FC7450BE7E57A6 7657331CBE3D94AD99D5D0390B3C8A62334D6EF051EC3038A17BFFE0E31A6799 0E0A5D974414046971582D06BEDB61E2C2D40F7B994265799E46DFA0D2060ACD 71AAC360D53222F18EC7BBED19A3CA2E125BF645CE8D466B1BE6D4DCFAEB3794
Algorand pNetwork Bridge Launch
Jun 24, 2022 - pNetwork is the first decentralized bridge to launch on algorand- it supports wrapped USDC, BTC, and USDT -Look at inflows and outflows by volume and number of transactions for each pUSDT , pBTC, and pUSDC by day Show the top 10 wallets that have bridge in each assets Tips: pUSDT, pUSDC, pBTC https://algoexplorer.io/asset/748208047 https://algoexplorer.io/asset/744665252 https://algoexplorer.io/asset/748211185 pBTC swap-appID 770103640 https://algoexplorer.io/tx/group/oh5fhauY39SE%2BDTMw6FIPPv8w2poW1y6oCc%2FgrzE87c%3D pUSDC swap-appID 770102986 https://algoexplorer.io/tx/group/ZH5NGfl3X3fyxkBt9bnKHglpuOzguPg8S7jtQF6s3wA%3D pUSDT swap-appID 770102986 https://algoexplorer.io/tx/group/uYvXusw1LW%2FcjwD%2FKdWw7uxbGgRc%2BlgcjzgvuZ6Y3aQ%3D
Kinetic Scavenger Hunt Kinetic Money Scavenger Hunt (Farsi)
Apr 28, 2022 - انجام دادن سواپ و استیک کردن روی ارز KNTC
Algorand Bounties New Wallets In May
Jun 17, 2022 - Q101. How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May? 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?"
Hot on ETH Week Day 1 (CowSwap Sushi Activity)
Apr 20, 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?
Solana OpenBook
Nov 21, 2022 - One of the aftereffects of the FTX meltdown for Solana was the need to fork (replace) Serum, the OG order book on Solana due to key control risk. The Solana defi community worked together to create OpenBook https://twitter.com/openbookdex How has Solana defi responded to the risks that Serum suddenly presented and has there been any traction on Openbook so far? How has liquidity flowed through Solana defi? What programs seemed to be most affected by the replacement of Serum? Does it seem like defi on Solana is becoming more decentralized?
THORChain $RUNE Upgrades
Jun 28, 2022 - Q.107 There has been a big push for users to upgrade their ETH.RUNE + BNB.RUNE -> native RUNE, as the wrapped versions will be depreciated. Have you seen an uptick in the amount of $RUNE being upgraded recently? Look at both the $RUNE volume + number of wallets. What is the trend over time + also how much is ETH vs BNB?
Open Analytics - SWEAT
Sep 20, 2022 - The SWEAT token has launched, to great fanfare! Give us your best open analysis of SWEAT's launch and the role of SWEAT in the NEAR ecosystem
Terra Bounties (How Relevant is Justin Sun?)
Apr 30, 2022 - Justin Sun has recently announced an algorithmic stablecoin, USDD, with 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 questions: is Justin Sun for real? Is USDD likely to accrue significant backing? How will its 30% offering fare over time?