binhachon$RUNE Price vs Swapping Volume - % price change and % volume change
    Updated 2022-01-23
    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