{ "database": "nvdaxcom_galliumhash_metabuilder", "timestamp": "2026-07-28T01:05:07+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": 3439, "endpoint": "https://mempool.space/api/v1/fees/recommended", "response_code": 200, "response_time_ms": 100, "data_size_bytes": 74, "called_at": "2025-10-27 20:54:25" } }, { "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": 715, "api_source": "blockchair", "endpoint": "/stats", "status": "success", "response_time_ms": 3328, "http_code": 200, "error_message": null, "created_at": "2025-10-28 17:08:28" } }, { "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": 159, "block_hash": "0000000000000000000160f75bf83269933d4d8d9f5c470f83dcc765bad1046a", "block_height": 920454, "timestamp": 1761256558, "block_time": "2025-10-23 21:55:58", "size_bytes": 1782151, "weight": 3993451, "transaction_count": 2401, "difficulty": "146716052770110.00", "nonce": 513682728, "merkle_root": "82a9ab19cd98bd05d23ff135bcd451edc32a94500f9cd1ac4a42a7de5b75a63e", "previous_block_hash": "0000000000000000000177441e7f8e4468d774444409773826d84d18b5dc5734", "total_fees": "0.01230199", "block_subsidy": "3.12500000", "miner_pool": "AntPool", "coinbase_data": "03860b0e194d696e656420627920416e74506f6f6c201f00010673278eeafabe6d6db608e9f50615db6dfc0033ff347f33a8... [truncated]", "version": 542015488, "bits": "386001697", "collected_at": "2025-10-23 22:30:24" } }, { "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": 2319, "collector_name": "PoolCollector", "collection_type": "pools", "status": "success", "records_collected": 23, "error_message": null, "execution_time_ms": 1128, "started_at": "2025-10-28 01:03:45", "completed_at": "2025-10-28 01:03:46" } }, { "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": 8, "snapshot_time": "2025-10-28 19:24:51", "exchange_name": "coingecko", "trading_pair": "BTC/USD", "bid_price": null, "ask_price": null, "last_price": "113987.00", "volume_24h": "57508971231.00", "spread_percentage": null, "collected_at": "2025-10-28 19:24:51" } }, { "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": 382, "snapshot_id": 382, "fastest_fee": "2.0000", "half_hour_fee": "1.0000", "hour_fee": "1.0000", "economy_fee": "1.0000", "minimum_fee": "1.0000", "collected_at": "2025-10-27 20:35:25" } }, { "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": 5, "snapshot_time": "2025-10-28 17:55:29", "data_source": "coingecko", "price_usd": "115448.00", "price_eur": "98975.00", "price_gbp": "86942.00", "price_change_24h": "-0.15", "price_change_7d": "2.00", "price_change_30d": "4.92", "market_dominance": "0.00", "price_change_percentage_24h": null, "market_cap_usd": "2303095686424.00", "volume_24h_usd": "56477052970.00", "volume_24h_btc": "489231.0000", "price_change_1h": "0.15", "circulating_supply": "19941234.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 17:55:29" } }, { "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": 181, "snapshot_time": "2025-10-27 20:02:22", "total_size_mb": "38.46", "transaction_count": 107879, "total_fees": "0.08270246", "minimum_fee_rate": "0.0000", "median_fee_rate": "10.0000", "average_fee_rate": "0.2150", "oldest_tx_timestamp": null, "collected_at": "2025-10-27 20:02:22" } }, { "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": 5, "timestamp": "2025-10-22 03:08:06", "size_mb": "22.15", "tx_count": 57757, "total_fees": "0.04198429", "min_fee": "0.0000", "median_fee": "10.0000", "avg_fee": "0.1896", "oldest_tx_timestamp": null, "collected_at": "2025-10-22 03:08:06" } }, { "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": 2870, "snapshot_id": 287, "txid": "b70c604fdcf26be4c679b67a31a051d84133432b5411efb231ff673bf604dd7c", "entry_time": "2025-10-27 20:20:14", "fee": "0.00000795", "fee_rate": "0.0000", "size_bytes": 0, "vsize": 264, "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": 26, "pool_name": "Poolin", "pool_identifier": "poolin", "coinbase_signature": null, "website_url": "https://www.poolin.com", "first_seen": "2025-10-25 16:30:26", "last_seen": "2026-07-21 09:20:23", "is_active": 1, "created_at": "2025-10-25 16:30:26" } }, { "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": 496, "snapshot_time": "2025-10-27 21:01:51", "data_source": "blockchair", "source_response_time_ms": 3322, "source_reliability_score": "1.00", "hash_rate_ehs": "1088.3258", "difficulty": "146716052770110.00", "next_difficulty_adjustment": "160.5497", "blocks_until_adjustment": 0, "average_block_time": "600.00", "blocks_count_24h": 149, "nodes_online": null, "utxo_count": null, "utxo_set_size_gb": "696.02", "collected_at": "2025-10-27 21:01:51" } }, { "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": 3, "period_hours": 168, "snapshot_time": "2025-10-23 02:22:37", "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:22:37" } }, { "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": 65, "pool_id": 2, "snapshot_time": "2026-07-21 09:21:25", "period_hours": 24, "total_fees_btc": "0.17253251", "avg_fee_per_block_btc": "0.03450650", "median_fee_per_block_btc": "0.03450650", "highest_fee_block_btc": "0.04745660", "lowest_fee_block_btc": "0.01354783", "full_blocks_count": 30, "empty_blocks_count": 0, "collected_at": "2026-07-21 09:21:25" } }, { "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": 57, "pool_id": 5, "snapshot_time": "2025-10-28 17:56:28", "reported_hashrate_ehs": null, "estimated_hashrate_ehs": "145.8659", "blocks_found_24h": 20, "blocks_found_3d": 12, "blocks_found_7d": 19, "blocks_found_30d": 19, "market_share_24h": "12.99", "market_share_3d": "10.08", "market_share_7d": "6.03", "market_share_30d": "6.03", "luck_percentage_24h": "100.00", "luck_percentage_7d": "100.00", "data_source": "mempool_space", "collected_at": "2025-10-28 17:56: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": 68, "sample_data": { "id": 52, "snapshot_time": "2025-10-29 09:12:31", "pool_id": 2, "rank_by_hashrate": 1, "rank_by_blocks": 1, "rank_by_fees": 1, "rank_by_luck": 1, "performance_score": "0.00", "trend_7d": "stable", "collected_at": "2025-10-29 09:12:31" } }, { "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": 12075, "pool_id": 15, "snapshot_time": "2025-10-27 22:28:06", "data_source": "unknown", "blocks_mined_24h": 9, "blocks_mined_7d": 9, "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 22:28:06" } }, { "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": 7, "name": "Luxor", "identifier": "luxor", "url": "https://mining.luxor.tech", "active": 1, "hashrate_ehs": "37.9301", "market_share": "4.44", "blocks_24h": 6, "blocks_7d": 2, "luck_pct": "100.00", "avg_fees_per_block": "0.02938200", "created_at": "2025-10-22 02:54:16", "updated_at": "2026-07-21 09:21:25" } }, { "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 } ] }