flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2024-06-04 01:54 PM
Tobi_1
2024-06-04 01:54 PM
Updated 2024-06-07
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
⌄
SELECT
BLOCK_TIMESTAMP_HOUR
,
SUM
(
UNIQUE_SIGNERS_COUNT
)
AS
unique_signers
FROM
solana
.
stats
.
ez_core_metrics_hourly
;
WHERE
BLOCK_TIMESTAMP_HOUR
>=
DATEADD
(
days
,
-
30
,
CURRENT_TIMESTAMP
(
)
)
GROUP
BY
BLOCK_TIMESTAMP_HOUR
ORDER
BY
BLOCK_TIMESTAMP_HOUR
;
Results