The text below documents how we retrieve daily liquidity data for stablecoin pools on Uniswap using The Graph’s public subgraph API.
Monitoring total value locked (TVL) in Uniswap pools helps identify stablecoin liquidity shifts that may signal early risk events.
Endpoint:
https://api.thegraph.com/subgraphs/name/uniswap/uniswap-v2
Authentication:
Example Query (GraphQL)
{
pairDayDatas(
first: 1,
orderBy: date,
orderDirection: desc,
where: { pairAddress: "PAIR_CONTRACT_ADDRESS" }
) {
date
reserveUSD
dailyVolumeUSD
}
}
Fields Monitored
Field Purpose
- reserveUSD Current liquidity (TVL) in USD
- dailyVolumeUSD Daily trading volume (optional secondary signal)
Example Response (truncated)
{
"data": {
"pairDayDatas": [
{
"date": 1714003200,
"reserveUSD": "145000000.00",
"dailyVolumeUSD": "5000000.00"
}
]
}
}
- date is in UNIX timestamp format (UTC midnight).
- reserveUSD gives current liquidity.
- dailyVolumeUSD shows daily volume for reference.
Monitoring Criteria
- TVL Drop Flag: If liquidity (reserveUSD) decreases by more than 10% in 24 hours, pool is flagged for review.
- Volume Spike Flag (optional): If dailyVolumeUSD spikes by more than 2x the 7-day average, the pool is flagged.
Rate Limits and Notes
- There are no strict rate limits, but it’s best practice to poll once a day.
- Uniswap V2 Subgraph is static; live updates are reflected with a minor delay (~minutes).
- Stablecoin pools to monitor:
USDC/DAI
USDC/USDT
DAI/USDT
FRAX/USDC
TUSD/USDC
(Pair contract addresses are stored separately in the project database.)
Responses are generated using AI and may contain mistakes.