Skip to content

Instantly share code, notes, and snippets.

@DenisCarriere

DenisCarriere/uniswap_data_summary.md

Created June 19, 2025 01:45
Show Gist options
  • Save DenisCarriere/96034a17785837f3248e2131ab723c36 to your computer and use it in GitHub Desktop.
Save DenisCarriere/96034a17785837f3248e2131ab723c36 to your computer and use it in GitHub Desktop.
Download ZIP
Uniswap Data Summary - Using The Graph Token API MCP
Raw
uniswap_data_summary.md

Uniswap Data Analysis Summary

Overview

This analysis covers the complete Uniswap decentralized exchange (DEX) dataset across multiple blockchain networks. Uniswap is one of the largest decentralized trading platforms, allowing users to swap cryptocurrencies without intermediaries.

Key Findings

Scale of Operations

  • Total Swap Transactions: Over 2.1 billion swaps across all networks
  • Time Period: April 2020 to June 2025 (5+ years of data)
  • Active Trading Pools: 448,649 unique pools on Ethereum mainnet alone
  • Daily Activity: ~280,000-310,000 swaps per day with 500-650 unique users daily

Network Distribution

The data spans 8 blockchain networks with varying activity levels:

Network Total Swaps Percentage
Base 743M 35.1%
Polygon 579M 27.3%
Ethereum Mainnet 356M 16.8%
Arbitrum One 299M 14.1%
Optimism 169M 8.0%
Others Various <5%

Protocol Evolution

Uniswap has evolved through multiple versions:

Uniswap V2 (Legacy)

  • 262M swaps (73.6% of Ethereum mainnet)
  • 413,820 pools
  • Simpler constant product model

Uniswap V3 (Current Main)

  • 91.8M swaps (25.8% of Ethereum mainnet)
  • 30,243 pools
  • Advanced concentrated liquidity features

Uniswap V4 (Latest)

  • 2.0M swaps (0.6% of Ethereum mainnet)
  • 4,587 pools
  • Newest features and improvements

Available Data Types

Transaction Data

  • Individual Swaps: Every trade with timestamps, amounts, prices, and participants
  • Pool Creation: When new trading pairs are established
  • Liquidity Operations: Adding and removing funds from pools

Market Data

  • OHLC Prices: Hourly open, high, low, close prices (52M records)
  • Volume Metrics: Trading volumes for all token pairs
  • Pool Activity: Aggregated statistics per pool

Metadata

  • Token Information: Names, symbols, decimal places for all traded tokens
  • Pool Details: Fee structures, token pairs, factory addresses
  • User Analytics: Unique active wallets and transaction patterns

Data Quality

Completeness

  • ✅ Full Historical Coverage: Complete data from protocol launch
  • ✅ Real-time Updates: Current through June 2025
  • ✅ Cross-chain Coverage: All major Uniswap deployments
  • ✅ Transaction-level Detail: Block-by-block precision

Reliability

  • Source: Direct blockchain data extraction
  • Verification: Cross-referenced across multiple data points
  • Consistency: Standardized schema across all networks

Use Cases

For Researchers

  • DeFi market analysis and trends
  • Liquidity provision strategies
  • Cross-chain activity comparisons
  • Protocol adoption studies

For Traders

  • Historical price analysis
  • Volume and liquidity tracking
  • Pool performance evaluation
  • Market maker analytics

For Developers

  • Building DEX applications
  • Integration with Uniswap data
  • Market making bot development
  • DeFi dashboard creation

For Investors

  • Protocol revenue analysis
  • Token pair performance
  • Market depth assessment
  • Risk evaluation

Technical Specifications

Database Structure

  • Primary Tables: swaps, pools, ohlc_prices, pool_activity_summary
  • Supporting Tables: Token metadata, protocol-specific events
  • Materialized Views: Optimized aggregations for fast queries
  • Format: SQL-queryable with standard database operations

Data Fields

Swap Records Include:

  • Timestamp and block information
  • Token amounts and prices
  • Pool and protocol identifiers
  • Transaction participants
  • Gas and fee data

Pool Records Include:

  • Creation timestamps
  • Token pair information
  • Fee structures
  • Factory contracts
  • Protocol versions

Recent Activity Snapshot (June 2025)

Daily Metrics

  • Average Daily Swaps: 290,000
  • Active Pools per Day: ~8,000
  • Unique Daily Users: 580
  • Cross-chain Activity: Consistent across all networks

Market Health Indicators

  • Pool Diversity: Thousands of active trading pairs
  • User Engagement: Steady daily active user count
  • Protocol Adoption: Strong V3 usage with emerging V4 activity
  • Network Distribution: Healthy spread across Layer 2 solutions

Conclusion

This Uniswap dataset represents one of the most comprehensive views into decentralized exchange activity available. With over 2 billion transactions across 8 networks and 5+ years of history, it provides unparalleled insights into:

  • The evolution of decentralized finance
  • Cross-chain trading patterns
  • Protocol innovation and adoption
  • Market microstructure in DeFi

The data's completeness, real-time nature, and granular detail make it suitable for everything from academic research to production trading systems.

Data current as of June 19, 2025. This analysis covers publicly available blockchain data from Uniswap protocol deployments.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment