eth.uniswap_v2.pool_stats

SQL table schema for eth.uniswap_v2.pool_stats

Ethereum Uniswap-V2 Pool stats (reserves, etc) for each block.

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.
reserve0	DOUBLE	The amount of liquidity of the first token staked in this pool. Provided as a convenience, but may overflow.
reserve0_hex	CHARACTER VARYING	Lossless encoding of the full reserve0 value as a hexadecimal string.
reserve1	DOUBLE	The amount of liquidity of the second token staked in this pool. Provided as a convenience, but may overflow.
reserve1_hex	CHARACTER VARYING	Lossless encoding of the full reserve1 value as a hexadecimal string.
block_timestamp_last	BIGINT	The timestamp of the last block that updated this pool.
price0_cumulative_last	CHARACTER VARYING	The last cumulative price of the first token, as reported by the contract.
price1_cumulative_last	CHARACTER VARYING	The last cumulative price of the second token, as reported by the contract.
total_supply_hex	CHARACTER VARYING	The total supply of liquidity tokens for this pool, encoded as a hexadecimal string.
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.