Bucket
File Layout
Files are partitioned by market address and date:Schema
Each row in the Parquet file represents a single L2 snapshot:| Column | Type | Description |
|---|---|---|
id | string | Unique snapshot identifier |
market | string | Market contract address (lowercase) |
blockNumber | int64 | Block number at snapshot time |
timestamp | int64 | Block timestamp (Unix epoch seconds, UTC) |
bids | string | JSON array of bid price levels |
asks | string | JSON array of ask price levels |
bidCount | int32 | Number of bid levels in the snapshot |
askCount | int32 | Number of ask levels in the snapshot |
Reading with Python
pyarrow directly: