where voter_address_label = 'Staked' and tx_status = 'SUCCEEDED'),

b_harvest as (select * from terra.gov_vote

where voter_address_label = 'B-Harvest' and tx_status = 'SUCCEEDED'),

final_selection as (select max(block_timestamp) as m, proposal_id as p from b_harvest

group by proposal_id )

select date(block_timestamp) as day, proposal_id, case when option = 'No' then '-1' when option = 'Yes' then '1' else '0' end as choice from b_harvest

inner join final_selection

on m = block_timestamp and p = proposal_id