PREVIEW / stock_5min / 2017-04-26

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-04-26.parquet
  size:    5.5 MB
  rows:    362,938
  symbols: 3,051

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-26 04:00:00	AAPL	Stock	36.18	36.18	36.18	36.18	400.0
2017-04-26 04:15:00	AAPL	Stock	36.1775	36.18	36.1775	36.18	3828.0
2017-04-26 04:20:00	AAPL	Stock	36.185	36.185	36.185	36.185	400.0
2017-04-26 04:55:00	AAPL	Stock	36.185	36.2	36.185	36.2	6720.0
2017-04-26 05:10:00	AAPL	Stock	36.1975	36.1975	36.1975	36.1975	560.0
2017-04-26 05:20:00	AAPL	Stock	36.1975	36.1975	36.1975	36.1975	896.0
2017-04-26 05:30:00	AAPL	Stock	36.1975	36.1975	36.1975	36.1975	440.0
2017-04-26 05:35:00	AAPL	Stock	36.1975	36.225	36.1875	36.1875	10516.0
2017-04-26 05:45:00	AAPL	Stock	36.1975	36.1975	36.1975	36.1975	1200.0
2017-04-26 06:00:00	AAPL	Stock	36.1975	36.1975	36.1975	36.1975	1644.0
2017-04-26 06:05:00	AAPL	Stock	36.215	36.2175	36.215	36.215	6000.0
2017-04-26 06:20:00	AAPL	Stock	36.1975	36.215	36.175	36.175	12048.0
2017-04-26 06:30:00	AAPL	Stock	36.1875	36.1875	36.1875	36.1875	560.0
2017-04-26 06:35:00	AAPL	Stock	36.17	36.17	36.1625	36.1625	15288.0
2017-04-26 06:45:00	AAPL	Stock	36.1625	36.1625	36.1625	36.1625	400.0
2017-04-26 06:55:00	AAPL	Stock	36.1575	36.1575	36.1575	36.1575	400.0
2017-04-26 07:00:00	AAPL	Stock	36.1375	36.14	36.1375	36.1375	6272.0
2017-04-26 07:05:00	AAPL	Stock	36.14	36.14	36.125	36.125	4016.0
2017-04-26 07:15:00	AAPL	Stock	36.1375	36.14	36.1375	36.14	9820.0
2017-04-26 07:20:00	AAPL	Stock	36.125	36.1375	36.125	36.125	8432.0
2017-04-26 07:30:00	AAPL	Stock	36.1	36.1025	36.0925	36.0925	11600.0
2017-04-26 07:35:00	AAPL	Stock	36.11	36.125	36.1	36.1	9924.0
2017-04-26 07:40:00	AAPL	Stock	36.105	36.105	36.1	36.1025	27804.0
2017-04-26 07:45:00	AAPL	Stock	36.1025	36.1025	36.1025	36.1025	12384.0
2017-04-26 07:55:00	AAPL	Stock	36.125	36.1725	36.125	36.15	30428.0
2017-04-26 08:00:00	AAPL	Stock	36.125	36.175	36.1	36.15	47168.0
2017-04-26 08:05:00	AAPL	Stock	36.1325	36.1375	36.1275	36.1375	10800.0
2017-04-26 08:10:00	AAPL	Stock	36.1375	36.1375	36.1375	36.1375	2392.0
2017-04-26 08:15:00	AAPL	Stock	36.1375	36.1375	36.1375	36.1375	400.0
2017-04-26 08:20:00	AAPL	Stock	36.15	36.15	36.15	36.15	1196.0
2017-04-26 08:25:00	AAPL	Stock	36.1475	36.1475	36.1475	36.1475	6000.0
2017-04-26 08:30:00	AAPL	Stock	36.15	36.15	36.1275	36.14	71328.0
2017-04-26 08:35:00	AAPL	Stock	36.15	36.1525	36.1375	36.1375	9200.0
2017-04-26 08:40:00	AAPL	Stock	36.1375	36.1375	36.1	36.1025	87896.0
2017-04-26 08:45:00	AAPL	Stock	36.1125	36.1325	36.105	36.1325	21648.0
2017-04-26 08:50:00	AAPL	Stock	36.125	36.14	36.1175	36.1175	19380.0
2017-04-26 08:55:00	AAPL	Stock	36.125	36.135	36.11	36.135	14076.0
2017-04-26 09:00:00	AAPL	Stock	36.1325	36.135	36.1075	36.1325	8468.0
2017-04-26 09:05:00	AAPL	Stock	36.125	36.13	36.1125	36.13	7400.0
2017-04-26 09:10:00	AAPL	Stock	36.125	36.1325	36.1175	36.1325	6184.0
2017-04-26 09:15:00	AAPL	Stock	36.125	36.1375	36.125	36.1325	4664.0
2017-04-26 09:20:00	AAPL	Stock	36.1375	36.1375	36.12	36.12	4800.0
2017-04-26 09:25:00	AAPL	Stock	36.125	36.125	36.0975	36.1225	84980.0
2017-04-26 09:30:00	AAPL	Stock	36.1225	36.1425	36.015	36.1	3574312.0
2017-04-26 09:35:00	AAPL	Stock	36.1025	36.135	36.0875	36.121	1628832.0
2017-04-26 09:40:00	AAPL	Stock	36.1208	36.15	36.1	36.1075	1387040.0
2017-04-26 09:45:00	AAPL	Stock	36.11	36.135	36.1025	36.1225	1349260.0
2017-04-26 09:50:00	AAPL	Stock	36.125	36.125	36.0875	36.1025	1017420.0
2017-04-26 09:55:00	AAPL	Stock	36.1075	36.1125	36.08	36.1	830164.0
2017-04-26 10:00:00	AAPL	Stock	36.1	36.1088	36.065	36.0675	1022248.0

> showing 50 of 362,938 rows — these rows as CSV

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