Query editor
/** ==================================================================================* SECTION 1: CONFIGURATION & PARAMETERS* Setup the target pool and decimals here.* ==================================================================================*/WITH config AS (SELECT{{pool_address}} AS pool_address,-- Token used for the price reference (e.g., WETH address)-- We need this to look up the vertical line price later0x4200000000000000000000000000000000000006 AS quote_token_address,18 AS decimals_token0,18 AS decimals_token1),/** ==================================================================================* SECTION 2: DATA INGESTION (THE "VIEW" LAYER)* ERROR FIX: Added CAST(amount AS DOUBLE) to prevent UINT256 overflow errors* ==================================================================================*/raw_logs AS (-- >>>> ADAPTER: UNISWAP V3 OPTIMISM <<<<SELECT tickLower, tickUpper, CAST(amount AS DOUBLE) AS amount, 1 AS signFROM uniswap_v3_optimism.uniswapv3pool_call_mintWHERE call_success AND contract_address = (SELECT pool_address FROM config)UNION ALLSELECT tickLower, tickUpper, CAST(amount AS DOUBLE) AS amount, -1 AS signFROM uniswap_v3_optimism.uniswapv3pool_call_burnWHERE call_success AND contract_address = (SELECT pool_address FROM config)/*-- >>>> ADAPTER: VELODROME SLIPSTREAM <<<<SELECT tickLower, tickUpper, CAST(amount AS DOUBLE) AS amount, 1 AS signFROM velodrome_v2_multichain.clpool_call_mintWHERE call_success AND contract_address = (SELECT pool_address FROM config)UNION ALLSELECT tickLower, tickUpper, CAST(amount AS DOUBLE) AS amount, -1 AS signFROM velodrome_v2_multichain.clpool_call_burnWHERE call_success AND contract_address = (SELECT pool_address FROM config)*/),/** ==================================================================================* SECTION 3: CORE LOGIC (DEX AGNOSTIC)* Calculates Net Liquidity at each tick.* ==================================================================================*/-- Calculate the net change at each tick boundarytick_moves AS (SELECTtickLower AS tick,amount * sign AS liquidity_delta