PREVIEW / stock_5min / 2017-12-06

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-12-06.parquet
  size:    5.5 MB
  rows:    359,495
  symbols: 2,941

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-06 04:00:00	AAPL	Stock	42.24	42.24	42.24	42.24	1496.0
2017-12-06 04:45:00	AAPL	Stock	42.25	42.25	42.25	42.25	400.0
2017-12-06 05:20:00	AAPL	Stock	42.235	42.235	42.2	42.2	6380.0
2017-12-06 05:35:00	AAPL	Stock	42.1875	42.1875	42.1825	42.1825	2800.0
2017-12-06 06:10:00	AAPL	Stock	42.1875	42.1875	42.1875	42.1875	800.0
2017-12-06 06:15:00	AAPL	Stock	42.15	42.1525	42.14	42.14	7256.0
2017-12-06 06:25:00	AAPL	Stock	42.1675	42.1675	42.1675	42.1675	2808.0
2017-12-06 06:30:00	AAPL	Stock	42.235	42.235	42.235	42.235	800.0
2017-12-06 06:55:00	AAPL	Stock	42.18	42.18	42.1675	42.1675	4000.0
2017-12-06 07:00:00	AAPL	Stock	42.225	42.25	42.2175	42.25	38088.0
2017-12-06 07:05:00	AAPL	Stock	42.225	42.225	42.2125	42.22	25332.0
2017-12-06 07:10:00	AAPL	Stock	42.205	42.205	42.2	42.2	3480.0
2017-12-06 07:15:00	AAPL	Stock	42.225	42.225	42.2	42.2	1600.0
2017-12-06 07:20:00	AAPL	Stock	42.2125	42.2125	42.1925	42.1925	5180.0
2017-12-06 07:25:00	AAPL	Stock	42.19	42.19	42.165	42.165	2616.0
2017-12-06 07:30:00	AAPL	Stock	42.165	42.165	42.1625	42.1625	5600.0
2017-12-06 07:40:00	AAPL	Stock	42.1875	42.2175	42.1875	42.2175	9800.0
2017-12-06 07:45:00	AAPL	Stock	42.2175	42.225	42.2	42.21	74100.0
2017-12-06 07:50:00	AAPL	Stock	42.2	42.2425	42.175	42.24	33140.0
2017-12-06 07:55:00	AAPL	Stock	42.215	42.215	42.1675	42.1675	18340.0
2017-12-06 08:00:00	AAPL	Stock	42.19	42.25	42.1625	42.1625	39172.0
2017-12-06 08:05:00	AAPL	Stock	42.1525	42.175	42.1175	42.175	67764.0
2017-12-06 08:10:00	AAPL	Stock	42.175	42.1825	42.1375	42.14	63944.0
2017-12-06 08:15:00	AAPL	Stock	42.14	42.145	42.0625	42.0875	111844.0
2017-12-06 08:20:00	AAPL	Stock	42.1	42.1	42.0275	42.0275	82356.0
2017-12-06 08:25:00	AAPL	Stock	42.06	42.06	41.9775	42.015	97912.0
2017-12-06 08:30:00	AAPL	Stock	42.025	42.0725	42.025	42.0375	60648.0
2017-12-06 08:35:00	AAPL	Stock	42.0375	42.0925	42.0375	42.0925	22768.0
2017-12-06 08:40:00	AAPL	Stock	42.0875	42.0875	42.05	42.085	19420.0
2017-12-06 08:45:00	AAPL	Stock	42.0825	42.0825	42.065	42.065	38824.0
2017-12-06 08:50:00	AAPL	Stock	42.055	42.0875	42.0375	42.0375	28152.0
2017-12-06 08:55:00	AAPL	Stock	42.0375	42.0875	42.0375	42.0875	27500.0
2017-12-06 09:00:00	AAPL	Stock	42.09	42.175	42.08	42.0975	124764.0
2017-12-06 09:05:00	AAPL	Stock	42.08	42.0875	42.0275	42.03	82920.0
2017-12-06 09:10:00	AAPL	Stock	42.035	42.0625	42.0325	42.0625	35772.0
2017-12-06 09:15:00	AAPL	Stock	42.05	42.0625	42.025	42.0375	55588.0
2017-12-06 09:20:00	AAPL	Stock	42.02	42.02	41.925	41.95	175272.0
2017-12-06 09:25:00	AAPL	Stock	41.955	41.985	41.835	41.8475	326692.0
2017-12-06 09:30:00	AAPL	Stock	41.875	42.1475	41.615	42.09	10365196.0
2017-12-06 09:35:00	AAPL	Stock	42.0825	42.2425	41.9825	42.2038	4462164.0
2017-12-06 09:40:00	AAPL	Stock	42.2	42.205	42.1175	42.17	2847208.0
2017-12-06 09:45:00	AAPL	Stock	42.1725	42.175	41.9625	41.97	2783016.0
2017-12-06 09:50:00	AAPL	Stock	41.965	42.2338	41.9525	42.175	2423824.0
2017-12-06 09:55:00	AAPL	Stock	42.1702	42.305	42.17	42.2825	2211700.0
2017-12-06 10:00:00	AAPL	Stock	42.2812	42.375	42.2325	42.245	2486800.0
2017-12-06 10:05:00	AAPL	Stock	42.24	42.295	42.195	42.2745	1470308.0
2017-12-06 10:10:00	AAPL	Stock	42.27	42.2875	42.145	42.155	1496588.0
2017-12-06 10:15:00	AAPL	Stock	42.1575	42.26	42.14	42.2525	943816.0
2017-12-06 10:20:00	AAPL	Stock	42.26	42.3125	42.24	42.2488	962708.0
2017-12-06 10:25:00	AAPL	Stock	42.25	42.3475	42.23	42.323	1098880.0

> showing 50 of 359,495 rows — these rows as CSV

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