Pinax

    Datasets

    Blockchain tables over S3, queried with your own project credentials.

    Delta Lake · Parquet · AWS Signature Version 4
    Resources & endpoints

    Blockchain tables over S3

    Finalized blockchain blocks, decoded into query-ready tables and partitioned by date. Read them from S3 with DuckDB, Polars, Spark or another Delta Lake client, using your own Pinax Project ID and API key.

    Ethereum backfillEthereum is backfilling from genesis and has not reached the chain head yet.

    Use it for

    • Analytics and research
    • Data warehouses and lakehouses
    • Backtesting and ML features
    Delta LakeParquet (zstd)Apache Iceberg · coming soon

    File layout

    s3://eth/blocks/date=YYYY-MM-DD/part-….zstd.parquet
s3://eth/transactions/date=YYYY-MM-DD/part-….zstd.parquet
s3://eth/logs/date=YYYY-MM-DD/part-….zstd.parquet

    Endpoint https://datasets.s3.pinax.network · bucket eth. Dates are UTC. The paths above illustrate the layout; query tables through their Delta log.

    Networks

    Ethereum Ethereum

    Backfilling from genesis

    s3://eth
    blockstransactionslogscallsstorage_changes+15 more
    BaseBases3://baseComing later · coverage and start block are not yet set
    BNBBNB Smart Chains3://bscComing later · coverage and start block are not yet set

    Tables

    Ethereum has 20 EVM tables: blocks, transactions, logs, withdrawals, access-list entries, code authorizations, calls and state changes. Each is partitioned by date. Pick a table to see its columns, or explore the Schemas reference.

    blockstransactionslogswithdrawalsaccess_listsset_code_authorizationscallsbalance_changescode_changesstorage_changesnonce_changesgas_changesaccount_creationssystem_callssystem_balance_changessystem_code_changessystem_storage_changessystem_nonce_changessystem_gas_changessystem_account_creations

    Read through the Delta log with delta_scan or scan_delta. Compaction replaces files, and the log identifies the active ones. SQL & Connect shows how to get started.

    SQL & Connect

    Connect DuckDB, Python, AWS CLI or Node.js with your own project.

    Iceberg catalogComing soon

    Learn how the REST catalog will describe the tables.

    Schemas

    Explore EVM, Solana, Bitcoin and Beacon table definitions.

    Try It

    Browse Ethereum tables, filter their files and preview rows.