with join_tx AS (

SELECT tx_hash

FROM polygon.core.ez_decoded_event_logs

WHERE decoded_log:from = '0x0000000000000000000000000000000000000000'

AND contract_address = '0xdac42eeb17758daa38caf9a3540c808247527ae3'

AND origin_function_signature = '0xb95cac28'

AND TX_STATUS = 'SUCCESS'

),

exit_tx AS (

SELECT tx_hash

FROM polygon.core.ez_decoded_event_logs

WHERE decoded_log:to = '0x0000000000000000000000000000000000000000'

AND contract_address = '0xdac42eeb17758daa38caf9a3540c808247527ae3'

AND origin_function_signature = '0x8bdb3913'

AND TX_STATUS = 'SUCCESS'),

pool_join AS (

CASE

when contract_address = '0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' then sum(raw_amount)/pow(10,18)

when contract_address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then sum(raw_amount)/pow(10,6)

end AS TWO_CLP_USDC_DAI_stake_amount,

CASE

when contract_address = '0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' then 'DAI'

when contract_address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then 'USDC'

end AS Asset

FROM polygon.core.fact_token_transfers

WHERE tx_hash IN (select tx_hash from join_tx)

AND contract_address IN ('0x8f3cf7ad23cd3cadbd9735aff958023239c6a063', '0x2791bca1f2de4661ed88a30c99a7a9449aa84174')

AND to_address = '0xba12222222228d8ba445958a75a0704d566bf2c8'

GROUP BY contract_address),