date_trunc('day', date) date,

sum (balance/ power(10, 6)) total_balance,

avg (balance/ power(10, 6)) average_balance,

median (balance/ power(10, 6)) median_balance,

count(distinct(address)) total_holders,

sum(total_balance) over (order by date) comulative_total_balance,

sum(average_balance) over (order by date) comulative_average_balance,

sum(median_balance) over (order by date) comulative_median_balance,

sum(total_holders) over (order by date) comulative_total_holders,

avg(average_balance) over (order by date rows between 6 preceding and current row) as average_balance_7_days_moving

from osmosis.core.fact_daily_balances

where 1 = 1

and currency = 'uosmo'

and date >= current_date - interval '1 months'

group by date

order by date