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-native

Native Ethereum transfers with transfer time's USD price.

token_addressSTRING
from_addressSTRING
to_addressSTRING
token_nameSTRING
token_symbolSTRING
usd_valueBIGNUMERIC
token_valueBIGNUMERIC
valueSTRING
transaction_hashSTRING
log_indexINTEGER
block_numberINTEGER
block_timestampTIMESTAMP

transfer-erc20

id: growhold.ethereum.transfer-erc20

ERC-20 token transfers with USD price synced from Coingecko

token_addressSTRING
from_addressSTRING
to_addressSTRING
token_nameSTRING
token_symbolSTRING
usd_valueBIGNUMERIC
token_valueBIGNUMERIC
valueSTRING
transaction_hashSTRING
log_indexINTEGER
block_numberINTEGER
block_timestampTIMESTAMP

transfer-erc721

id: growhold.ethereum.transfer-erc721

ERC-721 token transfers

token_addressSTRING
from_addressSTRING
to_addressSTRING
token_nameSTRING
token_symbolSTRING
usd_valueBIGNUMERIC
token_valueBIGNUMERIC
valueSTRING
transaction_hashSTRING
log_indexINTEGER
block_numberINTEGER
block_timestampTIMESTAMP

transfer-erc777

id: growhold.ethereum.transfer-erc777

ERC-777 token transfers

token_addressSTRING
from_addressSTRING
to_addressSTRING
token_nameSTRING
token_symbolSTRING
usd_valueBIGNUMERIC
token_valueBIGNUMERIC
valueSTRING
transaction_hashSTRING
log_indexINTEGER
block_numberINTEGER
block_timestampTIMESTAMP

transfer-erc1155

id: growhold.ethereum.transfer-erc1155

ERC-1155 token transfers

token_addressSTRING
from_addressSTRING
to_addressSTRING
token_nameSTRING
token_symbolSTRING
usd_valueBIGNUMERIC
token_valueBIGNUMERIC
valueSTRING
transaction_hashSTRING
log_indexINTEGER
block_numberINTEGER
block_timestampTIMESTAMP

transfer-other

id: growhold.ethereum.transfer-other

Other than ERC-20, ERC-721, ERC-777 or ERC-1155 transfers.

token_addressSTRING
from_addressSTRING
to_addressSTRING
token_nameSTRING
token_symbolSTRING
usd_valueBIGNUMERIC
token_valueBIGNUMERIC
valueSTRING
transaction_hashSTRING
log_indexINTEGER
block_numberINTEGER
block_timestampTIMESTAMP

call-erc20

id: growhold.ethereum.call-erc20

ERC-20 smart contract calls, excluding transfer and approval.

fromSTRING
contract_addressSTRING
contract_nameSTRING
nameSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

call-erc20-transfer

id: growhold.ethereum.call-erc20-transfer

ERC-20 smart contract transfer calls.

fromSTRING
contract_addressSTRING
contract_nameSTRING
nameSTRING
to_addressSTRING
valueSTRING
amountSTRING
value_aSTRING
amount_aSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

call-erc20-approval

id: growhold.ethereum.call-erc20-approval

ERC-20 smart contract approval calls.

fromSTRING
contract_addressSTRING
contract_nameSTRING
nameSTRING
approval_addressSTRING
approval_nameSTRING
valueSTRING
amountSTRING
approval_allBOOLEAN
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

call-erc721

id: growhold.ethereum.call-erc721

ERC-721 smart contract calls, excluding transfer and approval.

fromSTRING
contract_addressSTRING
contract_nameSTRING
nameSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

call-erc721-transfer

id: growhold.ethereum.call-erc721-transfer

ERC-721 smart contract transfer calls.

fromSTRING
contract_addressSTRING
contract_nameSTRING
nameSTRING
to_addressSTRING
valueSTRING
amountSTRING
value_aSTRING
amount_aSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

call-erc721-approval

id: growhold.ethereum.call-erc721-approval

ERC-721 smart contract approval calls.

fromSTRING
contract_addressSTRING
contract_nameSTRING
nameSTRING
approval_addressSTRING
approval_nameSTRING
valueSTRING
amountSTRING
approval_allBOOLEAN
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

call-erc777

id: growhold.ethereum.call-erc777

ERC-777 smart contract calls, excluding transfer and approval.

fromSTRING
contract_addressSTRING
contract_nameSTRING
nameSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

call-erc777-transfer

id: growhold.ethereum.call-erc777-transfer

ERC-777 smart contract transfer calls.

fromSTRING
contract_addressSTRING
contract_nameSTRING
nameSTRING
to_addressSTRING
valueSTRING
amountSTRING
value_aSTRING
amount_aSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

call-erc777-approval

id: growhold.ethereum.call-erc777-approval

ERC-777 smart contract approval calls.

fromSTRING
contract_addressSTRING
contract_nameSTRING
nameSTRING
approval_addressSTRING
approval_nameSTRING
valueSTRING
amountSTRING
approval_allBOOLEAN
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

call-erc1155

id: growhold.ethereum.call-erc1155

ERC-1155 smart contract calls, excluding transfer and approval.

fromSTRING
contract_addressSTRING
contract_nameSTRING
nameSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

call-erc1155-transfer

id: growhold.ethereum.call-erc1155-transfer

ERC-1155 smart contract transfer calls.

fromSTRING
contract_addressSTRING
contract_nameSTRING
nameSTRING
to_addressSTRING
valueSTRING
amountSTRING
value_aSTRING
amount_aSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

call-erc1155-approval

id: growhold.ethereum.call-erc1155-approval

ERC-1155 smart contract approval calls.

