mar1na-catscatscode
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.
$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.
Transactional Nature
Mar 27, 2022 - This dashboard reveals the relationship between Terra UST transaction volume, native swap volume, and fees paid to stakers.
New Users on Algorand vs. Ethereum vs. Solana vs. Terra
May 5, 2022 - This dashboard reveals the trends in new users joining and transacting on L1 blockchains: Algorand, Ethereum, Solana and Terra.
The Merge x Liquid Staked ETH
Sep 15, 2022 - This is a dashboard for OurNetwork: The Merge edition (issue #138). Author: mar1na (catscatscode)#3875 (Discord) / @shecodedtoday (Twitter). Last updated: 16 September 2022.
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).
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.
[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.
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.
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?
True Freeze: Distribution of Token Ownership (frETH, TF NFT, and FRZ)
Jul 29, 2022
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?
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.
[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?
[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.
Nyan Heroes NFT Mega Dashboard
Jul 21, 2022 - Flipside Crypto: Solana NFT Project Feature
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.
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
Solana Adoption: L1 Users
Mar 16, 2022 - L1 Unique Users on Solana vs Competitor Chains
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.
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?
[Lido] stETH Use Cases
Jun 8, 2022 - -- Date: 8 June 2022 -- Author: mar1na (catscatscode) -- Lido Q1. What are users doing with stETH from Lido?
[Flipside + Layer3] Nouns DAO NFT Analytics
Jun 7, 2022 - -- Date: 12 June 2022 -- Analyst: mar1na (catscatscode) --Layer3 Contest "Flipside Crypto: Nouns DAO".
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.
[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!
Algorand: Looking For Swap Arbitrage
Apr 1, 2022 - This analysis looks for wallets profiting from swap arbitrage of USDC and USDT on the Algorand DEXes since the beginning of 2022.
New kid on Base
Oct 12, 2023 - Can Base onboard 1 billion new users onto web3 and how? An analysis.
Stablecoin Arbitrage on Jupiter: Swapping on Solana for 800% Gains?
Mar 24, 2022 - Jupiter, a DEX aggregator for Solana, has been showing good results for those engaged in arbitrage. This dashboard explores what arbitrage results are becoming common, as well as some outliers who scored big.
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.
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?
Bored Phish: A dive into two BAYC phishing hacks in April and June 2022
Jul 24, 2022