{ "database": "nvdaxcom_galliumhash_metabuilder", "timestamp": "2026-04-15T13:03:42+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": 3952, "endpoint": "https://mempool.space/api/mempool/recent", "response_code": 200, "response_time_ms": 27, "data_size_bytes": 1122, "called_at": "2025-10-28 01:00:02" } }, { "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": 404, "api_source": "blockchair", "endpoint": "/stats", "status": "success", "response_time_ms": 3377, "http_code": 200, "error_message": null, "created_at": "2025-10-27 20:54:34" } }, { "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": 74, "block_hash": "00000000000000000000f8240c6d44a0e5f5dcff50108f39af8e629996521945", "block_height": 920299, "timestamp": 1761159422, "block_time": "2025-10-22 18:57:02", "size_bytes": 1054241, "weight": 2593007, "transaction_count": 2082, "difficulty": "146716052770110.00", "nonce": 1248714250, "merkle_root": "caf620e9ff5c7240bf8d31b1f3fc12d21e7fb1576750580a550b01ae71051790", "previous_block_hash": "000000000000000000017a290b573088cfb7d7183e09ff284ba022d4672e1b89", "total_fees": "0.01987598", "block_subsidy": "3.12500000", "miner_pool": "ViaBTC", "coinbase_data": "03eb0a0e082f5669614254432f2cfabe6d6d84d184823b343b15f85fdc91c27012aed7e9073675dd8ccd8739f6ba601bf546... [truncated]", "version": 536928256, "bits": "386001697", "collected_at": "2025-10-22 20:19:16" } }, { "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": 181, "collector_name": "MempoolCollector", "collection_type": "mempool", "status": "success", "records_collected": 12, "error_message": null, "execution_time_ms": 3116, "started_at": "2025-10-22 17:13:42", "completed_at": "2025-10-22 17:13: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": 13, "sample_data": { "id": 7, "snapshot_time": "2025-10-28 19:09:03", "exchange_name": "coingecko", "trading_pair": "BTC/USD", "bid_price": null, "ask_price": null, "last_price": "114981.00", "volume_24h": "57283333707.00", "spread_percentage": null, "collected_at": "2025-10-28 19:09:03" } }, { "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": 411, "snapshot_id": 411, "fastest_fee": "3.0000", "half_hour_fee": "1.0000", "hour_fee": "1.0000", "economy_fee": "1.0000", "minimum_fee": "1.0000", "collected_at": "2025-10-27 20:40:13" } }, { "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": 9, "snapshot_time": "2025-10-28 19:39:35", "data_source": "coingecko", "price_usd": "114011.00", "price_eur": "97757.00", "price_gbp": "85844.00", "price_change_24h": "-0.83", "price_change_7d": "1.58", "price_change_30d": "3.43", "market_dominance": "0.00", "price_change_percentage_24h": null, "market_cap_usd": "2274404816934.00", "volume_24h_usd": "59245358873.00", "volume_24h_btc": "519538.0000", "price_change_1h": "-0.62", "circulating_supply": "19941253.00000000", "total_supply": "19941278.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:39:35" } }, { "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": 457, "snapshot_time": "2025-10-27 20:49:04", "total_size_mb": "37.27", "transaction_count": 104416, "total_fees": "0.09799126", "minimum_fee_rate": "0.0000", "median_fee_rate": "10.0000", "average_fee_rate": "0.2629", "oldest_tx_timestamp": null, "collected_at": "2025-10-27 20:49:04" } }, { "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": 650, "timestamp": "2025-10-28 01:06:25", "size_mb": "33.37", "tx_count": 98208, "total_fees": "0.06373650", "min_fee": "0.0000", "median_fee": "10.0000", "avg_fee": "0.1910", "oldest_tx_timestamp": null, "collected_at": "2025-10-28 01:06:25" } }, { "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": 4880, "snapshot_id": 488, "txid": "15cb7de263b1ee8dda37fc3f4472334341f5b90d058b38ddc9b2a2501e23f299", "entry_time": "2025-10-27 20:55:20", "fee": "0.00000555", "fee_rate": "0.0000", "size_bytes": 0, "vsize": 372, "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": 1, "pool_name": "Foundry USA", "pool_identifier": "foundryusa", "coinbase_signature": null, "website_url": "https://foundrydigital.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": 119, "snapshot_time": "2025-10-27 19:43:01", "data_source": "blockchair", "source_response_time_ms": 3333, "source_reliability_score": "1.00", "hash_rate_ehs": "1080.8587", "difficulty": "146716052770110.00", "next_difficulty_adjustment": "160.3980", "blocks_until_adjustment": 0, "average_block_time": "600.00", "blocks_count_24h": 148, "nodes_online": null, "utxo_count": null, "utxo_set_size_gb": "696.00", "collected_at": "2025-10-27 19:43:01" } }, { "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": 22, "period_hours": 720, "snapshot_time": "2025-10-28 19:07:48", "total_blocks": 230, "unique_pools_count": 13, "top_pool_market_share": "23.22", "top_3_combined_share": "46.13", "top_5_combined_share": "59.44", "herfindahl_index": "0.0936", "nakamoto_coefficient": 4, "decentralization_score": "27.89", "data_source": "unknown", "collected_at": "2025-10-28 19:07:48" } }, { "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": 59, "pool_id": 5, "snapshot_time": "2025-10-29 09:31:06", "period_hours": 24, "total_fees_btc": "0.09523752", "avg_fee_per_block_btc": "0.01360536", "median_fee_per_block_btc": "0.01360536", "highest_fee_block_btc": "0.02161131", "lowest_fee_block_btc": "0.00440333", "full_blocks_count": 17, "empty_blocks_count": 0, "collected_at": "2025-10-29 09:31:06" } }, { "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": 82, "pool_id": 12, "snapshot_time": "2025-10-28 19:07:48", "reported_hashrate_ehs": null, "estimated_hashrate_ehs": "14.5866", "blocks_found_24h": 2, "blocks_found_3d": 0, "blocks_found_7d": 0, "blocks_found_30d": 0, "market_share_24h": "1.31", "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:07:48" } }, { "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": 57, "snapshot_time": "2025-10-29 09:31:06", "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:31:06" } }, { "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": 15668, "pool_id": 19, "snapshot_time": "2025-10-28 03:23:58", "data_source": "unknown", "blocks_mined_24h": 3, "blocks_mined_7d": 3, "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-28 03:23:58" } }, { "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": 14, "name": "Unknown", "identifier": "unknown", "url": "https://learnmeabitcoin.com/technical/coinbase-transaction", "active": 1, "hashrate_ehs": "14.5866", "market_share": "1.33", "blocks_24h": 2, "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 } ] }