SELECT

tx_hash,

block_timestamp,

'Ethereum' AS chain,

action,

liquidity_provider AS user,

amount0_usd + amount1_usd AS amount_usd

FROM ethereum.uniswapv3.ez_lp_actions

JOIN ethereum.core.fact_transactions

USING (tx_hash)

WHERE AMOUNT_USD < POW(10, 6)

UNION ALL

SELECT

tx_hash,

block_timestamp,

'Optimism' AS chain,

CASE

WHEN nft_from_address ILIKE '0x00%' THEN 'INCREASE_LIQUIDITY'

ELSE 'DECREASE_LIQUIDITY'

END AS action,

CASE

WHEN action = 'INCREASE_LIQUIDITY' THEN nft_to_address

ELSE nft_from_address

END AS user,

b.amount_usd + c.amount_usd AS amount_usd

FROM optimism.nft.ez_nft_transfers a

JOIN optimism.core.ez_token_transfers c

USING (tx_hash)

JOIN optimism.core.ez_token_transfers b

USING (tx_hash)

JOIN optimism.core.fact_transactions d

USING (tx_hash)

WHERE nft_address = '0xc36442b4a4522e871399cd717abdd847ab11fe88'