Table Description
Thethorchain.core_transfers table records all native asset transfers on THORChain. This table tracks RUNE and other asset transfers between addresses on the THORChain network. This table is partitioned by day.
Column Descriptions
| Column | Type | Description |
|---|---|---|
| block_id | bigint | Identifier |
| from_address | varchar | Source address |
| to_address | varchar | Destination address |
| asset | varchar | Asset identifier |
| rune_amount | decimal(38,0) | Amount in RUNE |
| rune_amount_usd | decimal(20,6) | USD value of RUNE amount |
| _unique_key | varchar | Unique Key |
| _INSERTED_TIMESTAMP | timestamp | Timestamp of the record |
| fact_transfers_id | bigint | Surrogate key for the fact record |
| day | timestamp | Date of the record |
| block_timestamp | timestamp | Timestamp of when the block was created |
| 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 |