Table Details
| Property | Value |
|---|---|
| Table Name | filecoin.raw.tipsets |
| Table Status | Beta 🌱 |
| Unique Key | timestamp, height |
| Clustering Key(s) | to_date("timestamp") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| height | NUMBER(38,0) | The block number (height) in the blockchain. |
| timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of this record. Alias for block_timestamp used in tables where the column is named timestamp rather than block_timestamp. |
| parent_base_fee | NUMBER(38,0) | Base fee of the parent tipset (attoFIL per gas unit), used to compute this tipset’s base fee |
| parent_weight | NUMBER(38,0) | Cumulative chain weight at the parent tipset |
| block_cids | VARIANT | Array of CIDs of all blocks included in this tipset |
| parent_block_cids | VARIANT | Array of CIDs of the parent tipset’s blocks |
| beacon_entries | VARIANT | Array of Drand randomness beacon entries included in this Filecoin block for verifiable randomness |
| parent_message_receipts | VARIANT | CID of the parent message receipts AMT |
| parent_state_root | VARIANT | CID of the state tree root after applying the parent tipset |
| block_cids_raw | VARIANT | Raw byte representation of the block CIDs array |
| parent_block_cids_raw | VARIANT | Raw byte representations of the parent block CIDs |
| block_count | NUMBER(38,0) | Number of blocks in this Filecoin tipset |
| miner_count | NUMBER(38,0) | Number of storage miners who produced blocks in this tipset |
| message_count | NUMBER(38,0) | Number of messages included in this Filecoin block or tipset |
| event_count | NUMBER(38,0) | Number of events emitted by this transaction, block, or receipt. |
| event_attribute_count | NUMBER(38,0) | Number of key-value attributes attached to all events in this transaction. |
| _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. |
| deal_event_count | NUMBER(38,0) | Number of deal state events recorded for this storage deal |
| fevm_token_transfer_count | NUMBER(38,0) | Number of EVM-compatible token transfers in this message |