flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Untitled Query
LTirrell
Untitled Query
Updated 2022-10-15
Copy Reference
Fork
9
1
›
SELECT
DISTINCT
signers
[
0
]
AS
addresses
,
MIN
(
DATE
(
block_timestamp
)
)
AS
first_active_date
FROM
solana
.
core
.
fact_transactions
GROUP
BY
signers
HAVING
first_active_date
=
'2022-06-18'
ORDER
by
addresses
Results
Run a query to Download Data