HeminLUNA Price vs. Anchor bLUNA Liquidations
    Updated 2022-04-20
    with tab1 as (
    SELECT
    date_trunc('day', block_timestamp) as cur_day,
    avg(price_usd) as luna_price
    FROM terra.oracle_prices
    WHERE symbol like 'LUNA'
    GROUP by 1
    ), tab2 as (
    SELECT
    cur_day,
    luna_price,
    avg(luna_price) OVER(ORDER BY cur_day
    ROWS BETWEEN 50 PRECEDING AND CURRENT ROW )
    as moving_avg_50_day,
    avg(luna_price) OVER(ORDER BY cur_day
    ROWS BETWEEN 200 PRECEDING AND CURRENT ROW )
    as moving_avg_200_day
    FROM tab1
    ), tab3 as (
    SELECT
    date_trunc('day', block_timestamp) as cd2,
    SUM(liquidated_amount_usd) as liquidation_volume,
    COUNT(*) as Number_of_liquidations
    FROM anchor.liquidations
    WHERE liquidated_currency LIKE 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp'
    GROUP BY 1
    )

    SELECT *
    from tab2 join tab3 on cd2 = cur_day

    Run a query to Download Data