I use beem API for pulling these data . HiveSQL is good for Hive but if you need to extract data for second layer tokens then it is better to use Hive-engine API or Beem API .

Let me know if you need any help .

Posted Using LeoFinance ^Beta