feat: add a new stream info API

[nitisht]

This API would report standard information like

stream creation time
first query able event time stamp
cache status
configured time column