fact_log as (

select

TX_HASH,

contract_address,

ORIGIN_FROM_ADDRESS as user_address,

ORIGIN_TO_ADDRESS as platform,

event_name,

case when try_to_number(event_inputs:amount0::string) < 0 then abs(try_to_number(event_inputs:amount0::string))

else abs(try_to_number(event_inputs:amount1::string)) end as amount_1,

case when try_to_number(event_inputs:amount0::string) > 0 then abs(try_to_number(event_inputs:amount0::string))

else abs(try_to_number(event_inputs:amount1::string)) end as amount_2

from optimism.core.fact_event_logs

where 1=1

and ORIGIN_TO_ADDRESS = '0xc36442b4a4522e871399cd717abdd847ab11fe88'

and event_name in ('IncreaseLiquidity', 'DecreaseLiquidity')

and event_inputs:liquidity is not null

--and tx_hash = '0x85e7a4e237777a72dbd1f09158c129458c3edc922cbe58eded51d03b21945371'

)

,pairs as (

select

t.block_timestamp,

f.tx_hash,

user_address,

f.contract_address as pair_address,

t.contract_address as token_address_1,

f.amount_1,

tt.contract_address as token_address_2,

f.amount_2,

platform,

f.event_name