{ "database": "nvdaxcom_galliumhash_metabuilder", "timestamp": "2026-04-28T15:59:17+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": 5816, "sample_data": { "id": 1769, "endpoint": "https://mempool.space/api/mempool/recent", "response_code": 200, "response_time_ms": 28, "data_size_bytes": 1142, "called_at": "2025-10-27 20:07:03" } }, { "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": 724, "sample_data": { "id": 212, "api_source": "blockchair", "endpoint": "/stats", "status": "success", "response_time_ms": 3326, "http_code": 200, "error_message": null, "created_at": "2025-10-27 20:21:02" } }, { "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": 352, "sample_data": { "id": 51, "block_hash": "0000000000000000000163f76db153177e2bb71361f1bf6f9ceed1793c9076f1", "block_height": 920265, "timestamp": 1761140958, "block_time": "2025-10-22 13:49:18", "size_bytes": 1618580, "weight": 3993812, "transaction_count": 3769, "difficulty": "146716052770110.00", "nonce": 2504875810, "merkle_root": "72eeb83746acce59e07e3c0f3342c3185dca6bc92f3e93a56b529a65d2cbcbd1", "previous_block_hash": "00000000000000000000763366759cb23dded1d25182bd7258f8ac7dd08dd4a8", "total_fees": "0.00000000", "block_subsidy": "0.00000000", "miner_pool": "Unknown", "coinbase_data": "", "version": 538525696, "bits": "386001697", "collected_at": "2025-10-22 15:12:39" } }, { "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": 3178, "sample_data": { "id": 233, "collector_name": "BlockCollector", "collection_type": "blocks", "status": "success", "records_collected": 3, "error_message": null, "execution_time_ms": 7338, "started_at": "2025-10-22 20:59:14", "completed_at": "2025-10-22 20:59:22" } }, { "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": 13, "sample_data": { "id": 10, "snapshot_time": "2025-10-28 23:57:17", "exchange_name": "coingecko", "trading_pair": "BTC/USD", "bid_price": null, "ask_price": null, "last_price": "112969.00", "volume_24h": "66110237286.00", "spread_percentage": null, "collected_at": "2025-10-28 23:57:17" } }, { "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": 805, "sample_data": { "id": 741, "snapshot_id": 741, "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-28 04:36:00" } }, { "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": 13, "sample_data": { "id": 3, "snapshot_time": "2025-10-27 03:51:13", "data_source": "coingecko", "price_usd": "115034.00", "price_eur": "98908.00", "price_gbp": "86341.00", "price_change_24h": "3.33", "price_change_7d": "6.48", "price_change_30d": "5.08", "market_dominance": "0.00", "price_change_percentage_24h": null, "market_cap_usd": "2291440982558.00", "volume_24h_usd": "48050372187.00", "volume_24h_btc": "417688.0000", "price_change_1h": "0.09", "circulating_supply": "19940434.00000000", "total_supply": "19940434.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-27 03:51:13" } }, { "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": 805, "sample_data": { "id": 124, "snapshot_time": "2025-10-27 19:39:25", "total_size_mb": "37.93", "transaction_count": 107140, "total_fees": "0.06957411", "minimum_fee_rate": "0.0000", "median_fee_rate": "10.0000", "average_fee_rate": "0.1834", "oldest_tx_timestamp": null, "collected_at": "2025-10-27 19:39:25" } }, { "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": 805, "sample_data": { "id": 480, "timestamp": "2025-10-27 20:53:40", "size_mb": "36.58", "tx_count": 101629, "total_fees": "0.06708014", "min_fee": "0.0000", "median_fee": "10.0000", "avg_fee": "0.1834", "oldest_tx_timestamp": null, "collected_at": "2025-10-27 20:53:40" } }, { "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": 8050, "sample_data": { "id": 3527, "snapshot_id": 353, "txid": "388a3c100b7df3af83f2c178be884455934c1fa0d7674dc4b7448227c4547c00", "entry_time": "2025-10-27 20:30:58", "fee": "0.00022570", "fee_rate": "0.0000", "size_bytes": 0, "vsize": 370, "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": 28, "sample_data": { "id": 3, "pool_name": "ViaBTC", "pool_identifier": "viabtc", "coinbase_signature": null, "website_url": "https://viabtc.com", "first_seen": "2025-10-22 02:54:16", "last_seen": "2025-10-29 09:31:06", "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": 791, "sample_data": { "id": 660, "snapshot_time": "2025-10-28 01:40:47", "data_source": "blockchair", "source_response_time_ms": 3317, "source_reliability_score": "1.00", "hash_rate_ehs": "1088.3258", "difficulty": "146716052770110.00", "next_difficulty_adjustment": "160.3511", "blocks_until_adjustment": 0, "average_block_time": "600.00", "blocks_count_24h": 149, "nodes_online": null, "utxo_count": null, "utxo_set_size_gb": "696.06", "collected_at": "2025-10-28 01:40:47" } }, { "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": 50, "sample_data": { "id": 8, "period_hours": 720, "snapshot_time": "2025-10-23 02:24:06", "total_blocks": 20, "unique_pools_count": 8, "top_pool_market_share": "8.89", "top_3_combined_share": "16.67", "top_5_combined_share": "18.89", "herfindahl_index": "0.0121", "nakamoto_coefficient": 8, "decentralization_score": "98.79", "data_source": "unknown", "collected_at": "2025-10-23 02:24:06" } }, { "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": 61, "sample_data": { "id": 46, "pool_id": 26, "snapshot_time": "2025-10-28 23:58:14", "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 23:58:14" } }, { "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": 200, "sample_data": { "id": 133, "pool_id": 21, "snapshot_time": "2025-10-28 19:40:28", "reported_hashrate_ehs": null, "estimated_hashrate_ehs": "7.2933", "blocks_found_24h": 1, "blocks_found_3d": 0, "blocks_found_7d": 0, "blocks_found_30d": 0, "market_share_24h": "0.65", "market_share_3d": "0.00", "market_share_7d": "0.00", "market_share_30d": "0.00", "luck_percentage_24h": "100.00", "luck_percentage_7d": "100.00", "data_source": "mempool_space", "collected_at": "2025-10-28 19:40:28" } }, { "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": 61, "sample_data": { "id": 21, "snapshot_time": "2025-10-28 19:07:48", "pool_id": 3, "rank_by_hashrate": 4, "rank_by_blocks": 2, "rank_by_fees": 5, "rank_by_luck": 5, "performance_score": "0.00", "trend_7d": "stable", "collected_at": "2025-10-28 19:07:48" } }, { "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": 17911, "sample_data": { "id": 6013, "pool_id": 1, "snapshot_time": "2025-10-27 20:21:19", "data_source": "unknown", "blocks_mined_24h": 332, "blocks_mined_7d": 332, "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:21:19" } }, { "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": 28, "sample_data": { "id": 10, "name": "Binance Pool", "identifier": "binancepool", "url": "https://pool.binance.com", "active": 1, "hashrate_ehs": "29.1732", "market_share": "2.67", "blocks_24h": 4, "blocks_7d": 0, "luck_pct": "100.00", "avg_fees_per_block": "0.00000000", "created_at": "2025-10-22 02:54:16", "updated_at": "2025-10-29 09:31:06" } }, { "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 } ] }