PREVIEW / stock_30min / 2016-01-11

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-11.parquet
  size:    1.6 MB
  rows:    82,931
  symbols: 3,385

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
2016-01-11 04:00:00	AAPL	Stock	24.41	24.495	24.41	24.425	47920.0
2016-01-11 04:30:00	AAPL	Stock	24.415	24.4425	24.41	24.4425	8004.0
2016-01-11 05:00:00	AAPL	Stock	24.4575	24.4575	24.4375	24.4375	2548.0
2016-01-11 05:30:00	AAPL	Stock	24.4125	24.4125	24.2975	24.3375	19580.0
2016-01-11 06:00:00	AAPL	Stock	24.325	24.4625	24.325	24.42	65656.0
2016-01-11 06:30:00	AAPL	Stock	24.46	24.4975	24.4125	24.4975	8976.0
2016-01-11 07:00:00	AAPL	Stock	24.48	24.5375	24.475	24.4875	101128.0
2016-01-11 07:30:00	AAPL	Stock	24.4925	24.4975	24.4375	24.4875	161668.0
2016-01-11 08:00:00	AAPL	Stock	24.4775	24.6375	24.4425	24.62	568524.0
2016-01-11 08:30:00	AAPL	Stock	24.6175	24.675	24.6	24.6275	395608.0
2016-01-11 09:00:00	AAPL	Stock	24.6275	24.7925	24.605	24.765	699996.0
2016-01-11 09:30:00	AAPL	Stock	24.7425	24.765	24.335	24.49	26577064.0
2016-01-11 10:00:00	AAPL	Stock	24.4875	24.615	24.45	24.53	16314420.0
2016-01-11 10:30:00	AAPL	Stock	24.5275	24.5975	24.4175	24.435	12547556.0
2016-01-11 11:00:00	AAPL	Stock	24.4325	24.52	24.375	24.46	11417112.0
2016-01-11 11:30:00	AAPL	Stock	24.4575	24.615	24.42	24.5678	10478172.0
2016-01-11 12:00:00	AAPL	Stock	24.57	24.6125	24.445	24.465	8095728.0
2016-01-11 12:30:00	AAPL	Stock	24.4625	24.5225	24.44	24.5038	8718628.0
2016-01-11 13:00:00	AAPL	Stock	24.505	24.5562	24.425	24.475	9433816.0
2016-01-11 13:30:00	AAPL	Stock	24.4775	24.505	24.395	24.4235	8608408.0
2016-01-11 14:00:00	AAPL	Stock	24.423	24.625	24.41	24.5875	11881284.0
2016-01-11 14:30:00	AAPL	Stock	24.59	24.6475	24.4825	24.5175	10691420.0
2016-01-11 15:00:00	AAPL	Stock	24.515	24.6412	24.375	24.6175	14502448.0
2016-01-11 15:30:00	AAPL	Stock	24.618	24.7138	24.58	24.6325	21595412.0
2016-01-11 16:00:00	AAPL	Stock	24.6325	24.6325	24.575	24.6125	10760388.0
2016-01-11 16:30:00	AAPL	Stock	24.6125	24.6325	24.3692	24.6175	358036.0
2016-01-11 17:00:00	AAPL	Stock	24.6175	24.6375	24.6125	24.6325	110920.0
2016-01-11 17:30:00	AAPL	Stock	24.6325	24.6375	24.6325	24.6375	32332.0
2016-01-11 18:00:00	AAPL	Stock	24.6375	24.6525	24.63	24.6375	21900.0
2016-01-11 18:30:00	AAPL	Stock	24.6425	24.6875	24.6425	24.68	43504.0
2016-01-11 19:00:00	AAPL	Stock	24.68	24.6875	24.6725	24.6825	41932.0
2016-01-11 19:30:00	AAPL	Stock	24.675	24.6875	24.6625	24.6875	50672.0
2016-01-11 04:00:00	MSFT	Stock	52.31	52.31	52.31	52.31	100.0
2016-01-11 06:00:00	MSFT	Stock	52.33	52.33	52.33	52.33	600.0
2016-01-11 08:00:00	MSFT	Stock	52.55	52.7	52.55	52.7	3989.0
2016-01-11 08:30:00	MSFT	Stock	52.65	52.66	52.6	52.63	13238.0
2016-01-11 09:00:00	MSFT	Stock	52.63	52.68	52.51	52.51	25730.0
2016-01-11 09:30:00	MSFT	Stock	52.51	52.85	52.35	52.425	3339817.0
2016-01-11 10:00:00	MSFT	Stock	52.42	52.541	52.08	52.48	2382052.0
2016-01-11 10:30:00	MSFT	Stock	52.49	52.53	52.025	52.08	1953671.0
2016-01-11 11:00:00	MSFT	Stock	52.08	52.319	52.01	52.22	1810712.0
2016-01-11 11:30:00	MSFT	Stock	52.215	52.58	52.17	52.395	1985479.0
2016-01-11 12:00:00	MSFT	Stock	52.4	52.42	51.82	51.87	2567534.0
2016-01-11 12:30:00	MSFT	Stock	51.87	52.0	51.8	51.926	1893790.0
2016-01-11 13:00:00	MSFT	Stock	51.93	52.02	51.68	51.785	2018056.0
2016-01-11 13:30:00	MSFT	Stock	51.79	51.835	51.48	51.58	1945479.0
2016-01-11 14:00:00	MSFT	Stock	51.575	52.06	51.46	51.985	2557687.0
2016-01-11 14:30:00	MSFT	Stock	51.99	52.08	51.845	51.912	1858795.0
2016-01-11 15:00:00	MSFT	Stock	51.92	52.33	51.68	52.25	2767679.0
2016-01-11 15:30:00	MSFT	Stock	52.26	52.59	52.21	52.3	4510509.0

> showing 50 of 82,931 rows — these rows as CSV

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