PREVIEW / stock_5min / 2017-09-06

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-06.parquet
  size:    5.4 MB
  rows:    354,395
  symbols: 2,983

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-06 04:00:00	AAPL	Stock	40.605	40.605	40.605	40.605	15588.0
2017-09-06 04:45:00	AAPL	Stock	40.6725	40.6725	40.6725	40.6725	1956.0
2017-09-06 05:05:00	AAPL	Stock	40.6275	40.6275	40.625	40.625	4560.0
2017-09-06 05:35:00	AAPL	Stock	40.605	40.605	40.605	40.605	800.0
2017-09-06 05:50:00	AAPL	Stock	40.605	40.605	40.605	40.605	5884.0
2017-09-06 05:55:00	AAPL	Stock	40.6175	40.6175	40.6175	40.6175	400.0
2017-09-06 06:00:00	AAPL	Stock	40.6725	40.6875	40.6725	40.6875	15672.0
2017-09-06 06:20:00	AAPL	Stock	40.67	40.67	40.67	40.67	400.0
2017-09-06 06:30:00	AAPL	Stock	40.65	40.65	40.65	40.65	800.0
2017-09-06 06:40:00	AAPL	Stock	40.6025	40.6025	40.6	40.6	2772.0
2017-09-06 06:45:00	AAPL	Stock	40.595	40.595	40.585	40.585	4800.0
2017-09-06 06:55:00	AAPL	Stock	40.585	40.585	40.5625	40.5625	2892.0
2017-09-06 07:00:00	AAPL	Stock	40.5825	40.595	40.5775	40.595	18772.0
2017-09-06 07:05:00	AAPL	Stock	40.595	40.6125	40.595	40.6125	8792.0
2017-09-06 07:10:00	AAPL	Stock	40.6125	40.625	40.61	40.61	8500.0
2017-09-06 07:15:00	AAPL	Stock	40.625	40.625	40.6125	40.6125	800.0
2017-09-06 07:20:00	AAPL	Stock	40.6125	40.625	40.6125	40.625	3012.0
2017-09-06 07:25:00	AAPL	Stock	40.645	40.645	40.645	40.645	3992.0
2017-09-06 07:30:00	AAPL	Stock	40.6425	40.6425	40.6425	40.6425	400.0
2017-09-06 07:40:00	AAPL	Stock	40.615	40.615	40.6125	40.6125	2000.0
2017-09-06 07:45:00	AAPL	Stock	40.6325	40.6475	40.63	40.6475	5200.0
2017-09-06 07:50:00	AAPL	Stock	40.6325	40.6325	40.6075	40.6075	24260.0
2017-09-06 07:55:00	AAPL	Stock	40.6075	40.625	40.6075	40.625	2136.0
2017-09-06 08:00:00	AAPL	Stock	40.6375	40.66	40.5875	40.655	65944.0
2017-09-06 08:05:00	AAPL	Stock	40.65	40.6525	40.64	40.65	15700.0
2017-09-06 08:10:00	AAPL	Stock	40.6525	40.6525	40.625	40.625	15384.0
2017-09-06 08:15:00	AAPL	Stock	40.625	40.6325	40.625	40.6325	9292.0
2017-09-06 08:20:00	AAPL	Stock	40.625	40.6475	40.625	40.635	28032.0
2017-09-06 08:25:00	AAPL	Stock	40.645	40.65	40.6425	40.645	15248.0
2017-09-06 08:30:00	AAPL	Stock	40.65	40.65	40.65	40.65	400.0
2017-09-06 08:35:00	AAPL	Stock	40.6375	40.6375	40.6125	40.6225	32236.0
2017-09-06 08:40:00	AAPL	Stock	40.6225	40.635	40.6225	40.63	14712.0
2017-09-06 08:45:00	AAPL	Stock	40.635	40.6425	40.63	40.64	45680.0
2017-09-06 08:50:00	AAPL	Stock	40.64	40.65	40.64	40.65	34164.0
2017-09-06 08:55:00	AAPL	Stock	40.66	40.675	40.66	40.6625	43828.0
2017-09-06 09:00:00	AAPL	Stock	40.6625	40.6675	40.6425	40.65	24536.0
2017-09-06 09:05:00	AAPL	Stock	40.6675	40.675	40.6675	40.6725	11808.0
2017-09-06 09:10:00	AAPL	Stock	40.675	40.675	40.6625	40.665	16716.0
2017-09-06 09:15:00	AAPL	Stock	40.665	40.6825	40.665	40.665	26556.0
2017-09-06 09:20:00	AAPL	Stock	40.68	40.695	40.675	40.675	20084.0
2017-09-06 09:25:00	AAPL	Stock	40.69	40.69	40.675	40.675	17636.0
2017-09-06 09:30:00	AAPL	Stock	40.6775	40.7475	40.6575	40.6625	3487700.0
2017-09-06 09:35:00	AAPL	Stock	40.6575	40.685	40.5525	40.5812	2250960.0
2017-09-06 09:40:00	AAPL	Stock	40.575	40.625	40.5125	40.5475	1900752.0
2017-09-06 09:45:00	AAPL	Stock	40.5425	40.625	40.5425	40.585	1374592.0
2017-09-06 09:50:00	AAPL	Stock	40.585	40.6125	40.535	40.57	1178156.0
2017-09-06 09:55:00	AAPL	Stock	40.57	40.6225	40.5325	40.595	882168.0
2017-09-06 10:00:00	AAPL	Stock	40.5938	40.625	40.5775	40.5875	1041508.0
2017-09-06 10:05:00	AAPL	Stock	40.5885	40.6415	40.575	40.6125	1088384.0
2017-09-06 10:10:00	AAPL	Stock	40.6125	40.645	40.5475	40.55	1372228.0

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

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