PREVIEW / stock_5min / 2018-06-28

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-06-28.parquet
  size:    5.6 MB
  rows:    365,153
  symbols: 2,840

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
2018-06-28 04:40:00	AAPL	Stock	46.1925	46.1925	46.1925	46.1925	1800.0
2018-06-28 04:45:00	AAPL	Stock	46.18	46.18	46.1675	46.1675	12800.0
2018-06-28 05:30:00	AAPL	Stock	46.1875	46.1875	46.175	46.175	3976.0
2018-06-28 05:35:00	AAPL	Stock	46.175	46.175	46.15	46.15	4492.0
2018-06-28 05:55:00	AAPL	Stock	46.15	46.15	46.15	46.15	400.0
2018-06-28 06:05:00	AAPL	Stock	46.15	46.15	46.15	46.15	1612.0
2018-06-28 06:25:00	AAPL	Stock	46.1875	46.1875	46.1875	46.1875	2192.0
2018-06-28 06:40:00	AAPL	Stock	46.2475	46.2475	46.2475	46.2475	1908.0
2018-06-28 07:00:00	AAPL	Stock	46.2175	46.23	46.2075	46.2075	52604.0
2018-06-28 07:05:00	AAPL	Stock	46.2125	46.2125	46.175	46.175	17748.0
2018-06-28 07:10:00	AAPL	Stock	46.17	46.2425	46.1625	46.2425	24420.0
2018-06-28 07:15:00	AAPL	Stock	46.2325	46.2325	46.2225	46.2225	7180.0
2018-06-28 07:20:00	AAPL	Stock	46.2225	46.225	46.2225	46.225	3428.0
2018-06-28 07:25:00	AAPL	Stock	46.2175	46.2175	46.175	46.175	21892.0
2018-06-28 07:30:00	AAPL	Stock	46.2	46.2	46.2	46.2	15064.0
2018-06-28 07:35:00	AAPL	Stock	46.225	46.24	46.225	46.24	1856.0
2018-06-28 07:40:00	AAPL	Stock	46.18	46.18	46.18	46.18	600.0
2018-06-28 07:45:00	AAPL	Stock	46.1625	46.1625	46.1375	46.1375	1600.0
2018-06-28 07:50:00	AAPL	Stock	46.1525	46.175	46.1525	46.175	1600.0
2018-06-28 07:55:00	AAPL	Stock	46.1575	46.17	46.1525	46.17	2000.0
2018-06-28 08:00:00	AAPL	Stock	46.22	46.2445	46.13	46.13	53700.0
2018-06-28 08:05:00	AAPL	Stock	46.1325	46.1325	46.075	46.11	20620.0
2018-06-28 08:10:00	AAPL	Stock	46.11	46.11	46.0625	46.0625	9200.0
2018-06-28 08:15:00	AAPL	Stock	46.09	46.09	45.9125	45.93	30728.0
2018-06-28 08:20:00	AAPL	Stock	45.9525	46.005	45.9325	45.9625	4400.0
2018-06-28 08:25:00	AAPL	Stock	45.975	45.975	45.9575	45.975	9816.0
2018-06-28 08:30:00	AAPL	Stock	45.965	45.9775	45.9175	45.9775	34916.0
2018-06-28 08:35:00	AAPL	Stock	46.0	46.0025	45.935	45.95	36812.0
2018-06-28 08:40:00	AAPL	Stock	45.9975	45.9975	45.955	45.9975	12364.0
2018-06-28 08:45:00	AAPL	Stock	45.985	46.025	45.985	46.015	14400.0
2018-06-28 08:50:00	AAPL	Stock	45.9975	46.0	45.9625	45.9625	11500.0
2018-06-28 08:55:00	AAPL	Stock	45.9575	45.975	45.91	45.91	38180.0
2018-06-28 09:00:00	AAPL	Stock	45.91	45.915	45.855	45.875	146724.0
2018-06-28 09:05:00	AAPL	Stock	45.87	45.9125	45.855	45.8775	66624.0
2018-06-28 09:10:00	AAPL	Stock	45.875	45.9025	45.86	45.9025	35060.0
2018-06-28 09:15:00	AAPL	Stock	45.895	45.9125	45.8775	45.9125	29400.0
2018-06-28 09:20:00	AAPL	Stock	45.9575	45.9575	45.9425	45.9425	2400.0
2018-06-28 09:25:00	AAPL	Stock	45.95	46.0275	45.95	46.0075	42784.0
2018-06-28 09:30:00	AAPL	Stock	46.0225	46.25	45.95	46.1925	2734576.0
2018-06-28 09:35:00	AAPL	Stock	46.19	46.23	46.1525	46.2075	1136740.0
2018-06-28 09:40:00	AAPL	Stock	46.2075	46.2975	46.15	46.195	1551704.0
2018-06-28 09:45:00	AAPL	Stock	46.1925	46.1998	46.04	46.1075	1510636.0
2018-06-28 09:50:00	AAPL	Stock	46.1025	46.2675	46.085	46.2425	1268896.0
2018-06-28 09:55:00	AAPL	Stock	46.2375	46.2875	46.2	46.25	1240832.0
2018-06-28 10:00:00	AAPL	Stock	46.2575	46.2875	46.13	46.1575	813124.0
2018-06-28 10:05:00	AAPL	Stock	46.1625	46.27	46.1525	46.2345	743128.0
2018-06-28 10:10:00	AAPL	Stock	46.2325	46.2725	46.1275	46.2325	1138272.0
2018-06-28 10:15:00	AAPL	Stock	46.2325	46.2525	46.17	46.1925	1080804.0
2018-06-28 10:20:00	AAPL	Stock	46.195	46.27	46.14	46.2575	1101204.0
2018-06-28 10:25:00	AAPL	Stock	46.2525	46.3198	46.17	46.195	932016.0

> showing 50 of 365,153 rows — these rows as CSV

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