> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Logs

Logs (or event logs), is a way for [smart contracts](https://ethereum.org/en/developers/docs/smart-contracts/#what-is-a-smart-contract) to communicate with the outside world by "documenting" small pieces of information. Event logs allow other people to know that something has happened without them having to query the contract directly.

### Table Details

| Property            | Value                                                   |
| ------------------- | ------------------------------------------------------- |
| Table Name          | `hyperevm.raw.logs`                                     |
| Table Status        | Production-Ready                                        |
| Unique Key          | `transaction_hash`, `log_index`                         |
| Clustering Key(s)   | `to_date("block_timestamp")`                            |
| Search Optimization | `transaction_hash`, `block_number`, `topic0`, `address` |

### Table Columns

| Column Name        | Data Type         | Description                                                                                          |
| ------------------ | ----------------- | ---------------------------------------------------------------------------------------------------- |
| transaction\_hash  | VARCHAR(66)       | Unique identifier of the transaction that this log belongs to.                                       |
| transaction\_index | NUMBER(38,0)      | The position of this transaction in the block that it belongs to. The first transaction has index 0. |
| log\_index         | NUMBER(38,0)      | The position of this log in the block that it belongs to. The first log has index 0.                 |
| from\_address      | VARCHAR(42)       | The address of the sending party of this transaction.                                                |
| to\_address        | VARCHAR(42)       | The address of the receiving party of this transaction, typically a contract address for logs.       |
| address            | VARCHAR(42)       | The address of the contract that emitted this log.                                                   |
| data               | VARCHAR(16777216) | Unindexed data containing further information of the event, encoded in hex.                          |
| topic0             | VARCHAR(66)       | The keccak256 hash of a flattened event signature string.                                            |
| topic1             | VARCHAR(66)       | First indexed topic of the event.                                                                    |
| topic2             | VARCHAR(66)       | Second indexed topic of the event.                                                                   |
| topic3             | VARCHAR(66)       | Third indexed topic of the event.                                                                    |
| block\_timestamp   | TIMESTAMP\_NTZ(9) | The time when the block that contains this log was included on the blockchain.                       |
| block\_number      | NUMBER(38,0)      | The length of the chain, in blocks.                                                                  |
| block\_hash        | VARCHAR(66)       | Unique identifier of the block that includes this log.                                               |
| \_created\_at      | TIMESTAMP\_NTZ(9) | Timestamp of the entry creation.                                                                     |
| \_updated\_at      | TIMESTAMP\_NTZ(9) | Timestamp of the entry update.                                                                       |

### Related Docs

* [EVM Raw Logs](/historical-data/supported-blockchains/evm/core-schemas/raw/logs)