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

Ethereum Wallets

What is this dataset for?

This dataset offers in-depth insights into Ethereum 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

Live with a ~15-minute delay to account for potential block reorganizations and ensure data accuracy

File structure details

  • File Name: ethereum_[date].csv

    • Files are created on a daily basis.

    • example: ethereum_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)

Field
Description
Example

user_address

The address on which the row is focused.

0xc8c939539efb7f5ba903fc99b61656979c46c045

chain

Always ethereum

ethereum

block_number

The height of the block.

7005997

timestamp

The timestamp of the block.

1546560004

transaction_hash

Transaction hash.

0x5a9e11432e5c7e2fccf598606858619cbd72f1de40db625fc4749ec1b032e144

transaction_type

Event type.

gas_buy

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

sender_address

The address that sends tokens or coins.

0xc8c939539efb7f5ba903fc99b61656979c46c045

receiver_address

The address that receives tokens or coins.

0x5a0b54d5dc17e0aadc383d2db43b0a0d3e029c4c

initiator_address

The address that signed the transaction.

0xc8c939539efb7f5ba903fc99b61656979c46c045

token_symbol

Symbol of the token or coin transfered

ETH

token_address

The address of the token or coin transfered.

0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee

direction

Inflow or outflow from the user_address.

out

amount

Amount of asset transfered.

0.16

balance_after

Wallet balance for the user_address for this asset.

0.4814735188

amount_usd

Amount of asset transferred in usd.

23.863262042004745

balance_after_usd

Wallet balance for the user_address for this asset in usd.

71.80955465881561

All possible values for the field transaction_type:

Value
Description

unknown

Unknown balance_change reason, only happens for the chain’s coin.

reward_mine_uncle

Uncle block rewards are awarded to miners who generate an uncle block that gets included in a valid block added to the chain. These uncle blocks are analogous to stale blocks in Bitcoin. However, rather than being disregarded, uncle blocks receive rewards dependent on their novelty.

reward_mine_block

Rewards granted to the miner who mines the current block.

dao_refund_contract

This is related to the execution of the DAO hard-fork, an event that occurred as a response to the notorious DAO hack in 2016. This hard-fork moved all the Ether initially stored in The DAO (and its child DAOs) to a refund contract. From this contract, original DAO token holders could claim their proportional share of the funds.

dao_adjust_balance

Refers to any adjustment made to an account’s balance in relation to DAO-related hard-fork or operations.

coin_transfer

A coin transfer operation.

genesis_balance

Refers to the balance attributed to addresses during the genesis block.

gas_buy

The amount of gas purchased by the initiator to execute the transaction.

reward_transaction_fee

Reward earned by the miner for including the transaction in the block.

reward_fee_reset

gas_refund

The process of refunding gas to the initiator when the state store is cleared.

touch_account

Refers to the process of interacting with an account in some way, such as updating its nonce.

suicide_refund

The process of refunding gas to a contract owner when the SELFDESTRUCT operation is called, as it clears the store.

suicide_withdraw

This action allows the withdrawal of the remaining coin (ex: ETH) in a self-destructed account to a specific address.

call_balance_override

This operation overrides the default balance of an account.

burn

Burning coins in chains where this process occurs.

withdrawal

Allows the withdrawal of rewards or stake for validators.

token_transfer

This operation involves the transfer of (ERC20) tokens.

wrap_coin

This operation mints WETH tokens after a coin (ex: ETH) deposit.

unwrap_coin

This operation burns WETH tokens before a coin (ex: ETH) withdrawal.

token_deposit

This operation allows the deposit of (ERC20) tokens into staking contracts or escrow.

token_withdrawal

This operation allows the withdrawal of (ERC20) tokens from the staking contracts or escrow.

PreviousBlockchain MonitoringNextBitcoin Wallets

Last updated 2 months ago

Was this helpful?