nitsAverage Age Stats
    Updated 2022-04-18
    with mints as
    (SELECT from_address as fa , max(block_timestamp) as last_mint from thorchain.swaps
    where contains(to_asset , '/')
    GROUP by 1 ),
    burns as
    (SELECT from_address , max(block_timestamp) as last_burn from thorchain.swaps
    where contains(from_asset , '/')
    GROUP by 1 )
    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 *, case when last_burn is NULL then abs(TIMESTAMPDIFF(SQL_TSI_SECOND, last_mint,CURRENT_TIMESTAMP)) else abs(TIMESTAMPDIFF(SQL_TSI_SECOND, last_mint,last_burn)) end as time_diff
    from
    (SELECT * from mints
    left join burns on fa= from_address ))
    -- where last_burn is NULL
    -- LIMIT 100
    -- GROUP by 1
    Run a query to Download Data