benchmark.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from subprocess import Popen, PIPE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import re\n",
    "reg_exec_time = re.compile(rb'Execution time: (\\d*\\.?\\d*)us\\n')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "from collections import OrderedDict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# note: all byte ops are in hex"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "class Op:\n",
    "    OP_0 = '00'\n",
    "    OP_FALSE = OP_0\n",
    "    OP_PUSHDATA1 = '4c'\n",
    "    OP_PUSHDATA2 = '4d'\n",
    "    OP_PUSHDATA4 = '4e'\n",
    "    OP_1NEGATE = '4f'\n",
    "    OP_RESERVED = '50'\n",
    "    OP_1 = '51'\n",
    "    OP_TRUE = OP_1\n",
    "    OP_2 = '52'\n",
    "    OP_3 = '53'\n",
    "    OP_4 = '54'\n",
    "    OP_5 = '55'\n",
    "    OP_6 = '56'\n",
    "    OP_7 = '57'\n",
    "    OP_8 = '58'\n",
    "    OP_9 = '59'\n",
    "    OP_10 = '5a'\n",
    "    OP_11 = '5b'\n",
    "    OP_12 = '5c'\n",
    "    OP_13 = '5d'\n",
    "    OP_14 = '5e'\n",
    "    OP_15 = '5f'\n",
    "    OP_16 = '60'\n",
    "\n",
    "    # control\n",
    "    OP_NOP = '61'\n",
    "    OP_VER = '62'\n",
    "    OP_IF = '63'\n",
    "    OP_NOTIF = '64'\n",
    "    OP_VERIF = '65'\n",
    "    OP_VERNOTIF = '66'\n",
    "    OP_ELSE = '67'\n",
    "    OP_ENDIF = '68'\n",
    "    OP_VERIFY = '69'\n",
    "    OP_RETURN = '6a'\n",
    "\n",
    "    # stack ops\n",
    "    OP_TOALTSTACK = '6b'\n",
    "    OP_FROMALTSTACK = '6c'\n",
    "    OP_2DROP = '6d'\n",
    "    OP_2DUP = '6e'\n",
    "    OP_3DUP = '6f'\n",
    "    OP_2OVER = '70'\n",
    "    OP_2ROT = '71'\n",
    "    OP_2SWAP = '72'\n",
    "    OP_IFDUP = '73'\n",
    "    OP_DEPTH = '74'\n",
    "    OP_DROP = '75'\n",
    "    OP_DUP = '76'\n",
    "    OP_NIP = '77'\n",
    "    OP_OVER = '78'\n",
    "    OP_PICK = '79'\n",
    "    OP_ROLL = '7a'\n",
    "    OP_ROT = '7b'\n",
    "    OP_SWAP = '7c'\n",
    "    OP_TUCK = '7d'\n",
    "\n",
    "    # splice ops\n",
    "    OP_CAT = '7e'\n",
    "    OP_SPLIT = '7f'   # after monolith upgrade (May 2018)\n",
    "    OP_NUM2BIN = '80' # after monolith upgrade (May 2018)\n",
    "    OP_BIN2NUM = '81' # after monolith upgrade (May 2018)\n",
    "    OP_SIZE = '82'\n",
    "\n",
    "    # bit logic\n",
    "    OP_INVERT = '83'\n",
    "    OP_AND = '84'\n",
    "    OP_OR = '85'\n",
    "    OP_XOR = '86'\n",
    "    OP_EQUAL = '87'\n",
    "    OP_EQUALVERIFY = '88'\n",
    "    OP_RESERVED1 = '89'\n",
    "    OP_RESERVED2 = '8a'\n",
    "\n",
    "    # numeric\n",
    "    OP_1ADD = '8b'\n",
    "    OP_1SUB = '8c'\n",
    "    OP_2MUL = '8d'\n",
    "    OP_2DIV = '8e'\n",
    "    OP_NEGATE = '8f'\n",
    "    OP_ABS = '90'\n",
    "    OP_NOT = '91'\n",
    "    OP_0NOTEQUAL = '92'\n",
    "\n",
    "    OP_ADD = '93'\n",
    "    OP_SUB = '94'\n",
    "    OP_MUL = '95'\n",
    "    OP_DIV = '96'\n",
    "    OP_MOD = '97'\n",
    "    OP_LSHIFT = '98'\n",
    "    OP_RSHIFT = '99'\n",
    "\n",
    "    OP_BOOLAND = '9a'\n",
    "    OP_BOOLOR = '9b'\n",
    "    OP_NUMEQUAL = '9c'\n",
    "    OP_NUMEQUALVERIFY = '9d'\n",
    "    OP_NUMNOTEQUAL = '9e'\n",
    "    OP_LESSTHAN = '9f'\n",
    "    OP_GREATERTHAN = 'a0'\n",
    "    OP_LESSTHANOREQUAL = 'a1'\n",
    "    OP_GREATERTHANOREQUAL = 'a2'\n",
    "    OP_MIN = 'a3'\n",
    "    OP_MAX = 'a4'\n",
    "\n",
    "    OP_WITHIN = 'a5'\n",
    "\n",
    "    # crypto\n",
    "    OP_RIPEMD160 = 'a6'\n",
    "    OP_SHA1 = 'a7'\n",
    "    OP_SHA256 = 'a8'\n",
    "    OP_HASH160 = 'a9'\n",
    "    OP_HASH256 = 'aa'\n",
    "    OP_CODESEPARATOR = 'ab'\n",
    "    OP_CHECKSIG = 'ac'\n",
    "    OP_CHECKSIGVERIFY = 'ad'\n",
    "    OP_CHECKMULTISIG = 'ae'\n",
    "    OP_CHECKMULTISIGVERIFY = 'af'\n",
    "\n",
    "    # expansion\n",
    "    OP_NOP1 = 'b0'\n",
    "    OP_CHECKLOCKTIMEVERIFY = 'b1'\n",
    "    OP_NOP2 = OP_CHECKLOCKTIMEVERIFY\n",
    "    OP_CHECKSEQUENCEVERIFY = 'b2'\n",
    "    OP_NOP3 = OP_CHECKSEQUENCEVERIFY\n",
    "    OP_NOP4 = 'b3'\n",
    "    OP_NOP5 = 'b4'\n",
    "    OP_NOP6 = 'b5'\n",
    "    OP_NOP7 = 'b6'\n",
    "    OP_NOP8 = 'b7'\n",
    "    OP_NOP9 = 'b8'\n",
    "    OP_NOP10 = 'b9'\n",
    "\n",
    "    # More crypto\n",
    "    OP_CHECKDATASIG = 'ba'\n",
    "    OP_CHECKDATASIGVERIFY = 'bb'\n",
    "\n",
    "    # multi-byte opcodes\n",
    "    OP_PREFIX_BEGIN = 'f0'\n",
    "    OP_PREFIX_END = 'f7'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "def push_int_hex(n):\n",
    "    assert n >= 0\n",
    "    op_name = f'OP_{n}'\n",
    "    if hasattr(Op, op_name):\n",
    "        return getattr(Op, op_name)\n",
    "    b = n.to_bytes(16, 'little')\n",
    "    b = b.rstrip(b'\\0')\n",
    "    return '%02x' % len(b) + b.hex()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "def varint_hex(n):\n",
    "    if n < 0xfd:\n",
    "        return '%02x' % n\n",
    "    elif n <= 0xffff:\n",
    "        return 'fd' + n.to_bytes(length=2, byteorder='little').hex()\n",
    "    elif n <= 0xffff_ffff:\n",
    "        return 'fe' + n.to_bytes(length=4, byteorder='little').hex()\n",
    "    else:\n",
    "        return 'ff' + n.to_bytes(length=8, byteorder='little').hex()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "from dataclasses import dataclass\n",
    "@dataclass\n",
    "class LimitParams:\n",
    "    MAX_SCRIPT_ELEMENT_SIZE: int = None\n",
    "    MAX_OPS_PER_SCRIPT: int = None\n",
    "    MAX_PUBKEYS_PER_MULTISIG: int = None\n",
    "    MAX_SCRIPT_SIZE: int = None\n",
    "    MAX_STACK_SIZE: int = None\n",
    "    ENABLE_OP_MUL: bool = False\n",
    "    ENABLE_INT128: bool = False\n",
    "    def param_list(self):\n",
    "        params = []\n",
    "        if self.MAX_SCRIPT_ELEMENT_SIZE is not None:\n",
    "            params.append(f'-MAX_SCRIPT_ELEMENT_SIZE={self.MAX_SCRIPT_ELEMENT_SIZE}')\n",
    "        if self.MAX_OPS_PER_SCRIPT is not None:\n",
    "            params.append(f'-MAX_OPS_PER_SCRIPT={self.MAX_OPS_PER_SCRIPT}')\n",
    "        if self.MAX_PUBKEYS_PER_MULTISIG is not None:\n",
    "            params.append(f'-MAX_PUBKEYS_PER_MULTISIG={self.MAX_PUBKEYS_PER_MULTISIG}')\n",
    "        if self.MAX_SCRIPT_SIZE is not None:\n",
    "            params.append(f'-MAX_SCRIPT_SIZE={self.MAX_SCRIPT_SIZE}')\n",
    "        if self.MAX_STACK_SIZE is not None:\n",
    "            params.append(f'-MAX_STACK_SIZE={self.MAX_STACK_SIZE}')\n",
    "        if self.ENABLE_OP_MUL:\n",
    "            params.append('-ENABLE_OP_MUL')\n",
    "        if self.ENABLE_INT128:\n",
    "            params.append('-ENABLE_INT128')\n",
    "        return params\n",
    "    def max_script_element_size(self):\n",
    "        return self.MAX_SCRIPT_ELEMENT_SIZE or 520\n",
    "    def max_ops_per_script(self):\n",
    "        return self.MAX_OPS_PER_SCRIPT or 201\n",
    "    def max_pubkeys_per_multisig(self):\n",
    "        return self.MAX_PUBKEYS_PER_MULTISIG or 20\n",
    "    def max_script_size(self):\n",
    "        return self.MAX_SCRIPT_SIZE or 10_000\n",
    "    def max_stack_size(self):\n",
    "        return self.MAX_STACK_SIZE or 1000"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "def bench_script(amount, script_sig, script_pub_key=None, limit_params=None, locktime=None, sequence=None):\n",
    "    version = '01000000'\n",
    "    if locktime is None:\n",
    "        locktime = '00000000'\n",
    "    else:\n",
    "        locktime = locktime.to_bytes(4, 'little').hex()\n",
    "    if sequence is None:\n",
    "        sequence = 'ffffffff'\n",
    "    else:\n",
    "        sequence = sequence.to_bytes(4, 'little').hex()\n",
    "    limit_params = limit_params or LimitParams()\n",
    "    \n",
    "    tx = (\n",
    "        version +\n",
    "        '01' + # one input\n",
    "        '77'*32 + '00'*4 + # 77..77:0, random outpoint\n",
    "        varint_hex(len(script_sig) // 2) + # len of script\n",
    "        script_sig +\n",
    "        sequence +\n",
    "        '00' + # no outputs\n",
    "        locktime\n",
    "    )\n",
    "    \n",
    "    params = (\n",
    "        ['./build/src/bitcoin-tx'] +\n",
    "        limit_params.param_list() +\n",
    "        [tx] +\n",
    "        ['benchin=0:' + '{:.8f}'.format(amount) + (':' + script_pub_key if script_pub_key is not None else '')]\n",
    "    )\n",
    "    \n",
    "    process = Popen(\n",
    "        params,\n",
    "        stdout=PIPE,\n",
    "        stderr=PIPE,\n",
    "    )\n",
    "    (output, err) = process.communicate()\n",
    "    exit_code = process.wait()\n",
    "    if exit_code:\n",
    "        print(output.decode())\n",
    "        raise ValueError(f'{err} for params {params}')\n",
    "    else:\n",
    "        m = reg_exec_time.match(output)\n",
    "        if m is None:\n",
    "            raise ValueError(f'unexpected output: {output.decode()} for params {params}')\n",
    "        return float(m.group(1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "def bench_tx(tx, amount, benchin, limit_params=None):\n",
    "    limit_params = limit_params or LimitParams()\n",
    "    params = (\n",
    "        ['./build/src/bitcoin-tx'] +\n",
    "        limit_params.param_list() +\n",
    "        [tx] +\n",
    "        ['benchin=0:' + '{:.8f}'.format(amount)]\n",
    "    )\n",
    "    \n",
    "    process = Popen(\n",
    "        params,\n",
    "        stdout=PIPE,\n",
    "        stderr=PIPE,\n",
    "    )\n",
    "    (output, err) = process.communicate()\n",
    "    exit_code = process.wait()\n",
    "    if exit_code:\n",
    "        print(output.decode())\n",
    "        raise ValueError(f'{err} for params {params}')\n",
    "    else:\n",
    "        return output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "def make_big_if_scripts(limit_params):\n",
    "    n_ifs = limit_params.max_ops_per_script() // 2\n",
    "    n_zero = limit_params.max_script_size() - 2 - (n_ifs * 2)\n",
    "    script = [Op.OP_0]\n",
    "    for _ in range(n_ifs):\n",
    "        script += [Op.OP_IF]\n",
    "    for _ in range(n_zero):\n",
    "        script += [Op.OP_0]\n",
    "    for _ in range(n_ifs):\n",
    "        script += [Op.OP_ENDIF]\n",
    "    return Op.OP_TRUE, ''.join(script)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "def make_big_int128_func(mode: str):\n",
    "    def make_big_int128_script(limit_params):\n",
    "        x = 0x7fff_ffff_ffff_ffff_ffff_ffff_ffff_ffff\n",
    "        y = 0x1234_5678_abcd_ef12\n",
    "        z = x // y\n",
    "        script = [\n",
    "            push_int_hex(x),\n",
    "            push_int_hex(y),\n",
    "            push_int_hex(z),\n",
    "        ]\n",
    "        n_arith = (limit_params.max_ops_per_script() - 1) // 4\n",
    "        for i in range(n_arith):\n",
    "            script += [\n",
    "                Op.OP_3DUP, \n",
    "                Op.OP_MUL,\n",
    "                Op.OP_DIV, \n",
    "                Op.OP_MUL if mode == 'mul' else Op.OP_MUL,\n",
    "            ]\n",
    "        script += [\n",
    "            Op.OP_2DROP,\n",
    "        ]\n",
    "        return '', ''.join(script)\n",
    "    make_big_int128_script.__name__ = f'make_big_int128_script_{mode}'\n",
    "    return make_big_int128_script"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "164.21"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "limit_params = LimitParams(ENABLE_OP_MUL=True, ENABLE_INT128=True)\n",
    "script_sig, script_pub_key = make_big_int128_func('mul')(LimitParams(limit_params))\n",
    "bench_script(1, script_sig, script_pub_key, limit_params)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "tests = [\n",
    "    (make_big_if_scripts,            LimitParams()),\n",
    "    (make_big_int128_func('mul'),    LimitParams(ENABLE_OP_MUL=True, ENABLE_INT128=True)),\n",
    "    (make_big_int128_func('div'),    LimitParams(ENABLE_OP_MUL=True, ENABLE_INT128=True)),\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "opcode_limits = [201, 300, 400, 500, 600, 700, 800, 900, 1000, 2000, 3000, 4000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "block_size = 32_000_000\n",
    "sig_check_dt = 70\n",
    "max_sig_check_dt = (block_size / 100) * sig_check_dt / 1_000_000"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "results = []\n",
    "script_sizes = []\n",
    "block_exec_times = []\n",
    "for opcode_limit in opcode_limits:\n",
    "    row = OrderedDict()\n",
    "    row['opcode_limit'] = opcode_limit\n",
    "    row_size = OrderedDict()\n",
    "    row_size['opcode_limit'] = opcode_limit\n",
    "    row_block = OrderedDict()\n",
    "    row_block['opcode_limit'] = opcode_limit\n",
    "    for f, limit_params in tests:\n",
    "        limit_params.MAX_OPS_PER_SCRIPT = opcode_limit\n",
    "        script_sig, script_pub_key = f(limit_params)\n",
    "        dt = bench_script(1, script_sig, script_pub_key, limit_params)\n",
    "        name = f.__name__.replace('make_', '')\n",
    "        row[name] = dt\n",
    "        size = len(script_pub_key) // 2\n",
    "        row_size[name] = size\n",
    "        row_block[name + ' p2sh'] = (block_size // (size + 41)) * dt / 1_000_000\n",
    "        row_block[name + ''] = (block_size // 41) * dt / 1_000_000\n",
    "    results.append(row)\n",
    "    script_sizes.append(row_size)\n",
    "    block_exec_times.append(row_block)\n",
    "df = pandas.DataFrame(results)\n",
    "df_size = pandas.DataFrame(script_sizes)\n",
    "df_block_exec = pandas.DataFrame(block_exec_times)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>opcode_limit</th>\n",
       "      <th>big_if_scripts</th>\n",
       "      <th>big_int128_script_mul</th>\n",
       "      <th>big_int128_script_div</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>201</td>\n",
       "      <td>9999</td>\n",
       "      <td>237</td>\n",
       "      <td>237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>300</td>\n",
       "      <td>9999</td>\n",
       "      <td>333</td>\n",
       "      <td>333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>400</td>\n",
       "      <td>9999</td>\n",
       "      <td>433</td>\n",
       "      <td>433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>500</td>\n",
       "      <td>9999</td>\n",
       "      <td>533</td>\n",
       "      <td>533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>600</td>\n",
       "      <td>9999</td>\n",
       "      <td>633</td>\n",
       "      <td>633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>700</td>\n",
       "      <td>9999</td>\n",
       "      <td>733</td>\n",
       "      <td>733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>800</td>\n",
       "      <td>9999</td>\n",
       "      <td>833</td>\n",
       "      <td>833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>900</td>\n",
       "      <td>9999</td>\n",
       "      <td>933</td>\n",
       "      <td>933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1000</td>\n",
       "      <td>9999</td>\n",
       "      <td>1033</td>\n",
       "      <td>1033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2000</td>\n",
       "      <td>9999</td>\n",
       "      <td>2033</td>\n",
       "      <td>2033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3000</td>\n",
       "      <td>9999</td>\n",
       "      <td>3033</td>\n",
       "      <td>3033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>4000</td>\n",
       "      <td>9999</td>\n",
       "      <td>4033</td>\n",
       "      <td>4033</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    opcode_limit  big_if_scripts  big_int128_script_mul  big_int128_script_div\n",
       "0            201            9999                    237                    237\n",
       "1            300            9999                    333                    333\n",
       "2            400            9999                    433                    433\n",
       "3            500            9999                    533                    533\n",
       "4            600            9999                    633                    633\n",
       "5            700            9999                    733                    733\n",
       "6            800            9999                    833                    833\n",
       "7            900            9999                    933                    933\n",
       "8           1000            9999                   1033                   1033\n",
       "9           2000            9999                   2033                   2033\n",
       "10          3000            9999                   3033                   3033\n",
       "11          4000            9999                   4033                   4033"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_size"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>opcode_limit</th>\n",
       "      <th>big_if_scripts p2sh</th>\n",
       "      <th>big_if_scripts</th>\n",
       "      <th>big_int128_script_mul p2sh</th>\n",
       "      <th>big_int128_script_mul</th>\n",
       "      <th>big_int128_script_div p2sh</th>\n",
       "      <th>big_int128_script_div</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>201</td>\n",
       "      <td>0.674433</td>\n",
       "      <td>165.166659</td>\n",
       "      <td>17.441013</td>\n",
       "      <td>118.259390</td>\n",
       "      <td>17.765614</td>\n",
       "      <td>120.460364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>300</td>\n",
       "      <td>0.689507</td>\n",
       "      <td>168.858362</td>\n",
       "      <td>18.643742</td>\n",
       "      <td>170.068117</td>\n",
       "      <td>18.714758</td>\n",
       "      <td>170.715922</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>400</td>\n",
       "      <td>0.741360</td>\n",
       "      <td>181.556886</td>\n",
       "      <td>20.635107</td>\n",
       "      <td>238.563656</td>\n",
       "      <td>21.532990</td>\n",
       "      <td>248.944134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>500</td>\n",
       "      <td>0.760641</td>\n",
       "      <td>186.278832</td>\n",
       "      <td>20.210685</td>\n",
       "      <td>282.949952</td>\n",
       "      <td>20.105877</td>\n",
       "      <td>281.482637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>600</td>\n",
       "      <td>0.699833</td>\n",
       "      <td>171.387140</td>\n",
       "      <td>21.602985</td>\n",
       "      <td>355.137195</td>\n",
       "      <td>22.639407</td>\n",
       "      <td>372.175226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>700</td>\n",
       "      <td>0.808606</td>\n",
       "      <td>198.025162</td>\n",
       "      <td>20.985293</td>\n",
       "      <td>396.167396</td>\n",
       "      <td>20.979919</td>\n",
       "      <td>396.065933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>800</td>\n",
       "      <td>0.805674</td>\n",
       "      <td>197.307114</td>\n",
       "      <td>23.710945</td>\n",
       "      <td>505.451186</td>\n",
       "      <td>21.550778</td>\n",
       "      <td>459.402453</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>900</td>\n",
       "      <td>0.892806</td>\n",
       "      <td>218.645628</td>\n",
       "      <td>20.971365</td>\n",
       "      <td>498.200462</td>\n",
       "      <td>20.498925</td>\n",
       "      <td>486.977059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1000</td>\n",
       "      <td>0.842707</td>\n",
       "      <td>206.376373</td>\n",
       "      <td>21.135083</td>\n",
       "      <td>553.638453</td>\n",
       "      <td>21.077281</td>\n",
       "      <td>552.124309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2000</td>\n",
       "      <td>0.990488</td>\n",
       "      <td>242.567555</td>\n",
       "      <td>22.767958</td>\n",
       "      <td>1151.733446</td>\n",
       "      <td>21.859961</td>\n",
       "      <td>1105.801786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3000</td>\n",
       "      <td>1.020382</td>\n",
       "      <td>249.888523</td>\n",
       "      <td>22.355722</td>\n",
       "      <td>1676.275345</td>\n",
       "      <td>21.979124</td>\n",
       "      <td>1648.037325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>4000</td>\n",
       "      <td>1.142030</td>\n",
       "      <td>279.679712</td>\n",
       "      <td>23.031934</td>\n",
       "      <td>2288.785932</td>\n",
       "      <td>23.108903</td>\n",
       "      <td>2296.434705</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    opcode_limit  big_if_scripts p2sh  big_if_scripts  \\\n",
       "0            201             0.674433      165.166659   \n",
       "1            300             0.689507      168.858362   \n",
       "2            400             0.741360      181.556886   \n",
       "3            500             0.760641      186.278832   \n",
       "4            600             0.699833      171.387140   \n",
       "5            700             0.808606      198.025162   \n",
       "6            800             0.805674      197.307114   \n",
       "7            900             0.892806      218.645628   \n",
       "8           1000             0.842707      206.376373   \n",
       "9           2000             0.990488      242.567555   \n",
       "10          3000             1.020382      249.888523   \n",
       "11          4000             1.142030      279.679712   \n",
       "\n",
       "    big_int128_script_mul p2sh  big_int128_script_mul  \\\n",
       "0                    17.441013             118.259390   \n",
       "1                    18.643742             170.068117   \n",
       "2                    20.635107             238.563656   \n",
       "3                    20.210685             282.949952   \n",
       "4                    21.602985             355.137195   \n",
       "5                    20.985293             396.167396   \n",
       "6                    23.710945             505.451186   \n",
       "7                    20.971365             498.200462   \n",
       "8                    21.135083             553.638453   \n",
       "9                    22.767958            1151.733446   \n",
       "10                   22.355722            1676.275345   \n",
       "11                   23.031934            2288.785932   \n",
       "\n",
       "    big_int128_script_div p2sh  big_int128_script_div  \n",
       "0                    17.765614             120.460364  \n",
       "1                    18.714758             170.715922  \n",
       "2                    21.532990             248.944134  \n",
       "3                    20.105877             281.482637  \n",
       "4                    22.639407             372.175226  \n",
       "5                    20.979919             396.065933  \n",
       "6                    21.550778             459.402453  \n",
       "7                    20.498925             486.977059  \n",
       "8                    21.077281             552.124309  \n",
       "9                    21.859961            1105.801786  \n",
       "10                   21.979124            1648.037325  \n",
       "11                   23.108903            2296.434705  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_block_exec"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>opcode_limit</th>\n",
       "      <th>big_if_scripts</th>\n",
       "      <th>big_int128_script_mul</th>\n",
       "      <th>big_int128_script_div</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>201</td>\n",
       "      <td>211.62</td>\n",
       "      <td>151.52</td>\n",
       "      <td>154.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>300</td>\n",
       "      <td>216.35</td>\n",
       "      <td>217.90</td>\n",
       "      <td>218.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>400</td>\n",
       "      <td>232.62</td>\n",
       "      <td>305.66</td>\n",
       "      <td>318.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>500</td>\n",
       "      <td>238.67</td>\n",
       "      <td>362.53</td>\n",
       "      <td>360.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>600</td>\n",
       "      <td>219.59</td>\n",
       "      <td>455.02</td>\n",
       "      <td>476.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>700</td>\n",
       "      <td>253.72</td>\n",
       "      <td>507.59</td>\n",
       "      <td>507.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>800</td>\n",
       "      <td>252.80</td>\n",
       "      <td>647.61</td>\n",
       "      <td>588.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>900</td>\n",
       "      <td>280.14</td>\n",
       "      <td>638.32</td>\n",
       "      <td>623.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1000</td>\n",
       "      <td>264.42</td>\n",
       "      <td>709.35</td>\n",
       "      <td>707.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2000</td>\n",
       "      <td>310.79</td>\n",
       "      <td>1475.66</td>\n",
       "      <td>1416.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3000</td>\n",
       "      <td>320.17</td>\n",
       "      <td>2147.73</td>\n",
       "      <td>2111.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>4000</td>\n",
       "      <td>358.34</td>\n",
       "      <td>2932.51</td>\n",
       "      <td>2942.31</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    opcode_limit  big_if_scripts  big_int128_script_mul  big_int128_script_div\n",
       "0            201          211.62                 151.52                 154.34\n",
       "1            300          216.35                 217.90                 218.73\n",
       "2            400          232.62                 305.66                 318.96\n",
       "3            500          238.67                 362.53                 360.65\n",
       "4            600          219.59                 455.02                 476.85\n",
       "5            700          253.72                 507.59                 507.46\n",
       "6            800          252.80                 647.61                 588.61\n",
       "7            900          280.14                 638.32                 623.94\n",
       "8           1000          264.42                 709.35                 707.41\n",
       "9           2000          310.79                1475.66                1416.81\n",
       "10          3000          320.17                2147.73                2111.55\n",
       "11          4000          358.34                2932.51                2942.31"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}