Crazy_KidSynth Mints + Burns
    Updated 2022-04-11
    WITH mint AS (SELECT date(block_timestamp) as date, to_asset as asset_minted, sum(to_amount) as amount_minted
    FROM thorchain.swaps
    WHERE to_asset LIKE '%/%' AND date < CURRENT_DATE
    GROUP BY date, to_asset),

    burn AS (SELECT date(block_timestamp) as date, from_asset as asset_burned, sum(from_amount) as amount_burned
    FROM thorchain.swaps
    WHERE from_asset LIKE '%/%' AND date < CURRENT_DATE
    GROUP BY date, from_asset)

    SELECT mint.date, asset_minted, amount_minted, asset_burned, amount_burned
    FROM mint JOIN burn on mint.date = burn.date
    ORDER BY mint.date DESC
    Run a query to Download Data