flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Top liquidity pools pact.fi
Papasot
Top liquidity pools pact.fi
Updated 2023-01-03
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
asset_name
AS
Liquidity_pool
,
COUNT
(
DISTINCT
(
address
)
)
AS
wallets
FROM
algorand
.
account_asset
WHERE
asset_name
like
'%PACT LP Token%'
AND
amount
>
0
GROUP
BY
asset_name
Order
by
wallets
DESC
Limit
10
Results
Run a query to Download Data