Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR(16777216) | Slug identifying the blockchain this record belongs to. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. |
| log_index | NUMBER(38,0) | Zero-based position of this event log within its transaction. |
| from_address | VARCHAR(42) | Address that paid the charge. |
| to_address | VARCHAR(42) | Address that received the charge. |
| memo_server_hash | VARCHAR(16777216) | Hash identifying the MPP server the charge was paid to (from the payment memo). |
| token_address | VARCHAR(42) | Contract address of the token used for the payment. |
| token_name | VARCHAR(16777216) | Human-readable name of the payment token. |
| token_symbol | VARCHAR(16777216) | Ticker symbol of the payment token. |
| raw_amount | FLOAT | Payment amount in the token’s smallest indivisible unit. |
| amount | FLOAT | Decimal-adjusted payment amount. |
| usd_amount | FLOAT | USD value of the payment at the record’s timestamp. |
| usd_exchange_rate | FLOAT | USD price of one unit of the payment token at the record’s timestamp. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this 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. |