flipside

    ETH Derivatives Pools
    OneDataAnalystETH Derivatives Pools
    Updated 2022-09-13
    SELECT POOL_NAME,PLATFORM,COUNT(*) AS Transactions

    FROM ethereum.core.ez_dex_swaps

    WHERE TOKEN_IN IN (lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84'),lower('0xae78736Cd615f374D3085123A210448E74Fc6393'),lower('0xE95A203B1a91a908F9B9CE46459d101078c2c3cb'))
    OR TOKEN_OUT IN (lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84'),lower('0xae78736Cd615f374D3085123A210448E74Fc6393'),lower('0xE95A203B1a91a908F9B9CE46459d101078c2c3cb'))

    GROUP BY 1,2
    ORDER BY 3 DESC
    Run a query to Download Data