proposal_id,

proposal_title,

proposal_start_time,

proposal_end_time

from ethereum.core.ez_snapshot

where space_id = 'aave.eth'

and lower(proposal_author) in ('0xa06c2e5bb33cd6718b08ec9335081cbba62861f7', '0x2cc1ade245020fc5aae66ad443e1f66e01c54df1')

and proposal_start_time >= timestamp '2023-04-10 00:00:00'

and proposal_start_time <= least(current_timestamp, timestamp '2023-07-17 00:00:00')

order by proposal_end_time desc;