flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Distinct Wallets By Month
jkhuhnke11
Distinct Wallets By Month
Updated 2023-06-24
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
SELECT
date_part
(
'month'
,
block_timestamp
::
date
)
as
month
,
count
(
distinct
tx_from
)
as
cnt_wallets
FROM
evmos
.
core
.
fact_transactions
WHERE
block_timestamp
::
date
>=
'2022-06-01'
GROUP
BY
date_part
(
'month'
,
block_timestamp
::
date
)
Results
Run a query to Download Data