PREVIEW / stock_30min / 2014-09-05

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-05.parquet
  size:    1.6 MB
  rows:    81,308
  symbols: 3,585

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
2014-09-05 04:00:00	AAPL	Stock	24.525	24.6125	24.525	24.5475	9092.0
2014-09-05 04:30:00	AAPL	Stock	24.5375	24.54	24.5125	24.5325	9856.0
2014-09-05 05:00:00	AAPL	Stock	24.525	24.5725	24.525	24.55	28968.0
2014-09-05 05:30:00	AAPL	Stock	24.595	24.595	24.54	24.54	11300.0
2014-09-05 06:00:00	AAPL	Stock	24.54	24.5475	24.515	24.5275	51080.0
2014-09-05 06:30:00	AAPL	Stock	24.5425	24.555	24.5225	24.5225	10536.0
2014-09-05 07:00:00	AAPL	Stock	24.5375	24.6825	24.5375	24.615	147904.0
2014-09-05 07:30:00	AAPL	Stock	24.62	24.6825	24.615	24.6575	186704.0
2014-09-05 08:00:00	AAPL	Stock	24.655	24.7325	24.53	24.7	608896.0
2014-09-05 08:30:00	AAPL	Stock	24.7025	24.75	24.665	24.7275	1072600.0
2014-09-05 09:00:00	AAPL	Stock	24.7375	24.7375	24.665	24.705	641000.0
2014-09-05 09:30:00	AAPL	Stock	24.7	24.8125	24.61	24.745	38806572.0
2014-09-05 10:00:00	AAPL	Stock	24.7475	24.8475	24.7275	24.76	19995476.0
2014-09-05 10:30:00	AAPL	Stock	24.7625	24.8	24.645	24.775	18404764.0
2014-09-05 11:00:00	AAPL	Stock	24.7738	24.8125	24.646	24.6797	17503944.0
2014-09-05 11:30:00	AAPL	Stock	24.6775	24.78	24.675	24.69	12087532.0
2014-09-05 12:00:00	AAPL	Stock	24.6925	24.7	24.6625	24.6968	7403136.0
2014-09-05 12:30:00	AAPL	Stock	24.695	24.7325	24.6	24.6048	13671732.0
2014-09-05 13:00:00	AAPL	Stock	24.605	24.674	24.5775	24.639	9314348.0
2014-09-05 13:30:00	AAPL	Stock	24.6378	24.6775	24.625	24.675	5762476.0
2014-09-05 14:00:00	AAPL	Stock	24.6775	24.705	24.67	24.705	8076368.0
2014-09-05 14:30:00	AAPL	Stock	24.7038	24.715	24.6475	24.6625	8212992.0
2014-09-05 15:00:00	AAPL	Stock	24.6612	24.675	24.6125	24.64	10670316.0
2014-09-05 15:30:00	AAPL	Stock	24.641	24.7475	24.6275	24.7375	27107036.0
2014-09-05 16:00:00	AAPL	Stock	24.7425	24.75	24.53	24.75	10777940.0
2014-09-05 16:30:00	AAPL	Stock	24.75	24.765	23.3368	24.755	1085812.0
2014-09-05 17:00:00	AAPL	Stock	24.7525	24.7625	24.7425	24.7575	498188.0
2014-09-05 17:30:00	AAPL	Stock	24.75	24.76	24.678	24.7575	138056.0
2014-09-05 18:00:00	AAPL	Stock	24.76	24.7625	24.7425	24.755	135720.0
2014-09-05 18:30:00	AAPL	Stock	24.755	24.7575	24.7425	24.7425	200268.0
2014-09-05 19:00:00	AAPL	Stock	24.74	24.75	24.735	24.75	71940.0
2014-09-05 19:30:00	AAPL	Stock	24.75	24.75	24.7375	24.7475	77704.0
2014-09-05 05:30:00	MSFT	Stock	45.21	45.21	45.21	45.21	1500.0
2014-09-05 07:30:00	MSFT	Stock	45.16	45.16	45.16	45.16	100.0
2014-09-05 08:00:00	MSFT	Stock	45.11	45.17	45.1	45.1	2700.0
2014-09-05 08:30:00	MSFT	Stock	45.12	45.23	45.12	45.22	19550.0
2014-09-05 09:00:00	MSFT	Stock	45.15	45.15	45.12	45.12	3400.0
2014-09-05 09:30:00	MSFT	Stock	45.11	45.31	45.11	45.17	4360523.0
2014-09-05 10:00:00	MSFT	Stock	45.165	45.36	45.15	45.33	1712673.0
2014-09-05 10:30:00	MSFT	Stock	45.325	45.36	45.21	45.215	1767129.0
2014-09-05 11:00:00	MSFT	Stock	45.22	45.43	45.21	45.405	1712527.0
2014-09-05 11:30:00	MSFT	Stock	45.41	45.43	45.35	45.38	1303231.0
2014-09-05 12:00:00	MSFT	Stock	45.37	45.54	45.37	45.53	2086372.0
2014-09-05 12:30:00	MSFT	Stock	45.53	45.72	45.52	45.719	2046431.0
2014-09-05 13:00:00	MSFT	Stock	45.71	45.875	45.7	45.82	2659773.0
2014-09-05 13:30:00	MSFT	Stock	45.81	45.86	45.74	45.79	2293499.0
2014-09-05 14:00:00	MSFT	Stock	45.79	45.91	45.74	45.765	2670271.0
2014-09-05 14:30:00	MSFT	Stock	45.765	45.78	45.74	45.77	949785.0
2014-09-05 15:00:00	MSFT	Stock	45.77	45.89	45.76	45.875	2044275.0
2014-09-05 15:30:00	MSFT	Stock	45.875	45.93	45.76	45.9	6456771.0

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

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