Description of the bitcoin.transactions table on Dune
input[1].witness_data[2]
or input[3].script_pub_key.address
depending on lengths of arrays within each value. It is an array(row(map))
type, and while it looks like just an array in the returned table - it is more than that!
input
Field | Data type | Description |
---|---|---|
value | double | The number of Satoshis attached to this output |
height | bigint | The height of the output |
tx_id | string | The transaction id of the output that is here used as input |
output_number | bigint | The number (index) of the output in transaction tx_id ’s outputs |
coinbase | string | The data specified in this transaction, if it was a coinbase transaction |
sequence | bigint | Sequence number |
witness_data | array<string> | Array of hex encoded witness data |
script_signature | struct | The script signature |
script_pub_key | struct | The script public key |
Field | Data type | Description |
---|---|---|
hex | string | The transaction’s script operations, in hex |
asm | string | The transaction’s script operations, in symbolic representation |
Field | Data type | Description |
---|---|---|
asm | string | The transaction’s script operations, in symbolic representation |
desc | string | The transaction’s script operations, in symbolic representation |
address | string | The transaction’s script operations, in symbolic representation |
hex | string | The transaction’s script operations, in hex |
type | string | The address type of the output |
Field | Data type | Description |
---|---|---|
index | bigint | 0-indexed number of an output within a transaction used by a later transaction to refer to that specific output |
value | double | The number of Satoshis attached to this output |
script_pub_key | struct | The public key |
Field | Data type | Description |
---|---|---|
asm | string | The transaction’s script operations, in symbolic representation |
hex | string | The transaction’s script operations, in hex |
address | string | The address the BTC came from |
type | string | The address type of the output |