flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
wallet addresses - kian
freemartian
wallet addresses - kian
Updated 2022-03-09
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
WITH
addresses
as
(
SELECT
tx_from
[
0
]
AS
new_addresses
,
min
(
block_timestamp
)
::
DATE
AS
TIME
FROM
terra
.
transactions
GROUP
BY
1
HAVING
TIME
>=
'2021-12-09'
)
SELECT
count
(
new_addresses
)
FROM
addresses
Results
Run a query to Download Data