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

Field	Description	Example
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

Field	Description	Example
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