Chainscope-Demo.txt

# Chainscope Demo
# See http://localhost:9200/_plugin/marvel/sense/index.html

# Block Count
#
# Gets the total number of blocks
# currently indexed by Elasticsearch
GET _search
{
  "query": {
    "match": { "_type": "block" }
  },
  "fields": [],
  "size": 0
}

# Block Height (Max and Min)
#
# Uses aggregations to detect highest and lowest height
# of blocks currently indexed by Elasticsearch
GET _search
{
  "query": {
    "match": { "_type": "block" }
  },
  "aggregations": {
    "min_height": {"min": { "field": "height" }},
    "max_height": {"max": { "field": "height" }}
  },
  "fields": [],
  "size": 0
}

# Block Difficulty (Max and Min)
#
# Uses aggregations for max and min difficulty
GET _search
{
  "query": {
    "match": { "_type": "block" }
  },
  "aggregations": {
    "min_difficulty": {"min": { "field": "difficulty" }},
    "max_difficulty": {"max": { "field": "difficulty" }}
  },
  "fields": [],
  "size": 0
}

# Block Size (Average, Min, Max)
#
# Uses aggregations for max, min and average size
# of blocks indexed by Elasticsearch
GET _search
{
  "query": {
    "match": { "_type": "block" }
  },
  "aggregations": {
    "avg_size": {"avg": { "field": "size" }},
    "min_size": {"min": { "field": "size" }},
    "max_size": {"max": { "field": "size" }}
  },
  "fields": [],
  "size": 0
}

# Block Data
#
# Uses partial_fields to get block information,
# without transaction data
GET _search
{
  "partial_fields": {
    "BLOCK": {
      "include": [],
      "exclude": ["txinfo.*", "tx"]
    }
  },
  "query": {
    "match": { "_type": "block" }
  },
  "from": 1000,
  "size": 5
}


# Multiple Blocks starting at Height
#
# Uses a range query on block height
GET _search
{
  "query": {
    "range": {
      "height": {
        "gte": "300100"
      }
    }
  },
  "partial_fields": {
    "BLOCK": {
      "include": [],
      "exclude": ["tx", "txinfo.*"]
    }
  },
  "size": 2
}

# First 5 Blocks
#
# Gets the first five blocks indexed by ES.
# Note, this doesn't include block 0, the genesis block!
GET _search
{
  "query": {
    "range": {
      "height": {
        "gte": "0",
        "lte": "5"
      }
    }
  },
  "partial_fields": {
    "BLOCK": {
      "include": []
    }
  },
  "size": 5,
  "sort": [
    {
      "height": {
        "order": "asc"
      }
    }
  ]
}

# Coinbase Transaction Data
#
# Gets data for the coinbase transaction,
# the first transaction in a block
GET _search
{
  "query": {
    "range": {
      "height": {
        "gte": "300100"
      }
    }
  },
  "script_fields": {
    "TX0": {
      "script": "_source.txinfo[0]"
    }
  },
  "size": 5
}

# Script Fields (and Coinbase)
#
# Uses dynamic scripting to create a new field
# Supports groovy, JavaScript, Python, and others
#
# Here we pluck the COINBASE field
GET _search
{
  "query": {
    "range": {
      "height": {
        "gte": "300100"
      }
    }
  },
  "script_fields": {
    "COINBASE": {
      "script": "_source.txinfo[0].vin[0].coinbase"
    }
  },
  "size": 2
}

# Human-readable Coinbase
# See python's binascii.unhexlify(hex_str), "".decode('hex')
# Or elasticsearch.js and String.fromCharCode(parseInt(hexCode))

# Transaction Data
#
# Gets first transaction from series of blocks,
# using script fields to pluck transaction info
GET _search
{
  "query": {
    "range": {
      "height": {
        "gte": "300100"
      }
    }
  },
  "script_fields": {
    "TX0": {
      "script": "_source.txinfo[1]"
    }
  },
  "size": 5
}

# ScriptPubKey (Lock, TxOut)
#
# Selects script pub key object from
# first transaction in a series of blocks
GET _search
{
  "query": {
    "range": {
      "height": {
        "gte": "300100"
      }
    }
  },
  "script_fields": {
    "SCRIPT_PUB_KEY": {
      "script": "_source.txinfo[1].vout.scriptPubKey"
    }
  },
  "size": 10
}

# Output Scripts
#
# Selects the scriptPubKey ASM from every output
# of first transaction in a series of blocks
GET _search
{
  "query": {
    "range": {
      "height": {
        "gte": "300200"
      }
    }
  },
  "script_fields": {
    "OUTPUT_SCRIPTS": {
      "script": "_source.txinfo[1].vout.scriptPubKey*.asm"
    }
  },
  "size": 3
}

# Input Scripts
#
# Selects the scriptSig ASM from every input
# of first transaction in a series of blocks
GET _search
{
  "query": {
    "range": {
      "height": {
        "gte": "300200"
      }
    }
  },
  "script_fields": {
    "INPUT_SCRIPTS": {
      "script": "_source.txinfo[1].vin.scriptSig*.asm"
    }
  },
  "size": 3
}

# Op Return
#
# Selects the output scripts (and embedded data)
# for blocks with transactions using OP_RETURN
GET _search
{
  "query": {
    "match": {
      "txinfo.vout.scriptPubKey.asm": "OP_RETURN"
    }
  },
  "script_fields": {
    "OUTPUT_SCRIPTS": {
      "script": "_source.txinfo*.vout.scriptPubKey.asm"
    }
  },
  "size": 3
}