select tick, amount0_adjusted, amount1_adjusted, liquidity

from ethereum.uniswapv3.ez_swaps

where block_number > 16000000 AND block_number < 16001000

AND pool_address = LOWER('0xCBCdF9626bC03E24f779434178A73a0B4bad62eD')

),

send_json AS (

SELECT '[' || LISTAGG(

'{' ||

'"tick": ' || tick || ',' ||

'"amount0_adjusted": ' || amount0_adjusted || ',' ||

'"amount1_adjusted": ' || amount1_adjusted || ',' ||

'"liquidity": ' || liquidity::integer || '' ||

'}', ','

) || ']' AS trades_json

FROM send

),

parameters AS (

SELECT 'budget' AS key, 100 AS value

UNION ALL

SELECT 'denominate' AS key, 1 AS value

UNION ALL

SELECT 'p1' AS key, 0 AS value -- 0 treated as NULL

UNION ALL

SELECT 'p2' AS key, 0 AS value -- 0 treated as NULL

UNION ALL

SELECT 'decimal_x' AS key, 10000000000 AS value

UNION ALL

SELECT 'decimal_y' AS key, 1000000000000000000 AS value

UNION ALL

SELECT 'fee' AS key, 0.003 AS value

),

parameter_url AS (