How can I filter between two datetime timestamps in a dataframe?

I have the following dataframe:

     price_lvl_size_total  raw_end_of_event    receive_timestamp  
154                0              True        2023-05-29 00:15:01.000138338   
160                0              True        2023-05-29 00:15:01.138503551

And I would like to filter for rows between the above two timestamps.

I have tried:

dateframe.between_time(2023-5-29 00:15:01.000138338, 2023-05-29 00:15:01.138503551)

But I get a invalid syntax error. I have also tried putting the datetime inside strings but I get

TypeError: Index must be DatetimeIndex

Don't you need to parse the timestamps first ? Anyways, you can try this :

# (if needed) to make sure the timestamps are cast to int64
# file["receive_timestamp"] = file["receive_timestamp"].astype("int64")
​
out = file.loc
下载地址
.between(1685319301000138338, 1685319301138503551)]
​
#variant ?
out = file.loc[pd.to_datetime(file["receive_timestamp"]).dt.microsecond.between(138, 138503)]

Output :

print(out)
​
     price_lvl_size_total  raw_end_of_event    receive_timestamp
154                     0              True  1685319301000138338
160                     0              True  1685319301138503551

Update :

Regarding the updated question, you can use :

# (if needed)
#file["receive_timestamp"] = pd.to_datetime(file["receive_timestamp"])

start, end = "2023-05-29 00:15:01.000138338", "2023-05-29 00:15:01.138503551"

out = file.loc
下载地址
.between(start, end)]