flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Sushi whale swaps top 10 pools by count 2022
Metiocre
Sushi whale swaps top 10 pools by count 2022
Updated 2022-05-05
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with
whale_swaps
as
(
SELECT
*
FROM
ethereum_sushi
.
ez_swaps
where
amount_out_usd
>=
{
{
MinimumAmount
}
}
and
block_timestamp
::
date
>=
'2022-01-01'
)
SELECT
pool_name
,
sum
(
1
)
as
count
FROM
whale_swaps
group
by
1
order
by
2
desc
Results
Run a query to Download Data