token_transfers

Schema: public

Description

The token_transfers table is used to store data about each token transfer on supported chains. It contains information such as the sender, recipient, contract, and value of each transfer. This table is useful for tracking the movement of tokens on the blockchain and analyzing token usage patterns.

Columns

Name	Type	Description	Default
id	character	Unique identifier for each transfer	None
chain	text	Name of the chain (e.g. kava, avalanche, etc.)	None
transaction_hash	text	Hash of the transaction where the transfer occurred	None
log_index	integer	Index of log that contains the transfer	None
consensus_time	timestamptz	Time at which the transfer was confirmed by the network	None
sender	text	Address of the sender	None
recipient	text	Address of the recipient	None
contract	text	Address of the token contract	None
entrypoint_contract	text	Address of the contract that was called by the transaction initiator	None
val	numeric	Raw amount of token transferred	None

Example

Get the most recent 10 transfers from our database

select *
from token_transfers
order by consensus_time desc
limit 10;

To get a human-friendly (decimaled) value for token transfers of a given token, use the function lib.transfers_for_token