Table description
Thepolkadot.transfers table 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 |