{u'description': u'Daily Sentiment data',
u'error': None,
u'id': u'3ab87543-ef36-4b68-8bc4-f4d4fe3c0bf1',
u'link': None,
u'name': u'Daily',
u'query': {u'filters': [{u'entity_sentiment': [[-100, 50]],
u'entity_ticker': [u'AAPL', u'AMZN'],
u'harvested_at': [[u'2017-11-01 00:00:00',
u'2017-11-30 00:00:00']]}],
u'select': [{u'field': u'entity_sentiment', u'function': u'sum'},
{u'field': u'entity_ticker', u'function': u'group'},
{u'alias': u'day',
u'field': u'harvested_at',
u'function': u'day'}]},
u'sql': u"SELECT SUM(entity_sentiment) AS sum_entity_sentiment, entity_ticker, DATE_TRUNC('day', harvested_at) AS day FROM (SELECT * FROM archive WHERE (((entity_sentiment >= -100 AND entity_sentiment <= 50)) AND ((entity_ticker = 'AAPL') OR (entity_ticker = 'AMZN')) AND ((harvested_at >= '2017-11-01 00:00:00'::TIMESTAMP AND harvested_at <= '2017-11-30 00:00:00'::TIMESTAMP)))) AS filters GROUP BY entity_ticker, day;",
u'status': u'queued'}