Bitpulse DeFi Data Catalog Overview
Welcome to defi_liquidity — Bitpulse's query-ready DeFi dataset on BigQuery.
It packages clean views across chains and DEXes (networks, tokens, DEX instances, pools, OHLCV, and Uniswap v3 pools/states/swaps/positions).
Schemas are stable, timestamps are UTC, addresses are lowercase, and joins are via integer IDs for fast analytics.
Authentication
To access the Data Catalog:
- Visit the Access Permissions page and fill out the request form
- Our team will review your request
- Once approved, you'll be added directly to the BigQuery project with appropriate permissions
Query Tutorial: First Steps
New to BigQuery or need help getting started? Visit our Data Catalog BigQuery Tutorial: First Steps for beginner-friendly instructions, example queries, and practical tips to start exploring the Data Catalog immediately.
Available Tables
The Data Catalog provides access to the following tables:
Core Tables
- Network - Master registry of supported blockchains
- Block - Blockchain block information
- Token Contract - Network-specific token contract metadata
- DEX Instance - Deployments of DEX protocols per network
- Liquidity Pool - Registry of liquidity pools across DEXes
- Liquidity Pool Token - Token composition of liquidity pools
- Pool OHLCV - OHLCV time series per pool & direction
- Pool LP Position - Liquidity provider positions
- Pool TVL - Total value locked in pools
Protocol-Specific Tables
Uniswap V3
- Uniswap V3 Pool - Registry of Uniswap V3 pools
- Uniswap V3 Pool State - Time-series snapshots of V3 pool state
- Uniswap V3 Position - NFT-based liquidity positions
- Uniswap V3 Swap - Every Uniswap V3 swap with details
For any questions or support, please reach out to us at support@bitpulse.io