# Bitcoin Wallets

## What is this dataset for? 

This dataset offers in-depth insights into BTC 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: bitcoin\_\[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`             | Always `bitcoin`                                                                                                 | `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`                                                     |