Bitcoin & UTXO Wallets

What is this CSV for?

This CSV offers in-depth insights into BTC and other UTXO wallets including transfers and wallet balances over time.

File structure details

This product is made of two distinct tables: - Balance Data - One row for each address balance change. - Transaction Data - One row for each transaction.

  • File Name: [blockchain]_[date].csv

    • Files are created on a daily basis.

    • example: bitcoin_2023-02-12.csv

  • Cut-off time: 00:00:00 UTC

    • We use the timestamp of the block in order to cut-off the data points between days.

  • Column Delimeter: ,(comma)

  • Decimal Mark (in numbers): . (dot)

Balance Data

FieldDescriptionExample

user_address

The address on which the row is focused.

15HCzh8AoKRnTWMtmgAsT9TKUPrQ6oh9HQ

chain

Blockchain name.

bitcoin

block_number

The height of the block.

394889

timestamp

The timestamp of the block.

1453681271

transaction_hash

Transaction hash.

94ad60ff0ef4cd0f31cab884adc6c39720273e9468ac0019a339911f0dd26e76

transaction_type

Event type.

minerReward

transaction_index

The index of the transaction.

0

ordinal

Generated number that gives the order of each balance impact, for one file. Based on call index and log indexes.

2

token_symbol

Symbol of the coin transfered

BTC

direction

Inflow or outflow from the user_address.

in

amount

Amount of asset transfered.

25.42860520

balance_after

Wallet balance for the user_address for this asset.

531.52819202

amount_usd

Amount of asset transferred in usd.

10171.442886426918

balance_after_usd

Wallet balance for the user_address for this asset in usd.

212611.2936645534

Transaction Data

FieldDescriptionExample

chain

Blockchain name.

bitcoin

block_number

The height of the block.

395211

timestamp

The timestamp of the block.

1453853136

transaction_hash

Transaction hash.

94ad60ff0ef4cd0f31cab884adc6c39720273e9468ac0019a339911f0dd26e76

transaction_index

The index of the transaction.

0

sender_addresses

The addresses that sends the coin.

[1A8MMLhpGEyNqEsqzkReXtmBx9LBQgt8Mh]

receiver_addresses

The addresses that receives the coin.

[19Ntq9wC9i39284EZVVf4R7DbCz7gThxzs,12eKGe5hLdKBe8mQ7dv8NixEcX96XHBkoZ]

token_symbol

Symbol of the coin transfered

BTC

amount_out

Amount of asset transfered.

10.12592654

fees

Fees paid for the transaction.

0.0004

amount_out_usd

Amount of asset transferred in usd.

3965.771819253574

fees_usd

Fees paid for the transaction in usd.

0.15665813112855445

Last updated