select

block_timestamp,

proposer_address

from osmosis.core.fact_blocks

where block_timestamp >= '2023-02-01 00:00:00'

and block_timestamp <= '2023-02-07 00:00:00'

),

validator_info as(

select

raw_metadata[0]['uptime']['address'] as address,

label

from osmosis.core.dim_labels

where label_subtype = 'validator'

select

block_timestamp as "Block time",

label as "Validator"

from osmosis_blocks_info

inner join validator_info on proposer_address = address

order by block_timestamp asc