q
Out[235]:
[{u'Code': u'GE',
  u'datetime': u'2011-11-14T19:30:03-05:00[US/Eastern]'},
 {u'Code': u'PP',
  u'datetime': u'2012-21-14T18:50-05:00[US/Eastern]'},
 {u'Code': u'IO',
  u'Summary': [{u'prod': u'book',
    u'num': 81.04,
    u'devil': 17},
   {u'prod': u'game',
    u'num': 191.5,
    u'devil': 10},
   {u'prod': u'desk',
    u'num': 55.5,
    u'devil': -6},
   {u'angel': u'ipo',
    u'num': 503.0,
    u'devil': 1}],
  u'datetime': u'2013-10-14T16:30-05:00[US/Eastern]'},
 {u'Code': u'BI',
  u'datetime': u'2014-11-14T12:30-05:00[US/Eastern]'},
 {u'Code': u'EZ',
  u'datetime': u'2015-12-14T10:00-05:00[US/Eastern]'},
 {u'Code': u'JC',
  u'datetime': u'2016-10-14T08:30:01-05:00[US/Eastern]'},
 {u'Code': u'WX',
  u'Summary': [{u'angel': u'yut',
    u'num': 0,
    u'prod': u'read',
    u'devil': 0.0},
   {u'angel: u'fgf',
    u'prod': u'fart',
    u'devil': 0.0},
   {u'prod': u'red',
    u'num': 673,
    u'angel': u'deft',
    u'devil': 0,
   { u'devil': 0,
    u'prod': u'dog',
   {u'angel': u'hut',
    u'devil': 99,
  u'datetime': u'2017-10-13T05:00:02-05:00[US/Eastern]'},

pd.DataFrame(q)
    Out[229]:
             Code                                            Summary                        datetime
    0          GE                                                NaN  2011-11-11T19:30:03-05:00[US/Eastern]
    1          PP                                                NaN  2012-12-25T18:50-05:00[US/Eastern]
    2          IO  [{u'prod': u'book', u'angel': u'I...               2013-11-04T16:30-05:00[US/Eastern]
    3          BI                                                NaN  2014-12-14T08:30:01-05:00[US/Eastern]
    4          JC                                                NaN  2016-11-14T04:30-05:00[US/Eastern]
    5          WX  [{u'prod': u'orange', u'devil': -2, u's...         2017-10-13T03:30:08-05:00[US/Eastern]