hyperliquid.raw.builder_transactions table contains successfully completed transactions with builder address and fee.
Table Details
| Property | Value |
|---|---|
| Table Name | hyperliquid.raw.builder_transactions |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, hash |
| Clustering Key(s) | block_timestamp::date |
| Search Optimization | block_height, hash, user |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| builder | VARCHAR(134217728) | The builder address associated with the transaction |
| f | VARCHAR(134217728) | The builder fee |
| action_type | VARCHAR(134217728) | The type of action triggered by the transaction |
| action | VARIANT | The full action payload as a JSON variant |
| error | VARCHAR(134217728) | Error message if the action in the transaction failed |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block the transaction belongs to |
| block_height | NUMBER(38,0) | The height of the block the transaction belongs to |
| hash | VARCHAR(134217728) | Transaction hash |
| user | VARCHAR(134217728) | The address of the user that executed the transaction |
| _ingested_at | TIMESTAMP_NTZ(9) | Ingestion timestamp for the row. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |