Crazy_KidstETH Most Common Pools 1
Updated 2022-04-27
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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