PapasotUST burnt/minted
    Updated 2022-07-07
    --https://app.flipsidecrypto.com/dashboard/pleasure-to-burn-1xFfCo
    --credits to the original author David Enoch(potmo)

    WITH BM AS(
    WITH BURNED AS(
    SELECT TO_DATE(block_timestamp) AS date,
    CAST(SUM (offer_amount_usd) AS INTEGER) AS "UST burned"
    --CAST(SUM (token_0_amount) AS INTEGER) AS "UST minted"
    FROM terra.swaps
    WHERE TO_DATE(block_timestamp) >= dateadd(day, -180, current_date())
    AND offer_currency = 'UST'
    AND tx_status = 'SUCCEEDED'
    GROUP BY 1
    ORDER BY 1 ),

    MINTED AS (
    SELECT TO_DATE(block_timestamp) AS date,
    CAST(SUM (offer_amount_USD)/ 1000000 AS INTEGER) AS "UST minted"
    --CAST(SUM (token_0_amount) AS INTEGER) AS "UST minted"
    FROM terra.swaps
    WHERE TO_DATE(block_timestamp) >= dateadd(day, -180, current_date())
    AND offer_currency = 'LUNA'
    AND tx_status = 'SUCCEEDED'
    GROUP BY 1
    ORDER BY 1 )
    SELECT *
    FROM BURNED
    JOIN MINTED
    USING(DATE))
    --SELECT * FROM BM

    Run a query to Download Data