ValiMohammadi
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
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
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.
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.
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?
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?
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
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?
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?
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?
Terra Bounties (Validator Voting vs. Investor Inclinations)Board
Apr 23, 2022 - Analyze the last 5 governance proposals. Out of the total Luna that voted in favor, how many % are from validators vs. retail investors for each proposal and on average?
Algorand Bounties (Rand Gallery NFT Sales)
May 2, 2022 - Rand Gallery is one of the largest NFT marketplaces on Algorand. Let’s take a deeper look into rand gallery’s history and the performance of the marketplace. Show Daily NFT sale volume in # of sales, ALGOs, and USD over time. Show how much Rand Gallery has earned in fees daily and accumulated over time. -How many NFTs have been sold through Rand Gallery and what is the total -volume in ALGOs of NFT sales. What was the biggest NFT sale in both ALGOs and USD. What was the NFT? Tips: NFT Sale Example: https://algoexplorer.io/tx/group/m5Xmjvw60T%2B%2F9%2Bxo15Oi5GjffoRHNRtBkSYDDZBeLgc%3D Fees are sent to: RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE NFT Statistics and Explorer: https://www.nftexplorer.app/stats"
THORChain Bounties Deposit rate from L1s
Jun 15, 2022 - Q105. Look at users swapping from native L1 assets to $RUNE. Are there any trends by chain or over time?
Algorand Bounties( Gard.Money Algorand’s First Algorithmic )Stablecoin
Apr 18, 2022 - Q55. GARD is the world's first algorithmic stablecoin on Algorand's blockchain. Let’s look at the collateral debt positions(CDP) users are taking on. This is where users put ALGOs up as collateral and in turn get GARD(Asset ID 684649988) in return. Gard is a stable coin pegged to $1 in value.
Solana Bounties( Magic Eden Whales)
Apr 13, 2022 - Q50. Track the top 20 wallets in terms of sales volume on Magic Eden since March 1st. What have these wallets been buying the most over that time period? As in, which collections seem to have their attention? Do these wallets tend to ""sweep"" (buy a lot of the same collection at once) or patiently buy collections? How often are these wallets buying NFTs and what does their profit look like?
THORChain Bounties (Initial swap volumes of LUNA and UST)
Apr 15, 2022 - Q66. Measure and compare the first three days of swap volumes of the following tokens: Doge, LUNA and UST
Algorand Bounties Crazy Goose Flock and $CRUMB Token
Jun 10, 2022 - Crazy Goose Flock is one of the strongest growing NFT communities on Algorand. Let’s look at the holders of the CGF! Chart the holder breakdown of the CGF NFTs. How many holders hold more than one CGF NFT? Who holds the most CGF? Show the wallet balance distribution of CGF holders. Are there any whales holding a CGF? Also chart the wallet creation date for crazy goose flock holders. Are the wallets who hold CGF newer or older? The Crazy Goose Flock are also airdropping their community utility token to CGF holders. Show these airdrop transactions. Who are the biggest $CRUMB holders? https://twitter.com/CrazyGooseFlock/status/1531039099372584962?s=20&t=ZM0LBiWXBRfykqaAi16YEA https://twitter.com/CrazyGooseFlock/status/1528842444762238976?s=20&t=wE7H9RYDUER1ZiNzWUcRgg Note anything else interesting about the holders of the community, the NFTs, or the airdrop!
Terra Bounties (UST Competitive Advantages)
May 4, 2022 - Why would a user choose to transact using UST over DAI (and vice versa)?
Terra Bounties The Nightmare Scenario
Apr 18, 2022 - Q183. Recently, attacks have been leveled against Terra, suggesting that it is doomed to collapse as UST reaches unsustainable levels. Specifically, concerns have been raised that at a low enough LUNA price, users will no longer be able to redeem $1 of UST for $1 of LUNA. In what circumstances would the price and supply of LUNA and the supply of UST constitute a serious threat to UST redemption, i.e. create an imbalance wherein the UST-LUNA exchange mechanism would no longer function properly? What is the likelihood of such a scenario, and how might it be mitigated?
Algorand Week: (New User Bounty Getting Started With Algorand Bounties)
May 19, 2022 - We want to understand what ASAs(Algorand Standard Assets) new wallets created in 2022 hold.
Wallet swaping ALGOs Getting Started With Algorand Bounties 3.0
Apr 27, 2022 - We are going to dive into ALGO swaps on the Algorand DEXs.
Algorand Bounties AlgoFi's AlgoVault Governance Period 3
Apr 22, 2022 - Q54. AlgoVault allows you to commit to Algorand Governance via the AlgoFi protocol. Let’s look at what users placed their ALGOs in the AlgoVault and Committed to Governance What is the current total amount of ALGOs in AlgoFis AlgoVault?(Look at all the wallets that are created via the AlgoVault then use the algorand.account table to calculate total balance) What percent of the AlgoVault Wallets have committed to governance? What percent of the ALGOs in the AlgoVault have been committed to the How much have they committed? (Decode the tx_message: try_base64_decode_string(tx_message:txn:note::string) like ‘af/gov1:j{“com”:%’ Show the algoVault wallets governance commitment by number of wallets and amount of ALGOs over time.