PREVIEW / stock_5min / 2017-12-13

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-12-13.parquet
  size:    5.7 MB
  rows:    372,412
  symbols: 2,938

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-12-13 04:30:00	AAPL	Stock	42.935	42.935	42.935	42.935	400.0
2017-12-13 05:35:00	AAPL	Stock	42.975	42.975	42.975	42.975	6000.0
2017-12-13 06:00:00	AAPL	Stock	42.975	42.975	42.975	42.975	2000.0
2017-12-13 06:25:00	AAPL	Stock	42.93	42.93	42.925	42.925	23456.0
2017-12-13 06:30:00	AAPL	Stock	42.925	42.925	42.925	42.925	17912.0
2017-12-13 06:45:00	AAPL	Stock	42.9625	42.9625	42.9625	42.9625	800.0
2017-12-13 07:00:00	AAPL	Stock	42.895	42.9375	42.88	42.925	2800.0
2017-12-13 07:05:00	AAPL	Stock	42.925	42.925	42.925	42.925	2644.0
2017-12-13 07:15:00	AAPL	Stock	42.9	42.9	42.9	42.9	400.0
2017-12-13 07:20:00	AAPL	Stock	42.9025	42.9025	42.9025	42.9025	3600.0
2017-12-13 07:25:00	AAPL	Stock	42.9025	42.9275	42.9025	42.9275	3192.0
2017-12-13 07:30:00	AAPL	Stock	42.93	42.96	42.925	42.925	9792.0
2017-12-13 07:35:00	AAPL	Stock	42.925	42.925	42.925	42.925	800.0
2017-12-13 07:45:00	AAPL	Stock	42.9325	42.9325	42.9325	42.9325	1280.0
2017-12-13 07:50:00	AAPL	Stock	42.9475	42.9475	42.9	42.9	8272.0
2017-12-13 07:55:00	AAPL	Stock	42.895	42.895	42.895	42.895	2000.0
2017-12-13 08:00:00	AAPL	Stock	42.9625	42.9625	42.8775	42.8925	10300.0
2017-12-13 08:05:00	AAPL	Stock	42.8925	42.9125	42.8925	42.9125	4808.0
2017-12-13 08:10:00	AAPL	Stock	42.925	42.925	42.9125	42.9125	8020.0
2017-12-13 08:20:00	AAPL	Stock	42.9375	42.9375	42.9375	42.9375	2000.0
2017-12-13 08:25:00	AAPL	Stock	42.9475	42.9625	42.9475	42.9475	9872.0
2017-12-13 08:30:00	AAPL	Stock	42.965	43.0275	42.9475	43.0275	45092.0
2017-12-13 08:35:00	AAPL	Stock	42.995	43.12	42.995	43.105	85688.0
2017-12-13 08:40:00	AAPL	Stock	43.065	43.09	43.065	43.075	31228.0
2017-12-13 08:45:00	AAPL	Stock	43.08	43.09	43.075	43.09	20200.0
2017-12-13 08:50:00	AAPL	Stock	43.1	43.1125	43.1	43.1125	14828.0
2017-12-13 08:55:00	AAPL	Stock	43.1	43.1025	43.075	43.0775	35556.0
2017-12-13 09:00:00	AAPL	Stock	43.08	43.0925	43.0775	43.0925	19400.0
2017-12-13 09:05:00	AAPL	Stock	43.0775	43.09	43.075	43.08	26160.0
2017-12-13 09:10:00	AAPL	Stock	43.08	43.17	43.08	43.17	79696.0
2017-12-13 09:15:00	AAPL	Stock	43.15	43.1725	43.1375	43.1425	58044.0
2017-12-13 09:20:00	AAPL	Stock	43.1425	43.1475	43.1225	43.1225	29768.0
2017-12-13 09:25:00	AAPL	Stock	43.1	43.1575	43.1	43.15	137544.0
2017-12-13 09:30:00	AAPL	Stock	43.1575	43.365	43.125	43.3075	6126584.0
2017-12-13 09:35:00	AAPL	Stock	43.31	43.385	43.28	43.3675	3025944.0
2017-12-13 09:40:00	AAPL	Stock	43.3675	43.38	43.2958	43.32	2188940.0
2017-12-13 09:45:00	AAPL	Stock	43.325	43.33	43.27	43.295	1366896.0
2017-12-13 09:50:00	AAPL	Stock	43.2975	43.3275	43.2825	43.325	1236200.0
2017-12-13 09:55:00	AAPL	Stock	43.3225	43.3575	43.235	43.235	1145284.0
2017-12-13 10:00:00	AAPL	Stock	43.235	43.2775	43.2225	43.2507	1158372.0
2017-12-13 10:05:00	AAPL	Stock	43.2475	43.25	43.15	43.165	1552748.0
2017-12-13 10:10:00	AAPL	Stock	43.165	43.2288	43.1625	43.2012	1126404.0
2017-12-13 10:15:00	AAPL	Stock	43.195	43.225	43.1625	43.1775	933468.0
2017-12-13 10:20:00	AAPL	Stock	43.1775	43.205	43.1575	43.18	673044.0
2017-12-13 10:25:00	AAPL	Stock	43.175	43.2075	43.1525	43.1925	941428.0
2017-12-13 10:30:00	AAPL	Stock	43.1918	43.2125	43.14	43.1875	784400.0
2017-12-13 10:35:00	AAPL	Stock	43.1875	43.2975	43.1875	43.25	1490432.0
2017-12-13 10:40:00	AAPL	Stock	43.25	43.275	43.2375	43.2525	842272.0
2017-12-13 10:45:00	AAPL	Stock	43.2537	43.255	43.195	43.2325	698264.0
2017-12-13 10:50:00	AAPL	Stock	43.235	43.255	43.2225	43.245	840184.0

> showing 50 of 372,412 rows — these rows as CSV

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