votes AS (

SELECT

block_timestamp,

tx_hash,

proposal_id,

support,

voter,

voting_power

FROM

ethereum.aave.ez_votes v

),

txs AS (

SELECT

block_timestamp,

tx_hash,

gas_used,

tx_fee,

gas_price

FROM

ethereum.core.fact_transactions

),

final AS (

SELECT

v.block_timestamp,

v.tx_hash,

v.support,

v.proposal_id,

v.voter,

v.voting_power::number as voting_pow,

t.gas_used,

t.tx_fee,

t.gas_price

FROM

votes v

LEFT JOIN txs t on v.tx_hash = t.tx_hash