select date_trunc(day,BLOCK_TIMESTAMP) as date , sum (RUNE_AMOUNT) as sum_amount ,
sum (sum_amount) over ( order by date ) as cum_amount ,
count (DISTINCT from_address) as num_old_addresess,
count (DISTINCT to_address) as num_new_addresses,
sum (RUNE_AMOUNT_USD) as sum_USD_amount, sum (sum_USD_amount) over ( order by date ) AS cum_amount_USD
from flipside_prod_db.thorchain.upgrades
where BLOCK_TIMESTAMP >= CURRENT_DATE -30
group by 1