GCP - Bigquery - String to Timestamp

Obs: Transforma string (20191010) em um timestamp

Obs2: Transforma string(20191020) em um timestamp e soma mais 1 dia

select *
from  `MeuProjeto.Conjunto.TabelaExemplo` 
where data >= CAST(PARSE_DATE('%Y%m%d',  '20191010') AS TIMESTAMP) 
and data < TIMESTAMP_ADD(
              CAST(PARSE_DATE('%Y%m%d','20191020') AS TIMESTAMP),INTERVAL 1 DAY) 
order by 1 desc



Obrigado