EVM Dataset
This page describes the datasets available for EVM-compatible chains in Nodit Datashare. You can review the table structure of the stored data, along with the primary key and columns for each table. Use this information to understand the types and structure of data you can extract with Datashare.
EVM Dataset
These are the datasets available for EVM-compatible chains in Nodit Datashare. Select the dataset you need to extract data from. You can view the schema for each dataset in Data Schema.
| Table | Description |
|---|---|
blocks | Block data |
contracts | Contract data |
delegate_contracts | Delegate contract data |
erc1155_holders | ERC-1155 holder data |
erc1155_meta | ERC-1155 metadata |
erc1155_transfers | ERC-1155 transfer data |
erc20_holders | ERC-20 holder data |
erc20_meta | ERC-20 metadata |
erc20_transfers | ERC-20 transfer data |
erc721_holders | ERC-721 holder data |
erc721_inventories | ERC-721 inventory data |
erc721_meta | ERC-721 metadata |
erc721_transfers | ERC-721 transfer data |
logs | Event log data |
logs_decoded | Event log data decoded via 4byte.directory |
receipts | Transaction execution result data |
traces | Transaction trace data |
traces_decoded | Trace data decoded via 4byte.directory |
transactions | Transaction data |
Ethereum Only Dataset
These datasets are available on Ethereum only.
| Table | Description |
|---|---|
token_ohlcv_5m/1h/1d | OHLCV data for tokens in 5m/1h/1d intervals, calculated from Uniswap USDT and USDC trading data |
uniswap_trades | Aggregated trade data across Uniswap v1, v2, and v3 |
uniswap_v1_ethereum_exchange | Uniswap v1 exchange address data |
uniswap_v2_ethereum_exchange | Uniswap v2 exchange address data |
uniswap_v3_ethereum_exchange | Uniswap v3 exchange address data |
withdrawals | Withdrawal data |
Data Schema
The data schema for each table. For each column, you can find the type, description, the table's Unique Key, and the columns that support filtering ("Filterable Columns").
blocks
Unique Key: block_number
Filterable Columns: None
| Column | Type | Description |
|---|---|---|
block_number | INTEGER | The unique number of the block, incrementing sequentially from the genesis block (block 0). |
hash | VARCHAR | The unique identifying hash of the block, provided as a 64-character hexadecimal string prefixed with 0x. |
parent_hash | VARCHAR | The hash of the preceding block (parent block), forming the linked structure of the blockchain. |
nonce | VARCHAR | A value used to prove block validity under proof-of-work (PoW). Returns 0x0000000000000000 after the transition to proof-of-stake (PoS). |
sha3_uncles | VARCHAR | The hash of all uncle blocks included in the block, used for block validation. |
logs_bloom | VARCHAR | A Bloom filter value used to quickly filter event logs from all transactions in the block. |
transactions_root | VARCHAR | The Merkle tree root hash of all transactions included in the block. |
state_root | VARCHAR | The Merkle tree root hash representing the entire account state after processing the block. |
receipts_root | VARCHAR | The Merkle tree root hash of all transaction receipts included in the block. |
miner | VARCHAR | The address of the miner (or validator) who produced the block. |
difficulty | VARCHAR | The block generation difficulty. Returns 0 after the transition to PoS. |
total_difficulty | VARCHAR | The cumulative sum of difficulty from block 0 through the current block. |
size | VARCHAR | The size of the block in bytes. |
extra_data | VARCHAR | Arbitrary data added by the block producer. Returns 0x if no value is present. |
gas_limit | VARCHAR | The maximum amount of gas allowed in the block. The combined gas of all transactions in the block cannot exceed this value. |
gas_used | VARCHAR | The total amount of gas actually consumed by all transactions included in the block. |
block_timestamp | TIMESTAMP(6) | The time at which the block was produced. |
transaction_count | INTEGER | The total number of transactions included in the block. |
mix_hash | VARCHAR | A hash value used to verify block validity under proof-of-work (PoW). |
transactions | ARRAY(VARCHAR) | The list of transaction hashes included in the block. |
log_count | INTEGER | The total number of event logs included in the block. |
base_fee_per_gas | VARCHAR | The base gas fee per unit for the block, introduced in EIP-1559. This fee is burned for each unit of gas consumed in the block. |
withdrawals_root | VARCHAR | The Merkle tree root hash of all validator withdrawals included in the block. |
withdrawal_count | INTEGER | The total number of validator withdrawal transactions included in the block. |
blob_gas_used | VARCHAR | The total amount of gas consumed by Blob data in the block, introduced in EIP-4844. |
excess_blob_gas | VARCHAR | The cumulative amount of gas exceeding the target Blob gas usage, used to calculate the Blob base fee. |
parent_beacon_block_root | VARCHAR | The root hash of the parent beacon block, introduced in EIP-4788. |
requests_hash | VARCHAR | A hash that cryptographically commits to the order and content of all requests in the block. |
contracts
Unique Key: address, block_number
Filterable Columns: address, external_from, internal_from
| Column | Type | Description |
|---|---|---|
address | VARCHAR | The address of the deployed smart contract. |
bytecode | VARCHAR | The executable bytecode of the contract stored on the blockchain. |
function_sighashes | ARRAY(VARCHAR) | The list of 4-byte signature hashes for the functions exposed by the contract. |
block_number | INTEGER | The block number in which the contract was deployed. |
external_from | VARCHAR | The EOA address that deployed the contract via an external transaction. |
internal_from | VARCHAR | The contract address that created this contract via an internal transaction (call). |
transaction_hash | VARCHAR | The hash of the transaction that deployed the contract. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the contract deployment was produced. |
delegate_contracts
Unique Key: address, block_number
Filterable Columns: address, contract_address
| Column | Type | Description |
|---|---|---|
address | VARCHAR | The EOA address that received delegated code via EIP-7702. |
contract_address | VARCHAR | The contract address where the code delegated to the EOA resides. |
transaction_hashes | ARRAY(VARCHAR) | The list of transaction hashes for transactions that performed code delegation. |
block_number | INTEGER | The block number in which the code delegation was detected. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the code delegation was produced. |
erc1155_holders
Unique Key: token_address, address, token_id, block_number
Filterable Columns: token_address, address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the ERC-1155 token contract. |
address | VARCHAR | The address of the account holding the ERC-1155 token. |
token_id | VARCHAR | The unique ID of the held ERC-1155 token. |
value | VARCHAR | The quantity of the specific token ID held by the address. |
transfer_id | VARCHAR | The identifier of the last transfer event that determined this holding state. |
block_number | INTEGER | The block number in which this holding state was recorded. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing this holding state was produced. |
erc1155_meta
Unique Key: token_address, block_number
Filterable Columns: token_address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the ERC-1155 token contract. |
deployer | VARCHAR | The address that deployed the ERC-1155 contract. |
transaction_hash | VARCHAR | The hash of the transaction in which the ERC-1155 contract was deployed. |
name | VARCHAR | The name of the token collection as defined in the contract. |
symbol | VARCHAR | The symbol (ticker) of the token collection as defined in the contract. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the contract deployment was produced. |
block_number | INTEGER | The block number in which the contract was deployed. |
category | INTEGER | A category code indicating the classification of the contract. |
erc1155_transfers
Unique Key: transaction_hash, log_index, batch_index
Filterable Columns: token_address, from_address, to_address, operator
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the transferred ERC-1155 token contract. |
from_address | VARCHAR | The address of the sending account that transferred the token. |
to_address | VARCHAR | The address of the receiving account that received the token. |
token_id | VARCHAR | The unique ID of the transferred ERC-1155 token. |
transaction_hash | VARCHAR | The hash of the transaction in which the transfer occurred. |
log_index | INTEGER | The index of this event log within the transaction. |
batch_index | INTEGER | The index of this transfer within the batch for batch transfers. |
block_number | INTEGER | The block number in which the transfer occurred. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the transfer was produced. |
value | VARCHAR | The quantity of tokens transferred. |
operator | VARCHAR | The address of the operator account that executed the token transfer. |
erc20_holders
Unique Key: token_address, address, block_number
Filterable Columns: token_address, address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the ERC-20 token contract. |
address | VARCHAR | The address of the account holding the ERC-20 token. |
block_number | INTEGER | The block number in which this holding state was recorded. |
value | VARCHAR | The quantity of ERC-20 tokens held by the address. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing this holding state was produced. |
transfer_id | VARCHAR | The identifier of the last transfer event that determined this holding state. |
erc20_meta
Unique Key: token_address, block_number
Filterable Columns: token_address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the ERC-20 token contract. |
deployer | VARCHAR | The address that deployed the ERC-20 contract. |
transaction_hash | VARCHAR | The hash of the transaction in which the ERC-20 contract was deployed. |
name | VARCHAR | The name of the ERC-20 token as defined in the contract. |
symbol | VARCHAR | The symbol (ticker) of the ERC-20 token as defined in the contract. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the contract deployment was produced. |
block_number | INTEGER | The block number in which the contract was deployed. |
total_supply | VARCHAR | The total supply of the ERC-20 token, provided as a decimal string. |
category | INTEGER | A category code indicating the classification of the contract. |
decimals | VARCHAR | The number of decimal places for the ERC-20 token, used when calculating token amounts. |
erc20_transfers
Unique Key: transaction_hash, log_index
Filterable Columns: token_address, from_address, to_address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the transferred ERC-20 token contract. |
from_address | VARCHAR | The address of the sending account that transferred the token. |
to_address | VARCHAR | The address of the receiving account that received the token. |
value | VARCHAR | The quantity of ERC-20 tokens transferred. |
transaction_hash | VARCHAR | The hash of the transaction in which the transfer occurred. |
log_index | INTEGER | The index of this event log within the transaction. |
block_number | INTEGER | The block number in which the transfer occurred. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the transfer was produced. |
erc721_holders
Unique Key: token_address, address, block_number
Filterable Columns: token_address, address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the ERC-721 NFT contract. |
address | VARCHAR | The address of the account holding the ERC-721 NFT. |
block_number | INTEGER | The block number in which this holding state was recorded. |
quantity | VARCHAR | The total quantity of ERC-721 NFTs held by the address. |
transfer_id | VARCHAR | The identifier of the last transfer event that determined this holding state. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing this holding state was produced. |
erc721_inventories
Unique Key: token_address, token_id, block_number
Filterable Columns: token_address, address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the ERC-721 NFT contract. |
address | VARCHAR | The address of the account currently owning the NFT. |
transaction_hash | VARCHAR | The hash of the last transaction that determined this inventory state. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing this inventory state was produced. |
token_id | VARCHAR | The unique token ID of the ERC-721 NFT. |
block_number | INTEGER | The block number in which this inventory state was recorded. |
erc721_meta
Unique Key: token_address, block_number
Filterable Columns: token_address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the ERC-721 NFT contract. |
deployer | VARCHAR | The address that deployed the ERC-721 contract. |
transaction_hash | VARCHAR | The hash of the transaction in which the ERC-721 contract was deployed. |
name | VARCHAR | The name of the NFT collection as defined in the contract. |
symbol | VARCHAR | The symbol (ticker) of the NFT collection as defined in the contract. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the contract deployment was produced. |
block_number | INTEGER | The block number in which the contract was deployed. |
category | INTEGER | A category code indicating the classification of the contract. |
erc721_transfers
Unique Key: transaction_hash, log_index
Filterable Columns: token_address, from_address, to_address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the transferred ERC-721 NFT contract. |
from_address | VARCHAR | The address of the sending account that transferred the NFT. |
to_address | VARCHAR | The address of the receiving account that received the NFT. |
token_id | VARCHAR | The unique token ID of the transferred ERC-721 NFT. |
transaction_hash | VARCHAR | The hash of the transaction in which the transfer occurred. |
log_index | INTEGER | The index of this event log within the transaction. |
block_number | INTEGER | The block number in which the transfer occurred. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the transfer was produced. |
logs
Unique Key: transaction_hash, log_index
Filterable Columns: address
| Column | Type | Description |
|---|---|---|
address | VARCHAR | The address of the contract that emitted the event log. |
topics | ARRAY(VARCHAR) | The list of topics identifying the event. The first entry is the keccak256 hash of the event signature. |
data | VARCHAR | ABI-encoded data containing the non-indexed event parameters. |
block_number | INTEGER | The block number in which the event log was recorded. |
transaction_hash | VARCHAR | The hash of the transaction that emitted the event log. |
block_hash | VARCHAR | The hash of the block containing the event log. |
log_index | INTEGER | The index of this event log within the block. |
removed | BOOLEAN | Indicates whether the log was removed due to a chain reorganization (reorg). |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the event log was produced. |
transaction_index | INTEGER | The index of this transaction within the block. |
logs_decoded
Unique Key: transaction_hash, log_index
Filterable Columns: address
| Column | Type | Description |
|---|---|---|
decode_event | VARCHAR | Information about the event decoded via 4byte.directory. |
signature | VARCHAR | The signature string of the event used for decoding. |
address | VARCHAR | The address of the contract that emitted the decoded event. |
block_number | INTEGER | The block number in which the decoded event log was recorded. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the decoded event log was produced. |
transaction_index | INTEGER | The index of this transaction within the block. |
transaction_hash | VARCHAR | The hash of the transaction that emitted the decoded event. |
log_index | INTEGER | The index of this event log within the transaction. |
receipts
Unique Key: transaction_hash
Filterable Columns: from_address, to_address
| Column | Type | Description |
|---|---|---|
block_hash | VARCHAR | The hash of the block containing this receipt. |
block_number | INTEGER | The block number containing this receipt. |
contract_address | VARCHAR | The address of the contract created if the transaction was a contract deployment; otherwise null. |
cumulative_gas_used | VARCHAR | The cumulative gas used up to and including this transaction within the block. |
effective_gas_price | VARCHAR | The actual gas price per unit applied to the transaction. |
from_address | VARCHAR | The address of the account that sent the transaction. |
gas_used | VARCHAR | The amount of gas actually consumed by this transaction. |
logs_bloom | VARCHAR | A Bloom filter value used to quickly filter event logs emitted by this transaction. |
status | VARCHAR | The execution result of the transaction: success (1) or failure (0). |
to_address | VARCHAR | The address of the receiving account or the called contract. |
transaction_hash | VARCHAR | The hash of the transaction corresponding to this receipt. |
transaction_index | INTEGER | The index of this transaction within the block. |
type | VARCHAR | The transaction type as defined by EIP-2718. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the transaction was produced. |
revert_reason | VARCHAR | The revert reason string returned by the contract when the transaction fails. |
error | VARCHAR | Detailed information about the error that occurred during transaction execution. |
root | VARCHAR | The state root hash used in pre-EIP-658 transactions. |
blob_gas_price | VARCHAR | The gas price per unit for Blob data, introduced in EIP-4844. |
blob_gas_used | VARCHAR | The amount of gas consumed by the Blob data in this transaction. |
traces
Unique Key: trace_id
Filterable Columns: from_address, to_address
| Column | Type | Description |
|---|---|---|
trace_id | VARCHAR | The unique identifier for this trace. |
block_hash | VARCHAR | The hash of the block containing this trace. |
block_number | INTEGER | The block number containing this trace. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing this trace was produced. |
transaction_index | INTEGER | The index of this transaction within the block. |
transaction_hash | VARCHAR | The hash of the transaction to which this trace belongs. |
from_address | VARCHAR | The address of the account or contract that initiated the call. |
to_address | VARCHAR | The address of the account or contract that received the call. |
value | VARCHAR | The amount of ETH transferred in this call, provided as a decimal string. |
input | VARCHAR | The input data passed to the call, containing ABI-encoded function call information. |
output | VARCHAR | The output data returned as a result of the call. |
trace_type | VARCHAR | The type of trace: call, create, suicide, reward, and others. |
call_type | VARCHAR | The specific call subtype when trace_type is call: call, delegatecall, staticcall, and others. |
gas | VARCHAR | The amount of gas allocated to this call. |
gas_used | VARCHAR | The amount of gas actually consumed by this call. |
subtraces | INTEGER | The number of sub-traces generated by this trace. |
trace_address | ARRAY(INTEGER) | An array indicating the position of this trace in the trace tree within the transaction. |
error | VARCHAR | Information about the error that occurred during call execution. |
status | VARCHAR | The execution result of this trace: success (1) or failure (0). |
revert_reason | VARCHAR | The revert reason string returned by the contract when execution fails. |
reward_type | VARCHAR | The type of reward (block reward, uncle reward, etc.) when trace_type is reward. |
traces_decoded
Unique Key: trace_id
Filterable Columns: from_address, to_address
| Column | Type | Description |
|---|---|---|
decode_trace | VARCHAR | Information about the trace function call decoded via 4byte.directory. |
decode_tx | VARCHAR | Information about the transaction function call decoded via 4byte.directory. |
signature | VARCHAR | The signature string of the function used for decoding. |
trace_id | VARCHAR | The unique identifier for this decoded trace. |
block_number | INTEGER | The block number containing the decoded trace. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the decoded trace was produced. |
transaction_index | INTEGER | The index of this transaction within the block. |
transaction_hash | VARCHAR | The hash of the transaction to which the decoded trace belongs. |
from_address | VARCHAR | The address of the account or contract that initiated the call. |
to_address | VARCHAR | The address of the account or contract that received the call. |
value | VARCHAR | The amount of ETH transferred in this call, provided as a decimal string. |
trace_address | ARRAY(INTEGER) | An array indicating the position of this trace in the trace tree within the transaction. |
transactions
Unique Key: hash
Filterable Columns: from_address, to_address
| Column | Type | Description |
|---|---|---|
hash | VARCHAR | The unique identifying hash of the transaction, provided as a 64-character hexadecimal string prefixed with 0x. |
nonce | VARCHAR | The nonce value that prevents duplicate transactions from the same address and determines execution order. |
block_hash | VARCHAR | The hash of the block containing this transaction. |
block_number | INTEGER | The block number containing this transaction. |
transaction_index | INTEGER | The index of this transaction within the block. |
from_address | VARCHAR | The address of the account that sent the transaction. |
to_address | VARCHAR | The address of the receiving account or the called contract. |
value | VARCHAR | The amount of ETH transferred in this transaction, provided as a decimal string. |
gas | VARCHAR | The maximum amount of gas provided by the sender for executing the transaction. |
gas_price | VARCHAR | The gas price per unit proposed by the sender, used in legacy transactions. |
input | VARCHAR | ABI-encoded input data containing contract function call information. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing this transaction was produced. |
type | VARCHAR | The transaction type as defined by EIP-2718. |
max_priority_fee_per_gas | VARCHAR | The maximum tip per unit of gas paid to the miner (validator), introduced in EIP-1559. |
max_fee_per_gas | VARCHAR | The maximum gas price per unit the sender is willing to pay, introduced in EIP-1559. |
access_list | ARRAY(ROW(storage_keys ARRAY(VARCHAR), address VARCHAR)) | A pre-declared list of storage addresses and keys the transaction will access, introduced in EIP-2930. |
max_fee_per_blob_gas | VARCHAR | The maximum gas price per unit for Blob data the sender is willing to pay, introduced in EIP-4844. |
blob_versioned_hashes | VARCHAR | The list of versioned hashes for the Blob data attached to the transaction, introduced in EIP-4844. |
authorization_list | ARRAY(ROW(chain_id VARCHAR, nonce VARCHAR, address VARCHAR, y_parity VARCHAR, r VARCHAR, s VARCHAR)) | A list containing signature and authorization information for the transaction, introduced in EIP-7702. |
withdrawals
Ethereum Only
Unique Key: index
Filterable Columns: None
| Column | Type | Description |
|---|---|---|
index | INTEGER | The unique sequential index of this withdrawal among all withdrawal transactions. |
validator_index | INTEGER | The unique index of the validator that requested the withdrawal. |
recipient | VARCHAR | The address of the account that receives the withdrawn ETH. |
amount | VARCHAR | The amount of ETH withdrawn, provided in Gwei. |
block_number | INTEGER | The block number containing this withdrawal. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing this withdrawal was produced. |
uniswap_trades
Ethereum Only
Unique Key: transaction_hash, log_index
Filterable Columns: sender, recipient, bought_token_address, sold_token_address, project_contract_address
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP(6) | The time at which the block containing the trade was produced. |
transaction_hash | VARCHAR | The hash of the transaction containing the trade. |
log_index | INTEGER | The index of this trade event log within the transaction. |
sender | VARCHAR | The address of the account that requested the swap. |
recipient | VARCHAR | The address of the account that received the tokens as a result of the swap. |
bought_token_amount | VARCHAR | The quantity of tokens purchased in this trade. |
sold_token_amount | VARCHAR | The quantity of tokens sold in this trade. |
bought_token_address | VARCHAR | The contract address of the purchased token. |
sold_token_address | VARCHAR | The contract address of the sold token. |
project_contract_address | VARCHAR | The address of the Uniswap pool or exchange contract where this trade occurred. |
uniswap_ver | VARCHAR | The version of Uniswap (v1, v2, v3) in which this trade occurred. |
uniswap_v1_ethereum_exchange
Ethereum Only
Unique Key: exchange
Filterable Columns: exchange, token
| Column | Type | Description |
|---|---|---|
exchange | VARCHAR | The contract address of the Uniswap v1 exchange. |
contract_address | VARCHAR | The address of the Uniswap v1 Factory contract that created the exchange. |
transaction_hash | VARCHAR | The hash of the transaction in which the exchange contract was registered. |
log_index | INTEGER | The index of the exchange registration event log within the transaction. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the exchange registration was produced. |
block_number | INTEGER | The block number in which the exchange was registered. |
token | VARCHAR | The contract address of the ERC-20 token traded on this exchange. |
uniswap_v2_ethereum_exchange
Ethereum Only
Unique Key: pair
Filterable Columns: pair, token0, token1
| Column | Type | Description |
|---|---|---|
pair | VARCHAR | The contract address of the Uniswap v2 token pair (pool). |
contract_address | VARCHAR | The address of the Uniswap v2 Factory contract that created this pair. |
transaction_hash | VARCHAR | The hash of the transaction in which the pair contract was created. |
log_index | INTEGER | The index of the pair creation event log within the transaction. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the pair contract creation was produced. |
block_number | INTEGER | The block number in which the pair contract was created. |
_0 | VARCHAR | The value of the _0 field from the original event data. |
token0 | VARCHAR | The contract address of the first ERC-20 token in the pair. |
token1 | VARCHAR | The contract address of the second ERC-20 token in the pair. |
uniswap_v3_ethereum_exchange
Ethereum Only
Unique Key: pool
Filterable Columns: pool, token0, token1
| Column | Type | Description |
|---|---|---|
pool | VARCHAR | The contract address of the Uniswap v3 liquidity pool. |
contract_address | VARCHAR | The address of the Uniswap v3 Factory contract that created this pool. |
transaction_hash | VARCHAR | The hash of the transaction in which the pool contract was created. |
log_index | INTEGER | The index of the pool creation event log within the transaction. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the pool contract creation was produced. |
block_number | INTEGER | The block number in which the pool contract was created. |
fee | VARCHAR | The fee rate applied to this pool, in units of 1 ppm (1/1,000,000). |
tick_spacing | VARCHAR | The tick spacing value used to configure price ranges in the Uniswap v3 pool. |
token0 | VARCHAR | The contract address of the first ERC-20 token in the pool. |
token1 | VARCHAR | The contract address of the second ERC-20 token in the pool. |
token_ohlcv_5m
Ethereum Only
Unique Key: bucket, base_token_address, quote
Filterable Columns: base_token_address
| Column | Type | Description |
|---|---|---|
partition_day | DATE | A date value used for partition pruning to optimize query performance. |
bucket | TIMESTAMP(6) | The start time of the 5-minute OHLCV interval. |
base_token_address | VARCHAR | The contract address of the base token whose price is aggregated. |
base_symbol | VARCHAR | The symbol (ticker) of the base token. |
quote | VARCHAR | The address of the quote token used to express the base token price. |
open | DOUBLE | The base token price at the start of the bucket (open). |
high | DOUBLE | The highest base token price within the bucket (high). |
low | DOUBLE | The lowest base token price within the bucket (low). |
close | DOUBLE | The base token price at the end of the bucket (close). |
volume | DOUBLE | The total trading volume of the base token within the bucket. |
quote_volume | DOUBLE | The total trading volume denominated in the quote token within the bucket. |
trade_count | BIGINT | The total number of trades (swaps) that occurred within the bucket. |
token_ohlcv_1h
Ethereum Only
Unique Key: bucket, base_token_address, quote
Filterable Columns: base_token_address
| Column | Type | Description |
|---|---|---|
partition_day | DATE | A date value used for partition pruning to optimize query performance. |
bucket | TIMESTAMP(6) | The start time of the 1-hour OHLCV interval. |
base_token_address | VARCHAR | The contract address of the base token whose price is aggregated. |
base_symbol | VARCHAR | The symbol (ticker) of the base token. |
quote | VARCHAR | The address of the quote token used to express the base token price. |
open | DOUBLE | The base token price at the start of the bucket (open). |
high | DOUBLE | The highest base token price within the bucket (high). |
low | DOUBLE | The lowest base token price within the bucket (low). |
close | DOUBLE | The base token price at the end of the bucket (close). |
volume | DOUBLE | The total trading volume of the base token within the bucket. |
quote_volume | DOUBLE | The total trading volume denominated in the quote token within the bucket. |
trade_count | BIGINT | The total number of trades (swaps) that occurred within the bucket. |
token_ohlcv_1d
Ethereum Only
Unique Key: bucket, base_token_address, quote
Filterable Columns: base_token_address
| Column | Type | Description |
|---|---|---|
partition_day | DATE | A date value used for partition pruning to optimize query performance. |
bucket | TIMESTAMP(6) | The start time of the 1-day OHLCV interval. |
base_token_address | VARCHAR | The contract address of the base token whose price is aggregated. |
base_symbol | VARCHAR | The symbol (ticker) of the base token. |
quote | VARCHAR | The address of the quote token used to express the base token price. |
open | DOUBLE | The base token price at the start of the bucket (open). |
high | DOUBLE | The highest base token price within the bucket (high). |
low | DOUBLE | The lowest base token price within the bucket (low). |
close | DOUBLE | The base token price at the end of the bucket (close). |
volume | DOUBLE | The total trading volume of the base token within the bucket. |
quote_volume | DOUBLE | The total trading volume denominated in the quote token within the bucket. |
trade_count | BIGINT | The total number of trades (swaps) that occurred within the bucket. |