flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
06 top 10 pool out opt
Elprognerd
06 top 10 pool out opt
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_OUT_USD
)
AS
tot_amount_out
FROM
optimism
.
sushi
.
ez_swaps
WHERE
AMOUNT_OUT_USD
IS
NOT
NULL
GROUP
BY
1
ORDER
BY
3
DESC
LIMIT
10
Results
Run a query to Download Data