kosar73n
Getting Started With Solana Bounties
Feb 18, 2022 - Visualizing the number of transactions that staked SOL into Marinade Finance during the hour I did the same, and also highlighting my own specific staking transaction.
Monthly Swap Volume
May 11, 2022 - 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?
Sushiswap Bentobox Scavenger Hunt
Mar 25, 2022 - We want to make a limited order on the SushiSwap platform. We use Polygon network
Raydium Swaps
Apr 6, 2022 - Raydium is an automated market maker (AMM) built on the Solana blockchain that shares liquidity with the Serum decentralized exchange. Create a visualization comparing the quantity of swaps and number of unique wallets on Rayidum, Jupiter, and Orca since January 1st. What have been the ten most popular tokens to swap and swap for on Raydium during that time period? What tokens have become more popular over time? Hint: Use solana.fact_swaps where block_timestamp::date >= '2022-01-01' Hint: for labels for token addresses you can join with solana.dim_labels Hint: swap_programs: raydium v4, jupiter aggregator v2, orca
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? Note: Use the new ethereum_core data
Getting Started With Terra Bounties 2.0
Feb 11, 2022 - In this dashboard we summarize monthly UST deposits to the anchor protocol. anchor is a lending and savings protocol on the Terra blockchain
Getting Started With Terra Bounties (March 1)
Mar 4, 2022 - Visualizing the number of transactions that staked Luna into Flipside during the hour I did the same, and also highlighting my own specific staking transaction.
Votes, Votes, Votes
Apr 22, 2022 - Q185. On average, how much voting power (in Luna) was used to vote 'YES' for governance proposals? Out of this, how much Luna comes from validators vs regular wallets?
Sushi on Polygon
Mar 24, 2022 - Q57. What are the 10 largest sushi liquidity pools on Polygon? What is their volume and TVL?
Getting Started With Algorand Bounties
Feb 8, 2022 - Visualize the number of similar transactions to yours in a specific hour where you staked YLDY
Top Lido Stakers
Apr 27, 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?
January 2022 New Wallets Created
Feb 17, 2022 - Question 20: In January 2022, we see a surge in new wallets created. Were these new wallets interacting with any assets in particular? Were there any patterns in the amount of Algos these wallets held?
stETH Most Common Pools
Apr 27, 2022 - Use the ethereum_core tables to determine the pools most commonly used to swap in and out of stETH. What are the most common pairs? Which pools are most often used?
New Active Users
May 11, 2022 - Q1. Show the number of new unique users (wallets) per day that transacted with ParaSwap over the past two months.
Staking STBL on AlgoFi
Mar 18, 2022 - Question 33: Let's look at how much STBL, Algorand's First Stablecoin, has been staked on AlgoFi. Show the stake vs unstake actions over time Show the total number wallets that have staked over time Show the total amount of STBL staked(make sure to account for amounts that have been unstaked.
CLUB Liquidity
Mar 16, 2022 - What’s the liquidity of the CLUB token on decentralized exchanges? Analyze the trade volume on Uniswap, what is the largest trade? Did that trade affect the balance of tokens in the pool significantly?
Getting Started With Marinade Finance Bounties
Mar 12, 2022 - Become familiar with Marinade Finance and liquid staking
Swap Volume and Ukraine War
Apr 22, 2022 - How has the Ukraine war affected the swap volume on Sushi and Uniswap? Has there been a surge in demand for a particular token?
Tokemak Popularity
Mar 1, 2022 - Tokemak is a protocol that allows tracer governance token holders (TCR) to seek further ROI by way of yield farming. What is the popularity of Tokemak among tracer users?
Who's That Going Across My Bridge
Apr 22, 2022 - Q186. Pick one bridge from Terra and a destination of your choice. (e.g. Shuttle bridge Terra <-> Ethereum or Wormhole Terra <-> Solana). Assess the daily and cumulative amount of UST that goes through that bridge, both inflow and outflow. How many users are using the bridge on a daily basis? How many transactions take place on a daily basis?
Sablier Cash Streams
Apr 23, 2022 - Q9. Out of all streams of cash created on Sablier, how many have been cancelled before their stop time? Use Ethereum_core schema.
How Many Times was Hop used?
Apr 23, 2022 - Q12. How many times was the hop protocol used in 2022 in order to bridge funds to layer2? 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'
Trend Analysis
Apr 7, 2022 - Q63. Analyze the trend of active users and number of swaps for sushiswap and draw a comparison with Uniswap. Describe the trends that you see
Sushibar Servings
Apr 22, 2022 - Draw charts showing sushi tokens transferred to the Sushibar. Do it at different frequencies and describe the trends if any.
Anchor Scavenger Hunt (Farsi)
Jan 28, 2022 - اندکی پول به ولت خود انتقال دادم. بعدا در پروتکل انکر آن را واریز کردم. تا در سود شریک باشم
Member Roles
Mar 9, 2022 - A member is a user who has 35,000 or more $BANK tokens in their wallet (not counting members with Guest passes). A whale is a user who has over 150,000 $BANK tokens in their wallet. Show the number of members and whales on Bankless DAO over time (not counting Guest Passes for members).
Hop Bridge Volume
Apr 23, 2022 - 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'