date(date_trunc('day', block_timestamp)) as days,

count(DISTINCT(miner)) as miners

from ethereum.core.fact_blocks group by days