PREVIEW / stock_30min / 2013-12-20

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-20.parquet
  size:    1.7 MB
  rows:    85,668
  symbols: 3,541

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
2013-12-20 04:30:00	AAPL	Stock	19.5082	19.5104	19.5075	19.5104	39200.0
2013-12-20 05:00:00	AAPL	Stock	19.5046	19.5154	19.5043	19.5154	19600.0
2013-12-20 05:30:00	AAPL	Stock	19.5054	19.5054	19.5046	19.5046	5600.0
2013-12-20 06:30:00	AAPL	Stock	19.5164	19.5164	19.4721	19.4721	15400.0
2013-12-20 07:00:00	AAPL	Stock	19.4814	19.4929	19.4536	19.4643	209132.0
2013-12-20 07:30:00	AAPL	Stock	19.4643	19.4946	19.4571	19.4946	78960.0
2013-12-20 08:00:00	AAPL	Stock	19.4482	19.5286	19.445	19.5018	628600.0
2013-12-20 08:30:00	AAPL	Stock	19.5	19.5207	19.5	19.5179	442736.0
2013-12-20 09:00:00	AAPL	Stock	19.5179	19.5282	19.4646	19.4821	1189636.0
2013-12-20 09:30:00	AAPL	Stock	19.4818	19.6196	19.4578	19.603	86588040.0
2013-12-20 10:00:00	AAPL	Stock	19.6046	19.6389	19.5746	19.6371	29552992.0
2013-12-20 10:30:00	AAPL	Stock	19.6371	19.7004	19.6329	19.6875	26282200.0
2013-12-20 11:00:00	AAPL	Stock	19.6871	19.6886	19.6525	19.6641	17748108.0
2013-12-20 11:30:00	AAPL	Stock	19.6668	19.6839	19.6261	19.6407	18734884.0
2013-12-20 12:00:00	AAPL	Stock	19.6418	19.6429	19.6093	19.6389	11917220.0
2013-12-20 12:30:00	AAPL	Stock	19.6376	19.6539	19.6236	19.6279	9383584.0
2013-12-20 13:00:00	AAPL	Stock	19.6279	19.6339	19.6236	19.6243	7518112.0
2013-12-20 13:30:00	AAPL	Stock	19.6243	19.6357	19.6086	19.6314	8864044.0
2013-12-20 14:00:00	AAPL	Stock	19.6332	19.6468	19.6304	19.6432	10859856.0
2013-12-20 14:30:00	AAPL	Stock	19.6432	19.6486	19.6389	19.6411	10009776.0
2013-12-20 15:00:00	AAPL	Stock	19.6414	19.6421	19.6171	19.6248	16218748.0
2013-12-20 15:30:00	AAPL	Stock	19.6254	19.6429	19.5686	19.5971	44500484.0
2013-12-20 16:00:00	AAPL	Stock	19.6128	19.6326	19.4749	19.5965	57097572.0
2013-12-20 16:30:00	AAPL	Stock	19.5965	19.6352	19.5725	19.5957	12163676.0
2013-12-20 17:00:00	AAPL	Stock	19.5932	19.5982	19.5786	19.5786	9585296.0
2013-12-20 17:30:00	AAPL	Stock	19.5821	19.5964	19.5804	19.5893	351988.0
2013-12-20 18:00:00	AAPL	Stock	19.5829	19.5964	19.5829	19.5932	123200.0
2013-12-20 18:30:00	AAPL	Stock	19.5946	19.6089	19.5946	19.6089	218400.0
2013-12-20 19:00:00	AAPL	Stock	19.6093	19.6207	19.6093	19.6114	46620.0
2013-12-20 19:30:00	AAPL	Stock	19.615	19.6393	19.6107	19.6393	502432.0
2013-12-20 08:00:00	MSFT	Stock	36.3	36.3	36.26	36.26	28784.0
2013-12-20 08:30:00	MSFT	Stock	36.4	36.4	36.35	36.35	1000.0
2013-12-20 09:00:00	MSFT	Stock	36.36	36.38	36.15	36.25	66380.0
2013-12-20 09:30:00	MSFT	Stock	36.26	36.37	36.17	36.286	15909228.0
2013-12-20 10:00:00	MSFT	Stock	36.285	36.39	36.24	36.33	3003779.0
2013-12-20 10:30:00	MSFT	Stock	36.33	36.61	36.32	36.57	3268400.0
2013-12-20 11:00:00	MSFT	Stock	36.58	36.66	36.5	36.64	2395572.0
2013-12-20 11:30:00	MSFT	Stock	36.65	36.83	36.63	36.64	2317696.0
2013-12-20 12:00:00	MSFT	Stock	36.64	36.83	36.62	36.81	2117090.0
2013-12-20 12:30:00	MSFT	Stock	36.81	36.81	36.67	36.67	1593472.0
2013-12-20 13:00:00	MSFT	Stock	36.68	36.71	36.62	36.7	1326259.0
2013-12-20 13:30:00	MSFT	Stock	36.7	36.73	36.66	36.72	1220291.0
2013-12-20 14:00:00	MSFT	Stock	36.725	36.81	36.68	36.758	2338429.0
2013-12-20 14:30:00	MSFT	Stock	36.759	36.85	36.693	36.825	1891047.0
2013-12-20 15:00:00	MSFT	Stock	36.83	36.93	36.75	36.84	2976654.0
2013-12-20 15:30:00	MSFT	Stock	36.84	36.86	36.77	36.78	9008159.0
2013-12-20 16:00:00	MSFT	Stock	36.79	36.86	36.316	36.77	7980693.0
2013-12-20 16:30:00	MSFT	Stock	36.773	36.82	36.759	36.773	1549245.0
2013-12-20 17:00:00	MSFT	Stock	36.75	36.8	36.6	36.8	1484188.0
2013-12-20 17:30:00	MSFT	Stock	36.821	36.821	36.821	36.821	408.0

> showing 50 of 85,668 rows — these rows as CSV

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