date_trunc('day', block_timestamp) as day,

count(distinct(miner)) as daily_unique_miners

from ethereum.core.fact_blocks

where day >= current_date() - 30

and day <= '2022-9-14'

group by day