> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# polkadot.transfers

> Polkadot native token (DOT) transfers — sender, recipient, amount, and transfer type.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

## Table description

The `polkadot.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              |

## Table Sample

<TableSample tableSchema="polkadot" tableName="transfers" />