boomer77swap volume vs lp rewards
Updated 2022-05-10
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with swapvol as (select date_trunc('week', day) as dt, sum(swap_volume_rune) as swap_volume_rune, sum(swap_volume_rune_usd) as swap_volume_usd
from thorchain.daily_pool_stats
group by 1),
earn as (select date_trunc('week', day) as dt, sum(earnings_to_pools) as LP_rewards_rune, sum(earnings_to_pools_usd) as LP_rewards_usd
from thorchain.daily_earnings
group by 1)
select a.dt, a.swap_volume_rune, a.swap_volume_usd, b.LP_rewards_rune, b.LP_rewards_usd
from swapvol a
left join earn b on a.dt = b.dt
Run a query to Download Data