PREVIEW / stock_5min / 2017-05-02

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-05-02.parquet
  size:    5.4 MB
  rows:    354,945
  symbols: 3,070

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-05-02 04:00:00	AAPL	Stock	36.645	36.7	36.6375	36.7	20664.0
2017-05-02 04:05:00	AAPL	Stock	36.6975	36.6975	36.6975	36.6975	400.0
2017-05-02 04:25:00	AAPL	Stock	36.6575	36.6575	36.6575	36.6575	1460.0
2017-05-02 05:05:00	AAPL	Stock	36.6575	36.6575	36.6	36.6	2304.0
2017-05-02 05:10:00	AAPL	Stock	36.6375	36.6375	36.6375	36.6375	4152.0
2017-05-02 05:40:00	AAPL	Stock	36.6625	36.6625	36.6625	36.6625	440.0
2017-05-02 05:45:00	AAPL	Stock	36.655	36.6625	36.655	36.6625	892.0
2017-05-02 05:50:00	AAPL	Stock	36.6625	36.6625	36.6625	36.6625	1228.0
2017-05-02 05:55:00	AAPL	Stock	36.675	36.685	36.675	36.685	2924.0
2017-05-02 06:00:00	AAPL	Stock	36.685	36.73	36.685	36.73	6752.0
2017-05-02 06:05:00	AAPL	Stock	36.73	36.73	36.73	36.73	4000.0
2017-05-02 06:15:00	AAPL	Stock	36.7275	36.7275	36.7275	36.7275	2000.0
2017-05-02 06:20:00	AAPL	Stock	36.7025	36.7025	36.6875	36.6875	1720.0
2017-05-02 06:35:00	AAPL	Stock	36.6875	36.7	36.6875	36.7	2400.0
2017-05-02 06:40:00	AAPL	Stock	36.705	36.705	36.7	36.7	6240.0
2017-05-02 06:50:00	AAPL	Stock	36.71	36.7125	36.71	36.7125	4760.0
2017-05-02 06:55:00	AAPL	Stock	36.705	36.705	36.6875	36.6875	5880.0
2017-05-02 07:00:00	AAPL	Stock	36.7025	36.7325	36.7025	36.725	63620.0
2017-05-02 07:05:00	AAPL	Stock	36.7225	36.7225	36.7125	36.7125	10300.0
2017-05-02 07:10:00	AAPL	Stock	36.7175	36.725	36.7175	36.7225	2340.0
2017-05-02 07:15:00	AAPL	Stock	36.715	36.715	36.6725	36.6725	52356.0
2017-05-02 07:20:00	AAPL	Stock	36.675	36.675	36.6675	36.675	8080.0
2017-05-02 07:25:00	AAPL	Stock	36.69	36.695	36.6375	36.6375	28308.0
2017-05-02 07:30:00	AAPL	Stock	36.64	36.6625	36.64	36.6625	14088.0
2017-05-02 07:35:00	AAPL	Stock	36.675	36.695	36.66	36.665	13372.0
2017-05-02 07:40:00	AAPL	Stock	36.6775	36.7	36.655	36.7	26388.0
2017-05-02 07:45:00	AAPL	Stock	36.7	36.7425	36.7	36.7	71264.0
2017-05-02 07:50:00	AAPL	Stock	36.7025	36.7025	36.675	36.695	10404.0
2017-05-02 07:55:00	AAPL	Stock	36.7175	36.72	36.7175	36.7175	3720.0
2017-05-02 08:00:00	AAPL	Stock	36.725	36.7425	36.66	36.7325	136144.0
2017-05-02 08:05:00	AAPL	Stock	36.7325	36.75	36.7325	36.75	94192.0
2017-05-02 08:10:00	AAPL	Stock	36.75	36.7925	36.75	36.7925	45748.0
2017-05-02 08:15:00	AAPL	Stock	36.7875	36.8	36.775	36.775	45652.0
2017-05-02 08:20:00	AAPL	Stock	36.7675	36.835	36.7675	36.82	167188.0
2017-05-02 08:25:00	AAPL	Stock	36.82	36.8325	36.8125	36.8125	98592.0
2017-05-02 08:30:00	AAPL	Stock	36.8125	36.8125	36.7875	36.8125	91328.0
2017-05-02 08:35:00	AAPL	Stock	36.8025	36.8075	36.78	36.78	27464.0
2017-05-02 08:40:00	AAPL	Stock	36.79	36.8075	36.79	36.8025	17716.0
2017-05-02 08:45:00	AAPL	Stock	36.8	36.8125	36.8	36.805	36200.0
2017-05-02 08:50:00	AAPL	Stock	36.8	36.81	36.8	36.81	7400.0
2017-05-02 08:55:00	AAPL	Stock	36.81	36.82	36.8	36.8125	38456.0
2017-05-02 09:00:00	AAPL	Stock	36.8125	36.86	36.8125	36.8375	86312.0
2017-05-02 09:05:00	AAPL	Stock	36.8375	36.8475	36.825	36.825	113788.0
2017-05-02 09:10:00	AAPL	Stock	36.8325	36.8375	36.825	36.835	71660.0
2017-05-02 09:15:00	AAPL	Stock	36.83	36.835	36.8025	36.8325	57132.0
2017-05-02 09:20:00	AAPL	Stock	36.8225	36.83	36.7775	36.8225	88848.0
2017-05-02 09:25:00	AAPL	Stock	36.8225	36.885	36.775	36.885	347276.0
2017-05-02 09:30:00	AAPL	Stock	36.885	36.9	36.745	36.895	8862380.0
2017-05-02 09:35:00	AAPL	Stock	36.89	36.9225	36.875	36.88	3568280.0
2017-05-02 09:40:00	AAPL	Stock	36.88	36.89	36.8175	36.86	2305064.0

> showing 50 of 354,945 rows — these rows as CSV

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