Ethereum Wallets

What is this CSV for?

This CSV offers in-depth insights into Ethereum wallets including transfers and wallet balances over time. Wallet Data can also be accessed through Google BigQuery. To get started, read our guide.

File structure details

File Structure Details

• File Name: [blockchain]_[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	Blockchain name.	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.