DATASET bigquery-public-data DB crypto_ethereum - quickdatabasediagrams

bigquery-public-data.crypto_ethereum.blocks.QDD

"bigquery-public-data.crypto_ethereum.balances" as Bal
-
address STRING
eth_balance NUMERIC

"bigquery-public-data.crypto_ethereum.blocks" as B
--
column_name data_type
timestamp TIMESTAMP
number INT64
hash STRING
parent_hash STRING
nonce STRING
sha3_uncles STRING
logs_bloom STRING
transactions_root STRING
state_root STRING
receipts_root STRING
miner STRING
difficulty NUMERIC
total_difficulty NUMERIC
size INT64
extra_data STRING
gas_limit INT64
gas_used INT64
transaction_count INT64


"bigquery-public-data.crypto_ethereum.contracts" as C
---
address STRING
bytecode STRING
function_sighashes ARRAY<STRING>
is_erc20 BOOL
is_erc721 BOOL
block_timestamp TIMESTAMP
block_number INT64
block_hash STRING

"bigquery-public-data.crypto_ethereum.logs" as L
----
log_index INT64
transaction_hash STRING
transaction_index INT64
address STRING
data STRING
topics ARRAY<STRING>
block_timestamp TIMESTAMP
block_number INT64
block_hash STRING

"bigquery-public-data.crypto_ethereum.token_transfers" as TokTran
-----
token_address STRING
from_address STRING
to_address STRING
value STRING
transaction_hash STRING
log_index INT64
block_timestamp TIMESTAMP
block_number INT64
block_hash STRING

"bigquery-public-data.crypto_ethereum.tokens" as Tok
------
column_name data_type
address STRING
symbol STRING
name STRING
decimals STRING
total_supply STRING
block_timestamp TIMESTAMP
block_number INT64
block_hash STRING


"bigquery-public-data.crypto_ethereum.traces" as Trace
-------
column_name data_type
transaction_hash STRING
transaction_index INT64
from_address STRING
to_address STRING
value NUMERIC
input STRING
output STRING
trace_type STRING
call_type STRING
reward_type STRING
gas INT64
gas_used INT64
subtraces INT64
trace_address STRING
error STRING
status INT64
block_timestamp TIMESTAMP
block_number INT64
block_hash STRING
trace_id STRING

"bigquery-public-data.crypto_ethereum.transactions" as Tran
--------
hash STRING 
nonce INT64
transaction_index INT64
from_address STRING
to_address STRING
value NUMERIC
gas INT64
gas_price INT64
input STRING
receipt_cumulative_gas_used INT64
receipt_gas_used INT64
receipt_contract_address STRING
receipt_root STRING
receipt_status INT64
block_timestamp TIMESTAMP
block_number INT64
block_hash STRING