The aptos.assets.fungible_transfers table contains transfers of coin / fungible transfers.

Column NameDescription
from_addressThe source address of the fungible token transfer
to_addressThe destination address of the fungible token transfer
token_typeType of token - either ‘coin’ or ‘fungible_asset’
coin_addressContract address of the coin (applicable when token_type is ‘coin’)
coin_nameName of the coin (applicable when token_type is ‘coin’)
coin_symbolSymbol of the coin (applicable when token_type is ‘coin’)
coin_decimalsDecimal precision of the coin (applicable when token_type is ‘coin’)
fa_addressContract address of the fungible asset (applicable when token_type is ‘fungible_asset’)
fa_nameName of the fungible asset (applicable when token_type is ‘fungible_asset’)
fa_symbolSymbol of the fungible asset (applicable when token_type is ‘fungible_asset’)
fa_decimalsDecimal precision of the fungible asset (applicable when token_type is ‘fungible_asset’)
token_addressCoalesced address from either coin_address or fa_address
token_nameCoalesced name from either coin_name or fa_name
token_symbolCoalesced symbol from either coin_symbol or fa_symbol
token_decimalsCoalesced decimals from either coin_decimals or fa_decimals
match_typeClassification of how the transfer was matched/identified
transfer_typeType of transfer operation
withdraw_metadataJSON metadata for the withdrawal event
deposit_metadataJSON metadata for the deposit event
raw_amount_strRaw transfer amount as a string
raw_amountRaw transfer amount as a float
amount_strNormalized transfer amount as a string (adjusted for token decimals)
amountNormalized transfer amount as a float
usd_amountUSD value of the transfer at the time of transaction
usd_exchange_rateUSD exchange rate of the token at the time of transaction
tx_senderAddress that sent the transaction
tx_payloadFull payload details of the transaction
block_hashHash of the block containing the transfer
block_heightBlock number/height of the transfer
block_timestampTimestamp when the block was created
transaction_hashHash of the transaction containing the transfer
transaction_indexIndex of the transaction within the block
transaction_versionVersion number of the transaction
event_indexIndex of the event within the transaction
unique_idUnique identifier for the transfer event
created_atTimestamp when this record was created
updated_atTimestamp when this record was last updated
tx_functionFunction called in the transaction (currently null in the example)