date_trunc('day', block_timestamp) as time,

count(*)

from base.core.fact_blocks

where block_timestamp > current_date -10

group by time