{ "database": "nvdaxcom_galliumhash_metabuilder", "timestamp": "2026-06-12T20:42:52+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": 965, "endpoint": "https://mempool.space/api/block/000000000000000000016b259445e83842fa5d2b8e151542e21abb1466a537df", "response_code": 200, "response_time_ms": 30, "data_size_bytes": 440, "called_at": "2025-10-23 18:27:00" } }, { "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": 166, "api_source": "blockchair", "endpoint": "/stats", "status": "success", "response_time_ms": 3317, "http_code": 200, "error_message": null, "created_at": "2025-10-27 20:13:17" } }, { "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": 135, "block_hash": "0000000000000000000090004f0bba715b38fec36a30e0fabe0ab09f2336ef43", "block_height": 920413, "timestamp": 1761232648, "block_time": "2025-10-23 15:17:28", "size_bytes": 301686, "weight": 731007, "transaction_count": 701, "difficulty": "146716052770110.00", "nonce": 3070568389, "merkle_root": "1a91f34092aab0afc47f049e9de8959fd44138162ed37b931d28ffb8574f20f4", "previous_block_hash": "0000000000000000000110250e95eedb07efcbeca95b53ff92e6a69cda9ad51f", "total_fees": "0.00415655", "block_subsidy": "3.12500000", "miner_pool": "Unknown", "coinbase_data": "035d0b0e040047fa687c204d415241204d61646520696e2055534120f09f87baf09f87b8207c763034fabe6d6d132ec9b2d4... [truncated]", "version": 543604736, "bits": "386001697", "collected_at": "2025-10-23 15:34:33" } }, { "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": 3138, "collector_name": "MempoolCollector", "collection_type": "mempool", "status": "success", "records_collected": 12, "error_message": null, "execution_time_ms": 3136, "started_at": "2025-10-28 19:35:10", "completed_at": "2025-10-28 19:35:13" } }, { "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": 6, "snapshot_time": "2025-10-28 19:06:47", "exchange_name": "coingecko", "trading_pair": "BTC/USD", "bid_price": null, "ask_price": null, "last_price": "114916.00", "volume_24h": "57088648225.00", "spread_percentage": null, "collected_at": "2025-10-28 19:06:47" } }, { "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": 391, "snapshot_id": 391, "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:36:31" } }, { "name": "market_data", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "PRI", "default": null, "extra": "auto_increment" }, { "name": "snapshot_time", "type": "datetime", "null": "NO", "key": "MUL", "default": null, "extra": "" }, { "name": "data_source", "type": "varchar(50)", "null": "NO", "key": "MUL", "default": "unknown", "extra": "" }, { "name": "price_usd", "type": "decimal(15,2)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "price_eur", "type": "decimal(15,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "price_gbp", "type": "decimal(15,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "price_change_24h", "type": "decimal(8,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "price_change_7d", "type": "decimal(8,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "price_change_30d", "type": "decimal(8,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "market_dominance", "type": "decimal(5,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "price_change_percentage_24h", "type": "decimal(6,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "market_cap_usd", "type": "decimal(20,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "volume_24h_usd", "type": "decimal(20,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "volume_24h_btc", "type": "decimal(15,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "price_change_1h", "type": "decimal(8,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "circulating_supply", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "total_supply", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "max_supply", "type": "decimal(20,8)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "ath_price", "type": "decimal(15,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "ath_date", "type": "datetime", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "atl_price", "type": "decimal(15,2)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "atl_date", "type": "datetime", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "source_response_time_ms", "type": "int(11)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "MUL", "default": "current_timestamp()", "extra": "" } ], "row_count": 13, "sample_data": { "id": 11, "snapshot_time": "2025-10-29 08:58:43", "data_source": "coingecko", "price_usd": "113029.00", "price_eur": "97227.00", "price_gbp": "85561.00", "price_change_24h": "-1.21", "price_change_7d": "4.62", "price_change_30d": "1.23", "market_dominance": "0.00", "price_change_percentage_24h": null, "market_cap_usd": "2253976023692.00", "volume_24h_usd": "67988904105.00", "volume_24h_btc": "601478.0000", "price_change_1h": "-0.44", "circulating_supply": "19941515.00000000", "total_supply": "19941515.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-29 08:58:43" } }, { "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": 655, "snapshot_time": "2025-10-28 01:06:42", "total_size_mb": "33.38", "transaction_count": 98244, "total_fees": "0.06414382", "minimum_fee_rate": "0.0000", "median_fee_rate": "10.0000", "average_fee_rate": "0.1922", "oldest_tx_timestamp": null, "collected_at": "2025-10-28 01:06:42" } }, { "name": "mempool_state", "columns": [ { "name": "id", "type": "bigint(20)", "null": "NO", "key": "", "default": "0", "extra": "" }, { "name": "timestamp", "type": "datetime", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "size_mb", "type": "decimal(10,2)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "tx_count", "type": "int(11)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "total_fees", "type": "decimal(20,8)", "null": "NO", "key": "", "default": null, "extra": "" }, { "name": "min_fee", "type": "decimal(12,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "median_fee", "type": "decimal(12,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "avg_fee", "type": "decimal(12,4)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "oldest_tx_timestamp", "type": "bigint(20)", "null": "YES", "key": "", "default": null, "extra": "" }, { "name": "collected_at", "type": "datetime", "null": "YES", "key": "", "default": "current_timestamp()", "extra": "" } ], "row_count": 805, "sample_data": { "id": 570, "timestamp": "2025-10-28 01:01:24", "size_mb": "33.04", "tx_count": 97179, "total_fees": "0.05586262", "min_fee": "0.0000", "median_fee": "10.0000", "avg_fee": "0.1691", "oldest_tx_timestamp": null, "collected_at": "2025-10-28 01:01:24" } }, { "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": 7946, "snapshot_id": 795, "txid": "14fba543a09ac50901bda9ffade6a46b0d3234112e4c85ebeda45fc0824136b6", "entry_time": "2025-10-28 17:08:17", "fee": "0.00005488", "fee_rate": "0.0000", "size_bytes": 0, "vsize": 782, "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": 8, "pool_name": "SBI Crypto", "pool_identifier": "sbicrypto", "coinbase_signature": null, "website_url": "https://sbicrypto.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": 526, "snapshot_time": "2025-10-27 21:08:56", "data_source": "blockchair", "source_response_time_ms": 3313, "source_reliability_score": "1.00", "hash_rate_ehs": "1093.9942", "difficulty": "146716052770110.00", "next_difficulty_adjustment": "160.6113", "blocks_until_adjustment": 0, "average_block_time": "600.00", "blocks_count_24h": 150, "nodes_online": null, "utxo_count": null, "utxo_set_size_gb": "696.02", "collected_at": "2025-10-27 21:08:56" } }, { "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": 30, "period_hours": 720, "snapshot_time": "2025-10-28 19:25:45", "total_blocks": 232, "unique_pools_count": 13, "top_pool_market_share": "23.31", "top_3_combined_share": "46.32", "top_5_combined_share": "59.51", "herfindahl_index": "0.0938", "nakamoto_coefficient": 4, "decentralization_score": "27.88", "data_source": "unknown", "collected_at": "2025-10-28 19:25:45" } }, { "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": 31, "pool_id": 4, "snapshot_time": "2025-10-28 19:25:45", "period_hours": 24, "total_fees_btc": "0.12348148", "avg_fee_per_block_btc": "0.01372016", "median_fee_per_block_btc": "0.01372016", "highest_fee_block_btc": "0.02628028", "lowest_fee_block_btc": "0.00118873", "full_blocks_count": 16, "empty_blocks_count": 0, "collected_at": "2025-10-28 19:25:45" } }, { "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": 113, "pool_id": 7, "snapshot_time": "2025-10-28 19:25:45", "reported_hashrate_ehs": null, "estimated_hashrate_ehs": "21.8799", "blocks_found_24h": 3, "blocks_found_3d": 3, "blocks_found_7d": 8, "blocks_found_30d": 8, "market_share_24h": "1.95", "market_share_3d": "2.31", "market_share_7d": "2.45", "market_share_30d": "2.45", "luck_percentage_24h": "100.00", "luck_percentage_7d": "100.00", "data_source": "mempool_space", "collected_at": "2025-10-28 19:25:45" } }, { "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": 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": 17911, "sample_data": { "id": 2719, "pool_id": 18, "snapshot_time": "2025-10-27 19:55:00", "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-27 19:55:00" } }, { "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": 23, "name": "slush", "identifier": "slush", "url": "", "active": 1, "hashrate_ehs": "0.0000", "market_share": "0.00", "blocks_24h": 0, "blocks_7d": 0, "luck_pct": "100.00", "avg_fees_per_block": "0.00000000", "created_at": "2025-10-22 20:19:19", "updated_at": "2025-10-28 23:56:58" } }, { "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 } ] }