mar1na-catscatscode
Solana Fees
Feb 9, 2022 - The Solana Fees bounty asks to 1) visualize transaction fees per day accumulated since the beginning of January, 2) plot the transaction fees per transaction on each day, and 3) determine whether the fees have stayed consistent.
Avalanche Free Square Question: DEX Swap Behaviors
Jun 27, 2022 - -- Date: 27 June 2022 -- Author: mar1na (catscatscode) -- Avalanche open-ended bounty: This analysis examines swapping activity on Avalanche: How many swaps take place daily? Are many wallets making swaps or is it a small group of users? What DEXes are the most popular? Are there trends in swap amounts, sizes, and/or user adoption? Overall, how robust is DEX activity on Avalanche and does it show any signs of growth?
[Terra] Scanner Sweep
Apr 3, 2022 - This dashboard goes meta: It summarizes and offers the highlights from the 5 top Terra mega-dashboards that Flipside Crypto community analysts (aka some of the #bestanalyticalminds) created for the Acme of Skill bounty in March 2022.
[Algorand Week: Algomint] Swapping goBTC and goETH on DEXs
May 21, 2022 - -- Date: 21 May 2022 -- Author: catscatscode -- Q72. goETH and goBTC are wrapped forms of ETH and BTC minted by algoMint. Let's look at goBTC and goETH swaps across the DEXs since the beginning of April and get a better understanding of how wallets are swapping goETH and goBTC, especially during the price crash in May.
Pooly NFTs
Jun 22, 2022 - -- Date: 22 June 2022 -- Author: mar1na (catscatscode) -- Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Bored Phish: A dive into two BAYC phishing hacks in April and June 2022
Jul 24, 2022
2023 Web3 Wrapped: Your Swaps
Nov 29, 2023 - Enter your address to find out if you've been a super-swapper this year! Currently supports Ethereum mainnet.
Bridgesplit and MonkeDAO's DAOJONES
Feb 23, 2022 - Bridgesplit enables any unique asset to become liquid and yield-generative via NFT-collateralized lending, indexes, and more. A Solana Monkey Business NFT was so fractionalized on 12/6/2021, and resulting token (DAOJONES) trading began soon after. This analysis shows daily transaction volume and the number of distinct wallets that transacted with DAOJONES. It also identifies the peak "hype" moment and analyzes the reasons behind it.
Nyan Heroes NFT Mega Dashboard
Jul 21, 2022 - Flipside Crypto: Solana NFT Project Feature
Stablecoins Analysis on Uniswap (Unigrants Community Analytics - Bounty #10)
May 12, 2022 - This analysis is the winner of the Uniswap Community Analytics Bounty Round #10. The dashboard dives into the stablecoin landscape on Uniswap, taking into account the rapid development of the context with Terra and its stablecoin UST.
True Freeze: Distribution of Token Ownership (frETH, TF NFT, and FRZ)
Jul 29, 2022
Unstaked ETH - Shapella Aftermath 📤
Apr 13, 2023 - Track the unstaking of ETH on the Beacon chain after the Shanghai upgrade. Staking vs. withdrawing, institutional vs. individual unstakers, and destinations for withdrawn ETH
Token Flow: the Blockchain Time Machine for Ethereum Data
Mar 22, 2022 - Token Flow data warehouse tracks state and storage changes on the Ethereum blockchain. This analysis is an exploratory dive into Token Flow data on Flipside Crypto.
[Lido] Top LDO Holders
Jun 2, 2022 - -- Date: 2 June 2022 -- Author: mar1na (catscatscode) -- Lido Q1. Who are the top LDO holders on ethereum and where have their LDO come from? Did they buy it or was it an airdrop?
OpenSea vs. Blur in February 2024
Feb 5, 2024 - Blur 5x’s OpenSea volume with $122M+ weekly, while OpenSea eyes alternatives. Read on for a snapshot of the NFT market's top competition.
Active Wallets on Terra
May 1, 2022 - This dashboard charts the number of active wallets on Terra by day, month, and Year-To-Date in 2022.
The Typical Minter is Seasoned: Flipside Crypto's GodMode NFT
Jun 9, 2022 - -- Date: 9 June 2022 -- Author: mar1na (catscatscode) -- Flash Bounty: Analyze the Ethereum profile of those who minted during the first hour after launch. How many of them moved the minimum .1 ETH into their minting wallet vs. already had at least .1 ETH in that wallet? How many of them have been active in NFT purchases over the past six months? Can you construct a “typical minter” profile/profiles based on their wallet behavior?
Is Polygon Slowing Down?
Jul 13, 2022 - Polygon daily transactions, active users, and new user acquisition -- do these metrics indicate that Polygon is growing or plateauing? Why?
Flipside Crypto: Learn to Solve Algorand Bounties
Mar 23, 2022 - New to Flipside Crypto and Algorand? No fear, your comprehensive step-by-step tutorial is here. Learn how to use SQL to discover and visualize the volume of Algorand token moved daily to and from centralized exchanges (CEXs).
Solana Adoption: L1 Users
Mar 16, 2022 - L1 Unique Users on Solana vs Competitor Chains
Polygon's Supersonic Speed: Comparing Block Performance with L1s and L2s
Jul 26, 2022
[Algorand] What Are Users Swapping gALGO3 For?
Apr 28, 2022 - This dashboard examines the swaps that users have been performing with gALGO3 in the current governance period. How much are they swapping, for which tokens, and on what DEXes? This analysis answers these questions.
Transactional Nature
Mar 27, 2022 - This dashboard reveals the relationship between Terra UST transaction volume, native swap volume, and fees paid to stakers.
Head to Head: Top UST vs DAI Holders
Mar 26, 2022 - This dashboard reveals the top 10 addresses by amount of UST held, and top 10 addresses by amount of DAI held, measured by most recent wallet balances.
Analysis of Celsius Wallets (15 June 2022)
Jun 16, 2022 - -- Date: 15 June 2022 -- Author: mar1na (catscatscode) -- Celsius Flash Bounty: Recently, Celsius made the decision to halt trading activity due to ‘extreme market conditions’, including a pair of events that had a severe impact: the depegging of stETH and the Luna crash. Potential Celsius owned addresses are circulating on Twitter. This dashboard examines the activity surrounding these newly identified Celsius wallet addresses: incoming vs. outgoing transactions over time, the average amount being moved, and wallet compositions by token.
True Freeze: Optimal ETH Freezing Duration, or How Long to HODL?
Aug 11, 2022 - Disclaimer: This is an analysis of past price trends, profits, and losses, and it is not financial advice.
[Template] Coin Age 🪙
Jun 15, 2023 - How old are your coins? Calculate Mean Coin Age and Sum Coin Age with this dashboard. Use this template as-is, or fork it to make more things!
MetaMasquerade Part 3: Swaps on MetaMask vs. Other Platforms
Jun 25, 2022 - This article is #3 in my 3-part data article series on Metamask. --Date: 25 June 2022 -- Author: mar1na (catscatscode) -- Q3. How many users are swapping via MetaMask vs other platforms? How much volume have these users done? Chart a comparison between the two, and show the following metrics over a time period of your choosing: transaction volume, average amount swapped, and a comparison of fees.
$ECO Velocity
Jun 11, 2023 - Method notes: 1. One can select the preferred time unit (minute, hour, day, month, year) at the top left of the dashboard (it may be required to log in or create a new free Flipside Crypto account). Applying the chosen time parameter will change both the x axis (horizontal axis, frequency at which the data is displayed) and the y axis (vertical axis, unit of measurement of coin age). 2. Data analysis in this dashboard includes the ECO Gnosis wallet.
[Optimism] User Behavior
Jun 25, 2022 - -- Date: 25 June 2022 -- Author: mar1na (catscatscode) -- How is user behavior (for swaps) different on Optimism compared to L1?
[Terra Luna] Let It Burn!
Apr 27, 2022 - This dashboard shows Terra LUNA token's weekly burn in 2022. It highlights the week that the most volume of LUNA burning happened, reveals what event caused this high burn, and elaborates on the effects of this burning on the Terra ecosystem.
New kid on Base
Oct 12, 2023 - Can Base onboard 1 billion new users onto web3 and how? An analysis.