Contains each validated block in the chain. block_timestamp is only available in this table, so you need to do an inner join on block_height to get block_timestamp to the other tables.
Field
Type
block_height
STRING
block_timestamp
TIMESTAMP
chain_id
STRING
proposer_address
STRING
validators_hash
STRING
Contains all messages and their payloads. It is partitioned by ingestions_timestamp and clustered by message_type. The message column contains the message body in a json object so you will need to use the different BigQuery json functions to extract the values.
Field
Type
block_height
INTEGER
chain_id
STRING
tx_id
STRING
message_index
INTEGER
message_type
STRING
message
JSON
ingestion_timestamp
TIMESTAMP
Contains all events and their corresponding attributes partitioned by tx_id. Events and their corresponding event_index are relative to the parent transaction , not the message. Events are identified by the event_type column and attributes by the attribute_key. Events are linked to transactions via column tx_id.
Field
Type
block_height
INTEGER
chain_id
STRING
tx_id
STRING
event_index
INTEGER
event_type
STRING
attribute_key
STRING
attribute_value
STRING
attribute_index
INTEGER
ingestion_timestamp
TIMESTAMP
Contains all events and their corresponding attributes partitioned by message_index. Events and their corresponding event_index are relative to the parent message_index which is relative to the tx_id. Events are identified by the event_type column and attributes by the attribute_key. Events are linked to transactions via column tx_id.
Field
Type
block_height
STRING
chain_id
STRING
tx_id
STRING
message_index
INTEGER
event_index
INTEGER
event_type
STRING
attribute_key
STRING
attribute_value
STRING
attribute_index
INTEGER
ingestion_timestamp
TIMESTAMP
Contains relevant data associated with a transaction.