> ## 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.calls

> Description of Substrate calls tables on Dune.

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.calls` table represents *internal* calls within Substrate extrinsics, including recursive calls from `proxy` and `utility` (batch) pallets, and provides detailed call arguments at each level of the call tree. Unlike the `extrinsics` table which only captures the top-level call, this table exposes the full call hierarchy.

Common queries on the `calls` table will typically filter on `block_time`, `call_section` and `call_method` and extract JSON encoded information in
`data` or `decoded_data`.

## Table Schema

| Column              | Type        | Description                                                               |
| ------------------- | ----------- | ------------------------------------------------------------------------- |
| `year`              | `INTEGER`   | Calendar year of the block (partition column)                             |
| `month`             | `INTEGER`   | Calendar month of the block (partition column)                            |
| `call_section`      | `VARCHAR`   | The pallet (module) of this call (e.g. `Balances`, `Staking`)             |
| `call_method`       | `VARCHAR`   | The method name within the pallet (e.g. `transfer`, `bond`)               |
| `block_number`      | `BIGINT`    | The sequential number of the block containing this call                   |
| `block_time`        | `TIMESTAMP` | The timestamp of the block containing this call                           |
| `extrinsic_id`      | `VARCHAR`   | Identifier of the parent extrinsic (format: `blockNumber-extrinsicIndex`) |
| `relay_chain`       | `VARCHAR`   | Name of the relay chain (e.g. `polkadot`, `kusama`)                       |
| `para_id`           | `BIGINT`    | Parachain ID, if this call is on a parachain                              |
| `id`                | `VARCHAR`   | Unique identifier for this call                                           |
| `block_hash`        | `VARBINARY` | Hash of the block containing this call                                    |
| `extrinsic_hash`    | `VARBINARY` | Hash of the parent extrinsic                                              |
| `extrinsic_section` | `VARCHAR`   | The pallet of the top-level extrinsic                                     |
| `extrinsic_method`  | `VARCHAR`   | The method of the top-level extrinsic                                     |
| `call_id`           | `VARCHAR`   | Identifier for this specific call within the extrinsic                    |
| `call_index`        | `VARBINARY` | Encoded index of the call within the pallet                               |
| `call_args`         | `VARCHAR`   | JSON-encoded arguments passed to this call                                |
| `call_args_def`     | `VARCHAR`   | JSON-encoded definition/schema of the call arguments                      |
| `root`              | `BOOLEAN`   | Whether this is the root (top-level) call in the extrinsic                |
| `leaf`              | `BOOLEAN`   | Whether this is a leaf call with no further nested calls                  |
| `fee`               | `DOUBLE`    | Transaction fee paid for this call                                        |
| `weight`            | `BIGINT`    | Execution weight consumed by this call                                    |
| `signed`            | `BOOLEAN`   | Whether the parent extrinsic was signed                                   |
| `signer_ss58`       | `VARCHAR`   | SS58-encoded address of the extrinsic signer                              |
| `signer_pub_key`    | `VARBINARY` | Public key of the extrinsic signer                                        |
| `lifetime`          | `VARCHAR`   | Validity period of the extrinsic (mortal/immortal era)                    |
| `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="calls" />
