PREVIEW / stock_5min / 2014-09-09

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-09-09.parquet
  size:    5.4 MB
  rows:    362,593
  symbols: 3,565

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2014-09-09 04:00:00	AAPL	Stock	24.75	24.75	24.65	24.65	1000.0
2014-09-09 04:05:00	AAPL	Stock	24.665	24.725	24.665	24.725	9060.0
2014-09-09 04:10:00	AAPL	Stock	24.73	24.735	24.73	24.735	5000.0
2014-09-09 04:15:00	AAPL	Stock	24.7375	24.75	24.7375	24.75	29956.0
2014-09-09 04:20:00	AAPL	Stock	24.75	24.765	24.75	24.75	5200.0
2014-09-09 04:25:00	AAPL	Stock	24.7575	24.7625	24.75	24.75	1600.0
2014-09-09 04:30:00	AAPL	Stock	24.735	24.735	24.725	24.735	17956.0
2014-09-09 04:35:00	AAPL	Stock	24.735	24.735	24.7225	24.7225	2292.0
2014-09-09 04:40:00	AAPL	Stock	24.705	24.7175	24.705	24.7175	800.0
2014-09-09 04:45:00	AAPL	Stock	24.7175	24.7175	24.7175	24.7175	400.0
2014-09-09 04:50:00	AAPL	Stock	24.7175	24.7175	24.7175	24.7175	1272.0
2014-09-09 04:55:00	AAPL	Stock	24.7275	24.7275	24.7175	24.7175	920.0
2014-09-09 05:00:00	AAPL	Stock	24.7425	24.7425	24.7175	24.7175	13836.0
2014-09-09 05:05:00	AAPL	Stock	24.7175	24.7175	24.7025	24.7025	7200.0
2014-09-09 05:15:00	AAPL	Stock	24.7325	24.735	24.715	24.715	13396.0
2014-09-09 05:30:00	AAPL	Stock	24.725	24.725	24.715	24.715	8800.0
2014-09-09 05:40:00	AAPL	Stock	24.735	24.7425	24.7275	24.7375	14824.0
2014-09-09 05:45:00	AAPL	Stock	24.7275	24.7275	24.725	24.725	3184.0
2014-09-09 05:50:00	AAPL	Stock	24.725	24.735	24.7125	24.7125	18400.0
2014-09-09 05:55:00	AAPL	Stock	24.7325	24.735	24.7125	24.7125	3200.0
2014-09-09 06:00:00	AAPL	Stock	24.735	24.735	24.705	24.73	12540.0
2014-09-09 06:05:00	AAPL	Stock	24.7375	24.7475	24.7375	24.7475	1200.0
2014-09-09 06:10:00	AAPL	Stock	24.75	24.7625	24.75	24.7625	21124.0
2014-09-09 06:15:00	AAPL	Stock	24.7675	24.775	24.76	24.775	10652.0
2014-09-09 06:20:00	AAPL	Stock	24.775	24.8225	24.775	24.8075	29556.0
2014-09-09 06:25:00	AAPL	Stock	24.7975	24.81	24.76	24.76	12800.0
2014-09-09 06:30:00	AAPL	Stock	24.7825	24.7825	24.775	24.775	3800.0
2014-09-09 06:35:00	AAPL	Stock	24.7825	24.7825	24.745	24.745	8844.0
2014-09-09 06:40:00	AAPL	Stock	24.76	24.765	24.76	24.765	2852.0
2014-09-09 06:45:00	AAPL	Stock	24.7725	24.7725	24.7625	24.77	5648.0
2014-09-09 06:50:00	AAPL	Stock	24.7675	24.775	24.7625	24.7675	28092.0
2014-09-09 06:55:00	AAPL	Stock	24.7725	24.775	24.7675	24.77	26828.0
2014-09-09 07:00:00	AAPL	Stock	24.7725	24.78	24.7675	24.775	79936.0
2014-09-09 07:05:00	AAPL	Stock	24.775	24.775	24.765	24.765	31920.0
2014-09-09 07:10:00	AAPL	Stock	24.7725	24.7875	24.7675	24.7875	31680.0
2014-09-09 07:15:00	AAPL	Stock	24.78	24.7925	24.7775	24.79	145504.0
2014-09-09 07:20:00	AAPL	Stock	24.7925	24.7925	24.7825	24.7875	43792.0
2014-09-09 07:25:00	AAPL	Stock	24.7875	24.7925	24.7825	24.7875	35176.0
2014-09-09 07:30:00	AAPL	Stock	24.7925	24.8175	24.7875	24.8175	99868.0
2014-09-09 07:35:00	AAPL	Stock	24.81	24.8175	24.8025	24.8075	66380.0
2014-09-09 07:40:00	AAPL	Stock	24.81	24.8125	24.78	24.7875	58784.0
2014-09-09 07:45:00	AAPL	Stock	24.78	24.795	24.7725	24.795	42800.0
2014-09-09 07:50:00	AAPL	Stock	24.795	24.7975	24.7825	24.7975	111104.0
2014-09-09 07:55:00	AAPL	Stock	24.7975	24.81	24.7875	24.7875	98372.0
2014-09-09 08:00:00	AAPL	Stock	24.7875	24.8175	24.765	24.8	431884.0
2014-09-09 08:05:00	AAPL	Stock	24.785	24.8125	24.775	24.7925	182876.0
2014-09-09 08:10:00	AAPL	Stock	24.79	24.7925	24.7575	24.7575	141164.0
2014-09-09 08:15:00	AAPL	Stock	24.7575	24.77	24.7575	24.77	71068.0
2014-09-09 08:20:00	AAPL	Stock	24.7675	24.7675	24.71	24.71	333404.0
2014-09-09 08:25:00	AAPL	Stock	24.7125	24.75	24.7125	24.75	133084.0

> showing 50 of 362,593 rows — these rows as CSV

> unlock the full archive -- $79 one-time