fix TimescaleDB sorting and types