binhachon5. [Easy] Swapping - Percentage per chain
    Updated 2021-10-25
    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

    Run a query to Download Data