LP Actions

Every time a position has a decrease or increase liquidity event recorded on the pool a new record is appended to the uniswapv3.lp_actions table.

We retrieve the below results via:

select 
    tx_id, 
    action,
    block_timestamp, 
    amount0_usd + amount1_usd as total_usd
from uniswapv3.lp_actions where pool_address = '0xa6f253d4894e0cbb68679816cfee647eec999964' 
order by block_timestamp desc;

Note: TVL cannot be computed from this table. Swap events change TVL. The most accurate method is to query pool stats as we do above. Since pool stats relies on actual reads from the node it is guaranteed to be 100% accurate.

TVL

In the chart below we retrieve TVL by querying the uniswapv3.pool_stats table. Every time an event occurs on a pool a number of stats are read from the contract, including the balance of each token.

SELECT 
    block_id, 
    block_timestamp,
    token0_balance_usd + token1_balance_usd as tvl
FROM uniswapv3.pool_stats 
WHERE pool_address = '0xa6f253d4894e0cbb68679816cfee647eec999964' 
ORDER BY block_id DESC