charliemarketplace
flipside-101
Dec 8, 2023 - Deep Dive into the foundations of crypto via flipside schemas: Core, DeFi, Governance, NFT, Price. Including reviews of Dims, Labels, Tags, Contracts (ABIs/IDLs), Facts of Transactions, Event Logs, Traces, Swaps, NFTs, and common blockers when analyzing crypto data.
OpenseaPro NFT Rank by Waves
Apr 7, 2023 - I don't know why, but 0xWave didn't make a dashboard haha. Source: https://twitter.com/0xWave/status/1643364409694375936
Flipside Data Fact Transactions Lag
Aug 15, 2022 - For Flipside and User awareness - tracks lag in minutes of latest data from [CHAIN].core.fact_transactions in minutes refreshed every 3 hours.
.ETH vs .SOL
Nov 1, 2023 - Looking at ENS (.eth) activity each month since 2020. Noticeable resurgence of new registrations & renewals. But it seems ENS trading (a subset of transfers) has remained lagged. Prices are in ETH terms. Looking at the (limited in data) Bonfida Name Service to get registration counts. Note Bonfida now has a new Solana Name Service program, whose new ID was not included here. But some stats are taken for October 2023 from their SNS website to add context to the overlapping programs.
Post-Airdrop-Actions
Dec 15, 2022 - Categorize claimants of tracked airdrops (please help us add more!) by their post-airdrop action. Order of Labeling: Keepooor, Dumpooor, Hedgooor, Exchangooor, Market Maker, Trader, Maximizooor, Intermediary, Undefined. Users categorized as first category where they meet condition. Note: Chart caps at 7 + Other. Will update when chart cap expands.
HarryPotterObamaSonic10Inu
Jul 17, 2023 - HarryPotterObamaSonic10Inu is the latest shitcoin to make me laugh enough to (1) put some liquidity into the 1% Uni v3 pool and (2) make a whole dashboard on how painful its rug will be. Why is all the liquidity from 3 mev bots? Will I get to 10x or not?
Tornado Cash
Nov 7, 2023 - Monthly Deposit/Withdrawal flows of Tornado Cash contracts. NOTE: Tornado Cash was Sanctioned by US Treasury on August 6, 2022.
EVM Developer Trends
Jan 9, 2024 - Understanding Contract Development Patterns on Ethereum
Layer 2 Margins
Jan 18, 2024 - Looking at Optimism's ETH tx fees (gross revenue) adjusted for the L1 transaction fees paid to Ethereum (Batcher & State Root Proposer).
What makes a Blue Chip NFT?
Jan 9, 2024 - Among the top 1,000 NFT projects* by Lifetime ETH Volume - which stand out? All Analysis done using data PRIOR to February 8th, 2024 (for reproducibility).
Major Stablecoin Stats
Aug 24, 2023 - Looking at USDT, DAI, and USDC volume and user transfer stats on Ethereum Mainnet with a focus on UTC hour to estimate usage across time zones. Also includes a breakdown of SMALL Transfers ( <= $1,000 per transfer) to estimate retail level usage across market time zones. Data 2021 to most recently completed month.
Ethereum Blockspace
Jul 4, 2022 - An overview of Ethereum's mechanics, and structural fundamentals.
ETH Stake Stats
Jul 25, 2023 - Week by Week growth of Liquid Staked ETH markets (Negative values means more withdrawals than deposits!)
Uni V3 Pool Snapshot
Jun 28, 2023 - Price & Liquidity for any Uni v3 pool on Ethereum mainnet at a block height using the Quicknode Add-on for LiveQuery.
AAVE v3 USDT Debt vs Premium Collateral
Aug 2, 2023 - For simplicity, let's look at the ETH Millionaires (using Flipside Tags data) that have the most USDT Debt in AAVE. Then, categorizing their collateral against that USDT as either Premium (WBTC or ETH) vs non-Premium (every other possible collateral) we can identify millionaires at a higher risk of being liquidated in a way that could generate bad debt for AAVE.
Stablecoins - Big & Small Volume
Nov 2, 2023 - Comparing USDT, USDC, and DAI transfer volume & the number of unique senders historically at the month level (2021 - most recently completed month). Then aggregating it at the UTC hour (with notes on NYSE, London, and Tokyo market trading hours) to estimate differences in stablecoin adoption across global regions. Also includes a parallel breakdown looking at only transfers of $1,000 or less. This data is for exclusively the ethereum blockchain.
NFT Sales, Revenue, and Royalties
Oct 31, 2023 - NFT Sales (specifically bids won & sales denominated ETH, WETH, or Blur ETH) on Ethereum Mainnet. Aggregated over last 30 Days. The vast majority of NFT sales are denominated in WETH. Mostly to ignore spam tokens & wash trading.
Wormhole Dex Correlations
Oct 17, 2023 - In October, Wormhole users predominantly biased towards Uniswap v2 over v3 and Curve. This may indicate adoption from MEV bots and/or support for smaller tokens biased toward the v2 style exchange.
Gaming is off-chain
Mar 1, 2024 - Too much of crypto gaming is off-chain, even on "cheap" chains like Polygon.