Bitcoin & UTXO Wallets
Last updated
Last updated
This CSV offers in-depth insights into BTC and other UTXO wallets including transfers and wallet balances over time.
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 |
|---|---|---|
Transaction 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
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