The goal of this query is to get an average usd size of liquidity adds and removes from a dex pool.

Liquidity actions are filtered for those with a USD amount over $100k to only get high $ value transactions.

My expectation before running the query is that the top pools pools will have 2 majors tokens (SOL, USDC, any LST's and probably a few high mktCap memes)

The top 10 pools show unexpected results.

SOL-jitoSOL, Trump-USDT/SOL are normal

PepeAI-SOL with an average of $997M and #1 looks strange, so let's copy the pool address and search for it in Solscan

https://solscan.io/account/6YQX6FZANbJ6noxry6twhJy3GDN4z1oNN2SdoifvDrMA

The pool TVL is only $326

2 theories:

1. all liquidity was recently removed

2. There might be some incorrect price data

Let's filter solana.defi.ez_liquidity_pool_actions actions for only this pool and see what we get.

Only 2 actions for the pepeAI-SOL pool and one of them has a value of $1.99 BILLIONS

The SOL $ value seems sensible.

So something must be wrong with the pepeAI price

Let's fetch pepeAI price from the solana.price.ez_prices_hourly

The solana.defi.ez_liquidity_pool_actions price is in-line with the price in the ez_prices_hourly

Was pepeAI ever close to this price?

Searching birdeye for the pepeAI token address B4afKumM2AkrrZZbia94bzrKdxTHp1iv7QgPNp611kiA we can see that price was nowhere near $0.000242

Price in the tables is 6 orders of magnitude higher than the mid price in January 2th

Results must be looked at critically in order to debug these kind of erroneous data.

Always double check your results with other data sources.

Everything written in this dashboard is meant as positive criticism

I have also fallen to these kind of errors by blindly accepting results of my own queries

Always double-check your results with other open sources