SELECT

DISTINCT tx_hash,

block_timestamp :: date AS date,

event_inputs :optionId :: NUMBER AS vote_option,

event_inputs :pollId :: NUMBER AS proposal,

'MakerDAO' AS protocol

FROM

ethereum.core.fact_event_logs

WHERE block_timestamp :: date >= '2022-03-25'

AND contract_address = '0xd3a9fe267852281a1e6307a1c37cdfd76d39b133'

AND origin_to_address = LOWER('0x84b05B0a30B6AE620F393D1037f217e607AD1B96')

UNION

SELECT

tx_id AS transaction,

block_timestamp :: date as date,

CASE WHEN program_name = 'marinade' THEN

'marinade'

ELSE

'saber'

END AS protocol,

CASE WHEN vote_choice IS NULL THEN

'not available for tribeca'

ELSE

vote_choice

END AS vote_option,

proposal

FROM solana.core.fact_proposal_votes

WHERE block_timestamp :: date >= '2022-04-07'

AND voter = '715vvwpR4mUAHTH78c88xUPyPHCUgzNMb9X7iWNpHTEG'

UNION