PREVIEW / stock_5min / 2017-04-25

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-04-25.parquet
  size:    5.5 MB
  rows:    363,306
  symbols: 3,069

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-04-25 04:20:00	AAPL	Stock	35.985	35.985	35.985	35.985	4000.0
2017-04-25 05:05:00	AAPL	Stock	35.975	35.975	35.975	35.975	800.0
2017-04-25 05:25:00	AAPL	Stock	35.975	35.975	35.9625	35.9625	5616.0
2017-04-25 07:20:00	AAPL	Stock	35.975	35.975	35.975	35.975	4000.0
2017-04-25 07:25:00	AAPL	Stock	35.975	35.975	35.965	35.9675	8400.0
2017-04-25 07:30:00	AAPL	Stock	35.985	35.985	35.975	35.975	6200.0
2017-04-25 07:35:00	AAPL	Stock	35.985	35.9875	35.985	35.9875	7600.0
2017-04-25 07:40:00	AAPL	Stock	35.9875	35.9875	35.9875	35.9875	2000.0
2017-04-25 07:55:00	AAPL	Stock	35.99	35.99	35.99	35.99	4772.0
2017-04-25 08:00:00	AAPL	Stock	35.99	35.9925	35.98	35.99	15412.0
2017-04-25 08:05:00	AAPL	Stock	35.99	35.995	35.9875	35.995	8548.0
2017-04-25 08:10:00	AAPL	Stock	35.995	36.015	35.995	36.015	22940.0
2017-04-25 08:15:00	AAPL	Stock	36.015	36.0225	36.015	36.02	3000.0
2017-04-25 08:20:00	AAPL	Stock	36.015	36.0225	36.01	36.0225	9300.0
2017-04-25 08:25:00	AAPL	Stock	36.0225	36.025	36.0225	36.0225	11124.0
2017-04-25 08:30:00	AAPL	Stock	36.025	36.025	36.015	36.015	22000.0
2017-04-25 08:35:00	AAPL	Stock	36.035	36.0375	36.03	36.0375	4576.0
2017-04-25 08:40:00	AAPL	Stock	36.0325	36.0375	36.0325	36.0375	3216.0
2017-04-25 08:45:00	AAPL	Stock	36.0425	36.0425	36.025	36.04	10000.0
2017-04-25 08:50:00	AAPL	Stock	36.05	36.05	36.0375	36.05	11964.0
2017-04-25 08:55:00	AAPL	Stock	36.05	36.05	36.015	36.015	29236.0
2017-04-25 09:00:00	AAPL	Stock	36.015	36.02	36.01	36.02	18392.0
2017-04-25 09:05:00	AAPL	Stock	36.02	36.0475	36.02	36.0475	14048.0
2017-04-25 09:10:00	AAPL	Stock	36.03	36.05	36.03	36.0475	20232.0
2017-04-25 09:15:00	AAPL	Stock	36.035	36.0375	36.03	36.0375	4952.0
2017-04-25 09:20:00	AAPL	Stock	36.0375	36.05	35.925	36.0	132672.0
2017-04-25 09:25:00	AAPL	Stock	35.9925	36.0075	35.9625	36.0075	68640.0
2017-04-25 09:30:00	AAPL	Stock	35.9925	36.08	35.9675	36.055	3816812.0
2017-04-25 09:35:00	AAPL	Stock	36.055	36.0675	36.0378	36.05	1585924.0
2017-04-25 09:40:00	AAPL	Stock	36.05	36.065	36.0325	36.049	1367488.0
2017-04-25 09:45:00	AAPL	Stock	36.05	36.115	36.0475	36.1025	1606308.0
2017-04-25 09:50:00	AAPL	Stock	36.1025	36.1125	36.0575	36.065	1215292.0
2017-04-25 09:55:00	AAPL	Stock	36.065	36.0675	36.025	36.04	1194136.0
2017-04-25 10:00:00	AAPL	Stock	36.04	36.085	36.0375	36.0695	1362488.0
2017-04-25 10:05:00	AAPL	Stock	36.07	36.0975	36.07	36.095	897608.0
2017-04-25 10:10:00	AAPL	Stock	36.096	36.0975	36.0275	36.0475	1425284.0
2017-04-25 10:15:00	AAPL	Stock	36.0475	36.07	36.025	36.0575	768488.0
2017-04-25 10:20:00	AAPL	Stock	36.0598	36.07	36.035	36.0525	650600.0
2017-04-25 10:25:00	AAPL	Stock	36.05	36.0675	36.05	36.0625	594760.0
2017-04-25 10:30:00	AAPL	Stock	36.0625	36.0875	36.0575	36.0762	762680.0
2017-04-25 10:35:00	AAPL	Stock	36.0762	36.1088	36.0575	36.1025	707400.0
2017-04-25 10:40:00	AAPL	Stock	36.1025	36.1075	36.08	36.1	744700.0
2017-04-25 10:45:00	AAPL	Stock	36.1	36.1025	36.0825	36.1	451556.0
2017-04-25 10:50:00	AAPL	Stock	36.0975	36.1075	36.08	36.0935	803404.0
2017-04-25 10:55:00	AAPL	Stock	36.095	36.115	36.095	36.1	616248.0
2017-04-25 11:00:00	AAPL	Stock	36.0975	36.1175	36.09	36.1125	513852.0
2017-04-25 11:05:00	AAPL	Stock	36.1125	36.1425	36.111	36.135	1199096.0
2017-04-25 11:10:00	AAPL	Stock	36.1362	36.1625	36.1325	36.1625	665892.0
2017-04-25 11:15:00	AAPL	Stock	36.1602	36.175	36.1525	36.17	1052380.0
2017-04-25 11:20:00	AAPL	Stock	36.17	36.1725	36.1525	36.1575	511620.0

> showing 50 of 363,306 rows — these rows as CSV

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