SELECT table1.timestamp::DATE, table2.segment, COUNT(table1.timestamp::DATE) as count, ABS(SUM(table1.amount)) as sum, table3.category, table3.text

FROM table1 LEFT JOIN table3 ON table1.id = table3.id LEFT JOIN table2 ON table1.hash = table2.hash

WHERE table1.time::DATE >= '2015-01-01' AND table1.time::DATE < '2015-02-01' AND table2.segment IN (1,2)

GROUP BY (table1.time::DATE, table2.segment, table3.category, table3.text) ORDER BY table1.timestamp::DATE, sum DESC;