flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Untitled Query
SocioCrypto
Untitled Query
Updated 2022-09-17
Copy Reference
Fork
9
1
2
3
4
›
⌄
SELECT
date_trunc
(
'{{interval}}'
,
block_timestamp
)
as
date
,
COUNT
(
DISTINCT
miner
)
as
n_miner
FROM
ethereum
.
core
.
fact_blocks
GROUP
BY
date
Results
Run a query to Download Data