PREVIEW / stock_5min / 2017-08-23

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-23.parquet
  size:    5.2 MB
  rows:    341,864
  symbols: 2,955

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
2017-08-23 05:00:00	AAPL	Stock	39.965	39.965	39.965	39.965	800.0
2017-08-23 05:15:00	AAPL	Stock	39.9375	39.9375	39.9375	39.9375	3728.0
2017-08-23 06:10:00	AAPL	Stock	39.8875	39.8875	39.8875	39.8875	1600.0
2017-08-23 06:40:00	AAPL	Stock	39.8275	39.8275	39.805	39.805	1600.0
2017-08-23 07:00:00	AAPL	Stock	39.8625	39.87	39.85	39.87	4856.0
2017-08-23 07:05:00	AAPL	Stock	39.8725	39.91	39.8725	39.91	26472.0
2017-08-23 07:10:00	AAPL	Stock	39.8875	39.8875	39.8875	39.8875	1472.0
2017-08-23 07:15:00	AAPL	Stock	39.8725	39.8725	39.855	39.855	7556.0
2017-08-23 07:20:00	AAPL	Stock	39.855	39.8725	39.855	39.8725	7468.0
2017-08-23 07:25:00	AAPL	Stock	39.8725	39.8725	39.8725	39.8725	1200.0
2017-08-23 07:35:00	AAPL	Stock	39.8575	39.8575	39.835	39.835	5364.0
2017-08-23 07:40:00	AAPL	Stock	39.835	39.835	39.835	39.835	5636.0
2017-08-23 07:45:00	AAPL	Stock	39.825	39.825	39.8125	39.8125	27332.0
2017-08-23 07:50:00	AAPL	Stock	39.8125	39.8125	39.8125	39.8125	400.0
2017-08-23 07:55:00	AAPL	Stock	39.8225	39.8225	39.8025	39.8025	11592.0
2017-08-23 08:00:00	AAPL	Stock	39.8125	39.8725	39.8025	39.83	100820.0
2017-08-23 08:05:00	AAPL	Stock	39.83	39.84	39.8125	39.84	29836.0
2017-08-23 08:10:00	AAPL	Stock	39.835	39.835	39.8125	39.8125	5988.0
2017-08-23 08:15:00	AAPL	Stock	39.8175	39.835	39.8175	39.835	2044.0
2017-08-23 08:20:00	AAPL	Stock	39.835	39.835	39.7725	39.795	79456.0
2017-08-23 08:25:00	AAPL	Stock	39.78	39.785	39.7675	39.7775	20696.0
2017-08-23 08:30:00	AAPL	Stock	39.7625	39.7875	39.755	39.765	18408.0
2017-08-23 08:35:00	AAPL	Stock	39.7525	39.78	39.7525	39.78	27288.0
2017-08-23 08:40:00	AAPL	Stock	39.765	39.7825	39.755	39.78	28112.0
2017-08-23 08:45:00	AAPL	Stock	39.7725	39.7875	39.7725	39.7875	5732.0
2017-08-23 08:50:00	AAPL	Stock	39.775	39.7825	39.7625	39.7825	31992.0
2017-08-23 08:55:00	AAPL	Stock	39.775	39.785	39.75	39.785	79540.0
2017-08-23 09:00:00	AAPL	Stock	39.75	39.7525	39.7375	39.75	33384.0
2017-08-23 09:05:00	AAPL	Stock	39.74	39.74	39.7175	39.7275	35356.0
2017-08-23 09:10:00	AAPL	Stock	39.7275	39.745	39.72	39.7225	20636.0
2017-08-23 09:15:00	AAPL	Stock	39.7225	39.7225	39.7	39.7	24684.0
2017-08-23 09:20:00	AAPL	Stock	39.71	39.7375	39.6975	39.72	27992.0
2017-08-23 09:25:00	AAPL	Stock	39.72	39.785	39.715	39.77	80236.0
2017-08-23 09:30:00	AAPL	Stock	39.7675	39.8675	39.72	39.7463	2954636.0
2017-08-23 09:35:00	AAPL	Stock	39.7475	39.8952	39.728	39.875	2078024.0
2017-08-23 09:40:00	AAPL	Stock	39.8725	39.8975	39.83	39.8625	1373240.0
2017-08-23 09:45:00	AAPL	Stock	39.865	39.935	39.85	39.9275	1269460.0
2017-08-23 09:50:00	AAPL	Stock	39.9275	39.97	39.8808	39.945	1389964.0
2017-08-23 09:55:00	AAPL	Stock	39.9475	40.0625	39.94	40.0425	2676056.0
2017-08-23 10:00:00	AAPL	Stock	40.04	40.04	39.94	39.9878	1409980.0
2017-08-23 10:05:00	AAPL	Stock	39.99	40.0075	39.89	39.9075	1202492.0
2017-08-23 10:10:00	AAPL	Stock	39.91	39.9425	39.8825	39.9075	1058532.0
2017-08-23 10:15:00	AAPL	Stock	39.906	40.0	39.906	39.9725	1221900.0
2017-08-23 10:20:00	AAPL	Stock	39.975	39.995	39.9375	39.995	550600.0
2017-08-23 10:25:00	AAPL	Stock	39.991	39.9925	39.95	39.9675	442560.0
2017-08-23 10:30:00	AAPL	Stock	39.97	39.99	39.92	39.9625	692176.0
2017-08-23 10:35:00	AAPL	Stock	39.9675	39.97	39.9125	39.94	739196.0
2017-08-23 10:40:00	AAPL	Stock	39.9425	39.985	39.925	39.9625	645436.0
2017-08-23 10:45:00	AAPL	Stock	39.96	40.0225	39.96	40.0132	906068.0
2017-08-23 10:50:00	AAPL	Stock	40.015	40.0175	39.985	40.012	725292.0

> showing 50 of 341,864 rows — these rows as CSV

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