Skip to main content

Table Description

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

ColumnTypeDescription
block_idbigintIdentifier
from_addressvarcharSource address
to_addressvarcharDestination address
assetvarcharAsset identifier
rune_amountdecimal(38,0)Amount in RUNE
rune_amount_usddecimal(20,6)USD value of RUNE amount
_unique_keyvarcharUnique Key
_INSERTED_TIMESTAMPtimestampTimestamp of the record
fact_transfers_idbigintSurrogate key for the fact record
daytimestampDate of the record
block_timestamptimestampTimestamp of when the block was created
dim_block_idbigintReference to the block dimension table
inserted_timestamptimestampTime when the record was inserted
modified_timestamptimestampTime when the record was last modified

Table Sample