MahDiamond-S-7
Algorand NFT Shuffle Hunt
Jun 29, 2022 - Time to dive into Algorand NFTs! With this bounty you will have the opportunity to experience the Algorand NFT space by participating in two NFT shuffles. A shuffle is where you are dropped a random NFT in the collection(NOTE: All NFTs in each shuffle are the same so only mint 1 from each shuffle, otherwise you will be disqualified).
Hop Bridge Volume
Apr 22, 2022 - {Bounty Assignment}[Ethereum] Q11. How many Matic token were bridged in 2022 per day from ethereum to layer2 using Hop? Use Ethereum_core schema. Hints: contract address for ethereum bridge for Matic : 0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2...... MATIC contract address on ethereum: 0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0....... Event name that sends token from user's wallet to the bridge is 'Transfer'....... Event name that sends token from the bridge to the layer 2 wallet is 'TransferSentToL2'.......
Arbitrum Scv Hnt Odyssey
Jun 25, 2022 - Welcome to the Arbitrum Odyssey! Arbitrum has announced the Odyssey initiative to invite users to explore the Arbitrum ecosystem. Users that participate stand to receive exclusive NFTs (and possibly ~fingers crossed~ an airdrop at some point!). We hope this scavenger hunt will help you find an easy and enjoyable entry point into the ecosystem. Each step of this scavenger hunt is aligned with steps required to participate in the Arbitrum Odyssey.
Celsius Swaps
Jun 21, 2022 - [Sushiswap Bounties]{Bounty Assignment} : Q95. Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps? Hint: you can find all addresses belonging to Celsius network by querying this table: flipside_prod_db.crosschain.address_labels
LUNA Market Cap
May 8, 2022 - [Terra Bounties] {Bounty Assignment} : Q201. Back to basics! Display the LUNA price and market cap trend over 30, 60, 90 days; the past year; and all time.
ETH Staked
Jun 15, 2022 - [Lido Bounties]{Bounty Assignment} : Q9. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Gard.Money Algorand’s First Algorithmic Stablecoin
Apr 19, 2022 - {Bounty assignment} [Algorand Bounties]- 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. --- --- --- * Chart how much GARD has been minted by day * Chart how many wallets mint GARD each day. -How much has Gard.Money generated in ALGO fees? Show the fees accumulation over time. -What is the total amount of ALGO collateral currently backing the GARD?
Stable Coins Lent on Kashi
Jun 12, 2022 - [Sushiswap Bounties]{Bounty Assignment} : Q92. Draw a chart showing the TVL of Stable coins on kashi pairs across all markets. Hint: You can include USDC, USDT, DAI and UST in your analysis and look for the transactions where they are deposited on Kashi for lending. The event name would be 'LogAddAsset'. Removing them will generate 'LogRemoveAsset'.
Sushimaker👨🍳🍣
Apr 27, 2022 - [Sushiswap Bounties]{Bounty Assignment} Ever wondered why you generate yield by parking your SUSHI's in the sushibar? (yes yes, the staking). Well, the Sushibar is always served with fresh SUSHI from a contract that is called Sushimaker. Describe the role of sushimaker and say how many SUSHI's it serves to the sushibar per day. Also compare the amount of sushi that is being staked by users with the amount of sushi that is being served by sushimaker. Hints: A transfer event is generated for each staking and for each serving, there is a serve event in that transaction.
Folks Finance: Minting gALGO3 For Governance
Apr 19, 2022 - {Bounty assignment} [Algorand Bounties]- Q53. Folks Finance is a newly launched lending and borrowing protocol built on Algorand. They offer a unique liquid Algorand governance opportunity which allows you to still utilize your ALGOs in in the form of gALGO3 a token you mint when you deposit your ALGOs into their governance pool. An important note is ALGO and gALGO3 are one to one in terms of value..... This allows you to still use the value of your ALGOs in the form of gALGO3 and earn governance rewards since your ALGOs will be placed in governance via their protocol and the staking pool. Click here to learn more: https://docs.folks.finance/protocol-architecture/algo-liquid-governance....
Sushibar Servings- Sushiswap Bounties
Apr 16, 2022 - {Bounty Assignment] Q66. Draw charts showing sushi tokens transferred to the Sushibar. Do it at different frequencies and describe the trends if any.
1M New Algorand Wallets In May
May 17, 2022 - [Algorand Bounties] {Bounty Assignment} : Q66. From May 4th to May 10 we saw over a million wallets being created. What are these new wallets doing on Algorand? Some things to look at: -Using the account table, show the distribution of ALGOs these wallets have? -Are these wallets swapping assets? If so, what assets are these wallets swapping for? -What assets do these wallets hold using the account_asset table? -Do we see any commonalities our patterns across these wallets?
Getting Started With Marinade Finance Bounties
Mar 12, 2022 - Marinade Bounties on Solana net. Bounty Assignment : Question 1. How many unique wallets have staked SOL on Marinade in the month of March? Create a visualization using Velocity to show user adoption per day in March. Question 2. How much mSOL has been deposited into the single-side MNDE pool in the month of March? Create a visualization using Velocity that shows mSOL deposits per day in March.
NEAR Scavenger Hunt
Jul 12, 2022 - Welcome to the NEAR Ecosystem! We hope this NEAR Hunt will help you find an easy and enjoyable entry point into the ecosystem Payout 4.323 NEAR on Near network
Getting Started with Algorand
Feb 8, 2022 - Bounty Assignment: visualize the number of similar transactions to mine, in a specific hour where I staked YLDY.
Daily Transactions and Unique Addresses
Jul 12, 2022 - {Polygon Network} [Bounty Assignment] : Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022. In your estimation, discuss whether Polygon is still growing, has reached a plateau, etc.
Terra Scvng Hnt
Jan 25, 2022 - // Mahdi.s7 // { this dashboard is showing the steps of Terra Scavenger Hunt} ... using Terra station wallet / stake/delegate my LUNA tokens with the Flipside Crypto validators, 25-1-2022 /.
Getting Started With Marinade Finance Bounties (Redux)
May 6, 2022 - Marinade Bounties on Solana net. Bounty Assignment : Question 1. How many unique wallets have staked SOL on Marinade in the month of March? Create a visualization using Velocity to show user adoption per day in March. Note: Be sure to limit block_timestamp to only the month of March Question 2. How much mSOL has been deposited into the single-side MNDE pool in the month of March? Create a visualization using Velocity that shows mSOL deposits per day in March.
New DEX Users- Algorand Bounties
Mar 31, 2022 - {Bounty Assignment} : Q40. Let's use the algorand.swap table to look at users who are using the new DEXes(Decentralized Exchange): PactFi, AlgoFi, WagmiSwap and whether or not they previously used the Tinyman exchange? ....... What percent of wallets for each of the new DEXes(swap_programs:PactFi, AlgoFi, Wagmiswap) had previously used Tinyman to perform a swap?
Getting Started with Terra Bounties (Jun 25)
Jan 26, 2022 - In response to: find all transactions delegating LUNA to "Flipside" on Jan 25, 2022, 2:11 AM when I completed the Terra Scavenger Hunt. a chart that visualizes those transactions, and highlights my delegation transaction in Orange color. and also the result table.
Sablier TVL
Apr 22, 2022 - {Bounty assignment}[Ethereum] Q8. What is the total value locked in Sablier and by how many users? Use Ethereum_core schema.
Sushi Activity on Ethereum
Jun 27, 2022 - [Sushiswap Bounties]{Bounty Assignment} : Q96. How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lending ? Hint: use the tables in Sushi schema: ethereum.sushi .
Collateral Impact (May 13)
May 16, 2022 - [MakerDAO Bounties] {Bounty Assignment} : Q2. How does the volume on MakerDAO (in terms of DAI minting) change as more collateral tokens are added to the platform? Which tokens have impacted volume the most?
Polygon NFT
Jul 16, 2022 - {Polygon}[Bounty Assignment]: Q3.How popular are NFTs on Polygon? Track daily volume over the past month/year. How many Polygon users started off with NFTs? Who made the most profit?
Astroport Scavenger Hunt (Vietnamese)
Jan 26, 2022 - Hiển thị hoán đổi giao dịch từ UST-LUNA sang ASTRO ... Hiển thị giao dịch thêm UST và ASTRO vào nhóm thanh khoản ASTRO-UST
AlgoMint goMint Token Release
May 4, 2022 - [Algorand Bounties]{Bounty Assignment} : goMint was launched on Algofi, Tinyman, and Pact on March 30th, 2022. goMINT, is the first Algorand-native three-way listing so let's look at the performance of the goMint release between the 3 DEXs...... Show us the volume of ALGOs swapped for goMint by day on each DEX since the token release Show us the number of swaps and the number of wallets by day by DEX for goMINT/algo swaps in the first week of the token release....... In the first 24 hours of the token release- chart the average swap price in ALGOs for goMint across each DEX(AlgoFi Tinyman Pact). Do we see a higher average price for goMint on any of the DEXes? Note any other interesting findings between the DEXes related to the release of the goMint and the goMint/algopools, such as volume, number of swaps, or number of wallets swapping.
Monthly Swap Volume
May 9, 2022 - [Paraswap Bounties] {Bounty Assignment} : Q2. Show the total monthly swap volume on ParaSwap over the past year. How has the swap volume changed over time? Which DEX’s is most of the swap volume coming from?
Liquidity Space Voyage
Feb 3, 2022 - (Mini-Terra Tutorial)[ Bounty assignment: 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.] -- **** Note : we find that Astroport phase 3 Launch is after 2021-Dec-28 as our Reference DATE, so all transaction that has done after that moment is considered here.
Anchor Ecosystem Scv.Hnt
Jan 28, 2022 - (Farsi) A. برای بدست اوردن سود نشان دهیم . anchor رو در ust در این داشبورد ، میخواهیم تراکنش های دپوزیت کردن ////////// B. میکنیم . Liqudity سایت رفته و در استخر ایجاد سرمایه govern سپس به بخش
Saber Locked Over Time- Solana Bounties
Mar 29, 2022 - {Bounty Assignment} Q46. Review the scavenger hunt on veSBR for an explanation on the Saber Wars! Create a visualization showing the amount of SBR locked in governance over time since January 1st. Are there any notable trends on when SBR has been locked or wallets have exited from their locked positions? For example, have there been certain dates when we can expect there to be more locking activity than others? Provide some insight on locking behavior.
Anchor scavenger hunt D-Board
Dec 30, 2021 - //by: Mahdi.s7 // { the queries below are showing the steps of 'Sailing Into Anchor' Air-Drop project} 1- Go Lunar - acquire some LUNA token. 2- Bond My LUNA [Bonded(bLUNA)] to use as collateral: *A- mint bLUNA *B- Provide bLUNA. 3- Borrow against your bLUNA or bETH - take out a loan in UST. 4- Deposit some of your UST to earn yield (on Anchor GOVERNANCE).
Fuse Pool USDC Allocation
May 23, 2022 - [Rari Capital Bounties] {Bounty Assignment} : Q2. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
USDC Transfer Volumes- Algorand Bounties
Apr 14, 2022 - {Bounty assignment} Q51. Compare USDC transfer volumes on Algorand, Solana, Ethereum in 2022. Chart the daily volume of USDC that is sent between wallets on each blockchain for 2022. Chart the daily # of USDC transactions that are sent between wallets on each blockchain for 2022. Find the average USDC transfer size for each blockchain in 2022. Compare the trends of USDC transfers on each chain and note your findings.