# Bitcoin

#### Bitcoin base type tables available to query

| Table Name                                                                                                                                          | Description                                                    |
| --------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------- |
| [`btc.blocks`](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/bitcoin/btc.blocks)                                  | Block headers                                                  |
| [`btc.recent_blocks`](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/bitcoin/btc.blocks)                           | Block headers from the last 30 minutes, \~3 blocks             |
| [`btc.transactions`](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/bitcoin/btc.transactions)                      | Block transactions                                             |
| [`btc.recent_transactions`](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/bitcoin/btc.transactions)               | Block transactions from the last 30 minutes, \~3 blocks        |
| [`btc.transaction_inputs`](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/bitcoin/btc.transaction_inputs)          | All inputs to transactions                                     |
| [`btc.recent_transaction_inputs`](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/bitcoin/btc.transaction_inputs)   | Inputs to transactions from the last 30 minutes, \~3 blocks    |
| [`btc.transaction_outputs`](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/bitcoin/btc.transaction_outputs)        | All outputs from transactions                                  |
| [`btc.recent_transaction_outputs`](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/bitcoin/btc.transaction_outputs) | Outputs from transactions from the last 30 minutes, \~3 blocks |

The table list is also available as a SQL query using `show tables`. For example:

```sql
SHOW TABLES IN btc
```

The columns and their schema available for each table can be viewed with the `describe <table>` command. For example:

```sql
/* Show the columns available */
DESCRIBE btc.blocks;
DESCRIBE btc.transactions;
DESCRIBE btc.transaction_inputs;
DESCRIBE btc.transaction_outputs;
```

#### Improving query performance - indexed columns

| Table Name                | Indexed Columns                  |
| ------------------------- | -------------------------------- |
| `btc.blocks`              | `number` `timestamp`             |
| `btc.transactions`        | `block_number` `block_timestamp` |
| `btc.transaction_inputs`  | `block_number` `block_timestamp` |
| `btc.transaction_outputs` | `block_number` `block_timestamp` |