PREVIEW / stock_5min / 2017-01-11

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-11.parquet
  size:    5.3 MB
  rows:    350,902
  symbols: 3,128

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-01-11 04:00:00	AAPL	Stock	29.7775	29.7775	29.7175	29.7175	2000.0
2017-01-11 06:35:00	AAPL	Stock	29.695	29.695	29.695	29.695	768.0
2017-01-11 06:40:00	AAPL	Stock	29.7025	29.7025	29.7025	29.7025	796.0
2017-01-11 06:55:00	AAPL	Stock	29.735	29.7375	29.735	29.7375	2720.0
2017-01-11 07:00:00	AAPL	Stock	29.7125	29.7125	29.7125	29.7125	2824.0
2017-01-11 07:15:00	AAPL	Stock	29.7125	29.7225	29.7125	29.7225	2880.0
2017-01-11 07:30:00	AAPL	Stock	29.72	29.72	29.705	29.7125	10656.0
2017-01-11 07:35:00	AAPL	Stock	29.7125	29.7125	29.7125	29.7125	400.0
2017-01-11 07:40:00	AAPL	Stock	29.715	29.72	29.705	29.705	18680.0
2017-01-11 07:45:00	AAPL	Stock	29.705	29.705	29.705	29.705	8000.0
2017-01-11 07:50:00	AAPL	Stock	29.715	29.715	29.695	29.695	7080.0
2017-01-11 07:55:00	AAPL	Stock	29.705	29.705	29.6875	29.6875	15056.0
2017-01-11 08:00:00	AAPL	Stock	29.715	29.715	29.6875	29.7125	26332.0
2017-01-11 08:10:00	AAPL	Stock	29.71	29.715	29.71	29.715	1200.0
2017-01-11 08:15:00	AAPL	Stock	29.7125	29.72	29.7125	29.7125	2800.0
2017-01-11 08:20:00	AAPL	Stock	29.715	29.7325	29.715	29.7325	44564.0
2017-01-11 08:25:00	AAPL	Stock	29.7325	29.745	29.725	29.725	20440.0
2017-01-11 08:30:00	AAPL	Stock	29.725	29.725	29.71	29.71	12800.0
2017-01-11 08:35:00	AAPL	Stock	29.725	29.725	29.725	29.725	4000.0
2017-01-11 08:40:00	AAPL	Stock	29.7125	29.7125	29.7125	29.7125	1200.0
2017-01-11 08:45:00	AAPL	Stock	29.7125	29.7125	29.7125	29.7125	1508.0
2017-01-11 08:50:00	AAPL	Stock	29.705	29.715	29.7	29.7025	5100.0
2017-01-11 08:55:00	AAPL	Stock	29.705	29.705	29.705	29.705	4000.0
2017-01-11 09:00:00	AAPL	Stock	29.7025	29.715	29.7025	29.715	4412.0
2017-01-11 09:10:00	AAPL	Stock	29.71	29.7275	29.71	29.7125	7200.0
2017-01-11 09:15:00	AAPL	Stock	29.73	29.73	29.71	29.71	9072.0
2017-01-11 09:20:00	AAPL	Stock	29.72	29.7225	29.72	29.7225	5920.0
2017-01-11 09:25:00	AAPL	Stock	29.72	29.72	29.655	29.6625	125228.0
2017-01-11 09:30:00	AAPL	Stock	29.68	29.84	29.6575	29.7975	5644052.0
2017-01-11 09:35:00	AAPL	Stock	29.7975	29.815	29.7625	29.81	2640020.0
2017-01-11 09:40:00	AAPL	Stock	29.81	29.81	29.7275	29.74	1963980.0
2017-01-11 09:45:00	AAPL	Stock	29.74	29.745	29.71	29.73	1590280.0
2017-01-11 09:50:00	AAPL	Stock	29.7295	29.7575	29.705	29.7462	1342832.0
2017-01-11 09:55:00	AAPL	Stock	29.7475	29.795	29.7462	29.7888	1442036.0
2017-01-11 10:00:00	AAPL	Stock	29.7882	29.79	29.75	29.75	1198496.0
2017-01-11 10:05:00	AAPL	Stock	29.7525	29.765	29.7375	29.7452	1277160.0
2017-01-11 10:10:00	AAPL	Stock	29.7475	29.765	29.735	29.7388	787556.0
2017-01-11 10:15:00	AAPL	Stock	29.74	29.7475	29.7225	29.7425	743788.0
2017-01-11 10:20:00	AAPL	Stock	29.745	29.7512	29.73	29.735	817424.0
2017-01-11 10:25:00	AAPL	Stock	29.7325	29.75	29.7075	29.745	831040.0
2017-01-11 10:30:00	AAPL	Stock	29.745	29.76	29.7375	29.75	727200.0
2017-01-11 10:35:00	AAPL	Stock	29.75	29.78	29.75	29.77	1035072.0
2017-01-11 10:40:00	AAPL	Stock	29.77	29.7775	29.755	29.765	583216.0
2017-01-11 10:45:00	AAPL	Stock	29.765	29.77	29.745	29.755	684096.0
2017-01-11 10:50:00	AAPL	Stock	29.7575	29.765	29.735	29.7502	745380.0
2017-01-11 10:55:00	AAPL	Stock	29.751	29.7512	29.73	29.7425	643640.0
2017-01-11 11:00:00	AAPL	Stock	29.7425	29.76	29.735	29.7462	683868.0
2017-01-11 11:05:00	AAPL	Stock	29.745	29.7675	29.7425	29.7575	397864.0
2017-01-11 11:10:00	AAPL	Stock	29.7562	29.7825	29.75	29.7625	744756.0
2017-01-11 11:15:00	AAPL	Stock	29.7625	29.78	29.76	29.7725	663984.0

> showing 50 of 350,902 rows — these rows as CSV

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