Block Explorer Dataset Schemas
The block explorer dataset contains the following tables organized by category:
Available Tables
addressTransactions - Links addresses to their transactions
addressTransfers - Records token transfers for each address
addresses - Contains contract addresses and their metadata
balances - Token balances for addresses at specific blocks
Block and Transaction Data
batches - L2 batch processing information
blocks - Block information and metadata
transactions - Detailed transaction data
transactionReceipts - Transaction execution results
logs - Smart contract event logs
Token Data
tokens - Token contract information
transfers - Token transfer events
System Tables
counterStates - Processing state tracking
counters - Various system counters
To explore any table's schema, use:
SELECT column_name, data_typeFROM `lens-public-data.testnet_block_explorer_public.INFORMATION_SCHEMA.COLUMNS`WHERE table_name = 'table_name';To list all the tables in the dataset, use:
SELECT table_nameFROM `lens-public-data.testnet_block_explorer_public.INFORMATION_SCHEMA.TABLES`;The datasets are updated every 15 minutes to reflect the latest network activity.