import pandas as pd
from db import dbengine
engine = dbengine('serenitasdb')

df1 = pd.read_sql_query("SELECT date FROM test", engine)

df2 = pd.read_sql_query("SELECT date FROM test WHERE date<='2014-10-17'",
                        engine)
df2bis = pd.read_sql_query("SELECT date FROM test WHERE date<='2014-10-17'",
                           engine, parse_dates=['date'])
df3 = pd.read_sql_query("SELECT date FROM test", engine,
                        parse_dates=['date'])


# df4 = pd.read_sql_query("SELECT date FROM index_quotes " \
#                         "WHERE date BETWEEN '2016-10-01' AND '2016-11-30'", engine,
#                         index_col='date')


# CREATE TABLE test(date timestamptz);

# INSERT INTO test VALUES('2014-10-16 07:50:49-04'),('2014-11-06 07:42:06-05')