Historical transaction versions

I’m currently running a very slow data extraction on historical BCH blocks, beginning with the range 400,000 to 719551… (older blocks later on, probably only once that range is completed)

Results are slowly being aggregated in this folder of my bitcoin-cash-data-analysis repository:

https://gitlab.com/freetrader/bitcoin-cash-data-analysis/-/tree/master/txn_versions

The crude and slow Python script which extracts a block’s statistics is also there.

If anyone has much faster blockchain query facilities, @bitcoincashautist would certainly appreciate it :wink:

Otherwise, I’ll be committing automatically to grow the CSV file(s) there until their ranges are completed, and after that I might add a file that tracks daily towards the tip or something.

Just so we can get a better idea of what transactions versions have done, and are doing - mainnet only.

1 Like

First picture, which doesn’t sample many blocks in the total range.

Only v1 and v2 transactions spotted. This should change as more blocks are analysed.

1 Like

Adding a file where I will list anomalous transactions versions found.

It’s a WIP here:

More data on transactions < 400k becoming complete now.

First 200k transactions were all v1 transactions. The following graphs show the growth.

First 100k:

0-99999

Second 100k (from 100,000-199,999):

100000-199999

In the next 50k blocks, we can observe the first v2 transactions

200000-249999

(they are obscured on the graph above, but occur in blocks 209920 (first v2 coinbase!) and 226,637 (another v2 coinbase).

Below is a more up-to-date plot of the >400k range (but only about 10% of blocks sampled so far):

400000-719551_more_than_30k_blocks_analyzed

The bitmap graph doesn’t show it well, but of course there is a ground swell of v1 transactions that is obscured by the majority v2 transactions (green points which dominate these days).

Copying what the scan has picked up so far:

╔═════════════╦══════════════════════════════════════════════════════════════════╦═════════════╗
║ blockheight ║ transaction hash                                                 ║ version     ║
╠═════════════╬══════════════════════════════════════════════════════════════════╬═════════════╣
║ 256818      ║ 637dd1a3418386a418ceeac7bb58633a904dbf127fa47bbea9cc8f86fef7413f ║ -2107285824 ║
╠═════════════╬══════════════════════════════════════════════════════════════════╬═════════════╣
║ 256818      ║ c659729a7fea5071361c2c1a68551ca2bf77679b27086cc415adeeb03852e369 ║ -1703168784 ║
╠═════════════╬══════════════════════════════════════════════════════════════════╬═════════════╣
║ 257644      ║ 35e79ee733fad376e76d16d1f10088273c2f4c2eaba1374a837378a88e530005 ║ -2130706433 ║
╠═════════════╬══════════════════════════════════════════════════════════════════╬═════════════╣
║ 311495      ║ 64147d3d27268778c9d27aa434e8f270f96b2be859658950accde95a2f0ce79d ║ 0           ║
╚═════════════╩══════════════════════════════════════════════════════════════════╩═════════════╝

In block 209,920, a coinbase transaction that’s v2

https://bch.loping.net/tx/a7b0fd34c953aeabe93b984bc0e3690ea0165eacab450a5af453cc0ec3307c44

{
    "txid": "a7b0fd34c953aeabe93b984bc0e3690ea0165eacab450a5af453cc0ec3307c44",
    "hash": "a7b0fd34c953aeabe93b984bc0e3690ea0165eacab450a5af453cc0ec3307c44",
    "version": 2,
    "size": 117,
    "locktime": 0,
    "vin": [
        {
            "coinbase": "030134035175626974506f6f6c204d696e657273d9dd5ac86700000042544331",
            "sequence": 0
        }
    ],
    "vout": [
        {
            "value": 50,
            "n": 0,
            "scriptPubKey": {
                "asm": "OP_DUP OP_HASH160 5d331cb009698ad2d6079a20c194bac1463c1f4a OP_EQUALVERIFY OP_CHECKSIG",
                "hex": "76a9145d331cb009698ad2d6079a20c194bac1463c1f4a88ac",
                "reqSigs": 1,
                "type": "pubkeyhash",
                "addresses": [
                    "bitcoincash:qpwnx89sp95c45kkq7dzpsv5htq5v0qlfg80nk3459"
                ]
            }
        }
    ],
    "hex": "02000000010000000000000000000000000000000000000000000000000000000000000000ffffffff20030134035175626974506f6f6c204d696e657273d9dd5ac86700000042544331000000000100f2052a010000001976a9145d331cb009698ad2d6079a20c194bac1463c1f4a88ac00000000",
    "blockhash": "000000000000024f743ba8fadbeb4310cf6d0a23b4cd403fe59143ba0b4d1f92",
    "confirmations": 510164,
    "time": 1354077445,
    "blocktime": 1354077445,
    "coindaysdestroyed": 0
}

Thanks to both @freetrader and @joshmg we now have the data, and surprisingly there isn’t that many non-standard TX versions:

Version Count First Seen Last Seen
0 1 311495 311495
1 268265490 0 720189
2 82427548 209920 720189
3 1 370002 370002
4 1 407042 407042
2164260863 1 257644 257644
2187681472 1 256818 256818
2591798512 1 256818 256818
1 Like