PREVIEW / stock_5min / 2017-04-03

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-04-03.parquet
  size:    5.6 MB
  rows:    370,380
  symbols: 3,068

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-03 05:20:00	AAPL	Stock	35.9	35.9075	35.9	35.9075	28228.0
2017-04-03 05:55:00	AAPL	Stock	35.91	35.91	35.91	35.91	400.0
2017-04-03 06:05:00	AAPL	Stock	35.975	35.975	35.975	35.975	2120.0
2017-04-03 06:10:00	AAPL	Stock	35.9725	35.9725	35.9725	35.9725	400.0
2017-04-03 06:25:00	AAPL	Stock	35.975	35.975	35.97	35.97	2756.0
2017-04-03 06:40:00	AAPL	Stock	35.93	35.93	35.93	35.93	496.0
2017-04-03 07:10:00	AAPL	Stock	35.9525	35.9625	35.9525	35.96	9000.0
2017-04-03 07:15:00	AAPL	Stock	35.9675	35.9675	35.9675	35.9675	1200.0
2017-04-03 07:20:00	AAPL	Stock	35.94	35.955	35.94	35.94	11020.0
2017-04-03 07:30:00	AAPL	Stock	35.94	35.94	35.94	35.94	400.0
2017-04-03 07:35:00	AAPL	Stock	35.9325	35.9325	35.9325	35.9325	2800.0
2017-04-03 07:45:00	AAPL	Stock	35.9475	35.95	35.9475	35.95	2800.0
2017-04-03 07:50:00	AAPL	Stock	35.95	35.95	35.95	35.95	4824.0
2017-04-03 07:55:00	AAPL	Stock	35.9475	35.9475	35.9375	35.9375	2000.0
2017-04-03 08:00:00	AAPL	Stock	35.9375	35.9475	35.92	35.92	23900.0
2017-04-03 08:05:00	AAPL	Stock	35.92	35.9325	35.92	35.9325	6660.0
2017-04-03 08:10:00	AAPL	Stock	35.9075	35.9075	35.8875	35.8875	15504.0
2017-04-03 08:15:00	AAPL	Stock	35.8975	35.8975	35.8975	35.8975	6464.0
2017-04-03 08:20:00	AAPL	Stock	35.9	35.92	35.9	35.92	17608.0
2017-04-03 08:25:00	AAPL	Stock	35.92	35.9225	35.92	35.9225	4000.0
2017-04-03 08:30:00	AAPL	Stock	35.905	35.905	35.9	35.9	8000.0
2017-04-03 08:35:00	AAPL	Stock	35.9075	35.93	35.9075	35.93	28028.0
2017-04-03 08:40:00	AAPL	Stock	35.91	35.93	35.91	35.925	4000.0
2017-04-03 08:45:00	AAPL	Stock	35.925	35.945	35.925	35.945	26060.0
2017-04-03 08:50:00	AAPL	Stock	35.945	35.945	35.935	35.935	3184.0
2017-04-03 08:55:00	AAPL	Stock	35.945	35.945	35.93	35.93	32564.0
2017-04-03 09:00:00	AAPL	Stock	35.925	35.9375	35.925	35.925	5004.0
2017-04-03 09:05:00	AAPL	Stock	35.93	35.9475	35.93	35.94	42228.0
2017-04-03 09:10:00	AAPL	Stock	35.9375	35.945	35.9325	35.9325	51128.0
2017-04-03 09:15:00	AAPL	Stock	35.9375	35.9375	35.9325	35.9375	10940.0
2017-04-03 09:20:00	AAPL	Stock	35.9325	35.9325	35.9325	35.9325	1200.0
2017-04-03 09:25:00	AAPL	Stock	35.9375	35.9375	35.8825	35.9125	48216.0
2017-04-03 09:30:00	AAPL	Stock	35.9275	35.95	35.8875	35.935	3723716.0
2017-04-03 09:35:00	AAPL	Stock	35.9375	35.975	35.9275	35.975	2045648.0
2017-04-03 09:40:00	AAPL	Stock	35.97	36.03	35.9625	36.015	1606752.0
2017-04-03 09:45:00	AAPL	Stock	36.015	36.02	35.99	35.9915	1382948.0
2017-04-03 09:50:00	AAPL	Stock	35.9925	35.9963	35.9575	35.965	1127352.0
2017-04-03 09:55:00	AAPL	Stock	35.9675	35.989	35.95	35.962	872624.0
2017-04-03 10:00:00	AAPL	Stock	35.96	36.015	35.96	36.015	1097212.0
2017-04-03 10:05:00	AAPL	Stock	36.0125	36.0125	35.9275	35.9325	1142884.0
2017-04-03 10:10:00	AAPL	Stock	35.9325	35.9675	35.88	35.9275	1653964.0
2017-04-03 10:15:00	AAPL	Stock	35.9272	35.9775	35.9175	35.965	1148112.0
2017-04-03 10:20:00	AAPL	Stock	35.97	35.9725	35.9475	35.9675	739652.0
2017-04-03 10:25:00	AAPL	Stock	35.9675	35.9975	35.9675	35.9925	810240.0
2017-04-03 10:30:00	AAPL	Stock	35.994	36.0075	35.965	35.9725	814640.0
2017-04-03 10:35:00	AAPL	Stock	35.97	36.0	35.965	35.995	657884.0
2017-04-03 10:40:00	AAPL	Stock	35.995	36.005	35.97	35.9978	741164.0
2017-04-03 10:45:00	AAPL	Stock	35.995	36.0075	35.9825	35.9825	727348.0
2017-04-03 10:50:00	AAPL	Stock	35.9825	35.9838	35.94	35.95	863328.0
2017-04-03 10:55:00	AAPL	Stock	35.9475	35.9625	35.915	35.925	1022160.0

> showing 50 of 370,380 rows — these rows as CSV

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