{ "database": "nvdaxcom_galliumhash_metabuilder", "timestamp": "2026-08-23T02:46:35+00:00", "tables": [ { "name": "addresses", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "address", "type": "varchar(100)", "null": "NO", "key": "UNI", "default": null, "extra": "" }, { "name": "address_type", "type": "varchar(20)", "null": "YES", "key": "MUL", "default": null, "extra": "" }, { "name": "balance", "type": "decimal(20,8)", "null": "YES", "key": "MUL", "default": "0.00000000", "extra": "" }, { "name": "total_received", "type": "decimal(20,8)", "null": "YES", "key": "", "default": "0.00000000", "extra": "" }, { "name": "total_sent", "type": "decimal(20,8)", "null": "YES", "key": "", "default": "0.00000000", "extra": "" }, { "name": "transaction_count", "type": "int(11)", "null": "YES", "key": "", "default": "0", "extra": "" }, { "name": "first_seen", "type": "datetime", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "last_seen", "type": "datetime", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "is_exchange", "type": "tinyint(1)", "null": "YES", "key": "", "default": "0", "extra": "" }, { "name": "is_whale", "type": "tinyint(1)", "null": "YES", "key": "MUL", "default": "0", "extra": "" }, { "name": "label", "type": "varchar(255)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "", "default": "current_timestamp()", "extra": "" }, { "name": "updated_at", "type": "datetime", "null": "YES", "key": "", "default": "current_timestamp()", "extra": "on update current_timestamp()" } ], "row_count": 0, "sample_data": null }, { "name": "api_calls", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "endpoint", "type": "varchar(255)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "response_code", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "response_time_ms", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "data_size_bytes", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "called_at", "type": "datetime", "null": "YES", "key": "MUL", "default": "current_timestamp()", "extra": "" } ], "row_count": 5907, "sample_data": { "id": 1265, "endpoint": "https://mempool.space/api/mempool/recent", "response_code": 200, "response_time_ms": 30, "data_size_bytes": 1127, "called_at": "2025-10-27 19:38:56" } }, { "name": "api_health_monitoring", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "api_source", "type": "varchar(50)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "endpoint", "type": "varchar(255)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "status", "type": "enum('success','failed','timeout','rate_limited')", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "response_time_ms", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "http_code", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "error_message", "type": "text", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "created_at", "type": "datetime", "null": "YES", "key": "", "default": "current_timestamp()", "extra": "" } ], "row_count": 726, "sample_data": { "id": 176, "api_source": "blockchair", "endpoint": "/stats", "status": "success", "response_time_ms": 3306, "http_code": 200, "error_message": null, "created_at": "2025-10-27 20:14:50" } }, { "name": "blocks", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "block_hash", "type": "varchar(64)", "null": "NO", "key": "UNI", "default": null, "extra": "" }, { "name": "block_height", "type": "int(11)", "null": "NO", "key": "UNI", "default": null, "extra": "" }, { "name": "timestamp", "type": "bigint(20)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "block_time", "type": "datetime", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "size_bytes", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "weight", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "transaction_count", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "difficulty", "type": "decimal(30,2)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "nonce", "type": "bigint(20) unsigned", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "merkle_root", "type": "varchar(64)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "previous_block_hash", "type": "varchar(64)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "total_fees", "type": "decimal(20,8)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "block_subsidy", "type": "decimal(20,8)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "miner_pool", "type": "varchar(100)", "null": "YES", "key": "MUL", "default": null, "extra": "" }, { "name": "coinbase_data", "type": "text", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "version", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "bits", "type": "varchar(16)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "MUL", "default": "current_timestamp()", "extra": "" } ], "row_count": 365, "sample_data": { "id": 68, "block_hash": "00000000000000000001a7477689e1dddbb1aa826c76d85c4c825ed98fe155d1", "block_height": 920286, "timestamp": 1761155344, "block_time": "2025-10-22 17:49:04", "size_bytes": 1841013, "weight": 3993504, "transaction_count": 3242, "difficulty": "146716052770110.00", "nonce": 1264672588, "merkle_root": "bad16ed7607cd4daf698ee3c0e74dd22628774158b56c895c8c91c358c0e74df", "previous_block_hash": "00000000000000000001bae012cf2eb3f60a58b264e0bd84de8ec76edaf9e70e", "total_fees": "0.00000000", "block_subsidy": "0.00000000", "miner_pool": "Unknown", "coinbase_data": "", "version": 780296192, "bits": "386001697", "collected_at": "2025-10-22 18:11:29" } }, { "name": "collection_logs", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "collector_name", "type": "varchar(50)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "collection_type", "type": "varchar(50)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "status", "type": "enum('success','partial','failed')", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "records_collected", "type": "int(11)", "null": "YES", "key": "", "default": "0", "extra": "" }, { "name": "error_message", "type": "text", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "execution_time_ms", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "started_at", "type": "datetime", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "completed_at", "type": "datetime", "null": "YES", "key": "", "default": null, "extra": "" } ], "row_count": 3196, "sample_data": { "id": 3120, "collector_name": "PoolCollector", "collection_type": "pools", "status": "success", "records_collected": 23, "error_message": null, "execution_time_ms": 1132, "started_at": "2025-10-28 19:06:44", "completed_at": "2025-10-28 19:06:45" } }, { "name": "exchange_prices", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "snapshot_time", "type": "datetime", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "exchange_name", "type": "varchar(50)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "trading_pair", "type": "varchar(20)", "null": "NO", "key": "", "default": "BTC/USD", "extra": "" }, { "name": "bid_price", "type": "decimal(15,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "ask_price", "type": "decimal(15,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "last_price", "type": "decimal(15,2)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "volume_24h", "type": "decimal(20,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "spread_percentage", "type": "decimal(6,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "", "default": "current_timestamp()", "extra": "" } ], "row_count": 15, "sample_data": { "id": 12, "snapshot_time": "2025-10-29 09:11:37", "exchange_name": "coingecko", "trading_pair": "BTC/USD", "bid_price": null, "ask_price": null, "last_price": "113082.00", "volume_24h": "67685391284.00", "spread_percentage": null, "collected_at": "2025-10-29 09:11:37" } }, { "name": "fee_estimates", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "snapshot_id", "type": "bigint(20)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "fastest_fee", "type": "decimal(12,4)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "half_hour_fee", "type": "decimal(12,4)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "hour_fee", "type": "decimal(12,4)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "economy_fee", "type": "decimal(12,4)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "minimum_fee", "type": "decimal(12,4)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "MUL", "default": "current_timestamp()", "extra": "" } ], "row_count": 808, "sample_data": { "id": 198, "snapshot_id": 198, "fastest_fee": "1.0000", "half_hour_fee": "1.0000", "hour_fee": "1.0000", "economy_fee": "1.0000", "minimum_fee": "1.0000", "collected_at": "2025-10-27 20:05:31" } }, { "name": "market_data", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "snapshot_time", "type": "datetime", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "data_source", "type": "varchar(50)", "null": "NO", "key": "MUL", "default": "unknown", "extra": "" }, { "name": "price_usd", "type": "decimal(15,2)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "price_eur", "type": "decimal(15,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "price_gbp", "type": "decimal(15,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "price_change_24h", "type": "decimal(8,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "price_change_7d", "type": "decimal(8,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "price_change_30d", "type": "decimal(8,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "market_dominance", "type": "decimal(5,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "price_change_percentage_24h", "type": "decimal(6,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "market_cap_usd", "type": "decimal(20,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "volume_24h_usd", "type": "decimal(20,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "volume_24h_btc", "type": "decimal(15,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "price_change_1h", "type": "decimal(8,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "circulating_supply", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "total_supply", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "max_supply", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "ath_price", "type": "decimal(15,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "ath_date", "type": "datetime", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "atl_price", "type": "decimal(15,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "atl_date", "type": "datetime", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "source_response_time_ms", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "MUL", "default": "current_timestamp()", "extra": "" } ], "row_count": 15, "sample_data": { "id": 6, "snapshot_time": "2025-10-28 19:06:47", "data_source": "coingecko", "price_usd": "114916.00", "price_eur": "98521.00", "price_gbp": "86521.00", "price_change_24h": "-0.15", "price_change_7d": "2.38", "price_change_30d": "4.26", "market_dominance": "0.00", "price_change_percentage_24h": null, "market_cap_usd": "2293468346485.00", "volume_24h_usd": "57088648225.00", "volume_24h_btc": "496754.0000", "price_change_1h": "-0.29", "circulating_supply": "19941253.00000000", "total_supply": "19941253.00000000", "max_supply": null, "ath_price": "126080.00", "ath_date": "2025-10-06 18:57:42", "atl_price": "67.81", "atl_date": "2013-07-06 00:00:00", "source_response_time_ms": null, "collected_at": "2025-10-28 19:06:47" } }, { "name": "mempool_snapshots", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "snapshot_time", "type": "datetime", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "total_size_mb", "type": "decimal(10,2)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "transaction_count", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "total_fees", "type": "decimal(20,8)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "minimum_fee_rate", "type": "decimal(12,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "median_fee_rate", "type": "decimal(12,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "average_fee_rate", "type": "decimal(12,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "oldest_tx_timestamp", "type": "bigint(20)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "MUL", "default": "current_timestamp()", "extra": "" } ], "row_count": 809, "sample_data": { "id": 278, "snapshot_time": "2025-10-27 20:18:42", "total_size_mb": "36.58", "transaction_count": 101429, "total_fees": "0.06268085", "minimum_fee_rate": "0.0000", "median_fee_rate": "10.0000", "average_fee_rate": "0.1713", "oldest_tx_timestamp": null, "collected_at": "2025-10-27 20:18:42" } }, { "name": "mempool_state", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "", "default": "0", "extra": "" }, { "name": "timestamp", "type": "datetime", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "size_mb", "type": "decimal(10,2)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "tx_count", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "total_fees", "type": "decimal(20,8)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "min_fee", "type": "decimal(12,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "median_fee", "type": "decimal(12,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "avg_fee", "type": "decimal(12,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "oldest_tx_timestamp", "type": "bigint(20)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "", "default": "current_timestamp()", "extra": "" } ], "row_count": 809, "sample_data": { "id": 418, "timestamp": "2025-10-27 20:41:21", "size_mb": "36.90", "tx_count": 103040, "total_fees": "0.08517736", "min_fee": "0.0000", "median_fee": "10.0000", "avg_fee": "0.2309", "oldest_tx_timestamp": null, "collected_at": "2025-10-27 20:41:21" } }, { "name": "mempool_transactions", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "snapshot_id", "type": "bigint(20)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "txid", "type": "varchar(64)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "entry_time", "type": "datetime", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "fee", "type": "decimal(20,8)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "fee_rate", "type": "decimal(12,4)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "size_bytes", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "vsize", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "ancestor_count", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "ancestor_size", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "ancestor_fees", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "descendant_count", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "descendant_size", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "descendant_fees", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "is_rbf", "type": "tinyint(1)", "null": "YES", "key": "", "default": "0", "extra": "" }, { "name": "estimated_blocks_to_confirm", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" } ], "row_count": 8080, "sample_data": { "id": 525, "snapshot_id": 53, "txid": "002c1943eaed4c2d1b44053a10bb63a9df61ae53d48bc9c0740150c5f33a5e07", "entry_time": "2025-10-22 16:36:29", "fee": "0.00001520", "fee_rate": "0.0000", "size_bytes": 0, "vsize": 275, "ancestor_count": null, "ancestor_size": null, "ancestor_fees": null, "descendant_count": null, "descendant_size": null, "descendant_fees": null, "is_rbf": 0, "estimated_blocks_to_confirm": null } }, { "name": "mining_pools", "columns": [ { "name": "id", "type": "int(11)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "pool_name", "type": "varchar(100)", "null": "NO", "key": "UNI", "default": null, "extra": "" }, { "name": "pool_identifier", "type": "varchar(50)", "null": "YES", "key": "UNI", "default": null, "extra": "" }, { "name": "coinbase_signature", "type": "varchar(255)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "website_url", "type": "varchar(255)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "first_seen", "type": "datetime", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "last_seen", "type": "datetime", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "is_active", "type": "tinyint(1)", "null": "YES", "key": "MUL", "default": "1", "extra": "" }, { "name": "created_at", "type": "datetime", "null": "YES", "key": "", "default": "current_timestamp()", "extra": "" } ], "row_count": 29, "sample_data": { "id": 21, "pool_name": "Est3lar", "pool_identifier": "est3lar", "coinbase_signature": null, "website_url": "https://est3lar.io", "first_seen": "2025-10-22 02:54:16", "last_seen": "2025-10-29 09:30:11", "is_active": 1, "created_at": "2025-10-22 02:54:16" } }, { "name": "network_stats", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "snapshot_time", "type": "datetime", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "data_source", "type": "varchar(50)", "null": "YES", "key": "", "default": "unknown", "extra": "" }, { "name": "source_response_time_ms", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "source_reliability_score", "type": "decimal(3,2)", "null": "YES", "key": "", "default": "1.00", "extra": "" }, { "name": "hash_rate_ehs", "type": "decimal(12,4)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "difficulty", "type": "decimal(30,2)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "next_difficulty_adjustment", "type": "decimal(10,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "blocks_until_adjustment", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "average_block_time", "type": "decimal(10,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "blocks_count_24h", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "nodes_online", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "utxo_count", "type": "bigint(20)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "utxo_set_size_gb", "type": "decimal(10,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "MUL", "default": "current_timestamp()", "extra": "" } ], "row_count": 793, "sample_data": { "id": 210, "snapshot_time": "2025-10-27 20:09:46", "data_source": "blockchair", "source_response_time_ms": 3317, "source_reliability_score": "1.00", "hash_rate_ehs": "1080.8587", "difficulty": "146716052770110.00", "next_difficulty_adjustment": "160.3938", "blocks_until_adjustment": 0, "average_block_time": "600.00", "blocks_count_24h": 148, "nodes_online": null, "utxo_count": null, "utxo_set_size_gb": "696.01", "collected_at": "2025-10-27 20:09:46" } }, { "name": "pool_distribution_snapshots", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "period_hours", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "snapshot_time", "type": "datetime", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "total_blocks", "type": "int(11)", "null": "NO", "key": "", "default": "0", "extra": "" }, { "name": "unique_pools_count", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "top_pool_market_share", "type": "decimal(5,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "top_3_combined_share", "type": "decimal(5,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "top_5_combined_share", "type": "decimal(5,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "herfindahl_index", "type": "decimal(6,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "nakamoto_coefficient", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "decentralization_score", "type": "decimal(5,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "data_source", "type": "varchar(50)", "null": "YES", "key": "", "default": "unknown", "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "", "default": "current_timestamp()", "extra": "" } ], "row_count": 58, "sample_data": { "id": 52, "period_hours": 72, "snapshot_time": "2026-07-21 08:42:58", "total_blocks": 9, "unique_pools_count": 4, "top_pool_market_share": "40.00", "top_3_combined_share": "80.00", "top_5_combined_share": "90.00", "herfindahl_index": "0.2500", "nakamoto_coefficient": 2, "decentralization_score": "37.50", "data_source": "unknown", "collected_at": "2026-07-21 08:42:58" } }, { "name": "pool_fee_analysis", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "pool_id", "type": "int(11)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "snapshot_time", "type": "datetime", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "period_hours", "type": "int(11)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "total_fees_btc", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "avg_fee_per_block_btc", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "median_fee_per_block_btc", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "highest_fee_block_btc", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "lowest_fee_block_btc", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "full_blocks_count", "type": "int(11)", "null": "YES", "key": "", "default": "0", "extra": "" }, { "name": "empty_blocks_count", "type": "int(11)", "null": "YES", "key": "", "default": "0", "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "", "default": "current_timestamp()", "extra": "" } ], "row_count": 68, "sample_data": { "id": 28, "pool_id": 26, "snapshot_time": "2025-10-28 19:10:01", "period_hours": 24, "total_fees_btc": "0.01904162", "avg_fee_per_block_btc": "0.01904162", "median_fee_per_block_btc": "0.01904162", "highest_fee_block_btc": "0.01904162", "lowest_fee_block_btc": "0.01904162", "full_blocks_count": 1, "empty_blocks_count": 0, "collected_at": "2025-10-28 19:10:01" } }, { "name": "pool_hashrate_history", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "pool_id", "type": "int(11)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "snapshot_time", "type": "datetime", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "reported_hashrate_ehs", "type": "decimal(12,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "estimated_hashrate_ehs", "type": "decimal(12,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "blocks_found_24h", "type": "int(11)", "null": "YES", "key": "", "default": "0", "extra": "" }, { "name": "blocks_found_3d", "type": "int(11)", "null": "YES", "key": "", "default": "0", "extra": "" }, { "name": "blocks_found_7d", "type": "int(11)", "null": "YES", "key": "", "default": "0", "extra": "" }, { "name": "blocks_found_30d", "type": "int(11)", "null": "YES", "key": "", "default": "0", "extra": "" }, { "name": "market_share_24h", "type": "decimal(5,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "market_share_3d", "type": "decimal(5,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "market_share_7d", "type": "decimal(5,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "market_share_30d", "type": "decimal(5,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "luck_percentage_24h", "type": "decimal(6,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "luck_percentage_7d", "type": "decimal(6,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "data_source", "type": "varchar(50)", "null": "YES", "key": "", "default": "unknown", "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "MUL", "default": "current_timestamp()", "extra": "" } ], "row_count": 228, "sample_data": { "id": 218, "pool_id": 5, "snapshot_time": "2026-07-21 09:21:25", "reported_hashrate_ehs": null, "estimated_hashrate_ehs": "88.5035", "blocks_found_24h": 14, "blocks_found_3d": 2, "blocks_found_7d": 2, "blocks_found_30d": 2, "market_share_24h": "10.37", "market_share_3d": "15.38", "market_share_7d": "15.38", "market_share_30d": "15.38", "luck_percentage_24h": "100.00", "luck_percentage_7d": "100.00", "data_source": "mempool_space", "collected_at": "2026-07-21 09:21:25" } }, { "name": "pool_rankings", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "snapshot_time", "type": "datetime", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "pool_id", "type": "int(11)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "rank_by_hashrate", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "rank_by_blocks", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "rank_by_fees", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "rank_by_luck", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "performance_score", "type": "decimal(5,2)", "null": "YES", "key": "", "default": "0.00", "extra": "" }, { "name": "trend_7d", "type": "enum('rising','stable','declining')", "null": "YES", "key": "", "default": "stable", "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "", "default": "current_timestamp()", "extra": "" } ], "row_count": 68, "sample_data": { "id": 63, "snapshot_time": "2026-07-21 08:42:58", "pool_id": 5, "rank_by_hashrate": 2, "rank_by_blocks": 2, "rank_by_fees": 2, "rank_by_luck": 2, "performance_score": "0.00", "trend_7d": "stable", "collected_at": "2026-07-21 08:42:58" } }, { "name": "pool_statistics", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "pool_id", "type": "int(11)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "snapshot_time", "type": "datetime", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "data_source", "type": "varchar(50)", "null": "YES", "key": "", "default": "unknown", "extra": "" }, { "name": "blocks_mined_24h", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "blocks_mined_7d", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "hash_rate_ehs", "type": "decimal(12,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "market_share_percentage", "type": "decimal(5,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "average_fees_per_block", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "total_fees_24h", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "luck_percentage", "type": "decimal(6,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "empty_blocks_count", "type": "int(11)", "null": "YES", "key": "", "default": "0", "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "MUL", "default": "current_timestamp()", "extra": "" } ], "row_count": 17977, "sample_data": { "id": 7168, "pool_id": 6, "snapshot_time": "2025-10-27 20:29:23", "data_source": "unknown", "blocks_mined_24h": 48, "blocks_mined_7d": 48, "hash_rate_ehs": null, "market_share_percentage": "0.00", "average_fees_per_block": null, "total_fees_24h": null, "luck_percentage": null, "empty_blocks_count": 0, "collected_at": "2025-10-27 20:29:23" } }, { "name": "pools", "columns": [ { "name": "id", "type": "int(11)", "null": "NO", "key": "", "default": "0", "extra": "" }, { "name": "name", "type": "varchar(100)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "identifier", "type": "varchar(50)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "url", "type": "varchar(255)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "active", "type": "tinyint(1)", "null": "YES", "key": "", "default": "1", "extra": "" }, { "name": "hashrate_ehs", "type": "decimal(12,4)", "null": "NO", "key": "", "default": "0.0000", "extra": "" }, { "name": "market_share", "type": "decimal(5,2)", "null": "NO", "key": "", "default": "0.00", "extra": "" }, { "name": "blocks_24h", "type": "int(11)", "null": "NO", "key": "", "default": "0", "extra": "" }, { "name": "blocks_7d", "type": "int(11)", "null": "NO", "key": "", "default": "0", "extra": "" }, { "name": "luck_pct", "type": "decimal(6,2)", "null": "NO", "key": "", "default": "0.00", "extra": "" }, { "name": "avg_fees_per_block", "type": "decimal(20,8)", "null": "NO", "key": "", "default": "0.00000000", "extra": "" }, { "name": "created_at", "type": "datetime", "null": "YES", "key": "", "default": "current_timestamp()", "extra": "" }, { "name": "updated_at", "type": "datetime", "null": "YES", "key": "", "default": null, "extra": "" } ], "row_count": 29, "sample_data": { "id": 21, "name": "Est3lar", "identifier": "est3lar", "url": "https://est3lar.io", "active": 1, "hashrate_ehs": "0.0000", "market_share": "0.00", "blocks_24h": 3, "blocks_7d": 3, "luck_pct": "100.00", "avg_fees_per_block": "0.00000000", "created_at": "2025-10-22 02:54:16", "updated_at": "2025-10-29 09:30:11" } }, { "name": "transaction_inputs", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "transaction_id", "type": "bigint(20)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "input_index", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "previous_txid", "type": "varchar(64)", "null": "YES", "key": "MUL", "default": null, "extra": "" }, { "name": "previous_vout", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "script_sig", "type": "text", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "witness_data", "type": "text", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "sequence", "type": "bigint(20) unsigned", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "value", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" } ], "row_count": 0, "sample_data": null }, { "name": "transaction_outputs", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "transaction_id", "type": "bigint(20)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "output_index", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "value", "type": "decimal(20,8)", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "script_pubkey", "type": "text", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "address", "type": "varchar(100)", "null": "YES", "key": "MUL", "default": null, "extra": "" }, { "name": "output_type", "type": "varchar(20)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "is_spent", "type": "tinyint(1)", "null": "YES", "key": "MUL", "default": "0", "extra": "" }, { "name": "spent_in_txid", "type": "varchar(64)", "null": "YES", "key": "", "default": null, "extra": "" } ], "row_count": 0, "sample_data": null }, { "name": "transactions", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "txid", "type": "varchar(64)", "null": "NO", "key": "UNI", "default": null, "extra": "" }, { "name": "block_id", "type": "bigint(20)", "null": "YES", "key": "MUL", "default": null, "extra": "" }, { "name": "block_height", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "version", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "size_bytes", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "vsize", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "weight", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "locktime", "type": "bigint(20) unsigned", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "input_count", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "output_count", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "total_input_value", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "total_output_value", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "fee", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "fee_rate", "type": "decimal(12,4)", "null": "YES", "key": "MUL", "default": null, "extra": "" }, { "name": "confirmation_time", "type": "datetime", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "is_coinbase", "type": "tinyint(1)", "null": "YES", "key": "", "default": "0", "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "MUL", "default": "current_timestamp()", "extra": "" } ], "row_count": 0, "sample_data": null } ] }