Sushi vs Uni on L2-Uniswap-Polygon-pools

SalehSushi vs Uni on L2-Uniswap-Polygon-pools

Updated 2022-10-16

-- with lst_Arbitrum as (

-- select

-- case contract_address

-- when '0xc31e54c7a869b9fcbecc14363cf510d1c41fa443' then 'WETH / USDC'

-- when '0x17c14d2c404d167802b16c450d3c99f88f2c4f4d' then 'WETH / USDC'

-- when '0x641c00a822e8b671738d32a431a4fb6074e5c79d' then 'WETH / USDT'

-- when '0x13398e27a21be1218b6900cbedf677571df42a48' then 'USDT / USDC'

-- when '0xf8e5a77a4f187cfb455663b37619257565439f6a' then 'eFIL / USDT'

-- when '0x1aeedd3727a6431b8f070c0afaa81cc74f273882' then 'GMX / WETH'

-- when '0x149e36e72726e0bcea5c59d40df2c43f60f5a22d' then 'WBTC / WETH'

-- when '0x2f5e87c9312fa29aed5c179e456625d79015299c' then 'WBTC / WETH'

-- when '0xd37af656abf91c7f548fffc0133175b5e4d3d5e6' then 'DAI / USDC'

-- when '0xa961f0473da4864c5ed28e00fcc53a3aab056c1b' then 'WETH / DAI'

-- else null

-- end pool_name

-- ,count (distinct origin_from_address) as traders

-- ,count (distinct tx_hash) as swaps

-- from arbitrum.core.fact_event_logs f

-- where origin_to_address = '0xe592427a0aece92de3edee1f18e0157c05861564'

-- and pool_name is not null

-- and tx_status = 'SUCCESS'

-- and event_name = 'Swap'

-- group by 1

-- order by swaps desc

-- )

-- select * from lst_Arbitrum

-- with lst_Optimism as (

-- select

-- case contract_address

-- when '0x85149247691df622eaf1a8bd0cafd40bc45154a9' then 'ETH / USDC'

-- when '0x03af20bdaaffb4cc0a521796a223f7d85e2aac31' then 'ETH / DAI'

-- when '0x1c3140ab59d6caf9fa7459c6f83d4b52ba881d36' then 'OP / USDC'

-- when '0xc858a329bf053be78d6239c4a4343b8fbd21472b' then 'ETH / USDT'

-- when '0x95d9d28606ee55de7667f0f176ebfc3215cfd9c0' then 'ETH / DAI'

-- when '0x0392b358ce4547601befa962680bede836606ae2' then 'SNX / ETH'

-- when '0x827f0a2a4376bc26729f398b865f424dc8456841' then 'USDT / DAI'

Run a query to Download Data

flipside