Pre-fork BTC/BCH Spending Analysis

See this blog post for more details.

spent_status_by_day.csv

File link

Number of columns: 9

Number of rows: 1704

Column descriptions:

block_time.date                : Date, format: "YYYY-MM-DD"
value.btc.unspent.bch.unspent  : num  
outputs.btc.unspent.bch.unspent: int  
value.btc.spent.bch.unspent    : num  
outputs.btc.spent.bch.unspent  : int  
value.btc.unspent.bch.spent    : num  
outputs.btc.unspent.bch.spent  : int  
value.btc.spent.bch.spent      : num  
outputs.btc.spent.bch.spent    : int  

state_trans_by_day.csv

File link

Number of columns: 9

Number of rows: 1704

Column descriptions:

block_time.date : Date, format: "YYYY-MM-DD"
value.ff.to.tf  : num  
outputs.ff.to.tf: int  
value.ff.to.ft  : num  
outputs.ff.to.ft: int  
value.ff.to.tt  : num  
outputs.ff.to.tt: int  
value.ft.to.tt  : num  
outputs.ft.to.tt: num  
value.tf.to.tt  : num  
outputs.tf.to.tt: num  

pre-fork-BTC-BCH-spent_status.zip

File link

Compressed file size: 385MB

Uncompressed file size: 2,713MB

Number of columns: 6

Number of rows: 53,658,348

btc.spent.block_height: int  Block height that the output was spent on the BTC blockchain, if it was spent
bch.spent.block_height: int  Block height that the output was spent on the BCH blockchain, if it was spent
destination_index     : int  Unique integer index of the output that was created by the R script
value                 : num  Value of the output, in bitcoin units
bch.block_time        : POSIXct, format: "YYYY-MM-DD HH:MM:SS" Block time of the BCH block height
btc.block_time        : POSIXct, format: "YYYY-MM-DD HH:MM:SS" Block time of the BTC block height

CashFusion Descendants Analysis

File link

Compressed file size: 749MB

Uncompressed file size: 2,804MB

Number of columns: 5

Number of rows: 29,954,761

A CSV file of the UTXO set of BCH created between block heights of 646085 and 719602 that indicates which are CashFusion descendants and which are not.

See this blog post for more details.

Column descriptions:

txid_position: An identifier of an unspent output, in the form of TXID-position. The position of outputs is indexed from one, not from zero.
tx_graph_index: An integer index for the unspent output that was used in the transaction graph analysis.
value: The value, in BCH, of the output. Zero-valued outputs are included in the dataset.
is_cashfusion_descendant: Takes value of 1 if output is a descendant of a CashFusion transaction and 0 otherwise.
is_coinbase: Takes value of 1 if output is the result of a coinbase transaction and 0 otherwise.