PREVIEW / stock_30min / 2015-09-23

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-23.parquet
  size:    1.5 MB
  rows:    80,044
  symbols: 3,429

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
2015-09-23 04:00:00	AAPL	Stock	27.775	28.4	27.775	28.4	21800.0
2015-09-23 04:30:00	AAPL	Stock	28.4	28.465	28.36	28.4175	4000.0
2015-09-23 05:00:00	AAPL	Stock	28.4425	28.445	28.425	28.425	20400.0
2015-09-23 05:30:00	AAPL	Stock	28.435	28.445	28.435	28.445	7736.0
2015-09-23 06:00:00	AAPL	Stock	28.445	28.5	28.425	28.44	46532.0
2015-09-23 06:30:00	AAPL	Stock	28.43	28.4475	28.43	28.4475	8800.0
2015-09-23 07:00:00	AAPL	Stock	28.4475	28.5125	28.4425	28.49	71468.0
2015-09-23 07:30:00	AAPL	Stock	28.4875	28.4975	28.4375	28.45	102604.0
2015-09-23 08:00:00	AAPL	Stock	28.455	28.545	28.4375	28.5375	397632.0
2015-09-23 08:30:00	AAPL	Stock	28.5275	28.5525	28.48	28.4825	355068.0
2015-09-23 09:00:00	AAPL	Stock	28.485	28.4925	28.375	28.4075	324296.0
2015-09-23 09:30:00	AAPL	Stock	28.3925	28.5275	28.35	28.4672	19618608.0
2015-09-23 10:00:00	AAPL	Stock	28.4675	28.5225	28.4325	28.4872	10906552.0
2015-09-23 10:30:00	AAPL	Stock	28.4872	28.58	28.47	28.535	9370124.0
2015-09-23 11:00:00	AAPL	Stock	28.5328	28.5425	28.405	28.435	8088840.0
2015-09-23 11:30:00	AAPL	Stock	28.4375	28.4475	28.325	28.385	8772168.0
2015-09-23 12:00:00	AAPL	Stock	28.385	28.4575	28.335	28.4575	7815360.0
2015-09-23 12:30:00	AAPL	Stock	28.4575	28.4975	28.425	28.4875	5427096.0
2015-09-23 13:00:00	AAPL	Stock	28.485	28.5225	28.415	28.435	5027348.0
2015-09-23 13:30:00	AAPL	Stock	28.435	28.5625	28.4298	28.553	6550804.0
2015-09-23 14:00:00	AAPL	Stock	28.5525	28.6588	28.5425	28.5808	11662828.0
2015-09-23 14:30:00	AAPL	Stock	28.58	28.635	28.5125	28.545	7818616.0
2015-09-23 15:00:00	AAPL	Stock	28.5475	28.615	28.52	28.5985	10631904.0
2015-09-23 15:30:00	AAPL	Stock	28.5975	28.68	28.5675	28.585	16305612.0
2015-09-23 16:00:00	AAPL	Stock	28.58	28.615	28.5375	28.54	4930420.0
2015-09-23 16:30:00	AAPL	Stock	28.5625	28.59	28.55	28.5875	24992.0
2015-09-23 17:00:00	AAPL	Stock	28.5825	28.6	28.5825	28.59	18780.0
2015-09-23 17:30:00	AAPL	Stock	28.5825	28.5975	28.5825	28.595	36292.0
2015-09-23 18:00:00	AAPL	Stock	28.5975	28.6175	28.5875	28.6	49000.0
2015-09-23 18:30:00	AAPL	Stock	28.6125	28.62	28.6	28.6	21708.0
2015-09-23 19:00:00	AAPL	Stock	28.605	28.605	28.585	28.595	13652.0
2015-09-23 19:30:00	AAPL	Stock	28.5875	28.6025	28.58	28.585	21260.0
2015-09-23 07:30:00	MSFT	Stock	44.11	44.11	44.11	44.11	2000.0
2015-09-23 08:00:00	MSFT	Stock	44.11	44.16	44.1	44.1	1400.0
2015-09-23 08:30:00	MSFT	Stock	44.1	44.1	44.07	44.07	500.0
2015-09-23 09:00:00	MSFT	Stock	44.13	44.13	43.86	43.87	9624.0
2015-09-23 09:30:00	MSFT	Stock	43.9	44.0	43.77	43.97	1953221.0
2015-09-23 10:00:00	MSFT	Stock	43.97	44.11	43.94	44.08	1071151.0
2015-09-23 10:30:00	MSFT	Stock	44.08	44.17	43.91	44.02	1151880.0
2015-09-23 11:00:00	MSFT	Stock	44.03	44.057	43.77	43.81	1111891.0
2015-09-23 11:30:00	MSFT	Stock	43.805	43.805	43.55	43.659	1018237.0
2015-09-23 12:00:00	MSFT	Stock	43.66	43.67	43.51	43.585	977562.0
2015-09-23 12:30:00	MSFT	Stock	43.59	43.75	43.55	43.73	611719.0
2015-09-23 13:00:00	MSFT	Stock	43.724	43.85	43.7	43.73	637135.0
2015-09-23 13:30:00	MSFT	Stock	43.73	43.95	43.71	43.855	736736.0
2015-09-23 14:00:00	MSFT	Stock	43.85	44.01	43.83	43.86	876651.0
2015-09-23 14:30:00	MSFT	Stock	43.86	43.95	43.785	43.9	745079.0
2015-09-23 15:00:00	MSFT	Stock	43.895	44.03	43.83	43.96	1545697.0
2015-09-23 15:30:00	MSFT	Stock	43.96	44.08	43.867	43.88	2623039.0
2015-09-23 16:00:00	MSFT	Stock	43.87	43.97	43.87	43.96	1230127.0

> showing 50 of 80,044 rows — these rows as CSV

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