Table of contents

The eth_mainnet.erc20_approvals table provides indexed views of all erc20_approvals.

Columns

Name	Type	Description
contract_address	varchar	The address of the contract that emitted the transactions
token_name	varchar	Name of token
token_symbol	varchar	Symbol of token
token_decimals	integer	This is the number of decimal places that a token's value can be divided into
transaction_hash	varchar	Txn Hash or transaction hash is a unique identifier that is generated whenever a transaction is performed. A Txn Hash can be used to track and trace the status of a transaction.
transaction_index	integer	N/A
log_index	integer	N/A
block_hash	varchar	A unique identifier for that block
block_number	integer	The length of the blockchain in blocks
block_time	date	The time when the block was mined that includes this log
from_wallet	varchar	Address of the sender
to_wallet	varchar	Address of the receiver.
value	varchar	The amount of [chain_gas_token] sent in this transaction in wei.
value_decimal	varchar	N/A
ym	varchar	Year Month