KuramaCosmos - Proposal 82 validator votes
    Updated 2022-12-10
    with table_0 as (
    select distinct tx_id from cosmos.core.fact_msg_attributes
    where tx_succeeded = 'TRUE'
    and msg_type = 'proposal_vote'
    and attribute_key = 'proposal_id'
    and attribute_value = '82'
    ),


    -- we keep validators
    table_1 as (select distinct block_timestamp as hourly_date, tx_id, attribute_value as address from cosmos.core.fact_msg_attributes
    where tx_succeeded = 'TRUE'
    and msg_type = 'transfer'
    and attribute_key = 'sender'
    and tx_id in (select * from table_0)
    and attribute_value in ('cosmos1sjllsnramtg3ewxqwwrwjxfgc4n4ef9u0tvx7u',
    'cosmos1c4k24jzduc365kywrsvf5ujz4ya6mwymy8vq4q',
    'cosmos14lultfckehtszvzw4ehu0apvsr77afvyhgqhwh',
    'cosmos1v5y0tg0jllvxf5c3afml8s3awue0ymjuz3aksc',
    'cosmos196ax4vc0lwpxndu9dyhvca7jhxp70rmcfhxsrt',
    'cosmos18ruzecmqj9pv8ac0gvkgryuc7u004te9xr2mcr',
    'cosmos14k4pzckkre6uxxyd2lnhnpp8sngys9m6jtwwnd',
    'cosmos1tflk30mq5vgqjdly92kkhhq3raev2hnzldd74z',
    'cosmos1qaa9zej9a0ge3ugpx3pxyx602lxh3ztqda85ee',
    'cosmos19lss6zgdh5vvcpjhfftdghrpsw7a4434ut4md0',
    'cosmos1ey69r37gfxvxg62sh4r0ktpuc46pzjrmz29g45',
    'cosmos1hjct6q7npsspsg3dgvzk3sdf89spmlpfg8wwf7',
    'cosmos1clpqr4nrk4khgkxj78fcwwh6dl3uw4ep4tgu9q',
    'cosmos156gqf9837u7d4c4678yt3rl4ls9c5vuuxyhkw6',
    'cosmos132juzk0gdmwuxvx4phug7m3ymyatxlh9m9paea',
    'cosmos15urq2dtp9qce4fyc85m6upwm9xul3049um7trd',
    'cosmos1z8zjv3lntpwxua0rtpvgrcwl0nm0tltgyuy0nd',
    'cosmos1vf44d85es37hwl9f4h9gv0e064m0lla62x32sp',
    'cosmos16k579jk6yt2cwmqx9dz5xvq9fug2tekv6g34pl',
    'cosmos1zqgheeawp7cmqk27dgyctd80rd8ryhqsltfszt',
    Run a query to Download Data