strawbetty LUNA burned over the past 30 days
    Updated 2022-03-12

    SELECT TO_DATE(block_timestamp) AS date,
    CAST(SUM (token_0_amount) AS INTEGER) AS Luna_burned
    FROM terra.swaps
    WHERE offer_currency = 'LUNA'
    and block_timestamp::date >= '2022-02-01'
    and block_timestamp <= '2022-03-01'
    AND tx_status = 'SUCCEEDED'
    GROUP BY 1
    ORDER BY 1 -- )


    Run a query to Download Data