PREVIEW / stock_30min / 2018-04-18

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-18.parquet
  size:    1.7 MB
  rows:    83,498
  symbols: 2,855

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-04-18 04:00:00	AAPL	Stock	44.685	44.685	44.685	44.685	400.0
2018-04-18 04:30:00	AAPL	Stock	44.595	44.595	44.595	44.595	800.0
2018-04-18 05:00:00	AAPL	Stock	44.625	44.625	44.585	44.585	1600.0
2018-04-18 05:30:00	AAPL	Stock	44.54	44.54	44.54	44.54	2000.0
2018-04-18 06:00:00	AAPL	Stock	44.5425	44.5425	44.5375	44.5375	3348.0
2018-04-18 06:30:00	AAPL	Stock	44.6225	44.625	44.6225	44.625	5512.0
2018-04-18 07:00:00	AAPL	Stock	44.6	44.685	44.6	44.675	29960.0
2018-04-18 07:30:00	AAPL	Stock	44.6575	44.6575	44.6125	44.62	30220.0
2018-04-18 08:00:00	AAPL	Stock	44.625	44.6875	44.575	44.5875	82628.0
2018-04-18 08:30:00	AAPL	Stock	44.5875	44.5875	44.53	44.55	51800.0
2018-04-18 09:00:00	AAPL	Stock	44.565	44.575	44.445	44.445	181524.0
2018-04-18 09:30:00	AAPL	Stock	44.445	44.705	44.3975	44.4238	11360088.0
2018-04-18 10:00:00	AAPL	Stock	44.425	44.4325	44.22	44.305	8262572.0
2018-04-18 10:30:00	AAPL	Stock	44.305	44.426	44.2525	44.4225	5201412.0
2018-04-18 11:00:00	AAPL	Stock	44.4212	44.51	44.41	44.4752	5087940.0
2018-04-18 11:30:00	AAPL	Stock	44.475	44.5325	44.445	44.4875	3668400.0
2018-04-18 12:00:00	AAPL	Stock	44.4862	44.5825	44.4862	44.525	2997408.0
2018-04-18 12:30:00	AAPL	Stock	44.5275	44.5525	44.43	44.475	2682536.0
2018-04-18 13:00:00	AAPL	Stock	44.475	44.5775	44.4675	44.556	2600820.0
2018-04-18 13:30:00	AAPL	Stock	44.555	44.5625	44.475	44.4815	3109424.0
2018-04-18 14:00:00	AAPL	Stock	44.485	44.6575	44.445	44.6172	4409560.0
2018-04-18 14:30:00	AAPL	Stock	44.615	44.66	44.575	44.5765	3424416.0
2018-04-18 15:00:00	AAPL	Stock	44.5788	44.685	44.5515	44.57	3678504.0
2018-04-18 15:30:00	AAPL	Stock	44.57	44.5825	44.44	44.46	7792776.0
2018-04-18 16:00:00	AAPL	Stock	44.46	44.638	44.4475	44.45	9557428.0
2018-04-18 16:30:00	AAPL	Stock	44.45	44.4975	44.45	44.4975	20072.0
2018-04-18 17:00:00	AAPL	Stock	44.4775	44.5125	44.475	44.5125	28324.0
2018-04-18 17:30:00	AAPL	Stock	44.5075	44.5525	44.5075	44.515	23584.0
2018-04-18 18:00:00	AAPL	Stock	44.5125	44.5125	44.5075	44.5125	12152.0
2018-04-18 18:30:00	AAPL	Stock	44.52	44.52	44.495	44.495	4000.0
2018-04-18 19:00:00	AAPL	Stock	44.5125	44.5125	44.5	44.505	4460.0
2018-04-18 19:30:00	AAPL	Stock	44.525	44.55	44.51	44.55	16372.0
2018-04-18 04:00:00	MSFT	Stock	96.39	96.39	96.39	96.39	100.0
2018-04-18 05:30:00	MSFT	Stock	96.34	96.34	96.34	96.34	768.0
2018-04-18 06:00:00	MSFT	Stock	96.34	96.34	96.34	96.34	1311.0
2018-04-18 06:30:00	MSFT	Stock	96.38	96.39	96.38	96.39	900.0
2018-04-18 07:00:00	MSFT	Stock	96.4	96.5	96.37	96.5	1236.0
2018-04-18 07:30:00	MSFT	Stock	96.52	96.52	96.5	96.5	1874.0
2018-04-18 08:00:00	MSFT	Stock	96.59	96.59	96.35	96.4	14331.0
2018-04-18 08:30:00	MSFT	Stock	96.49	96.49	96.4	96.49	3750.0
2018-04-18 09:00:00	MSFT	Stock	96.483	96.49	96.2	96.2	14789.0
2018-04-18 09:30:00	MSFT	Stock	96.2	96.68	95.88	96.06	2402341.0
2018-04-18 10:00:00	MSFT	Stock	96.06	96.1	95.52	95.88	2060208.0
2018-04-18 10:30:00	MSFT	Stock	95.89	96.23	95.85	96.09	1719757.0
2018-04-18 11:00:00	MSFT	Stock	96.1	96.24	95.98	96.03	1171566.0
2018-04-18 11:30:00	MSFT	Stock	96.04	96.29	95.985	96.175	1000628.0
2018-04-18 12:00:00	MSFT	Stock	96.18	96.68	96.18	96.63	1491365.0
2018-04-18 12:30:00	MSFT	Stock	96.61	96.66	96.436	96.546	1253544.0
2018-04-18 13:00:00	MSFT	Stock	96.545	96.59	96.39	96.406	635516.0
2018-04-18 13:30:00	MSFT	Stock	96.405	96.44	96.255	96.3	677237.0

> showing 50 of 83,498 rows — these rows as CSV

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