User Behaviour | Optimism

KowalskiDeFiUser Behaviour | Optimism

Updated 2022-06-24

SELECT

FROM optimism.core.fact_event_logs

WHERE TX_HASH = ANY

(

SELECT TX_HASH

-- DISTINCT contract_address,

-- CASE

-- WHEN contract_address = '0xaa30d6bba6285d0585722e2440ff89e23ef68864' THEN 'hWETH-WETH'

-- WHEN contract_address = '0xe27bff97ce92c3e1ff7aa9f86781fdd6d48f5ee9' THEN 'nETH-WETH'

-- WHEN contract_address = '0x5847f8177221268d279cf377d0e01ab3fd993628' THEN '3crv?'

-- WHEN contract_address = '0xd9fb513766e60a569697d1f17ae466b0cb887454' THEN 'pWETH-WETH'

-- WHEN contract_address = '0x84baa3a0247380f27edbb93ec5d89e516bb31729' THEN 'pUSDC-USDC'

-- WHEN contract_address = '0xf181ed90d6cfac84b8073fdea6d34aa744b41810' THEN 'hDAI-DAI'

-- WHEN contract_address = '0xec4b41af04cf917b54aeb6df58c0f8d78895b5ef' THEN 'hUSDT-USDT'

-- WHEN contract_address = '0xf44938b0125a6662f9536281ad2cd6c499f22004' THEN 'nUSDC-USDC'

-- WHEN contract_address = '0x3c0ffaca566fccfd9cc95139fef6cba143795963' THEN 'hUSDC-USDC'

-- ELSE contract_address

-- END as ca_l

-- event_inputs:"amount0"/POW(10,18),

-- event_inputs:"amount1"/POW(10,18)

FROM optimism.core.fact_event_logs l

WHERE event_name = 'Swap'

)

Run a query to Download Data

flipside