flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
BECOME A PARTNER
flipside
05 top 10 pool in eth
Elprognerd
05 top 10 pool in eth
Updated 2022-10-27
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
pool_name
,
--DISTINCT(ORIGIN_FROM_ADDRESS) AS user,
COUNT
(
tx_hash
)
AS
n_txs
,
sum
(
AMOUNT_IN_USD
)
AS
tot_amount_in
FROM
ethereum
.
sushi
.
ez_swaps
WHERE
AMOUNT_IN_USD
IS
NOT
NULL
GROUP
BY
1
ORDER
BY
3
DESC
LIMIT
10
Results
Run a query to Download Data