flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Untitled Query
LTirrell
Untitled Query
Updated 2022-10-19
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
distinct
signers
[
0
]
AS
address
,
MIN
(
DATE
(
block_timestamp
)
)
AS
creation_date
,
MAX
(
DATE
(
block_timestamp
)
)
AS
last_use
FROM
solana
.
core
.
fact_transactions
GROUP
BY
address
limit
100
Results
Run a query to Download Data