LTirrell
Priority Fees for Solana Transactions
Apr 10, 2023 - A look at transactions using priority fees on Solana. See https://spire.fyi/ for more
Solana Fees
Feb 8, 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?
Thor -- It's Raining $RUNE!
Jan 20, 2022 - Which node operators have received the most rewards? Hint: Use thorchain.bond_actions
Pleasure to Burn
Mar 2, 2022 - Terra Q154: How much LUNA has been burned over the past 30 days? How has the supply of UST changed over the same time period? Display both of these, using visualizations.
StepN Growth
Mar 1, 2022 - Solana Q30: StepN is a Solana based 'move-to-earn' game (you earn the game's native token GST by moving around using their NFT sneakers and GPS system). The game has seen steady growth in popularity since it launched at the end of December (transitioned from a private beta mode to its current public mode). - Create a visualization showing the number of unique wallets that have transacted with GST by day since January 1st. - How much total GST has been transacted per day since January 1st? Provide some insights over the adoption of GST and how long it can accommodate its limitless supply as an in-game token.
Phantom Wallet Growth
Feb 9, 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.
👻 Phantom User Activity
Jun 26, 2023 - Investigating users of the Phantom wallet on Solana, using on-chain hints
Solana -- End of Year CEX Transfers
Jan 20, 2022 - Did the volume of transfers to centralized exchanges increase towards the end of December compared to the volume of transfers at the beginning of December? (Hint: you will need to use the "Labels" table). Create a visual to show the trend of these transfers in the month of December. Based on the trends you discover, give some reasoning to why this occurred.
Are Marketplaces Designed for Pro Traders Killing NFTs?
Mar 22, 2023 - or, are NFTs shitcoins with an image attached?
What is this address?
Apr 17, 2023 - The first installment of our series investigating an unknown Solana address. Update on 2023-05-05: Use the parameter below to select a date range
Solana: Popular Tokens by Transaction Count
Feb 23, 2022 - Ranking of popular labeled Solana tokens in the past week, by total number of transactions
Active Wallet Growth
Feb 1, 2022 - What is the number of unique active wallets (signers) over the past 7 days? Create a visualization showing the number of active wallets per day since the start of 2022. What trends do you see?
YAML: Yet Another Mad Lads dashboard
Apr 21, 2023 - Your source for Solana's most popular mint in recent memory
52 Pickup
Mar 2, 2022 - Terra Q153: Recently, a deal was announced wherein LUNA was sold for BTC at a price of about $52/LUNA. Some commentators on crypto-Twitter are contending that this represents the new floor price for LUNA. Over a time period of your choosing, how many days has LUNA closed above this price? How many days has it closed below this price?
Stablecoin Popularity
Jan 30, 2022 - Create a visualization comparing USDC, USDT, and UST (wormhole) usage in transactions throughout the month of January. Has UST seen more adoption in the Solana ecosystem this month? How do you expect this trend to continue? Why?
LUNA Distribution Mvmt 1: The Basics
Jan 22, 2022 - People who do not like crypto often cite wealth inequality as a reason: they claim that the tokens are concentrated in the hands of a few whales. Assess this claim for LUNA. How much of circulating supply is held by the top 100 addresses? Top 1%? Top 10%? BONUS: compare this to wealth distribution vs. a country or an index of your choosing.
Stablecoin Arbitrage on Jupiter
Mar 24, 2022 - Because Jupiter is a dex aggregator, there are naturally opportunities where one could take advantage of liquidity pairs across the ecosystem to create arbitrage. Since February 1st, what percentage of all swaps (with a size of at least $100) where a wallet starts the transaction with USDC or USDT and ends the transaction with either USDC or USDT have resulted in at least a 1% gain? - Are there any patterns behind the most common sources of arbitrage on Jupiter? - List the top 10 wallets in terms of total arbitrage gains and provide insight over their strategy. Note: Only include swaps where the swapped from amount of USDC/USDT and the swapped to amount of USDC/USDT were both greater or equal to 100 in this analysis.
Algorand -- NFTs Overview
Jan 21, 2022 - Let's get a better understanding of the Algorand NFT scene! How many total, non-closed NFTs are on the algorand network? - How many NFTs use the ARC3 vs ARC69 standard? - Additionally, show the minting of the NFTs with these standards over time. - Finally, show the daily total volume of total NFT sales, ARC3 NFT sales and ARC69 NFT sales over time (Tip: Here is an example of an NFT sale tx_group_id: lLa5DLImBy1PrQEWvcHR9HRZnpS/QPVQFvQPTaMvt74= ) Tip: For NFTs configured to the arc69 stanard, look at asset_configuration transactions such as 6Z5R47GSIMQC4JDCTRAPLPC5BTNCC5K5DJ2QKSACW4KV5RZFZDQQ and decode the note using try_base64_decode_string(tx_message:txn:note::string). You will find in the note the asset has been configured to the arc69 community standard: https://github.com/algokittens/arc69. For assets configured to the arc3 standard look for transactions who’s asset url ends with #arc3 https://github.com/algorandfoundation/ARCs/blob/main/ARCs/arc-0003.md
Terra -- Voting Records
Jan 20, 2022 - Select two Terra Validators of your choice and compare their voting history (governance votes). Off-chain data can be used to support your answer, but you must also utilize Flipside data in your answer to be eligible for full payment. BONUS: Can you find any proposals where your chosen validators voted differently? Why do you think this might be the case?
SMB Barrel Public Raffle
Jun 29, 2023 - Analysis of the ongoing SMB Barrel raffle, giving winners an SMB Barrel and the rights to mint a SMB v3
Transaction Volatility
Apr 19, 2023 - Why was there a decrease in transaction volatility in mid March?
Mad Lads: Mint and Honey
Apr 22, 2023 - A quick look at the anticipated mint, and honeypot to trap bots
Solana -- When Do Transactions Fail?
Jan 20, 2022 - Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and success rate of transactions throughout the month of December. Are there any noticeable patterns to when transactions are more likely to fail?
Phantom transfers?
Jun 17, 2023 - Investigating on-chain hints that transfers were made using the Phantom wallet. Inspired by marqu.
ABCDEF: Apps (Blockchain Challenge:) Distribution (Ethereum) Fees
Mar 24, 2023 - or, Blockchain Challenge: Ethereum-- top dApps, Fees, and ETH Distribution on the most popular decentralized network
SMB Gen 3: Monke Reveals and Sales
Jul 7, 2023 - Tracking SMB Gen3 Barrel Redemptions, and sales of SMB Barrels and Gen3 Monkes
Thorchain: Swapping
Oct 27, 2021 - The number of swaps as well as the unique number of swappers in total and by pool, today and daily.
Examining Loop Liquidity
Jan 27, 2022 - Visualize decentralized exchange (DEX) pools on LOOP (ex aUST/UST) vs Average # of liquidity positions on Loop DEX. Display the mean, median, and mode….3 separate graphs. The goal of this graph is to tell us: For wallets that have UST/aUST liquidity positions, how many other positions, on average, do these wallets also have on the DEX? If we can see mean, median, and mode, we can determine data skew from outliers
Thorchain: Number of Users of THORChain Bridges by Asset
Oct 26, 2021 - The number of users interacting with THORChain broken down by chain.
120. Red Team
Dec 22, 2021 - Using data, highlight any limitations in using the LUNAtic Score (https://science.flipsidecrypto.com/lunatics) to calibrate airdrops to loyal Terra users. What issues should be considered? What limitations does the tool have and how could they be addressed?
SCV Ready
Mar 24, 2022 - Keeping Terra data and data products up to speed is a full time job.
Thorchain: Volume of THORChain Bifrost Activity by Asset
Oct 26, 2021 - The volume of non-native rune being upgraded to native RUNE, broken down by chain (ETH + BNB)