fromSTRING
contract_addressSTRING
contract_nameSTRING
nameSTRING
approval_addressSTRING
approval_nameSTRING
valueSTRING
amountSTRING
approval_allBOOLEAN
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

call-other

id: growhold.ethereum.call-other

Decoded smart contract transaction calls with contract name, call function name and input data.

fromSTRING
contract_addressSTRING
contract_nameSTRING
nameSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

event-erc20

id: growhold.ethereum.event-erc20

ERC-20 smart contract events, excluding transfer and approval.

contract_addressSTRING
contract_nameSTRING
nameSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

event-erc20-transfer

id: growhold.ethereum.event-erc20-transfer

ERC-20 smart contract transfer events.

contract_addressSTRING
contract_nameSTRING
nameSTRING
from_addressSTRING
to_addressSTRING
valueSTRING
amountSTRING
value_aSTRING
amount_aSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

event-erc20-approval

id: growhold.ethereum.event-erc20-approval

ERC-20 smart contract approval events.

contract_addressSTRING
contract_nameSTRING
nameSTRING
owner_addressSTRING
approved_addressSTRING
valueSTRING
amountSTRING
approval_allBOOLEAN
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

event-erc721

id: growhold.ethereum.event-erc721

ERC-721 smart contract events, excluding transfer and approval.

contract_addressSTRING
contract_nameSTRING
nameSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

event-erc721-transfer

id: growhold.ethereum.event-erc721-transfer

ERC-721 smart contract transfer events.

contract_addressSTRING
contract_nameSTRING
nameSTRING
from_addressSTRING
to_addressSTRING
valueSTRING
amountSTRING
value_aSTRING
amount_aSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

event-erc721-approval

id: growhold.ethereum.event-erc721-approval

ERC-721 smart contract approval events.

contract_addressSTRING
contract_nameSTRING
nameSTRING
owner_addressSTRING
approved_addressSTRING
valueSTRING
amountSTRING
approval_allBOOLEAN
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

event-erc777

id: growhold.ethereum.event-erc777

ERC-777 smart contract events, excluding transfer and approval.

contract_addressSTRING
contract_nameSTRING
nameSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

event-erc777-transfer

id: growhold.ethereum.event-erc777-transfer

ERC-777 smart contract transfer events.

contract_addressSTRING
contract_nameSTRING
nameSTRING
from_addressSTRING
to_addressSTRING
valueSTRING
amountSTRING
value_aSTRING
amount_aSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

event-erc777-approval

id: growhold.ethereum.event-erc777-approval

ERC-777 smart contract approval events.

contract_addressSTRING
contract_nameSTRING
nameSTRING
owner_addressSTRING
approved_addressSTRING
valueSTRING
amountSTRING
approval_allBOOLEAN
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

event-erc1155

id: growhold.ethereum.event-erc1155

ERC-1155 smart contract events, excluding transfer and approval.

contract_addressSTRING
contract_nameSTRING
nameSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

event-erc1155-transfer

id: growhold.ethereum.event-erc1155-transfer

ERC-1155 smart contract transfer events.

contract_addressSTRING
contract_nameSTRING
nameSTRING
from_addressSTRING
to_addressSTRING
valueSTRING
amountSTRING
value_aSTRING
amount_aSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

event-erc1155-approval

id: growhold.ethereum.event-erc1155-approval

ERC-1155 smart contract approval events.

contract_addressSTRING
contract_nameSTRING
nameSTRING
owner_addressSTRING
approved_addressSTRING
valueSTRING
amountSTRING
approval_allBOOLEAN
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

event-other

id: growhold.ethereum.event-other

Decoded smart contract log events with contract name, event name and event data.

contract_addressSTRING
contract_nameSTRING
nameSTRING
dataRECORD
block_numberINTEGER
block_timestampTIMESTAMP
transaction_hashSTRING
transaction_indexINTEGER

contract

id: growhold.ethereum.contract

Contract metadata which can be merged in queries by using address for joins.

addressSTRING
nameSTRING
standardSTRING
compilerSTRING
evmSTRING
licenseSTRING
swarmSTRING

token

id: growhold.ethereum.token

Token metadata which can be merged in queries by using address for joins.

addressSTRING
standardSTRING
nameSTRING
symbolSTRING
decimalsINTEGER

block

id: growhold.ethereum.block

Ethereum blocks. Rarely used in data analytics, but sometimes useful for making queries into gas fees or difficulty.

numberINTEGER
hashSTRING
parent_hashSTRING
nonceSTRING
sha3_unclesSTRING
transactions_rootSTRING
state_rootSTRING
receipts_rootSTRING
minerSTRING
difficultyNUMERIC
total_difficultyNUMERIC
sizeINTEGER
extra_dataSTRING
gas_limitINTEGER
gas_usedINTEGER
timestampTIMESTAMP
transaction_countINTEGER
base_fee_per_gasINTEGER

transaction

id: growhold.ethereum.transaction

Raw data of transactions, excluding the bytecode of input. Majority of transactions are decoded to 'call' tables.

hashSTRING
block_numberINTEGER
transaction_indexINTEGER
from_addressSTRING
to_addressSTRING
valueNUMERIC
gasINTEGER
gas_priceINTEGER
block_timestampTIMESTAMP

log

id: growhold.ethereum.log

Raw data of smart contract logs, excluding the bytecode of topics. Majority of logs are decoded to 'event' tables.

log_indexINTEGER
transaction_hashSTRING
transaction_indexINTEGER
block_hashSTRING
block_numberINTEGER
block_timestampTIMESTAMP
addressSTRING
 
  • © 2022 Growhold, Inc.