Crazy_KidstETH Most Common Pools 1
    Updated 2022-04-27
    WITH swap_in AS (SELECT platform, contract_address as pool_address, COUNT(DISTINCT tx_hash) as no_of_swaps
    FROM ethereum_core.ez_dex_swaps
    WHERE token_in = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' AND token_out != '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    GROUP BY platform, pool_address
    ORDER BY no_of_swaps DESC),

    labels AS (SELECT address, address_name
    FROM ethereum_core.dim_labels)

    SELECT platform, pool_address, address_name as pool_name, no_of_swaps
    FROM swap_in JOIN labels ON pool_address = address
    Run a query to Download Data