Ethereum dataset
Growhold Ethereum dataset in Google BigQuery provides tables for DApp analytics, transfers with comparable USD prices as well as fully decoded smart contract calls and log events. To learn how to use the dataset, please find more instructions from the Google BigQuery documentation or Google Data Studio support.
transfer-native
id: growhold.ethereum.transfer-nativeNative Ethereum transfers with transfer time's USD price.
| token_address | STRING |
| from_address | STRING |
| to_address | STRING |
| token_name | STRING |
| token_symbol | STRING |
| usd_value | BIGNUMERIC |
| token_value | BIGNUMERIC |
| value | STRING |
| transaction_hash | STRING |
| log_index | INTEGER |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
transfer-erc20
id: growhold.ethereum.transfer-erc20ERC-20 token transfers with USD price synced from Coingecko
| token_address | STRING |
| from_address | STRING |
| to_address | STRING |
| token_name | STRING |
| token_symbol | STRING |
| usd_value | BIGNUMERIC |
| token_value | BIGNUMERIC |
| value | STRING |
| transaction_hash | STRING |
| log_index | INTEGER |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
transfer-erc721
id: growhold.ethereum.transfer-erc721ERC-721 token transfers
| token_address | STRING |
| from_address | STRING |
| to_address | STRING |
| token_name | STRING |
| token_symbol | STRING |
| usd_value | BIGNUMERIC |
| token_value | BIGNUMERIC |
| value | STRING |
| transaction_hash | STRING |
| log_index | INTEGER |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
transfer-erc777
id: growhold.ethereum.transfer-erc777ERC-777 token transfers
| token_address | STRING |
| from_address | STRING |
| to_address | STRING |
| token_name | STRING |
| token_symbol | STRING |
| usd_value | BIGNUMERIC |
| token_value | BIGNUMERIC |
| value | STRING |
| transaction_hash | STRING |
| log_index | INTEGER |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
transfer-erc1155
id: growhold.ethereum.transfer-erc1155ERC-1155 token transfers
| token_address | STRING |
| from_address | STRING |
| to_address | STRING |
| token_name | STRING |
| token_symbol | STRING |
| usd_value | BIGNUMERIC |
| token_value | BIGNUMERIC |
| value | STRING |
| transaction_hash | STRING |
| log_index | INTEGER |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
transfer-other
id: growhold.ethereum.transfer-otherOther than ERC-20, ERC-721, ERC-777 or ERC-1155 transfers.
| token_address | STRING |
| from_address | STRING |
| to_address | STRING |
| token_name | STRING |
| token_symbol | STRING |
| usd_value | BIGNUMERIC |
| token_value | BIGNUMERIC |
| value | STRING |
| transaction_hash | STRING |
| log_index | INTEGER |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
call-erc20
id: growhold.ethereum.call-erc20ERC-20 smart contract calls, excluding transfer and approval.
| from | STRING |
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
call-erc20-transfer
id: growhold.ethereum.call-erc20-transferERC-20 smart contract transfer calls.
| from | STRING |
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| to_address | STRING |
| value | STRING |
| amount | STRING |
| value_a | STRING |
| amount_a | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
call-erc20-approval
id: growhold.ethereum.call-erc20-approvalERC-20 smart contract approval calls.
| from | STRING |
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| approval_address | STRING |
| approval_name | STRING |
| value | STRING |
| amount | STRING |
| approval_all | BOOLEAN |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
call-erc721
id: growhold.ethereum.call-erc721ERC-721 smart contract calls, excluding transfer and approval.
| from | STRING |
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
call-erc721-transfer
id: growhold.ethereum.call-erc721-transferERC-721 smart contract transfer calls.
| from | STRING |
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| to_address | STRING |
| value | STRING |
| amount | STRING |
| value_a | STRING |
| amount_a | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
call-erc721-approval
id: growhold.ethereum.call-erc721-approvalERC-721 smart contract approval calls.
| from | STRING |
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| approval_address | STRING |
| approval_name | STRING |
| value | STRING |
| amount | STRING |
| approval_all | BOOLEAN |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
call-erc777
id: growhold.ethereum.call-erc777ERC-777 smart contract calls, excluding transfer and approval.
| from | STRING |
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
call-erc777-transfer
id: growhold.ethereum.call-erc777-transferERC-777 smart contract transfer calls.
| from | STRING |
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| to_address | STRING |
| value | STRING |
| amount | STRING |
| value_a | STRING |
| amount_a | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
call-erc777-approval
id: growhold.ethereum.call-erc777-approvalERC-777 smart contract approval calls.
| from | STRING |
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| approval_address | STRING |
| approval_name | STRING |
| value | STRING |
| amount | STRING |
| approval_all | BOOLEAN |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
call-erc1155
id: growhold.ethereum.call-erc1155ERC-1155 smart contract calls, excluding transfer and approval.
| from | STRING |
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
call-erc1155-transfer
id: growhold.ethereum.call-erc1155-transferERC-1155 smart contract transfer calls.
| from | STRING |
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| to_address | STRING |
| value | STRING |
| amount | STRING |
| value_a | STRING |
| amount_a | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
call-erc1155-approval
id: growhold.ethereum.call-erc1155-approvalERC-1155 smart contract approval calls.
| from | STRING |
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| approval_address | STRING |
| approval_name | STRING |
| value | STRING |
| amount | STRING |
| approval_all | BOOLEAN |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
call-other
id: growhold.ethereum.call-otherDecoded smart contract transaction calls with contract name, call function name and input data.
| from | STRING |
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
event-erc20
id: growhold.ethereum.event-erc20ERC-20 smart contract events, excluding transfer and approval.
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
event-erc20-transfer
id: growhold.ethereum.event-erc20-transferERC-20 smart contract transfer events.
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| from_address | STRING |
| to_address | STRING |
| value | STRING |
| amount | STRING |
| value_a | STRING |
| amount_a | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
event-erc20-approval
id: growhold.ethereum.event-erc20-approvalERC-20 smart contract approval events.
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| owner_address | STRING |
| approved_address | STRING |
| value | STRING |
| amount | STRING |
| approval_all | BOOLEAN |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
event-erc721
id: growhold.ethereum.event-erc721ERC-721 smart contract events, excluding transfer and approval.
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
event-erc721-transfer
id: growhold.ethereum.event-erc721-transferERC-721 smart contract transfer events.
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| from_address | STRING |
| to_address | STRING |
| value | STRING |
| amount | STRING |
| value_a | STRING |
| amount_a | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
event-erc721-approval
id: growhold.ethereum.event-erc721-approvalERC-721 smart contract approval events.
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| owner_address | STRING |
| approved_address | STRING |
| value | STRING |
| amount | STRING |
| approval_all | BOOLEAN |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
event-erc777
id: growhold.ethereum.event-erc777ERC-777 smart contract events, excluding transfer and approval.
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
event-erc777-transfer
id: growhold.ethereum.event-erc777-transferERC-777 smart contract transfer events.
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| from_address | STRING |
| to_address | STRING |
| value | STRING |
| amount | STRING |
| value_a | STRING |
| amount_a | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
event-erc777-approval
id: growhold.ethereum.event-erc777-approvalERC-777 smart contract approval events.
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| owner_address | STRING |
| approved_address | STRING |
| value | STRING |
| amount | STRING |
| approval_all | BOOLEAN |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
event-erc1155
id: growhold.ethereum.event-erc1155ERC-1155 smart contract events, excluding transfer and approval.
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
event-erc1155-transfer
id: growhold.ethereum.event-erc1155-transferERC-1155 smart contract transfer events.
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| from_address | STRING |
| to_address | STRING |
| value | STRING |
| amount | STRING |
| value_a | STRING |
| amount_a | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
event-erc1155-approval
id: growhold.ethereum.event-erc1155-approvalERC-1155 smart contract approval events.
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| owner_address | STRING |
| approved_address | STRING |
| value | STRING |
| amount | STRING |
| approval_all | BOOLEAN |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
event-other
id: growhold.ethereum.event-otherDecoded smart contract log events with contract name, event name and event data.
| contract_address | STRING |
| contract_name | STRING |
| name | STRING |
| data | RECORD |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| transaction_hash | STRING |
| transaction_index | INTEGER |
contract
id: growhold.ethereum.contractContract metadata which can be merged in queries by using address for joins.
| address | STRING |
| name | STRING |
| standard | STRING |
| compiler | STRING |
| evm | STRING |
| license | STRING |
| swarm | STRING |
token
id: growhold.ethereum.tokenToken metadata which can be merged in queries by using address for joins.
| address | STRING |
| standard | STRING |
| name | STRING |
| symbol | STRING |
| decimals | INTEGER |
block
id: growhold.ethereum.blockEthereum blocks. Rarely used in data analytics, but sometimes useful for making queries into gas fees or difficulty.
| number | INTEGER |
| hash | STRING |
| parent_hash | STRING |
| nonce | STRING |
| sha3_uncles | STRING |
| transactions_root | STRING |
| state_root | STRING |
| receipts_root | STRING |
| miner | STRING |
| difficulty | NUMERIC |
| total_difficulty | NUMERIC |
| size | INTEGER |
| extra_data | STRING |
| gas_limit | INTEGER |
| gas_used | INTEGER |
| timestamp | TIMESTAMP |
| transaction_count | INTEGER |
| base_fee_per_gas | INTEGER |
transaction
id: growhold.ethereum.transactionRaw data of transactions, excluding the bytecode of input. Majority of transactions are decoded to 'call' tables.
| hash | STRING |
| block_number | INTEGER |
| transaction_index | INTEGER |
| from_address | STRING |
| to_address | STRING |
| value | NUMERIC |
| gas | INTEGER |
| gas_price | INTEGER |
| block_timestamp | TIMESTAMP |
log
id: growhold.ethereum.logRaw data of smart contract logs, excluding the bytecode of topics. Majority of logs are decoded to 'event' tables.
| log_index | INTEGER |
| transaction_hash | STRING |
| transaction_index | INTEGER |
| block_hash | STRING |
| block_number | INTEGER |
| block_timestamp | TIMESTAMP |
| address | STRING |