Sort:  

Hive-Engine API is the way to go as their data is maintained off-chain.

Yup , doing that now.

Still i have to go through every block to retrieve the transaction details .

Right now I have stored one month data in persistent dictionary ( Shelve ) .