GLau
LUNA Distribution, Mvmt II
Feb 8, 2022 - Question 144: Answer one of the following two questions (or both, to be eligible for the grand prize): What is the distribution of LUNA for active wallets (i.e. wallets with at least one transaction in the past 90 days?
CEX Action Around Algorand Governance
Feb 25, 2022 - Let's look at how Algorand Governance influenced Centralized Exchange(CEX) action. First, let's look at the first commitment period of Sept 30th, 2021 to Oct 14th, 2021 and compare the previous two weeks Sept 14th, 2021- to Sept 30th, 2021. Did we see more ALGO volume movement from CEXs to wallets by day during the commitment period compared to the previous period? -Next lets zoom out a little, and compare August 14th, 2021 - Sept 13th to Sept 14th, 2021 - Oct 14th. Do we see more ALGO volume movement from CEXs to wallets by day leading up to and during the commitment period than the month before? Finally, lets look at the first governance payout period(Jan 1st, 2022- Jan 5th, 2022). Do we see an increased volume of ALGOs moving TO CEXs from Jan 1st, 2022 - Jan 14th, 2022 compared to the two weeks prior Dec 18th 2021 - Dec 31st 2021? How did the second commitment period Dec 24th 2021 - Jan 7, 2022 impact the ALGO volume movement to and from CEXs during the first governance payout period? Show the volume of ALGOs to and from CEXs during Dec 24th, 2021 to Jan 12th, 2022. Tips: -Use the Algorand Labels Table to identify which addresses are CEXs.
Solana Fees
Feb 7, 2022 - Question 6: One of the main advantages for a user of Solana is the extremely low fees relative to other blockchains. Create a visualization showing transaction fees per day accumulated since the beginning of January. Also create a visualization that shows transaction fees per transaction on each day. Do fees ever seem to spike or is it consistent?
Balloonsville Rug Pull
Feb 18, 2022 - Balloonsville is an NFT project that launched on the Magic Eden marketplace on February 5th, 2022 and rugged the following day. Due to the nature of the rug, this caused a large controversy in the Solana NFT community. Since February 5th, what is the total volume of Balloonsville secondary sales on Magic Eden? Over the same time period, what is the average sales price of Balloonsville NFTs on Magic Eden? Create a visualization of the sales volume and price over time of Balloonsville NFTs and provide insights about any spikes or trends you see.
Vote! - Sol
Feb 13, 2022 - Question 9: Create a visualization that compares the number of non-vote transactions to vote transactions per block since the start of February (hint, use the block table and the votes_block_agg table). What is the average ratio of votes to non-votes in a block? Have there been any timeframes of noticeable fluctuations of this ratio?
% Sol Staked
Feb 13, 2022 - Using the "Events" table, what percentage of Solana that has been transacted is staked? How has that percentage changed throughout the month of January? Create a visualization showing % SOL staked over time. What is the average amount of Solana staked during a staking transaction?
Getting started with SOL bounties
Nov 25, 2021 - I learned how to use the SOL tables from flipside crypto!
MonkeDAO Validator
Feb 18, 2022 - The MonkeDAO was the first NFT DAO on Solana and also was the first NFT DAO to set up a validator in an effort to help decentralize and secure the network. When a user decides to stake their Solana, they delegate which validator to support with their staked Solana. How many unique wallets since February 1st have decided to delegate their staked Solana to the MonkeDAO validator? Create a visualization showing delegations per day.
My first Bounty
Nov 25, 2021 - My attempt at the first bounty task. I use coinbase to buy Ethereum but have only used moved the Ethereum to stake to Eth 2.0 so my balances look weird. I used another wallet to try the code out.
16. Algorand Assets
Jan 30, 2022 - This dashboard explores Assets on the Algorand ecosystem. ASA's also known as Algorand Standard Assets are tokens that can be created on Algorand's blockchain that have the same security, compatibility, speed and ease of use as the Algo - the main governance token of the Algorand ecosystem. The Algorand ecosystem has many benefits for developers to produce ASA's. Algorand claims to have high transaction speeds at 4.5 seconds, scalability at over 1000 transactions per second, and strong security under its Pure Proof of Stake Protocol (PPoS). It makes sense that many want to use Algorand to create their own tokens. This dashboard will answer three main questions: 1. What are the top 10 most popular assets (ASAs) to hold outside of Algos? 2. When were these top 10 most popular ASAs added to Algorand wallets over time? 3. What is the wallet holding distribution for Yieldly, Opulous, and SimleCoin
Phantom Wallet Growth
Feb 8, 2022 - Question 5:This week, Phantom (the most popular wallet in the Solana ecosystem) released its mobile app. There is an expectation that this will gradually increase adoption. Track and visualize at least two metrics to compare growth in Solana activity in the start of February (when Phantom mobile launched) to the month of January.
Solana TPS
Feb 19, 2022 - One of Solana's main features is its speed compared to other blockchains. Blockchain performance is usually measured in Transactions per Second (TPS). Measure the TPS of Solana in February (non votes) and 'Successful TPS' per day and create a chart showing how TPS has fluctuated during that time period.
Solana Unique Programs
Feb 10, 2022 - One way to track developer growth in an ecosystem is through the number of unique contracts used. Create a visualization of the number of unique programs used per day since the beginning of January. What are the 5 most commonly used programs over that timeframe? What do those programs do and why do you think they are so popular?