LogoLogo
  • Kaiko Knowledge Hub
  • GENERAL
    • 👋Introduction
  • Getting Started
    • BigQuery
    • Google Cloud
    • Azure Blob
    • AWS S3
  • Data Feeds
    • Level 1 Aggregations
      • Trade Count, OHLCV & VWAP
        • VWAP Only
        • OHLCV Only
    • Level 1 Tick-Level
      • All trades
      • Best bids and asks (top of book)
      • Borrows, repayments, liquidations, and withdrawals
    • Level 2 Aggregations
      • Raw order book snapshot
    • Level 2 Tick-Level
      • Bids and asks
      • Mints and burns
      • Interest rates, borrowed and deposited amounts
      • Tokens in a liquidity pool
        • Tokens in a liquidity pool (Uniswap v3)
  • Analytics Solutions
    • Derivatives Risk Indicators
      • Exchange-provided metrics
  • Monitoring Solutions
    • Blockchain Monitoring
      • Ethereum Wallets
      • Bitcoin Wallets
Powered by GitBook
On this page
  • What is this dataset for?
  • Update frequencies
  • File structure details

Was this helpful?

Export as PDF
  1. Monitoring Solutions
  2. Blockchain Monitoring

Bitcoin Wallets

What is this dataset for?

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

Update frequencies

Channel
Update frequency

AWS

New CSV once a day

Azure

New CSV once a day

Google Cloud Platform

New CSV once a day

Snowflake

Not available

BigQuery

Data refreshes once a day

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

PreviousEthereum Wallets

Last updated 2 months ago

Was this helpful?