PREVIEW / stock_30min / 2016-11-08

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-08.parquet
  size:    1.5 MB
  rows:    79,829
  symbols: 3,159

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-11-08 04:00:00	AAPL	Stock	27.565	27.5725	27.4825	27.4825	12876.0
2016-11-08 04:30:00	AAPL	Stock	27.495	27.505	27.495	27.4975	3596.0
2016-11-08 05:00:00	AAPL	Stock	27.4975	27.4975	27.4975	27.4975	2800.0
2016-11-08 06:00:00	AAPL	Stock	27.4975	27.4975	27.475	27.48	11056.0
2016-11-08 06:30:00	AAPL	Stock	27.4975	27.52	27.485	27.485	4896.0
2016-11-08 07:00:00	AAPL	Stock	27.53	27.535	27.5275	27.5275	6772.0
2016-11-08 07:30:00	AAPL	Stock	27.5	27.515	27.5	27.515	4380.0
2016-11-08 08:00:00	AAPL	Stock	27.5225	27.5725	27.5025	27.55	34772.0
2016-11-08 08:30:00	AAPL	Stock	27.57	27.595	27.545	27.55	48676.0
2016-11-08 09:00:00	AAPL	Stock	27.5425	27.6275	27.52	27.59	167480.0
2016-11-08 09:30:00	AAPL	Stock	27.5775	27.595	27.455	27.485	9414192.0
2016-11-08 10:00:00	AAPL	Stock	27.4825	27.5125	27.425	27.51	6039228.0
2016-11-08 10:30:00	AAPL	Stock	27.51	27.5325	27.4825	27.5075	4544968.0
2016-11-08 11:00:00	AAPL	Stock	27.5075	27.64	27.4925	27.6175	6232740.0
2016-11-08 11:30:00	AAPL	Stock	27.6188	27.735	27.61	27.7282	6228224.0
2016-11-08 12:00:00	AAPL	Stock	27.73	27.9025	27.725	27.865	7815900.0
2016-11-08 12:30:00	AAPL	Stock	27.8662	27.93	27.815	27.91	4955320.0
2016-11-08 13:00:00	AAPL	Stock	27.91	27.925	27.805	27.805	5047260.0
2016-11-08 13:30:00	AAPL	Stock	27.8062	27.875	27.78	27.7842	5275200.0
2016-11-08 14:00:00	AAPL	Stock	27.7835	27.795	27.7025	27.7568	4628124.0
2016-11-08 14:30:00	AAPL	Stock	27.755	27.76	27.665	27.7275	4671840.0
2016-11-08 15:00:00	AAPL	Stock	27.7275	27.7675	27.705	27.7425	4663848.0
2016-11-08 15:30:00	AAPL	Stock	27.745	27.8525	27.71	27.765	13391220.0
2016-11-08 16:00:00	AAPL	Stock	27.765	27.8025	27.7075	27.765	5193656.0
2016-11-08 16:30:00	AAPL	Stock	27.7625	27.7725	27.745	27.7725	28096.0
2016-11-08 17:00:00	AAPL	Stock	27.77	27.775	27.755	27.755	49800.0
2016-11-08 17:30:00	AAPL	Stock	27.7625	27.77	27.75	27.7625	13220.0
2016-11-08 18:00:00	AAPL	Stock	27.7625	27.8175	27.7625	27.8	31580.0
2016-11-08 18:30:00	AAPL	Stock	27.7875	27.805	27.7825	27.805	28048.0
2016-11-08 19:00:00	AAPL	Stock	27.8	27.82	27.775	27.7925	130800.0
2016-11-08 19:30:00	AAPL	Stock	27.8075	27.8875	27.7375	27.865	249136.0
2016-11-08 07:30:00	MSFT	Stock	60.5	60.5	60.5	60.5	442.0
2016-11-08 08:00:00	MSFT	Stock	60.49	60.49	60.38	60.4	1700.0
2016-11-08 08:30:00	MSFT	Stock	60.38	60.47	60.38	60.47	9500.0
2016-11-08 09:00:00	MSFT	Stock	60.39	60.51	60.33	60.42	16613.0
2016-11-08 09:30:00	MSFT	Stock	60.55	60.55	60.2	60.22	2620895.0
2016-11-08 10:00:00	MSFT	Stock	60.225	60.34	60.15	60.27	1568452.0
2016-11-08 10:30:00	MSFT	Stock	60.27	60.42	60.23	60.35	1239570.0
2016-11-08 11:00:00	MSFT	Stock	60.36	60.575	60.32	60.505	1366017.0
2016-11-08 11:30:00	MSFT	Stock	60.505	60.6	60.43	60.485	935520.0
2016-11-08 12:00:00	MSFT	Stock	60.485	60.68	60.48	60.64	1284962.0
2016-11-08 12:30:00	MSFT	Stock	60.65	60.77	60.58	60.76	1024688.0
2016-11-08 13:00:00	MSFT	Stock	60.76	60.78	60.47	60.54	1616781.0
2016-11-08 13:30:00	MSFT	Stock	60.54	60.65	60.475	60.51	1110359.0
2016-11-08 14:00:00	MSFT	Stock	60.501	60.53	60.35	60.46	1128811.0
2016-11-08 14:30:00	MSFT	Stock	60.455	60.47	60.305	60.435	1118208.0
2016-11-08 15:00:00	MSFT	Stock	60.435	60.52	60.401	60.483	1215263.0
2016-11-08 15:30:00	MSFT	Stock	60.49	60.57	60.36	60.47	3384086.0
2016-11-08 16:00:00	MSFT	Stock	60.47	60.47	60.27	60.32	1740522.0
2016-11-08 16:30:00	MSFT	Stock	60.41	60.41	60.4	60.4	300.0

> showing 50 of 79,829 rows — these rows as CSV

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