When querying in BigQeury make sure you add the prefix celestia_ to all of the name tables below. For example, the table blocks should be:
select * from numia-data.celestia.celestia_blocks
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.
Contains all events and their corresponding attributes partitioned by block_height. Does not contain events triggered from messages and transactions signed by addresses. Events and their corresponding event_index are relative to the parent block , not the message or transactions. Events are identified by the event_type column and contains attributes by identified by attribute_key.
Contains all events and their corresponding attributes partitioned by tx_id and 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 can be extracted in event_atributes. Events are linked to transactions via column tx_id.
Contains relevant data associated with a transaction.
Contains the messages and their corresponding payload. Partitioned by tx_id where the combination of tx_id and message_index makes up the primary key.
Contains all information about active and non-active validators.
