{
  "creationTime": "1717801710477",
  "description": "Describes how account's state has changed and the reason.",
  "etag": "8x2rtftpOxOMNZm9+/TahQ==",
  "id": "bigquery-public-data:crypto_near_mainnet_us.account_changes",
  "kind": "bigquery#table",
  "lastModifiedTime": "1732678360341",
  "location": "us-east1",
  "numActiveLogicalBytes": "958438046825",
  "numActivePhysicalBytes": "150510660295",
  "numBytes": "3909884279095",
  "numCurrentPhysicalBytes": "939441041978",
  "numLongTermBytes": "2951446232270",
  "numLongTermLogicalBytes": "2951446232270",
  "numLongTermPhysicalBytes": "788930381683",
  "numPartitions": "1591",
  "numRows": "16065009588",
  "numTimeTravelPhysicalBytes": "0",
  "numTotalLogicalBytes": "3909884279095",
  "numTotalPhysicalBytes": "939441041978",
  "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 index in the Block",
        "mode": "NULLABLE",
        "name": "index_in_block",
        "type": "INTEGER"
      },
      {
        "description": "Account ID affected by the change",
        "mode": "NULLABLE",
        "name": "affected_account_id",
        "type": "STRING"
      },
      {
        "description": "The transaction hash that caused the change",
        "mode": "NULLABLE",
        "name": "caused_by_transaction_hash",
        "type": "STRING"
      },
      {
        "description": "The receipt ID that caused the change",
        "mode": "NULLABLE",
        "name": "caused_by_receipt_id",
        "type": "STRING"
      },
      {
        "description": "The update reason",
        "mode": "NULLABLE",
        "name": "update_reason",
        "type": "STRING"
      },
      {
        "description": "Non stacked balance",
        "mode": "NULLABLE",
        "name": "affected_account_nonstaked_balance",
        "type": "FLOAT"
      },
      {
        "description": "Stacked balance",
        "mode": "NULLABLE",
        "name": "affected_account_staked_balance",
        "type": "FLOAT"
      },
      {
        "description": "Storage usage",
        "mode": "NULLABLE",
        "name": "affected_account_storage_usage",
        "type": "FLOAT"
      }
    ]
  },
  "selfLink": "<https://bigquery.googleapis.com/bigquery/v2/projects/bigquery-public-data/datasets/crypto_near_mainnet_us/tables/account_changes>",
  "tableReference": {
    "datasetId": "crypto_near_mainnet_us",
    "projectId": "bigquery-public-data",
    "tableId": "account_changes"
  },
  "timePartitioning": {
    "field": "block_date",
    "type": "DAY"
  },
  "type": "TABLE"
}