SELECT

vote_timestamp,

CASE WHEN space_id = 'aave.eth' THEN

'AAVE'

WHEN space_id = 'opcollective.eth' THEN

'Optimism'

WHEN space_id = 'ens.eth' THEN

'ENS'

WHEN space_id = 'sushigov.eth' THEN

'Sushi'

END AS protocol,

CASE WHEN space_id = 'aave.eth' THEN voting_power END AS aave_voting_power,

CASE WHEN space_id = 'opcollective.eth' THEN voting_power END AS optimism_voting_power,

CASE WHEN space_id = 'ens.eth' THEN voting_power END AS ens_voting_power,

CASE WHEN space_id = 'sushigov.eth' THEN voting_power END AS sushi_voting_power,

CASE WHEN space_id = 'gnosis.eth' THEN voting_power END AS gnosis_voting_power

FROM "ETHEREUM"."CORE"."EZ_SNAPSHOT"

WHERE voter = '0x62a43123FE71f9764f26554b3F5017627996816a'

),

safe_balances_airdrop AS (

SELECT

tx_hash,

event_inputs :to :: STRING AS delegator,

event_inputs :value / POW(10,18) :: NUMBER AS amount

FROM ethereum.core.fact_event_logs

WHERE contract_address = '0x5afe3855358e112b5647b952709e6165e1c1eeee'

AND event_name = 'Transfer'

),

delegates AS (

SELECT

l.tx_hash,

l.block_timestamp,

event_inputs :delegate :: STRING AS delegate,

amount,

event_inputs :delegator :: STRING AS delegator