KuramaCosmos - Proposal 82 validator votes
Updated 2022-12-10Copy Reference Fork
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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