select day, pool_name, swap_count * 100 / coalesce(sum(swap_count) over (partition by day order by day),1) as swap_count,
unique_swapper * 100 / coalesce(sum(unique_swapper) over (partition by day order by day),1) as unique_swapper from (
select day, substr(pool_name,1,3) as pool_name, coalesce(sum(swap_count),0) as swap_count, coalesce(sum(unique_swapper_count),0) as unique_swapper from thorchain.daily_pool_stats
where swap_count > 0
group by day, substr(pool_name,1,3)
)
where day > getdate() - interval'90 days'
order by swap_count