Skip to main content
Schema: bitcoin.core Table: fact_clustered_transfers Type: View

​
Description

This table contains Bitcoin transfers between clustered entities, providing a simplified view of fund flows at the entity level rather than individual addresses. Each row represents a transfer between two distinct entities (such as exchanges, miners, or other identified clusters) with aggregated value and transaction information. The model applies address clustering algorithms to group related addresses into entities, enabling high-level analysis of fund movements between major Bitcoin ecosystem participants. This table updates daily as the clustering process identifies new relationships and refines existing entity groupings.

​
Key Use Cases

  • Entity-level fund flow analysis and exchange activity monitoring
  • Large-scale Bitcoin movement tracking between major ecosystem participants
  • Exchange inflow/outflow analysis and liquidity studies
  • Mining pool reward distribution and fee collection analysis
  • Institutional Bitcoin flow monitoring and whale movement detection
  • Cross-entity relationship analysis and network mapping
  • Simplified transaction graph analysis for high-level insights

​
Important Relationships

  • Provides entity-level aggregation of core.fact_transactions data
  • Utilizes core.dim_entity_clusters for address-to-entity mapping
  • Supports core.dim_labels for entity categorization and labeling
  • Enables integration with stats.ez_core_metrics_hourly for aggregated metrics
  • Complements gov.ez_miner_rewards for mining-related entity analysis
  • Provides simplified view for price.ez_prices_hourly market analysis

​
Commonly-used Fields

  • block_timestamp: Essential for time-series analysis and trend detection
  • from_entity and to_entity: Core fields for entity-level flow analysis
  • transfer_amount: Key metric for value flow analysis and economic studies
  • tx_id: Critical for linking to detailed transaction information
  • block_number: Important for chronological ordering and gap detection
  • Entity fields enable high-level analysis without address-level complexity

​
Columns

Column NameData TypeDescription
TX_IDTEXTThe transaction ID (STRING), a 64-character hexadecimal hash that uniquely identifies this transaction. Note: For SegWit transactions, the txid is calculated without including witness data, which can differ from the transaction hash (see tx_hash).
Example: 4d3c2b1a0f9e8d7c6b5a4e3d2c1b0a9876543210fedcba9876543210fedcba98 See: https://bitcoin.stackexchange.com/questions/77699/whats-the-difference-between-txid-and-hash-getrawtransaction-bitcoind | | BLOCK_NUMBER | NUMBER | The block height (INTEGER) of the block containing this transaction. In Bitcoin, block height is the number of blocks preceding a particular block in the blockchain, starting from the genesis block (height 0). Example: 845000 | | BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The timestamp (TIMESTAMP_NTZ, UTC) of the block that contains this transaction. This value is inherited from the block header and represents when the block was mined and the transaction was confirmed on-chain. Example: 2024-06-01 12:34:56.000 | | FROM_ENTITY | TEXT | The entity that sent the Bitcoin. If clustered, this is an ID from the address clustering process. If unclustered, this is an address. | | TO_ENTITY | TEXT | The entity that received the Bitcoin. If clustered, this is an ID from the address clustering process. If unclustered, this is an address. | | TRANSFER_AMOUNT | NUMBER | The amount, in Bitcoin, of the transfer. | | FACT_CLUSTERED_TRANSFERS_ID | TEXT | A unique identifier (STRING or NUMBER) for the record, used as a primary key for this table. Not a blockchain-native field. Example: 123456789 | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp (TIMESTAMP_NTZ, UTC) when this record was initially created and inserted into the table. Example: 2024-06-01 12:34:56.000 | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp (TIMESTAMP_NTZ, UTC) when this record was last modified by an internal process. Example: 2024-06-01 12:35:00.000 |