Bitcoin
All data tables available for Bitcoin.
The Bitcoin raw blockchain data tables in BigQuery.
Columns
Blocks
The bitcoin.blocks table provides indexed views of all blocks.
| Name | Type | Description |
|---|---|---|
| block_hash | string | The hash of all the block's contents. |
| l1_block_number | integer | The block's number. |
| gas_limit | integer | The maximum amount of gas that can be used in the block (in gas units). |
| gas_used | integer | The amount of gas used in the block (in gas units). |
| parent_hash | string | The hash of the block's parent block. |
| size | integer | The block's size (in bytes). |
| timestamp | timestamp | The block's timestamp. |
| transaction_count | integer | The number of transactions in the block. |
Transactions
The bitcoin.transactions table provides indexed views of all transactions that succeeded, or were partially successful (had at least 1 successful internal transaction).
| Name | Type | Description |
|---|---|---|
| block_number | integer | The block number the transaction was included in. |
| block_timestamp | timestamp | The transaction's timestamp. |
| from_address | string | The address of the transaction's sender. |
| gas_price | string | The actual price of gas used in the transaction (in Wei per gas unit). |
| receipt_gas_used | integer | The amount of gas used in the transaction (in gas units). |
| input | string | The input data for the transaction. |
| nonce | integer | The transaction sender's nonce. |
| to_address | string | The address of the transaction's recipient, if any. |
| transaction_hash | string | The transaction's hash. |
| transaction_type | integer | The type of the transaction (see EIP-1559, EIP-2718). |
| value | string | The amount sent by the transaction (in Wei). |
Updated about 1 year ago