SELECT FROM bigtable WHERE date >= '2015-01-01' AND date <= '2016-01-01' ORDER BY date desc;

CREATE INDEX CONCURRENTLY bigtable_date_index ON bigtable(date(date));