The table below lists all instances of 30-year auctions with negative real yields, along with the prevailing level of the VIX and the drawdown of the S&P 500 from all-time highs. Note that we only have auction dates going back to 2012, so I just assumed that all the prior ones occurred on the 12th of the month.