flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Untitled Query
nany_8
Untitled Query
Updated 2021-12-07
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
select
date_trunc
(
'week'
,
BLOCK_TIMESTAMP
)
as
week
,
count
(
distinct
(
ORIGIN_ADDRESS
)
)
as
distinct_from_addy
from
ethereum
.
udm_events
where
CONTRACT_ADDRESS
=
lower
(
'0xff56cc6b1e6ded347aa0b7676c85ab0b3d08b0fa'
)
group
by
week
order
by
week
desc
Results
Run a query to Download Data