strawbettyburned LUNA and burned UST
    Updated 2022-04-23
    with burntluna as (
    SELECT
    date_trunc ('day', block_timestamp) as date,
    sum(token_0_amount) as LUNA_BURNT
    from terra.swaps
    where to_date(block_timestamp) > '2022-03-01'
    and ask_currency = 'UST'
    and offer_currency = 'LUNA'
    and tx_status = 'SUCCEEDED'
    group by 1
    ), burntUST as (
    SELECT
    date_trunc ('day', block_timestamp) as date,
    sum(token_0_amount) as UST_BURNT
    from terra.swaps
    where to_date(block_timestamp) > '2022-03-01'
    and ask_currency = 'LUNA'
    and offer_currency = 'UST'
    and tx_status = 'SUCCEEDED'
    group by 1
    )

    select l.date, LUNA_BURNT, UST_BURNT
    from burntluna l left join burntUST u on l.date = u.date
    Run a query to Download Data