count(DISTINCT a.tx_hash) as count_vote,

count(DISTINCT voter) as count_voter,

count(DISTINCT proposal_id) as count_proposal,

sum(tx_fee) as total_fee,

avg(tx_fee) as avg_fee_per_vote,

median(tx_fee) as median_fee_per_vote,

max(tx_fee) as max_fee_per_day,

min(tx_fee) as min_fee_per_day,

avg(avg_fee_per_vote) over (order by day rows between 14 PRECEDING AND CURRENT ROW) as avg_14_day_moving,

avg(avg_fee_per_vote) over (order by day rows between 30 PRECEDING AND CURRENT ROW) as avg_30_day_moving,

sum(count_vote) over (order by day asc) as cumulative_vote,

sum(total_fee) over (order by day asc) as cumulative_eth

from ethereum.aave.ez_votes a join ethereum.core.fact_transactions b on a.tx_hash = b.tx_hash

where a.block_timestamp >= CURRENT_DATE - 180

group by 1