flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
1. weight anchor
boomer77
1. weight anchor
Updated 2022-01-08
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
sender
,
sum
(
deposit_amount
)
as
UST_deposited
,
count
(
distinct
tx_id
)
as
deposit_tx_count
from
anchor
.
deposits
where
date
(
block_timestamp
)
>=
CURRENT_DATE
-
30
group
by
1
order
by
2
desc
limit
10
Results
Run a query to Download Data