PREVIEW / stock_5min / 2017-09-19

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-19.parquet
  size:    5.4 MB
  rows:    348,495
  symbols: 2,969

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-09-19 04:00:00	AAPL	Stock	39.7125	39.7125	39.7125	39.7125	400.0
2017-09-19 04:05:00	AAPL	Stock	39.735	39.8	39.735	39.8	5724.0
2017-09-19 04:10:00	AAPL	Stock	39.75	39.75	39.75	39.75	800.0
2017-09-19 04:15:00	AAPL	Stock	39.75	39.75	39.75	39.75	400.0
2017-09-19 04:25:00	AAPL	Stock	39.7625	39.7625	39.7625	39.7625	400.0
2017-09-19 04:35:00	AAPL	Stock	39.745	39.7625	39.745	39.7625	1888.0
2017-09-19 04:40:00	AAPL	Stock	39.7625	39.7625	39.745	39.745	4316.0
2017-09-19 04:45:00	AAPL	Stock	39.7775	39.8	39.775	39.8	11200.0
2017-09-19 04:50:00	AAPL	Stock	39.755	39.755	39.755	39.755	400.0
2017-09-19 05:05:00	AAPL	Stock	39.7525	39.7525	39.725	39.725	2732.0
2017-09-19 05:15:00	AAPL	Stock	39.775	39.775	39.775	39.775	400.0
2017-09-19 05:35:00	AAPL	Stock	39.7875	39.7875	39.7875	39.7875	400.0
2017-09-19 05:40:00	AAPL	Stock	39.785	39.8	39.785	39.795	3200.0
2017-09-19 05:45:00	AAPL	Stock	39.8	39.83	39.79	39.83	11912.0
2017-09-19 05:50:00	AAPL	Stock	39.85	39.85	39.85	39.85	2400.0
2017-09-19 05:55:00	AAPL	Stock	39.8	39.8	39.8	39.8	2000.0
2017-09-19 06:00:00	AAPL	Stock	39.825	39.825	39.825	39.825	800.0
2017-09-19 06:05:00	AAPL	Stock	39.8425	39.8425	39.825	39.825	800.0
2017-09-19 06:10:00	AAPL	Stock	39.825	39.8275	39.8175	39.8275	3600.0
2017-09-19 06:15:00	AAPL	Stock	39.825	39.825	39.825	39.825	1600.0
2017-09-19 06:20:00	AAPL	Stock	39.81	39.81	39.8	39.8	2712.0
2017-09-19 06:30:00	AAPL	Stock	39.7925	39.7925	39.79	39.79	800.0
2017-09-19 06:35:00	AAPL	Stock	39.79	39.82	39.79	39.82	6200.0
2017-09-19 06:40:00	AAPL	Stock	39.8	39.82	39.8	39.82	3280.0
2017-09-19 06:45:00	AAPL	Stock	39.8125	39.825	39.8125	39.825	800.0
2017-09-19 06:50:00	AAPL	Stock	39.8325	39.8325	39.8325	39.8325	400.0
2017-09-19 07:00:00	AAPL	Stock	39.8075	39.8075	39.7875	39.7925	52020.0
2017-09-19 07:05:00	AAPL	Stock	39.7975	39.7975	39.7975	39.7975	1748.0
2017-09-19 07:10:00	AAPL	Stock	39.7825	39.7825	39.7775	39.78	12688.0
2017-09-19 07:15:00	AAPL	Stock	39.7775	39.78	39.7625	39.7625	23836.0
2017-09-19 07:20:00	AAPL	Stock	39.7575	39.8025	39.7575	39.8025	32232.0
2017-09-19 07:25:00	AAPL	Stock	39.8225	39.825	39.8025	39.8025	15400.0
2017-09-19 07:35:00	AAPL	Stock	39.795	39.8	39.795	39.8	3200.0
2017-09-19 07:40:00	AAPL	Stock	39.8125	39.89	39.8125	39.875	95960.0
2017-09-19 07:45:00	AAPL	Stock	39.8975	39.8975	39.875	39.8875	14436.0
2017-09-19 07:50:00	AAPL	Stock	39.8875	39.91	39.8775	39.91	57864.0
2017-09-19 07:55:00	AAPL	Stock	39.91	39.93	39.9	39.9	50876.0
2017-09-19 08:00:00	AAPL	Stock	39.81	39.9125	39.7775	39.905	82352.0
2017-09-19 08:05:00	AAPL	Stock	39.905	39.905	39.8625	39.8825	26904.0
2017-09-19 08:10:00	AAPL	Stock	39.8825	39.8875	39.875	39.875	18916.0
2017-09-19 08:15:00	AAPL	Stock	39.8675	39.875	39.8375	39.865	26724.0
2017-09-19 08:20:00	AAPL	Stock	39.855	39.9	39.845	39.865	64236.0
2017-09-19 08:25:00	AAPL	Stock	39.85	39.865	39.85	39.865	28612.0
2017-09-19 08:30:00	AAPL	Stock	39.865	39.8875	39.865	39.8775	88008.0
2017-09-19 08:35:00	AAPL	Stock	39.8775	39.8775	39.865	39.8775	22060.0
2017-09-19 08:40:00	AAPL	Stock	39.8825	39.8975	39.875	39.8975	49160.0
2017-09-19 08:45:00	AAPL	Stock	39.8975	39.9025	39.875	39.895	24284.0
2017-09-19 08:50:00	AAPL	Stock	39.88	39.8975	39.8775	39.8775	10112.0
2017-09-19 08:55:00	AAPL	Stock	39.8975	39.8975	39.88	39.8825	24632.0
2017-09-19 09:00:00	AAPL	Stock	39.89	39.905	39.8875	39.89	33104.0

> showing 50 of 348,495 rows — these rows as CSV

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