c2ctraderUST-LUNA Highway
    Updated 2022-04-16
    with basic_data AS (
    SELECT date_trunc('day',block_timestamp) day,
    tx_status status,
    offer_currency burned_coin,
    ask_currency minted_coin,
    TOKEN_1_AMOUNT minted_amount,
    offer_amount burned_amount
    from terra.swaps
    WHERE
    (status = 'SUCCEEDED') AND
    (minted_amount>0) AND
    (burned_amount > 0) AND
    (minted_coin = 'LUNA' AND burned_coin = 'UST') OR
    (minted_coin = 'UST' AND burned_coin = 'LUNA')
    ),

    minted_ust as (
    SELECT day, minted_coin ust,sum(minted_amount) minted_ust, burned_coin, sum(burned_amount) burned_luna from basic_data where (minted_coin = 'UST')
    GROUP BY day, minted_coin, burned_coin
    ORDER BY day, minted_coin
    ),
    minted_luna as (
    SELECT day, minted_coin,sum(minted_amount) minted_luna, burned_coin, sum(burned_amount) burned_ust from basic_data where (minted_coin = 'LUNA')
    GROUP BY day, minted_coin, burned_coin
    ORDER BY day, minted_coin
    )
    SELECT s.day,
    s.minted_ust,
    s.burned_luna,
    l.minted_luna,
    l.burned_ust
    from minted_ust s
    INNER JOIN minted_luna l ON s.day = l.day
    order by day
    Run a query to Download Data