lagandispenserpercent-FEES
    Updated 2022-08-03
    with lst_pools as (select top 10 pool_name ,sum(ADD_ASSET_LIQUIDITY_USD) from thorchain.daily_pool_stats
    group by 1
    order by 2 DESC
    )
    select date_trunc(week,day) as day ,pool_name,sum(SYSTEM_REWARDS_usd) as rewards_usd,sum(TOTAL_SWAP_FEES_USD) as sum_fee_usd
    from thorchain.daily_pool_stats where pool_name in(select pool_name from lst_pools)
    group by 1,2
    order by 1
    Run a query to Download Data