{
"clustering": {
"fields": [
"account_id"
]
},
"creationTime": "1709149927140",
"description": "Fungible Tokens daily balances",
"etag": "qNmt4PuGZ/vA32J9kUcvEA==",
"id": "bigquery-public-data:crypto_near_mainnet_us.ft_balances_daily",
"kind": "bigquery#table",
"lastModifiedTime": "1732635265539",
"location": "us-east1",
"numActiveLogicalBytes": "244596970",
"numActivePhysicalBytes": "60333718",
"numBytes": "1542339696",
"numCurrentPhysicalBytes": "353821968",
"numLongTermBytes": "1297742726",
"numLongTermLogicalBytes": "1297742726",
"numLongTermPhysicalBytes": "293488250",
"numPartitions": "683",
"numRows": "10345089",
"numTimeTravelPhysicalBytes": "0",
"numTotalLogicalBytes": "1542339696",
"numTotalPhysicalBytes": "353821968",
"partitionDefinition": {
"partitionedColumn": [
{
"field": "epoch_date"
}
]
},
"schema": {
"fields": [
{
"description": "The date of the Epoch. Used to partition the table",
"mode": "NULLABLE",
"name": "epoch_date",
"type": "DATE"
},
{
"description": "The max height of the Block in the epoch",
"mode": "NULLABLE",
"name": "epoch_block_height",
"type": "STRING"
},
{
"description": "The delegator Account ID",
"mode": "NULLABLE",
"name": "account_id",
"type": "STRING"
},
{
"description": "Liquid balance",
"mode": "NULLABLE",
"name": "liquid",
"type": "FLOAT"
},
{
"description": "Storage Usage",
"mode": "NULLABLE",
"name": "storage_usage",
"type": "INTEGER"
},
{
"description": "Unstaked balance",
"mode": "NULLABLE",
"name": "unstaked_not_liquid",
"type": "FLOAT"
},
{
"description": "Staked balance",
"mode": "NULLABLE",
"name": "staked",
"type": "FLOAT"
},
{
"description": "Reward",
"mode": "NULLABLE",
"name": "reward",
"type": "FLOAT"
},
{
"description": "The lockup delegator Account ID",
"mode": "NULLABLE",
"name": "lockup_account_id",
"type": "STRING"
},
{
"description": "Lockup liquid balance",
"mode": "NULLABLE",
"name": "lockup_liquid",
"type": "FLOAT"
},
{
"description": "Lockup unstaked balance",
"mode": "NULLABLE",
"name": "lockup_unstaked_not_liquid",
"type": "FLOAT"
},
{
"description": "Lockup staked balance",
"mode": "NULLABLE",
"name": "lockup_staked",
"type": "FLOAT"
},
{
"description": "Lockup Reward",
"mode": "NULLABLE",
"name": "lockup_reward",
"type": "FLOAT"
}
]
},
"selfLink": "<https://bigquery.googleapis.com/bigquery/v2/projects/bigquery-public-data/datasets/crypto_near_mainnet_us/tables/ft_balances_daily>",
"tableReference": {
"datasetId": "crypto_near_mainnet_us",
"projectId": "bigquery-public-data",
"tableId": "ft_balances_daily"
},
"timePartitioning": {
"field": "epoch_date",
"type": "DAY"
},
"type": "TABLE"
}