eth.uniswap_v2.pool_stats_detailed
SQL table schema for eth.uniswap_v2.pool_stats_detailed
Last updated
SQL table schema for eth.uniswap_v2.pool_stats_detailed
Last updated
Ethereum Uniswap-V2 join between pools and pool_stats.
Column Name | Data Type | Description |
---|---|---|
block_number
BIGINT
The number of the block at which these stats were calculated.
pool_address
CHARACTER VARYING
The address of the contract that defines this pool.
token0_symbol
CHARACTER VARYING
The human-readable symbol name for the first token in the pool, eg. "WETH".
token1_symbol
CHARACTER VARYING
The contract address that defines the second token in the pool.
reserve0
DOUBLE
The amount of liquidity of the first token staked in this pool.
Provided as a convenience, but may overflow.
reserve1
DOUBLE
The amount of liquidity of the second token staked in this pool.
Provided as a convenience, but may overflow.
price0
DOUBLE
The price of the first token in this pool: reserve0 / reserve1
.
price1
DOUBLE
The price of the second token in this pool: reserve1 / reserve0
.
total_supply_hex
CHARACTER VARYING
The total supply of liquidity tokens for this pool, encoded as a hexadecimal string.
token0_id
CHARACTER VARYING
The contract address that defines the first token in the pool.
token1_id
CHARACTER VARYING
The contract address that defines the second token in the pool.
block_timestamp_last
BIGINT
The timestamp of the last block that updated this pool.