{
  "creationTime": "1714079977388",
  "description": "A structure that represents an entire block in the NEAR blockchain. Block is the main entity in NEAR Protocol blockchain. Blocks are produced in NEAR Protocol every second.",
  "etag": "ct9Qmxygz2FHdCokWSJvxQ==",
  "id": "bigquery-public-data:crypto_near_mainnet_us.blocks",
  "kind": "bigquery#table",
  "lastModifiedTime": "1732678421002",
  "location": "us-east1",
  "numActiveLogicalBytes": "1120611212",
  "numActivePhysicalBytes": "617918865",
  "numBytes": "20142929526",
  "numCurrentPhysicalBytes": "10991028785",
  "numLongTermBytes": "19022318314",
  "numLongTermLogicalBytes": "19022318314",
  "numLongTermPhysicalBytes": "10373109920",
  "numPartitions": "1592",
  "numRows": "123555713",
  "numTimeTravelPhysicalBytes": "0",
  "numTotalLogicalBytes": "20142929526",
  "numTotalPhysicalBytes": "10991028785",
  "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 previous Block",
        "mode": "NULLABLE",
        "name": "prev_block_hash",
        "type": "STRING"
      },
      {
        "description": "The total supply of the Block",
        "mode": "NULLABLE",
        "name": "total_supply",
        "type": "FLOAT"
      },
      {
        "description": "The gas price of the Block",
        "mode": "NULLABLE",
        "name": "gas_price",
        "type": "FLOAT"
      },
      {
        "description": "The AccountId of the author of the Block",
        "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/blocks>",
  "tableReference": {
    "datasetId": "crypto_near_mainnet_us",
    "projectId": "bigquery-public-data",
    "tableId": "blocks"
  },
  "timePartitioning": {
    "field": "block_date",
    "type": "DAY"
  },
  "type": "TABLE"
}