PREVIEW / stock_30min / 2012-11-16

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-16.parquet
  size:    1.5 MB
  rows:    78,162
  symbols: 3,473

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
2012-11-16 04:00:00	AAPL	Stock	18.7179	18.75	18.7054	18.7054	9380.0
2012-11-16 04:30:00	AAPL	Stock	18.7054	18.7054	18.6786	18.6786	16800.0
2012-11-16 05:00:00	AAPL	Stock	18.6614	18.6614	18.6329	18.6329	23800.0
2012-11-16 05:30:00	AAPL	Stock	18.6343	18.6429	18.6304	18.6429	69412.0
2012-11-16 06:00:00	AAPL	Stock	18.6243	18.6696	18.6243	18.6696	18200.0
2012-11-16 06:30:00	AAPL	Stock	18.655	18.695	18.655	18.695	124432.0
2012-11-16 07:00:00	AAPL	Stock	18.7068	18.7711	18.7068	18.7411	347536.0
2012-11-16 07:30:00	AAPL	Stock	18.7639	18.8393	18.7536	18.8214	521164.0
2012-11-16 08:00:00	AAPL	Stock	18.8079	18.9679	18.7146	18.9	2221184.0
2012-11-16 08:30:00	AAPL	Stock	18.9	18.9286	18.7875	18.8361	1521800.0
2012-11-16 09:00:00	AAPL	Stock	18.8368	18.8661	18.7536	18.7571	4508448.0
2012-11-16 09:30:00	AAPL	Stock	18.7557	18.8029	18.4464	18.5296	171476956.0
2012-11-16 10:00:00	AAPL	Stock	18.5336	18.5657	18.4107	18.5496	109038720.0
2012-11-16 10:30:00	AAPL	Stock	18.5471	18.5714	18.3397	18.3979	81881884.0
2012-11-16 11:00:00	AAPL	Stock	18.3968	18.4243	18.1304	18.1393	98649628.0
2012-11-16 11:30:00	AAPL	Stock	18.1379	18.55	18.0625	18.5469	147659232.0
2012-11-16 12:00:00	AAPL	Stock	18.5486	18.8168	18.5214	18.8126	136452820.0
2012-11-16 12:30:00	AAPL	Stock	18.8093	18.9286	18.7461	18.775	106057616.0
2012-11-16 13:00:00	AAPL	Stock	18.7843	18.7843	18.6204	18.7486	63902328.0
2012-11-16 13:30:00	AAPL	Stock	18.7496	18.8786	18.6625	18.8518	49514780.0
2012-11-16 14:00:00	AAPL	Stock	18.8484	18.8657	18.6182	18.6782	51530360.0
2012-11-16 14:30:00	AAPL	Stock	18.6782	18.7786	18.56	18.7489	58414300.0
2012-11-16 15:00:00	AAPL	Stock	18.7446	18.7929	18.6611	18.7661	45840368.0
2012-11-16 15:30:00	AAPL	Stock	18.7707	18.8896	18.7589	18.8454	100417156.0
2012-11-16 16:00:00	AAPL	Stock	18.8425	18.8836	18.3571	18.8732	15066044.0
2012-11-16 16:30:00	AAPL	Stock	18.8818	18.9439	18.7554	18.9293	3603376.0
2012-11-16 17:00:00	AAPL	Stock	18.9293	18.935	18.8457	18.9321	2031540.0
2012-11-16 17:30:00	AAPL	Stock	18.9304	18.9336	18.8946	18.8946	856352.0
2012-11-16 18:00:00	AAPL	Stock	18.8943	18.9221	18.8943	18.905	549388.0
2012-11-16 18:30:00	AAPL	Stock	18.9021	18.9025	18.8811	18.8811	217616.0
2012-11-16 19:00:00	AAPL	Stock	18.8893	18.8982	18.8807	18.8925	174272.0
2012-11-16 19:30:00	AAPL	Stock	18.8925	18.9139	18.8886	18.9139	283808.0
2012-11-16 07:30:00	MSFT	Stock	26.66	26.7	26.66	26.7	2800.0
2012-11-16 08:00:00	MSFT	Stock	26.7	26.8	26.7	26.8	18920.0
2012-11-16 08:30:00	MSFT	Stock	26.8	26.8	26.72	26.73	16022.0
2012-11-16 09:00:00	MSFT	Stock	26.73	26.76	26.64	26.65	196469.0
2012-11-16 09:30:00	MSFT	Stock	26.67	26.8	26.46	26.535	12851110.0
2012-11-16 10:00:00	MSFT	Stock	26.54	26.54	26.44	26.455	5575678.0
2012-11-16 10:30:00	MSFT	Stock	26.46	26.55	26.41	26.473	5513842.0
2012-11-16 11:00:00	MSFT	Stock	26.475	26.5	26.36	26.375	3464853.0
2012-11-16 11:30:00	MSFT	Stock	26.37	26.54	26.36	26.535	5044341.0
2012-11-16 12:00:00	MSFT	Stock	26.54	26.64	26.51	26.625	4921321.0
2012-11-16 12:30:00	MSFT	Stock	26.63	26.65	26.53	26.57	2982129.0
2012-11-16 13:00:00	MSFT	Stock	26.56	26.63	26.54	26.555	1362548.0
2012-11-16 13:30:00	MSFT	Stock	26.56	26.58	26.5	26.56	1605807.0
2012-11-16 14:00:00	MSFT	Stock	26.55	26.57	26.44	26.445	2148677.0
2012-11-16 14:30:00	MSFT	Stock	26.45	26.53	26.41	26.492	2418970.0
2012-11-16 15:00:00	MSFT	Stock	26.5	26.56	26.46	26.546	2257549.0
2012-11-16 15:30:00	MSFT	Stock	26.55	26.67	26.5	26.53	7275305.0
2012-11-16 16:00:00	MSFT	Stock	26.525	26.57	26.483	26.529	5143111.0

> showing 50 of 78,162 rows — these rows as CSV

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