{
"creationTime": "1693414060998",
"description": "A structure that represents a chunk in the NEAR blockchain. Chunk of a Block is a part of a Block from a Shard. The collection of Chunks of the Block forms the NEAR Protocol Block. Chunk contains all the structures that make the Block: Transactions, Receipts, and Chunk Header.",
"etag": "FYWyO+yKe5QGAFsToeaA1g==",
"id": "bigquery-public-data:crypto_near_mainnet_us.chunks",
"kind": "bigquery#table",
"lastModifiedTime": "1732678271591",
"location": "us-east1",
"numActiveLogicalBytes": "11052393154",
"numActivePhysicalBytes": "4853149823",
"numBytes": "107844197262",
"numCurrentPhysicalBytes": "53423586527",
"numLongTermBytes": "96791804108",
"numLongTermLogicalBytes": "96791804108",
"numLongTermPhysicalBytes": "48570436704",
"numPartitions": "1591",
"numRows": "400617997",
"numTimeTravelPhysicalBytes": "0",
"numTotalLogicalBytes": "107844197262",
"numTotalPhysicalBytes": "53423586527",
"partitionDefinition": {
"partitionedColumn": [
{
"field": "block_date"
}
]
},
"schema": {
"fields": [
{
"description": "The date of the Block. Used to partition the table",
"mode": "NULLABLE",
"name": "block_date",
"type": "DATE"
},
{
"description": "The height of the Block",
"mode": "NULLABLE",
"name": "block_height",
"type": "INTEGER"
},
{
"description": "The timestamp of the Block in nanoseconds",
"mode": "NULLABLE",
"name": "block_timestamp",
"type": "INTEGER"
},
{
"description": "The timestamp of the Block in UTC",
"mode": "NULLABLE",
"name": "block_timestamp_utc",
"type": "TIMESTAMP"
},
{
"description": "The hash of the Block",
"mode": "NULLABLE",
"name": "block_hash",
"type": "STRING"
},
{
"description": "The hash of the Chunk",
"mode": "NULLABLE",
"name": "chunk_hash",
"type": "STRING"
},
{
"description": "The shard ID of the Chunk",
"mode": "NULLABLE",
"name": "shard_id",
"type": "INTEGER"
},
{
"description": "The signature of the Chunk",
"mode": "NULLABLE",
"name": "signature",
"type": "STRING"
},
{
"description": "The gas limit of the Chunk",
"mode": "NULLABLE",
"name": "gas_limit",
"type": "FLOAT"
},
{
"description": "The amount of gas spent on computations of the Chunk",
"mode": "NULLABLE",
"name": "gas_used",
"type": "FLOAT"
},
{
"description": "The AccountId of the author of the Chunk",
"mode": "NULLABLE",
"name": "author_account_id",
"type": "STRING"
}
]
},
"selfLink": "<https://bigquery.googleapis.com/bigquery/v2/projects/bigquery-public-data/datasets/crypto_near_mainnet_us/tables/chunks>",
"tableReference": {
"datasetId": "crypto_near_mainnet_us",
"projectId": "bigquery-public-data",
"tableId": "chunks"
},
"timePartitioning": {
"field": "block_date",
"type": "DAY"
},
"type": "TABLE"
}