Overview
This schema contains 7 tables and views for Bitcoin data.Tables and Views
Dim Entity Clusters
This table contains address clustering information that groups related Bitcoin addresses into entities based on common spending patterns and behavi…
Dim Labels
This table contains comprehensive address labels for Bitcoin addresses, providing categorized identification and classification of known entities, …
Fact Blocks
This table contains the complete block header data for all Bitcoin blocks, providing the foundational blockchain structure information.
Fact Clustered Transfers
This table contains Bitcoin transfers between clustered entities, providing a simplified view of fund flows at the entity level rather than individ…
Fact Inputs
This table contains detailed information about all transaction inputs in the Bitcoin blockchain, representing the spent UTXOs that fund each transa…
Fact Outputs
This table contains detailed information about all transaction outputs in the Bitcoin blockchain, representing the newly created UTXOs that result …
Fact Transactions
This table contains the canonical record of all confirmed Bitcoin transactions, providing comprehensive transaction-level data including block cont…