nitsNet Synths Amount Daily
    Updated 2022-05-03
    with mints as
    (SELECT date(block_timestamp) as day ,blockchain, to_asset as asset,sum(to_amount_usd) as total_amt_usd
    from thorchain.swaps
    where contains(to_asset , '/')
    GROUP by 1,2,3 ),
    burns as
    (SELECT date(block_timestamp) as day ,blockchain, from_asset as asset,sum(from_amount_usd)*(-1) as total_amt_usd
    from thorchain.swaps
    where contains(from_asset , '/')
    GROUP by 1,2,3 )
    -- SELECT avg(time_diff)/(60*60*24) as avg_time_in_days, median(time_diff/(60*60*24)) as median_time_in_days
    -- from
    -- (SELECT *, abs(TIMESTAMPDIFF(SQL_TSI_SECOND, last_mint,last_burn)) as time_diff
    -- from
    -- (SELECT * from mints
    -- left join burns on fa= from_address )
    -- where last_burn is NOT NULL )
    -- where last_burn is NULL
    -- LIMIT 100
    -- GROUP by 1
    SELECT day ,blockchain, asset,sum(total_amt_usd) as amt_usd
    from
    (SELECT * from mints
    UNION ALL
    SELECT * FROM burns )
    GROUP by 1,2 ,3
    -- limit 1000