PREVIEW / stock_5min / 2017-06-21

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-21.parquet
  size:    5.4 MB
  rows:    349,820
  symbols: 3,021

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-06-21 04:00:00	AAPL	Stock	36.17	36.17	36.17	36.17	400.0
2017-06-21 04:20:00	AAPL	Stock	36.0875	36.0875	36.0875	36.0875	800.0
2017-06-21 04:40:00	AAPL	Stock	36.1475	36.175	36.1475	36.175	5620.0
2017-06-21 05:25:00	AAPL	Stock	36.1475	36.1475	36.135	36.135	12260.0
2017-06-21 05:30:00	AAPL	Stock	36.1475	36.1475	36.1475	36.1475	3948.0
2017-06-21 05:35:00	AAPL	Stock	36.1475	36.1475	36.135	36.135	6000.0
2017-06-21 05:40:00	AAPL	Stock	36.135	36.135	36.135	36.135	416.0
2017-06-21 05:45:00	AAPL	Stock	36.135	36.135	36.135	36.135	400.0
2017-06-21 06:00:00	AAPL	Stock	36.1275	36.1275	36.1	36.1	3156.0
2017-06-21 06:45:00	AAPL	Stock	36.1275	36.1275	36.1275	36.1275	1200.0
2017-06-21 06:50:00	AAPL	Stock	36.14	36.1625	36.125	36.1625	4160.0
2017-06-21 06:55:00	AAPL	Stock	36.1825	36.1825	36.1825	36.1825	720.0
2017-06-21 07:00:00	AAPL	Stock	36.1875	36.1875	36.1875	36.1875	1988.0
2017-06-21 07:05:00	AAPL	Stock	36.185	36.1875	36.185	36.1875	1600.0
2017-06-21 07:10:00	AAPL	Stock	36.1875	36.1875	36.1875	36.1875	400.0
2017-06-21 07:15:00	AAPL	Stock	36.175	36.175	36.175	36.175	2700.0
2017-06-21 07:20:00	AAPL	Stock	36.165	36.165	36.165	36.165	400.0
2017-06-21 07:30:00	AAPL	Stock	36.1525	36.1525	36.1525	36.1525	800.0
2017-06-21 07:35:00	AAPL	Stock	36.15	36.15	36.15	36.15	1564.0
2017-06-21 07:50:00	AAPL	Stock	36.185	36.185	36.185	36.185	936.0
2017-06-21 07:55:00	AAPL	Stock	36.185	36.1875	36.1825	36.1875	7732.0
2017-06-21 08:00:00	AAPL	Stock	36.2075	36.21	36.125	36.2025	31816.0
2017-06-21 08:05:00	AAPL	Stock	36.23	36.23	36.23	36.23	440.0
2017-06-21 08:10:00	AAPL	Stock	36.21	36.21	36.21	36.21	2100.0
2017-06-21 08:15:00	AAPL	Stock	36.225	36.275	36.225	36.275	11212.0
2017-06-21 08:20:00	AAPL	Stock	36.29	36.3125	36.29	36.3125	14500.0
2017-06-21 08:25:00	AAPL	Stock	36.33	36.3325	36.3275	36.3275	9488.0
2017-06-21 08:30:00	AAPL	Stock	36.3275	36.3425	36.325	36.3425	6176.0
2017-06-21 08:35:00	AAPL	Stock	36.3425	36.3575	36.3275	36.3275	45840.0
2017-06-21 08:40:00	AAPL	Stock	36.3275	36.33	36.3275	36.33	3340.0
2017-06-21 08:45:00	AAPL	Stock	36.3375	36.35	36.3275	36.345	18628.0
2017-06-21 08:50:00	AAPL	Stock	36.345	36.345	36.345	36.345	5748.0
2017-06-21 08:55:00	AAPL	Stock	36.3575	36.3575	36.345	36.345	13296.0
2017-06-21 09:00:00	AAPL	Stock	36.3375	36.365	36.3375	36.365	50408.0
2017-06-21 09:05:00	AAPL	Stock	36.365	36.3825	36.365	36.375	24288.0
2017-06-21 09:10:00	AAPL	Stock	36.375	36.38	36.37	36.3725	6196.0
2017-06-21 09:15:00	AAPL	Stock	36.375	36.385	36.375	36.385	15748.0
2017-06-21 09:20:00	AAPL	Stock	36.3775	36.3775	36.37	36.375	3240.0
2017-06-21 09:25:00	AAPL	Stock	36.39	36.4	36.3425	36.385	43612.0
2017-06-21 09:30:00	AAPL	Stock	36.38	36.4325	36.29	36.335	2650544.0
2017-06-21 09:35:00	AAPL	Stock	36.3325	36.3412	36.2675	36.2755	1356792.0
2017-06-21 09:40:00	AAPL	Stock	36.2782	36.295	36.1975	36.255	1773592.0
2017-06-21 09:45:00	AAPL	Stock	36.25	36.28	36.2	36.215	1258796.0
2017-06-21 09:50:00	AAPL	Stock	36.2125	36.255	36.1525	36.1625	1554420.0
2017-06-21 09:55:00	AAPL	Stock	36.1625	36.2	36.16	36.1925	887936.0
2017-06-21 10:00:00	AAPL	Stock	36.1925	36.2975	36.1875	36.255	1732880.0
2017-06-21 10:05:00	AAPL	Stock	36.255	36.2975	36.2425	36.2772	1191928.0
2017-06-21 10:10:00	AAPL	Stock	36.28	36.325	36.2775	36.2925	1191868.0
2017-06-21 10:15:00	AAPL	Stock	36.2925	36.3	36.2585	36.265	710092.0
2017-06-21 10:20:00	AAPL	Stock	36.2638	36.305	36.245	36.285	790324.0

> showing 50 of 349,820 rows — these rows as CSV

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