trunc(x.block_timestamp,'day') as date ,

count(distinct y.tx_hash) as n_votes,

sum(n_votes) over (order by date) as total_votes,

count(distinct voter) as voters,

sum(voters) over (order by date) as total_voters,

sum(tx_fee) as eth_fees ,

avg(tx_fee) as avg_eth_fees ,

sum(gas_used/1e9) as gas_spent,

avg(gas_used/1e9) as avg_gas_spent,

sum(eth_fees) over (order by date asc) as cum_fees,

sum(gas_spent) over (order by date asc) as cum_gas

from ethereum.core.fact_transactions x

join ethereum.aave.ez_votes y on x.tx_hash=y.tx_hash

where date >= CURRENT_DATE - {{period_in_days}}

group by 1

order by 1 desc