charliemarketplace
EVM Snapshot
Nov 6, 2023 - Snapshots of acquired users, daily active users, NFT volume (USD) & # of NFT sales, DEX Swaps, and Contract deployments across the major EVM L1s and L2s. Also includes DeFiLlama Total Value Locked for the 7 EVM chains (USD). Daily & Monthly charts have separate (but still grouped) min/max parameters. Use YYYY-MM-DD format. Note that ANY metric in USD terms fluctuates as the token prices move. Often in-unit measures (e.g. gas token on each chain) is more useful for in-economy signal.
EVM Developer Snapshot
Feb 16, 2024 - What types of contracts are deployed to each EVM chain, which chain gets the most of which contract type?
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.
Cosmos Transfers: Hub vs Bridges (IBC In or Out)
Oct 31, 2023 - With numerous IBC launches in Q4 2023, Inter-Blockchain Communication Protocol (IBC) usage going through Cosmos Hub has skyrocketed. The 7-Day moving average shows a sustained increase of IBC In/Out transfers, exceeding Cosmos internal transfers for the first time since May 2023.
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.
BNB Accumulation
Nov 28, 2023 - Looking at BNB token accumulation on Binance Smart Chain, including Central Exchange flows To/From Binance's Central Exchange wallets.
OpenSea is too big!
Nov 11, 2021 - Track OpenSea dominance by # of sales, % of sales (count), and $$ sales all time and over time. We need to use truly decentralized NFT marketplaces!
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.
Ethereum Blockspace
Jul 4, 2022 - An overview of Ethereum's mechanics, and structural fundamentals.
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.
.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.
Solana Rewards
Nov 29, 2023 - Epoch Level Summaries for Solana Rewards across both Top Stakers and Top Validators.
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).
EVM Developer Trends
Jan 9, 2024 - Understanding Contract Development Patterns on Ethereum
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
ARB Claimer Review
Apr 20, 2023 - Quick look at those who claimed ARB and what they did with them after.
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?
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.
Bitcoin Weekly Fees vs Block Rewards
Jan 2, 2024 - Note: Left Axis is # of Bitcoin (raw); Right Axis is % (Fees / (Fees+Rewards))
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).
ETH Stake Stats
Jul 25, 2023 - Week by Week growth of Liquid Staked ETH markets (Negative values means more withdrawals than deposits!)
Uniswap Analytics
Jan 3, 2022 - Across Uniswap v2 & v3 on Mainnet - # of pools launched (over time) For the Top 30 pairs - total amount traded - avg amount traded - largest trade ever per pair TODO [ top 30 pairs] - top 100 largest trades - slippage for $10k - liquidity (USD + native) - fees generated (USD) - total fees paid (by asset)
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.
OP #2 Drop Review
Apr 21, 2023 - Optimism Foundation sent OP directly to users for the #2 Airdrop. NOTE THE FOLLOWING CAVEAT: We look at all transfers from OP Foundation after 2023-02-08 of the OP token. This pulls in miscellaneous grant distributions incorrectly. But as a % of total tokens it should be negligible for the purposes of categorizing actions.
Tracking my 1 ETH bet on OpenSea
Mar 1, 2022 - LooksRARE destroyed my bet LOL. Talk about wash trading!
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.
Avalanche Small-not-Micro Coin Trade Counts
Jan 9, 2024 - As Avalanche Foundation considers investment directly into culture/meme tokens. I wondered how many tokens are approaching some kind of "meme" status. Here, I emphasized the growth of tokens trading 100 - 1,000 times per day. The < 100 trades/day category was massive, as numerous tokens launch every day. 100 trades felt like a good minimum, while the over 1,000 category seemed small enough to consider as having "made it" in some sense. This Small, but not Micro, set of tokens (tokens trading 100-249 or 250-999 times per day) has skyrocketed on Avalanche over the last 3 months.
domi-avalanche
Jan 3, 2024 - miscellaneous token swap volume (in-unit AND USD equivalent) and moving average weighted USD price
Gaming is off-chain
Mar 1, 2024 - Too much of crypto gaming is off-chain, even on "cheap" chains like Polygon.
MKR DAO Snapshots
Aug 29, 2022 - Targeting users with > 100 MKR who don't vote much.
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.
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.