...
   WHERE asof_date = '$test_date'
   ...