GraphSense Transformation Output Tables

The GraphSense transformation pipeline reads raw block data, which is ingested into Cassandra by the graphsense-blocksci component, and computes de-normalized views, which are again stored in Cassandra.

This is a documentation of all generated output tables and fields.

summary_statistics

Provides summary statistics for a computed currency-specific dataset.

• no_blocks: number of processed blocks
• no_address_relations: number of address relations
• no_addresses: total number of distinct addresses
• no_clusters: number of computed clusters (with > 1 addresses)
• no_transactions: number of transactions
• timestamp: timestamp of latest block considered in dataset

address

Provides summary statistics for a given cryptocurrency address.

• address_prefix: first five characters of the address; used for internal dataset partitioning and lookup only (e.g., t1XBa)
• address: cryptocurrency address (e.g., t1XBa17NfzHrCN8Kn6NtnVdXkGxpjoyZKPr)
• first_tx: the first transaction the address has been involved in (e.g., "{height: 481827, tx_hash: 0xbae701eb8e4a552fff840ece1d84ffbcdfc6be650fcb351c921344c0041da4cd, timestamp: 1550216321}")
• last_tx: the last transaction the address has been involved in (e.g., "{height: 481827, tx_hash: 0xbae701eb8e4a552fff840ece1d84ffbcdfc6be650fcb351c921344c0041da4cd, timestamp: 1550216321}")
• no_incoming_txs: the number of transactions using this address as input (e.g., 1)
• no_outgoing_txs: the number of transactions using this address as output (e.g., 0)
• in_degree: the number of incoming address graph edges
• out_degree: the number of outgoing address graph edges
• total_received: total amount of currency units received (e.g., "{satoshi: 73450000, eur: 2341.41, usd: 2644.98}")
• total_spent: total amount of currency units spent ("{satoshi: 0, eur: 0, usd: 0}")

Note: GraphSense stores cryptocurrency subunits for maintaining precision in computations. The field name "satoshi" is for legacy reasons.