select

-- a.*, b.*,

a.tx_hash,

a.block_timestamp::date as date,

case

when topics[0] = '0x320958176930804eb66c2343c7343fc0367dc16249590c0f195783bee199d094' then 'Deposit' -- TransferFromL1Completed(address,uint256,uint256,uint256,address,uint256)

when topics[0] = '0xf52ad20d3b4f50d1c40901dfb95a9ce5270b2fc32694e5c668354721cd87aa74' then 'Withdraw' -- TransfersCommitted(uint256,bytes32,uint256,uint256)

when topics[0] = '0xe35dddd4ea75d7e9b3fe93af4f4e40e778c3da4074c9d93e7c6536f1e803c1eb' then 'Withdraw'

end as actions,

case

when b.CONTRACT_ADDRESS = '0xe38faf9040c7f09958c638bbdb977083722c5156' then 'WETH'

when b.CONTRACT_ADDRESS = '0x56900d66d74cb14e3c86895789901c9135c95b16' then 'DAI'

when b.CONTRACT_ADDRESS = '0x25d8039bb044dc227f741a9e381ca4ceae2e6ae8' then 'USDC'

when b.CONTRACT_ADDRESS = lower('0x2057C8ECB70Afd7Bee667d76B4CD373A325b1a20') then 'USDT'

when b.CONTRACT_ADDRESS = lower('0xa492d3596e8391E376D4f5a5cBA5C077B890b094') then 'WBTC'

end as token

, raw_amount

from

optimism.core.fact_event_logs a

left join optimism.core.fact_token_transfers b

on a.tx_hash = b.tx_hash

where

date >= '2022-07-01'

and date <= '2022-07-31'

-- date < CURRENT_DATE

and (

topics[0] = '0x320958176930804eb66c2343c7343fc0367dc16249590c0f195783bee199d094' -- TransferFromL1Completed(address,uint256,uint256,uint256,address,uint256)

or topics[0] = '0xf52ad20d3b4f50d1c40901dfb95a9ce5270b2fc32694e5c668354721cd87aa74' -- TransfersCommitted(uint256,bytes32,uint256,uint256)

or topics[0] = '0xe35dddd4ea75d7e9b3fe93af4f4e40e778c3da4074c9d93e7c6536f1e803c1eb' -- TransferSent(bytes32,uint256,address,uint256,bytes32,uint256,uint256,uint256,uint256)

)

-- synaps bridge 0xAf41a65F786339e7911F4acDAD6BD49426F2Dc6b

-- across protocol 0xa420b2d1c0841415A695b81E5B867BCD07Dff8C9