Table description
The Substrate transfers table stores the types of stored assets, the sender and recipient, and the estimated value of the tokens converted into USD, if available.Table Schema
| Column | Type | Description |
|---|---|---|
year | INTEGER | Calendar year of the block (partition column) |
month | INTEGER | Calendar month of the block (partition column) |
day | INTEGER | Calendar day of the block (partition column) |
block_time | TIMESTAMP | The timestamp of the block containing this transfer |
block_number | BIGINT | The sequential number of the block containing this transfer |
event_id | VARCHAR | Unique identifier of the event that recorded this transfer |
extrinsic_id | VARCHAR | Identifier of the extrinsic that initiated this transfer |
section | VARCHAR | The pallet (module) that processed this transfer (e.g. Balances) |
method | VARCHAR | The transfer method name (e.g. Transfer, TransferKeepAlive) |
extrinsic_hash | VARBINARY | Hash of the extrinsic that initiated this transfer |
block_hash | VARBINARY | Hash of the block containing this transfer |
from_ss58 | VARCHAR | SS58-encoded address of the sender |
from_pub_key | VARBINARY | Public key of the sender |
to_ss58 | VARCHAR | SS58-encoded address of the recipient |
to_pub_key | VARBINARY | Public key of the recipient |
asset | VARCHAR | Asset type or identifier being transferred |
symbol | VARCHAR | Token symbol of the transferred asset (e.g. DOT, KSM) |
decimals | BIGINT | Number of decimal places for the token |
amount | DOUBLE | Transfer amount in human-readable units |
raw_amount | DECIMAL(38,9) | Transfer amount in the smallest denomination (Planck) |
updated_at | TIMESTAMP | When this record was last updated in the database |
ingested_at | TIMESTAMP | When this record was first ingested into the database |