Skip to main content

Table Details

PropertyValue
Table Namemonad_testnet.assets.fungible_token_transfers
Table StatusProduction-Ready
Unique Keytransaction_hash, log_index

Table Columns

Column NameData TypeDescription
token_typeVARCHAR(16777216)Type of the token (e.g., ‘erc20’, ‘native’)
from_addressVARCHAR(42)Address from which the tokens were transferred
to_addressVARCHAR(42)Address where the tokens were transferred to
token_addressVARCHAR(42)Token address of the token
token_nameVARCHAR(16777216)Name of the token
token_symbolVARCHAR(16777216)Token symbol
raw_amount_strVARCHAR(16777216)Amount of tokens moved (unnormalized) in string
raw_amountFLOATAmount of tokens moved (unnormalized)
amount_strVARCHAR(16777216)Amount of tokens moved, normalized in string
amountFLOATAmount of tokens moved, normalized by the decimal points defined in the token contract
usd_amountFLOATThe amount of tokens moved, in $USD
usd_exchange_rateFLOATThe price of a single token, in USD
transaction_from_addressVARCHAR(42)The address that initiated the transaction
transaction_to_addressVARCHAR(42)The address that received the transaction
transaction_hashVARCHAR(66)Transaction hash that this transfer belongs to
transaction_indexNUMBER(38,0)The position of this transaction in the block. The first transaction has index 0
log_indexNUMBER(38,0)The position of this log within the block. The first log has index 0
call_typeVARCHAR(16777216)Type of the call that generated this transfer
transfer_typeVARCHAR(16777216)Type of the transfer
block_timestampTIMESTAMP_NTZ(9)The timestamp of the block that contains this transfer
block_numberNUMBER(38,0)The block number that contains this transfer
block_hashVARCHAR(66)The block hash that contains this transfer
unique_idVARCHAR(16777216)Unique id for each transfer, includes transaction hash, log index and credit/debit type
_tokens_updated_atTIMESTAMP_NTZ(9)Timestamp when token metadata was last updated
_created_atTIMESTAMP_NTZ(9)Timestamp when this record was created
_updated_atTIMESTAMP_NTZ(9)Timestamp when this record was last updated
_changed_since_full_refreshBOOLEANIndicates if the record has changed since the last full refresh