zakkisyedSynth mint/burn over time
    Updated 2022-04-13
    SELECT date_trunc('day', block_timestamp) as dayz,
    --from_asset, to_asset, pool_name,
    CASE WHEN memo like '%/%' THEN 1 ELSE 0 END AS is_synth,
    count (distinct tx_id) as N,
    case when from_asset like '%/%' THEN 'burn' ELSE 'mint' END AS burn_mint

    FROM thorchain.swap_events
    WHERE block_timestamp >= '2022-03-09'
    and is_synth = 1
    -- and from_asset like '%/%' -- mint

    GROUP BY 1,2,4
    ORDER BY 3 DESC
    Run a query to Download Data