boomer77thor swap ratio
Updated 2022-01-16
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with swap_from as (select date_trunc('month', block_timestamp) as dt, from_asset, sum(from_amount_usd) as from_volume
from thorchain.swaps
group by 1,2),
swap_to as (select date_trunc('month', block_timestamp) as dt, to_asset, sum(from_amount_usd) as to_volume
from thorchain.swaps
group by 1,2)
select a.dt, a.from_asset, a.from_volume, b.to_volume, round((b.to_volume/a.from_volume),2) as ratio, ((ratio-1)/1) as net
from swap_from a
left outer join swap_to b on a.from_asset = b.to_asset and a.dt = b.dt
Run a query to Download Data