c2ctraderDaily minted LUNA and burned UST
    Updated 2022-04-15
    with basic_data AS (
    SELECT date_trunc('day',block_timestamp) day, tx_status status, ask_currency minted_coin, offer_currency burned_coin, offer_amount_usd burned_amount_usd from terra.swaps
    WHERE
    (status = 'SUCCEEDED') AND
    (burned_amount_usd > 0) AND
    (minted_coin = 'LUNA' AND burned_coin = 'UST') OR
    (minted_coin = 'UST' AND burned_coin = 'LUNA')
    --LIMIT 50
    ),

    minted_ust as (
    SELECT day, minted_coin, burned_coin, sum(burned_amount_usd) burned_luna_usd 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, burned_coin, sum(burned_amount_usd) burned_ust_usd from basic_data where (minted_coin = 'LUNA')
    GROUP BY day, minted_coin, burned_coin
    ORDER BY day, minted_coin
    )
    SELECT minted_ust.day, minted_ust.minted_coin coin_ust_minted, minted_ust.burned_luna_usd, minted_luna.minted_coin coin_luna_minted, minted_luna.burned_ust_usd
    from minted_ust
    INNER JOIN minted_luna ON minted_ust.day = minted_luna.day




    Run a query to Download Data