SELECT

block_timestamp,

CASE

WHEN block_number < 15537393 THEN 'Before the Merge'

ELSE 'After the Merge'

END AS period,

tx_hash,

contract_address AS pool_address,

CASE

WHEN event_name = 'Mint' THEN 'Deposit'

WHEN event_name = 'Burn' THEN 'Withdraw'

END AS lp_act_type,

to_number(event_inputs:amount0) AS amount0,

to_number(event_inputs:amount1) AS amount1,

origin_from_address AS LPer

FROM ethereum.core.fact_event_logs

WHERE contract_address IN (SELECT pool_address FROM ethereum.core.dim_dex_liquidity_pools WHERE platform = 'sushiswap')

AND event_name IN ('Mint','Burn')

),

lp_tx2 AS (

SELECT

a.block_timestamp,

a.period,

a.tx_hash,

a.LPer,

a.pool_address,

b.pool_name,

a.lp_act_type,

-- b.token0 AS token0_address,

-- c.symbol AS token0_symbol,

-- a.amount0 AS token0_amount_raw,

-- c.amount AS token0_amount,

-- c.amount_usd AS token0_amount_usd_,

-- b.token1 AS token1_address,

-- d.symbol AS token1_symbol,