eth.uniswap_v2.pool_stats_detailed

SQL table schema for eth.uniswap_v2.pool_stats_detailed

Ethereum Uniswap-V2 join between pools and pool_stats.

Column NameData TypeDescription

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.

Last updated