Skip to main content

PoolDayData

Entity to store the daily metrics for each pool.

Schema

FieldTypederivedFromDescriptionField Missing
idID!PoolDayData Entity ID. Format: <pool.address>-<Timestamp rounded to current day by dividing by 86400>
dateInt!Timestamp rounded to hour by dividing by 86400
poolPool!Pool Entity for which the daily metrics are tracked
liquidityBigInt!In range Liquidity at the end of the day
sqrtPriceBigInt!Pool Price at the end of the day
token0PriceBigDecimal!Price of token0 in terms of token1 at the end of the day
token1PriceBigDecimal!Price of token1 in terms of token0 at the end of the day
tickBigIntActice Tick at the end of the day
feeGrowthGlobal0X128BigInt!Global Fee Marker Value for token0 at the end of the dayarbitrum-one
feeGrowthGlobal1X128BigInt!Global Fee Marker Value for token1 at the end of the dayarbitrum-one
tvlUSDBigDecimal!TVL available at the end of the day derived in USD
volumeToken0BigDecimal!Total daily volume in token0
volumeToken1BigDecimal!Total daily volume in token1
volumeUSDBigDecimal!Total daily volume in USD
feesUSDBigDecimal!Total swap fee taken during the day in terms of USD
txCountBigInt!No. of transactions in pool executed during the day
openBigDecimal!Open Price of token0
highBigDecimal!High Price of token0
lowBigDecimal!Low Price of token0
closeBigDecimal!Close Price of token0

Referencing Functions

FunctionNameCreateReadUpdateSave
updatePoolDayData()
handleSwap()