sushiswap_pools AS (

SELECT pool_address

, pool_name

, token0

, token1

FROM ethereum.core.dim_dex_liquidity_pools

WHERE platform = 'sushiswap'

),

lp_actions_prep_1 AS (

SELECT tx_hash

, block_timestamp

, block_number

, contract_address AS pool_address

, (CASE event_name WHEN 'Mint' THEN 'Deposit' WHEN 'Burn' THEN 'Withdraw' END) AS lp_action

, event_inputs['amount0']::bigint AS amount0_raw

, event_inputs['amount1']::bigint AS amount1_raw

, origin_from_address AS liquidity_provider

FROM ethereum.core.fact_event_logs

WHERE block_timestamp BETWEEN '2022-09-01' AND '2022-09-29'

AND contract_address IN (SELECT pool_address FROM sushiswap_pools)

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

),

lp_actions_prep_2 AS (

SELECT lp.tx_hash

, lp.block_timestamp

, lp.block_number

, lp.liquidity_provider

, lp.pool_address

, p.pool_name

, lp.lp_action