Query editor
WITH pool_filter AS (SELECT 0xFa5b5C3DB5945450B678c74263d75F4E65a785fB AS pool_address),liquidity_deltas AS (-- 1. MINTS (Añadir Liquidez)-- Tick INFERIOR: La liquidez entra (+)SELECTtickLower as tick,CAST(amount AS DOUBLE) as deltaFROM pancakeswap_v3_bnb.PancakeV3Pool_evt_Mint, pool_filterWHERE contract_address = pool_addressUNION ALL-- Tick SUPERIOR: La liquidez sale (-)SELECTtickUpper as tick,-1 * CAST(amount AS DOUBLE) as deltaFROM pancakeswap_v3_bnb.PancakeV3Pool_evt_Mint, pool_filterWHERE contract_address = pool_addressUNION ALL-- 2. BURNS (Quitar Liquidez) - ¡AQUÍ ESTÁ LA CLAVE!-- Tick INFERIOR: Se retira liquidez (-)SELECTtickLower as tick,-1 * CAST(amount AS DOUBLE) as deltaFROM pancakeswap_v3_bnb.PancakeV3Pool_evt_Burn, pool_filterWHERE contract_address = pool_addressUNION ALL-- Tick SUPERIOR: Dejamos de retirar.-- Matemáticamente, para "cerrar" el rango de resta, tenemos que SUMAR (+)SELECTtickUpper as tick,CAST(amount AS DOUBLE) as deltaFROM pancakeswap_v3_bnb.PancakeV3Pool_evt_Burn, pool_filterWHERE contract_address = pool_address),tick_cumulatives AS (SELECTtick,SUM(delta) as net_changeFROM liquidity_deltasGROUP BY 1),liquidity_curve AS (SELECTtick,-- Precio normal (USDT per GMT) -> Aprox 0.41/ POWER(1.0001, tick) as price,-- SUMA ACUMULADA: Es obligatoria.-- El contrato no guarda "Liquidez Total = 500" en cada tick.-- Guarda: "Aquí empieza +500" y "Aquí acaba -500".