DISTINCT tx_hash as transaction,

block_timestamp :: date AS date,

'MakerDAO' AS protocol,

event_inputs :optionId :: STRING AS vote_option,

event_inputs :pollId :: STRING AS proposal

FROM

ethereum.core.fact_event_logs

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

AND contract_address = '0xd3a9fe267852281a1e6307a1c37cdfd76d39b133'

AND origin_to_address = LOWER('0x84b05B0a30B6AE620F393D1037f217e607AD1B96') -- This works for Maker

UNION

SELECT

tx_id AS transaction,

block_timestamp :: date as date,

program_name AS protocol,

CASE WHEN vote_choice IS NULL THEN

'not available for tribeca gov. platform'

ELSE

vote_choice :: STRING

END AS vote_option,

proposal :: STRING AS proposal

FROM solana.core.fact_proposal_votes

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

AND voter = '715vvwpR4mUAHTH78c88xUPyPHCUgzNMb9X7iWNpHTEG'

AND program_name = 'marinade'

UNION

SELECT

tx_id as transaction,

block_timestamp :: date AS date,

blockchain as protocol,

vote_option :: STRING as vote_option,