PREVIEW / stock_30min / 2017-06-05

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-05.parquet
  size:    1.6 MB
  rows:    81,310
  symbols: 3,050

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-05 04:00:00	AAPL	Stock	38.6	38.6	38.4875	38.5	63632.0
2017-06-05 04:30:00	AAPL	Stock	38.575	38.575	38.465	38.465	7088.0
2017-06-05 05:30:00	AAPL	Stock	38.5675	38.5675	38.545	38.545	2724.0
2017-06-05 06:00:00	AAPL	Stock	38.5275	38.5275	38.465	38.5	28388.0
2017-06-05 06:30:00	AAPL	Stock	38.525	38.54	38.5125	38.525	7208.0
2017-06-05 07:00:00	AAPL	Stock	38.535	38.575	38.51	38.5425	115612.0
2017-06-05 07:30:00	AAPL	Stock	38.545	38.575	38.5375	38.55	122336.0
2017-06-05 08:00:00	AAPL	Stock	38.57	38.8625	38.49	38.57	856456.0
2017-06-05 08:30:00	AAPL	Stock	38.5625	38.6	38.55	38.59	213980.0
2017-06-05 09:00:00	AAPL	Stock	38.58	38.6225	38.5625	38.5975	338916.0
2017-06-05 09:30:00	AAPL	Stock	38.585	38.6125	38.365	38.525	20302556.0
2017-06-05 10:00:00	AAPL	Stock	38.525	38.595	38.415	38.4625	8805828.0
2017-06-05 10:30:00	AAPL	Stock	38.4625	38.595	38.447	38.4475	6803756.0
2017-06-05 11:00:00	AAPL	Stock	38.45	38.515	38.42	38.4275	6365756.0
2017-06-05 11:30:00	AAPL	Stock	38.43	38.485	38.4225	38.455	3976816.0
2017-06-05 12:00:00	AAPL	Stock	38.4525	38.4875	38.4288	38.48	3522996.0
2017-06-05 12:30:00	AAPL	Stock	38.48	38.485	38.4325	38.4575	2978160.0
2017-06-05 13:00:00	AAPL	Stock	38.46	38.5425	38.4475	38.4963	4098120.0
2017-06-05 13:30:00	AAPL	Stock	38.495	38.5125	38.4275	38.4325	3745336.0
2017-06-05 14:00:00	AAPL	Stock	38.43	38.4575	38.415	38.4525	3541456.0
2017-06-05 14:30:00	AAPL	Stock	38.454	38.49	38.435	38.44	2993484.0
2017-06-05 15:00:00	AAPL	Stock	38.4425	38.49	38.3975	38.4625	5826824.0
2017-06-05 15:30:00	AAPL	Stock	38.46	38.49	38.4275	38.4825	8437188.0
2017-06-05 16:00:00	AAPL	Stock	38.4825	38.4925	38.4425	38.4925	6275668.0
2017-06-05 16:30:00	AAPL	Stock	38.4825	38.5025	38.48	38.485	142388.0
2017-06-05 17:00:00	AAPL	Stock	38.4975	38.4975	38.475	38.475	42116.0
2017-06-05 17:30:00	AAPL	Stock	38.475	38.4825	38.465	38.475	42936.0
2017-06-05 18:00:00	AAPL	Stock	38.4725	38.4825	38.4725	38.475	7192.0
2017-06-05 18:30:00	AAPL	Stock	38.475	38.5	38.475	38.5	56916.0
2017-06-05 19:00:00	AAPL	Stock	38.48	38.4975	38.48	38.495	14560.0
2017-06-05 19:30:00	AAPL	Stock	38.4875	38.5	38.4775	38.5	43128.0
2017-06-05 07:00:00	MSFT	Stock	71.98	71.99	71.43	71.43	1393.0
2017-06-05 07:30:00	MSFT	Stock	71.91	71.91	71.83	71.83	1128.0
2017-06-05 08:00:00	MSFT	Stock	71.76	71.76	71.76	71.76	25914.0
2017-06-05 08:30:00	MSFT	Stock	71.73	71.73	71.68	71.68	2778.0
2017-06-05 09:00:00	MSFT	Stock	71.7	71.94	71.61	71.94	8433.0
2017-06-05 09:30:00	MSFT	Stock	71.97	72.418	71.81	72.38	3074885.0
2017-06-05 10:00:00	MSFT	Stock	72.38	72.61	72.31	72.595	2459051.0
2017-06-05 10:30:00	MSFT	Stock	72.6	72.89	72.59	72.61	2648094.0
2017-06-05 11:00:00	MSFT	Stock	72.615	72.81	72.615	72.71	2248999.0
2017-06-05 11:30:00	MSFT	Stock	72.715	72.74	72.51	72.68	1503524.0
2017-06-05 12:00:00	MSFT	Stock	72.69	72.78	72.52	72.54	909375.0
2017-06-05 12:30:00	MSFT	Stock	72.54	72.545	72.24	72.3	1312553.0
2017-06-05 13:00:00	MSFT	Stock	72.31	72.485	72.29	72.36	1185334.0
2017-06-05 13:30:00	MSFT	Stock	72.36	72.39	72.265	72.288	949585.0
2017-06-05 14:00:00	MSFT	Stock	72.29	72.455	72.255	72.42	1373568.0
2017-06-05 14:30:00	MSFT	Stock	72.42	72.44	72.34	72.36	1097115.0
2017-06-05 15:00:00	MSFT	Stock	72.37	72.445	72.32	72.37	1285681.0
2017-06-05 15:30:00	MSFT	Stock	72.37	72.435	72.27	72.28	4768264.0
2017-06-05 16:00:00	MSFT	Stock	72.29	72.32	72.28	72.28	4919767.0

> showing 50 of 81,310 rows — these rows as CSV

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