Skip to main content
Schema: movement.core Table: fact_transfers Type: Base Table

What

This table contains Deposit and Withdraw events on the Movement blockchain. Note: transfers with a 0 amount are excluded.

Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERAlso known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed.
VERSIONNUMBERThe version also know as the height of the transactions that have been executed on the Movement blockchain. The first transaction in the blockchain has a version of 0. The version number is incremented by 1 for each transaction that is executed on the blockchain.
SUCCESSBOOLEANThe boolean value indicating whether the transaction was successful or not.
EVENT_INDEXNUMBERUnique identifier for the event. This is a monotonically increasing integer that is incremented for each event. This is useful for determining the order of changes.
CREATION_NUMBERNUMBERCeation number corresponding to the event stream originating from the given account.
TRANSFER_EVENTTEXTThe type of transfer event. Value will either be ‘WithdrawEvent’ or ‘DepositEvent’
ACCOUNT_ADDRESSTEXTThe top level address for this event.
AMOUNTNUMBERThe non-decimal adjusted amount of a token. For example, if a token has 18 decimals, then the amount of 1 token is 10^18.
TOKEN_ADDRESSTEXTThe full address of the token. This string contains the account,module, and resource.
IS_FUNGIBLEBOOLEANBoolean indicating whether the transfer was conducted using the legacy coin transfer mechanism (a simpler, original method for transferring coins) or the fungible_asset module (a newer, more flexible system for managing fungible assets).
STORE_ADDRESSTEXTAddress of the fungible store
FACT_TRANSFERS_IDTEXTThe unique identifier for each row in the table.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.