{
  "creationTime": "1698858694680",
  "description": "It's recomended to select only the columns and partitions (block_date) needed to avoid unecessary query costs. This view filters the receipt_actions table to have the latest account state based on action_kind CREATE_ACCOUNT, TRANSFER, and DELETE_ACCOUNT.",
  "etag": "OOfgw377hT916vlXK5izrA==",
  "id": "bigquery-public-data:crypto_near_mainnet_us.accounts",
  "kind": "bigquery#table",
  "lastModifiedTime": "1698859383137",
  "location": "us-east1",
  "numActiveLogicalBytes": "0",
  "numBytes": "0",
  "numLongTermBytes": "0",
  "numLongTermLogicalBytes": "0",
  "numRows": "0",
  "numTotalLogicalBytes": "0",
  "schema": {
    "fields": [
      {
        "description": "The date of the Block. Used to partition the table",
        "name": "block_date",
        "type": "DATE"
      },
      {
        "description": "The height of the Block",
        "name": "block_height",
        "type": "INTEGER"
      },
      {
        "description": "The timestamp of the Block in nanoseconds",
        "name": "block_timestamp",
        "type": "INTEGER"
      },
      {
        "description": "The timestamp of the Block in UTC",
        "name": "block_timestamp_utc",
        "type": "TIMESTAMP"
      },
      {
        "description": "The hash of the Block",
        "name": "block_hash",
        "type": "STRING"
      },
      {
        "description": "The hash of the Chunk",
        "name": "chunk_hash",
        "type": "STRING"
      },
      {
        "description": "The shard ID of the Chunk",
        "name": "shard_id",
        "type": "INTEGER"
      },
      {
        "description": "The index in the ACTION receipt",
        "name": "index_in_action_receipt",
        "type": "INTEGER"
      },
      {
        "description": "An unique id for the receipt",
        "name": "receipt_id",
        "type": "STRING"
      },
      {
        "description": "The account ID",
        "name": "account_id",
        "type": "STRING"
      },
      {
        "description": "The action kind: CREATE_ACCOUNT, DELETE_ACCOUNT, TRANSFER",
        "name": "action_kind",
        "type": "STRING"
      },
      {
        "description": "Active Flag",
        "name": "is_active",
        "type": "BOOLEAN"
      }
    ]
  },
  "selfLink": "<https://bigquery.googleapis.com/bigquery/v2/projects/bigquery-public-data/datasets/crypto_near_mainnet_us/tables/accounts>",
  "tableReference": {
    "datasetId": "crypto_near_mainnet_us",
    "projectId": "bigquery-public-data",
    "tableId": "accounts"
  },
  "type": "VIEW"
}