binhachon$RUNE Price vs Swapping Volume - % price change and % volume change
Updated 2022-01-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with swap_volume as (
select
date_trunc('day', block_timestamp) as swap_volume_time,
sum(from_amount_usd) as swap_volume
from thorchain.swaps
group by swap_volume_time
),
RUNE_price as (
select
date_trunc('day', block_timestamp) as RUNE_price_time,
avg(rune_usd) as rune_price
from thorchain.prices
group by RUNE_price_time
)
select
swap_volume_time,
swap_volume,
rune_price,
lag(rune_price, 1, rune_price) over (order by swap_volume_time) as previous_week_price,
100 * (rune_price - previous_week_price) / previous_week_price as price_changes_percent,
lag(swap_volume, 1, swap_volume) over (order by swap_volume_time) as previous_week_volume,
100 * (swap_volume - previous_week_volume) / previous_week_volume as volume_changes_percent
from swap_volume
inner join RUNE_price on (swap_volume_time = RUNE_price_time)
qualify volume_changes_percent < 1000
order by swap_volume_time desc
Run a query to Download Data