0xaiman2023-04-30 12:35 PM
    with
    raw as (
    select
    proposal_id,
    validator,
    validator_address,
    address,
    updated_at as vote_time
    from
    osmosis.core.fact_governance_validator_votes fgvv
    right join osmosis.core.fact_validators fv on fv.address = fgvv.validator_address
    ),
    vinception as (
    select
    attribute_value as validator,
    block_timestamp as tvi
    from
    osmosis.core.fact_msg_attributes
    where
    msg_type = 'create_validator'
    and attribute_key = 'validator'
    ),
    raw2 as (
    select
    proposal_id,
    min(updated_at) as vote_time
    from
    osmosis.core.fact_governance_validator_votes fgvv
    group by
    1
    ),
    raw3 as (
    select
    proposal_id,
    vote_time,
    tvi,
    Run a query to Download Data