Ingesting stock OHLC data to influxdb in csv format

InfluxDB 2
,
1

I have got stock prices data (in OHLC form) saved in csv files. It is of the form:

#datatype measurement,dateTime:RFC3339,double,double,double,double,long
Timestamp, Open , High , Low ,Close, Volume
Paytm 2022-05-12T09:15:00+0530,526,526.75,520.25,524.15,112975
Paytm 2022-05-12T09:16:00+0530,523.8,525.95,520.5,524.1,71508
Paytm 2022-05-12T09:17:00+0530,524.15,525.3,522.1,523.5,73357
Paytm 2022-05-12T09:18:00+0530,523.25,524.85,521,524,62054
…
…

I tried uploading the csv file to my bucket using csv file protocol but it kept giving me error. I think my csv file is fine but I am not sure why it keeps giving me the error “missing expected annotation datatype”.

Someone please help if possible.

2

You specified a column measurement but there is no such column in your csv data.

3

It was a typing mistake. Edited the post but it doesn’t change the fact that it’s still not working.

4

There is no comma between Paytm and the timestamp, therefore no valid csv.