PREVIEW / stock_5min / 2017-11-24

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-11-24.parquet
  size:    3.2 MB
  rows:    196,700
  symbols: 2,837

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-11-24 04:00:00	AAPL	Stock	43.75	43.75	43.75	43.75	3492.0
2017-11-24 04:05:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	3588.0
2017-11-24 04:10:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	3292.0
2017-11-24 04:15:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	3000.0
2017-11-24 04:20:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	6532.0
2017-11-24 04:40:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	400.0
2017-11-24 04:55:00	AAPL	Stock	43.7725	43.7725	43.7725	43.7725	400.0
2017-11-24 05:45:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	400.0
2017-11-24 05:50:00	AAPL	Stock	43.775	43.775	43.775	43.775	796.0
2017-11-24 06:00:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	400.0
2017-11-24 06:20:00	AAPL	Stock	43.8375	43.8375	43.8375	43.8375	400.0
2017-11-24 06:25:00	AAPL	Stock	43.835	43.8375	43.835	43.8375	916.0
2017-11-24 06:35:00	AAPL	Stock	43.8	43.8	43.8	43.8	400.0
2017-11-24 06:45:00	AAPL	Stock	43.8	43.8	43.785	43.785	1572.0
2017-11-24 06:50:00	AAPL	Stock	43.7725	43.7725	43.7725	43.7725	5340.0
2017-11-24 06:55:00	AAPL	Stock	43.7675	43.7675	43.7675	43.7675	2000.0
2017-11-24 07:00:00	AAPL	Stock	43.75	43.7675	43.75	43.765	27852.0
2017-11-24 07:05:00	AAPL	Stock	43.775	43.7975	43.77	43.7975	11520.0
2017-11-24 07:10:00	AAPL	Stock	43.7775	43.7775	43.775	43.7775	7024.0
2017-11-24 07:15:00	AAPL	Stock	43.7775	43.7975	43.7775	43.7975	6400.0
2017-11-24 07:20:00	AAPL	Stock	43.795	43.7975	43.795	43.7975	1976.0
2017-11-24 07:25:00	AAPL	Stock	43.8	43.8175	43.8	43.815	8976.0
2017-11-24 07:30:00	AAPL	Stock	43.82	43.8225	43.8125	43.815	14588.0
2017-11-24 07:35:00	AAPL	Stock	43.8125	43.8125	43.805	43.805	2000.0
2017-11-24 07:40:00	AAPL	Stock	43.8125	43.8275	43.8125	43.8275	1000.0
2017-11-24 07:45:00	AAPL	Stock	43.8125	43.8125	43.8075	43.8075	2652.0
2017-11-24 07:50:00	AAPL	Stock	43.805	43.805	43.8	43.805	7676.0
2017-11-24 07:55:00	AAPL	Stock	43.7975	43.8075	43.7975	43.805	12780.0
2017-11-24 08:00:00	AAPL	Stock	43.8175	43.835	43.75	43.8225	38232.0
2017-11-24 08:05:00	AAPL	Stock	43.8325	43.85	43.8325	43.8325	44880.0
2017-11-24 08:10:00	AAPL	Stock	43.8425	43.875	43.8425	43.87	53480.0
2017-11-24 08:15:00	AAPL	Stock	43.855	43.8875	43.85	43.88	40832.0
2017-11-24 08:20:00	AAPL	Stock	43.885	43.91	43.885	43.89	33856.0
2017-11-24 08:25:00	AAPL	Stock	43.895	43.9	43.875	43.9	49420.0
2017-11-24 08:30:00	AAPL	Stock	43.86	43.8875	43.86	43.8875	19228.0
2017-11-24 08:35:00	AAPL	Stock	43.8925	43.8925	43.865	43.865	5952.0
2017-11-24 08:40:00	AAPL	Stock	43.875	43.89	43.875	43.89	10032.0
2017-11-24 08:45:00	AAPL	Stock	43.8775	43.8875	43.875	43.885	10584.0
2017-11-24 08:50:00	AAPL	Stock	43.875	43.885	43.8675	43.875	31800.0
2017-11-24 08:55:00	AAPL	Stock	43.8725	43.8825	43.855	43.855	11992.0
2017-11-24 09:00:00	AAPL	Stock	43.865	43.875	43.855	43.855	29988.0
2017-11-24 09:05:00	AAPL	Stock	43.87	43.875	43.85	43.8625	23056.0
2017-11-24 09:10:00	AAPL	Stock	43.8575	43.875	43.8575	43.875	10048.0
2017-11-24 09:15:00	AAPL	Stock	43.875	43.8775	43.875	43.8775	15032.0
2017-11-24 09:20:00	AAPL	Stock	43.8675	43.87	43.85	43.87	11996.0
2017-11-24 09:25:00	AAPL	Stock	43.875	43.875	43.7625	43.79	330372.0
2017-11-24 09:30:00	AAPL	Stock	43.775	43.8225	43.6615	43.7325	4738508.0
2017-11-24 09:35:00	AAPL	Stock	43.7325	43.855	43.73	43.82	2152012.0
2017-11-24 09:40:00	AAPL	Stock	43.82	43.875	43.7825	43.7975	2009436.0
2017-11-24 09:45:00	AAPL	Stock	43.8025	43.8275	43.78	43.8135	868520.0

> showing 50 of 196,700 rows — these rows as CSV

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