flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Weekly Active Wallets - kimia 2
freemartian
Weekly Active Wallets - kimia 2
Updated 2022-05-05
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with
wallets
as
(
select
tx_from
,
count
(
*
)
as
number
,
date_trunc
(
'week'
,
block_timestamp
)
as
DATE
from
terra
.
transactions
where
tx_status
=
'SUCCEEDED'
group
by
tx_from
,
date
)
select
count
(
number
)
,
DATE
from
wallets
where
number
>=
7
group
by
DATE
Results
Run a query to Download Data