lagandispenserpercent-FEES
Updated 2022-08-03
9
1
2
3
4
5
6
7
8
9
›
⌄
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