Ethereum Wallets

What is this CSV for?

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)

FieldDescriptionExample

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:

ValueDescription

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.

Last updated