boomer77to rune vol
Updated 2022-01-23
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with vol as (select date_trunc('day', block_timestamp) as dt, sum(to_amount) as volume_rune
from thorchain.swaps
where to_asset = 'THOR.RUNE'
group by 1),
price as (select date_trunc('day', block_timestamp) as dt, avg(rune_usd) as rune_price
from thorchain.prices
group by 1)
select a.dt, a.volume_rune, b.rune_price
from vol a
left outer join price b on a.dt = b.dt
Run a query to Download Data