flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Untitled Query
lagandispenser
Untitled Query
Updated 2022-01-04
Copy Reference
Fork
9
1
2
3
4
›
⌄
with
adressess
as
(
Select
from_address
,
count
(
from_address
)
as
number_of_swaps
from
thorchain
.
swaps
Where
block_timestamp
>=
current_date
-
30
Group
by
1
order
by
2
desc
limit
1
)
Select
*
from
adressess
Results
Run a query to Download Data