SELECT
    time verifier_time,
    verifierData.outcome verifier_outcome,
    verifierData.score verifier_score,
    verifierData.kvPairString.key feature_name,
    verifierData.kvPairString.value feature_value,
   FROM [tt-dp-prod:mi.fides_events_nrt]
   WHERE ((_PARTITIONTIME >= DATE_ADD(TIMESTAMP('2018-01-10'), -1, 'DAY')
   AND _PARTITIONTIME <= DATE_ADD(TIMESTAMP('2018-01-10'), 1, 'DAY'))
   OR _PARTITIONTIME IS NULL)
   AND requestID = 37904033
   AND verifierData.name = "request.ml_ghosting_verifier_v2"