Table Description
Thethorchain.core_transfer_events table event data for native asset transfers on THORChain. This table captures transfer events between addresses. This table is partitioned by day.
Column Descriptions
| Column | Type | Description |
|---|---|---|
| from_address | varchar | Source address |
| to_address | varchar | Destination address |
| asset | varchar | Asset identifier |
| amount_e8 | bigint | Amount in e8 units (1e8 = 1 unit) |
| event_id | bigint | Event identifier |
| block_timestamp | timestamp | Timestamp of when the block was created |
| _inserted_timestamp | timestamp | Timestamp of the record |
| fact_transfer_events_id | bigint | Surrogate key for the transfer event record |
| day | timestamp | Date of the record |
| dim_block_id | bigint | Reference to the block dimension table |
| inserted_timestamp | timestamp | Time when the record was inserted |
| modified_timestamp | timestamp | Time when the record was last modified |