PREVIEW / stock_30min / 2016-05-17

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-17.parquet
  size:    1.6 MB
  rows:    83,089
  symbols: 3,324

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-05-17 04:00:00	AAPL	Stock	23.5	23.75	23.5	23.675	72460.0
2016-05-17 04:30:00	AAPL	Stock	23.7	23.7	23.6975	23.7	23408.0
2016-05-17 05:00:00	AAPL	Stock	23.6975	23.7125	23.665	23.665	150252.0
2016-05-17 05:30:00	AAPL	Stock	23.685	23.6875	23.655	23.6625	35980.0
2016-05-17 06:00:00	AAPL	Stock	23.6875	23.7475	23.6875	23.7	73224.0
2016-05-17 06:30:00	AAPL	Stock	23.73	23.73	23.625	23.625	97972.0
2016-05-17 07:00:00	AAPL	Stock	23.66	23.66	23.5525	23.585	178648.0
2016-05-17 07:30:00	AAPL	Stock	23.59	23.6125	23.565	23.6125	36048.0
2016-05-17 08:00:00	AAPL	Stock	23.6	23.66	23.5625	23.59	255712.0
2016-05-17 08:30:00	AAPL	Stock	23.5975	23.6	23.525	23.54	310964.0
2016-05-17 09:00:00	AAPL	Stock	23.54	23.75	23.5275	23.655	1711328.0
2016-05-17 09:30:00	AAPL	Stock	23.6375	23.675	23.36	23.4525	36375452.0
2016-05-17 10:00:00	AAPL	Stock	23.455	23.495	23.335	23.3475	14919272.0
2016-05-17 10:30:00	AAPL	Stock	23.3475	23.4625	23.3375	23.4513	12588052.0
2016-05-17 11:00:00	AAPL	Stock	23.45	23.5325	23.405	23.4575	10686340.0
2016-05-17 11:30:00	AAPL	Stock	23.4575	23.55	23.45	23.5062	9246892.0
2016-05-17 12:00:00	AAPL	Stock	23.5075	23.56	23.455	23.5012	8462760.0
2016-05-17 12:30:00	AAPL	Stock	23.5025	23.51	23.4112	23.435	6657912.0
2016-05-17 13:00:00	AAPL	Stock	23.4375	23.495	23.43	23.4575	5951896.0
2016-05-17 13:30:00	AAPL	Stock	23.46	23.495	23.3825	23.385	6602648.0
2016-05-17 14:00:00	AAPL	Stock	23.385	23.4195	23.315	23.3775	11118580.0
2016-05-17 14:30:00	AAPL	Stock	23.3775	23.38	23.285	23.3275	9325624.0
2016-05-17 15:00:00	AAPL	Stock	23.3275	23.375	23.2525	23.295	9850288.0
2016-05-17 15:30:00	AAPL	Stock	23.2975	23.37	23.29	23.37	15466800.0
2016-05-17 16:00:00	AAPL	Stock	23.3725	23.375	23.3575	23.3675	12411028.0
2016-05-17 16:30:00	AAPL	Stock	23.3675	23.3825	23.365	23.3725	31552.0
2016-05-17 17:00:00	AAPL	Stock	23.3825	23.3875	23.375	23.3775	23372.0
2016-05-17 17:30:00	AAPL	Stock	23.375	23.38	23.375	23.38	18544.0
2016-05-17 18:00:00	AAPL	Stock	23.375	23.3775	23.37	23.375	23384.0
2016-05-17 18:30:00	AAPL	Stock	23.3775	23.385	23.3775	23.38	12000.0
2016-05-17 19:00:00	AAPL	Stock	23.38	23.385	23.3775	23.385	4816.0
2016-05-17 19:30:00	AAPL	Stock	23.3825	23.3875	23.3775	23.3775	31060.0
2016-05-17 05:00:00	MSFT	Stock	51.63	51.63	51.63	51.63	1049.0
2016-05-17 07:00:00	MSFT	Stock	51.55	51.55	51.53	51.53	700.0
2016-05-17 07:30:00	MSFT	Stock	51.51	51.52	51.41	51.51	4260.0
2016-05-17 08:00:00	MSFT	Stock	51.56	51.56	51.4	51.45	2360.0
2016-05-17 08:30:00	MSFT	Stock	51.45	51.45	50.728	51.45	14792.0
2016-05-17 09:00:00	MSFT	Stock	51.42	51.79	51.4	51.72	4256.0
2016-05-17 09:30:00	MSFT	Stock	51.72	51.73	51.055	51.12	2826510.0
2016-05-17 10:00:00	MSFT	Stock	51.13	51.13	50.82	50.87	1938270.0
2016-05-17 10:30:00	MSFT	Stock	50.871	50.97	50.75	50.922	1401515.0
2016-05-17 11:00:00	MSFT	Stock	50.92	51.01	50.81	50.81	1109384.0
2016-05-17 11:30:00	MSFT	Stock	50.82	50.95	50.815	50.891	946719.0
2016-05-17 12:00:00	MSFT	Stock	50.89	50.92	50.77	50.829	802703.0
2016-05-17 12:30:00	MSFT	Stock	50.82	50.84	50.67	50.76	939477.0
2016-05-17 13:00:00	MSFT	Stock	50.76	50.84	50.69	50.815	750086.0
2016-05-17 13:30:00	MSFT	Stock	50.82	50.9	50.63	50.64	1215463.0
2016-05-17 14:00:00	MSFT	Stock	50.645	50.675	50.44	50.55	2248319.0
2016-05-17 14:30:00	MSFT	Stock	50.55	50.63	50.48	50.565	1479394.0
2016-05-17 15:00:00	MSFT	Stock	50.57	50.64	50.36	50.45	2214218.0

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

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