boomer77swap by price
Updated 2021-10-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with vol as (select date_trunc('hour', block_timestamp) as bh, sum(to_amount_usd) as swap_volume, count(distinct tx_id) as Transaction_Count
from thorchain.swaps
where block_timestamp >= CURRENT_DATE - 30
group by 1),
price as (select date_trunc('hour', block_timestamp) as bh, avg(rune_usd) as rune_price
from thorchain.prices
where block_timestamp >= CURRENT_DATE - 30
group by 1)
select a.bh, a.swap_volume, a. transaction_count, b.rune_price
from vol a
join price b on a.bh = b.bh
Run a query to Download Data