SocioCryptomost common pools by ethereum.dex_swaps
    Updated 2022-04-25
    SELECT CASE WHEN pool_name = 'STETH-WETH LP' THEN 'stETH-WETH LP'
    WHEN pool_name = 'stETH-WETH LP' THEN 'stETH-WETH LP'
    WHEN pool_name = '0xdc24316b9ae028f1497c275eb9192a3ea0f67022' THEN 'Lido: Curve Liquidity Farming Pool Contract'
    END as pool_names,
    pool_address,
    CASE WHEN direction = 'IN' THEN 'swap from stETH'
    WHEN direction = 'OUT' THEN 'swap for stETH'
    END as swap,
    platform,
    count(tx_id) as n_swaps
    FROM ethereum.dex_swaps
    WHERE token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    GROUP BY pool_names,platform,swap,pool_address
    ORDER BY n_swaps DESC
    Run a query to Download Data