Skip to main content

TokenHourData

Entities capturing the hourly metrics for a token across all of Uniswap.

Schema

FieldTypederivedFromDescription
idID!TokenHourData Entity ID. Format: <token address>-<Timestamp rounded to the hour by dividing by 3600>
periodStartUnixInt!Timestamp rounded to the hour by dividing by 3600
tokenToken!Token Entity for which the hourly metric were recorded
volumeBigDecimal!Hourly swap volume of the token
volumeUSDBigDecimal!Hourly swap volume of the token in derived USD
untrackedVolumeUSDBigDecimal!Hourly swap volume of the token in derived USD (including in pools with tokens with unreliable USD value)
totalValueLockedBigDecimal!Liquidity across all pools in token units at the end of the hour
totalValueLockedUSDBigDecimal!Total value of liquidity across all pools in token units in derived USD at the end of the hour
priceUSDBigDecimal!Price of token in USD at the end of the hour
feesUSDBigDecimal!Total Fee Collected in derived USD at the end of the hour
openBigDecimal!Open Price of the token
highBigDecimal!High Price of the token
lowBigDecimal!Low Price of the token
closeBigDecimal!Close Price of the token

Referencing Functions

FunctionNameCreateReadUpdateSave
updateTokenHourData()