{
  "creationTime": "1693409006655",
  "description": "Transaction is the main way of interraction between a user and a blockchain. Transaction contains: Signer account ID, Receiver account ID, and Actions.",
  "etag": "XDDIqbEkwCI1zimpFNxG+w==",
  "id": "bigquery-public-data:crypto_near_mainnet_us.transactions",
  "kind": "bigquery#table",
  "lastModifiedTime": "1732678278360",
  "location": "us-east1",
  "numActiveLogicalBytes": "299202241376",
  "numActivePhysicalBytes": "106131775652",
  "numBytes": "1295392497002",
  "numCurrentPhysicalBytes": "485899828547",
  "numLongTermBytes": "996190255626",
  "numLongTermLogicalBytes": "996190255626",
  "numLongTermPhysicalBytes": "379768052895",
  "numPartitions": "1579",
  "numRows": "2759210995",
  "numTimeTravelPhysicalBytes": "0",
  "numTotalLogicalBytes": "1295392497002",
  "numTotalPhysicalBytes": "485899828547",
  "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 transaction hash",
        "mode": "NULLABLE",
        "name": "transaction_hash",
        "type": "STRING"
      },
      {
        "description": "The index in the Chunk",
        "mode": "NULLABLE",
        "name": "index_in_chunk",
        "type": "INTEGER"
      },
      {
        "description": "An account on which behalf transaction is signed",
        "mode": "NULLABLE",
        "name": "signer_account_id",
        "type": "STRING"
      },
      {
        "description": "An access key which was used to sign a transaction",
        "mode": "NULLABLE",
        "name": "signer_public_key",
        "type": "STRING"
      },
      {
        "description": "Nonce is used to determine order of transaction in the pool. It increments for a combination of `signer_id` and `public_key`",
        "mode": "NULLABLE",
        "name": "nonce",
        "type": "INTEGER"
      },
      {
        "description": "Receiver account for this transaction",
        "mode": "NULLABLE",
        "name": "receiver_account_id",
        "type": "STRING"
      },
      {
        "description": "A signature of a hash of the Borsh-serialized Transaction",
        "mode": "NULLABLE",
        "name": "signature",
        "type": "STRING"
      },
      {
        "description": "Transaction status",
        "mode": "NULLABLE",
        "name": "status",
        "type": "STRING"
      },
      {
        "description": "Receipt ID that the transaction was converted.",
        "mode": "NULLABLE",
        "name": "converted_into_receipt_id",
        "type": "STRING"
      },
      {
        "description": "Gas burnt in the receipt conversion",
        "mode": "NULLABLE",
        "name": "receipt_conversion_gas_burnt",
        "type": "INTEGER"
      },
      {
        "description": "Tokens burnt in the receipt conversion",
        "mode": "NULLABLE",
        "name": "receipt_conversion_tokens_burnt",
        "type": "FLOAT"
      }
    ]
  },
  "selfLink": "<https://bigquery.googleapis.com/bigquery/v2/projects/bigquery-public-data/datasets/crypto_near_mainnet_us/tables/transactions>",
  "tableReference": {
    "datasetId": "crypto_near_mainnet_us",
    "projectId": "bigquery-public-data",
    "tableId": "transactions"
  },
  "timePartitioning": {
    "field": "block_date",
    "type": "DAY"
  },
  "type": "TABLE"
}