SELECT

pool_address as pa1,

pool_name as pn1

from optimism.velodrome.ez_pool_details

WHERE TOKEN0_SYMBOL LIKE '{{token1}}'

AND TOKEN1_SYMBOL LIKE '{{token2}}'

), pool_2 as (

SELECT

pool_address as pa2,

pool_name as pn2

from optimism.velodrome.ez_pool_details

WHERE TOKEN1_SYMBOL LIKE '{{token2}}'

AND TOKEN0_SYMBOL LIKE '{{token1}}'

SELECT

date_trunc('day', block_timestamp),

sum(CASE WHEN LP_ACTION LIKE 'withdraw' THEN -1 * LP_TOKEN_AMOUNT_USD ELSE LP_TOKEN_AMOUNT_USD END) as net_liquidity,

sum(CASE WHEN LP_ACTION LIKE 'withdraw' THEN LP_TOKEN_AMOUNT_USD END) as withdraw,

sum(CASE WHEN LP_ACTION LIKE 'deposit' THEN LP_TOKEN_AMOUNT_USD END) as deposit,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as users

FROM optimism.velodrome.ez_lp_actions

LEFT OUTER JOIN pool_1

on pa1 = pool_address

LEFT OUTER JOIN pool_2

on pa2 = pool_address

WHERE pool_address in (SELECT pa1 from pool_1)

OR pool_address in (SELECT pa2 from pool_2)

GROUP BY 1--,2