To filter Athena query data between two dates, you have to convert the date column data (saved as string) into timestamp and then type cast using date function.