PREVIEW / stock_30min / 2013-11-06

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-06.parquet
  size:    1.6 MB
  rows:    81,181
  symbols: 3,529

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-11-06 04:00:00	AAPL	Stock	18.75	18.7771	18.7375	18.7375	33600.0
2013-11-06 04:30:00	AAPL	Stock	18.7089	18.7143	18.7004	18.7004	42000.0
2013-11-06 05:00:00	AAPL	Stock	18.7004	18.7271	18.6964	18.7271	48440.0
2013-11-06 05:30:00	AAPL	Stock	18.7146	18.7482	18.7146	18.7321	27916.0
2013-11-06 06:00:00	AAPL	Stock	18.7321	18.7857	18.7146	18.7768	208320.0
2013-11-06 06:30:00	AAPL	Stock	18.7768	18.7875	18.7768	18.785	65800.0
2013-11-06 07:00:00	AAPL	Stock	18.7768	18.7925	18.7496	18.7536	152488.0
2013-11-06 07:30:00	AAPL	Stock	18.7529	18.7875	18.725	18.725	230440.0
2013-11-06 08:00:00	AAPL	Stock	18.7389	18.7857	18.6571	18.6893	1278284.0
2013-11-06 08:30:00	AAPL	Stock	18.6893	18.7379	18.6875	18.7282	850360.0
2013-11-06 09:00:00	AAPL	Stock	18.73	18.75	18.6982	18.7143	913304.0
2013-11-06 09:30:00	AAPL	Stock	18.7196	18.745	18.625	18.6468	43463868.0
2013-11-06 10:00:00	AAPL	Stock	18.6464	18.7054	18.5746	18.5825	26051788.0
2013-11-06 10:30:00	AAPL	Stock	18.5836	18.5954	18.5107	18.5347	25498284.0
2013-11-06 11:00:00	AAPL	Stock	18.5343	18.59	18.5071	18.5743	14695352.0
2013-11-06 11:30:00	AAPL	Stock	18.5714	18.6146	18.54	18.5616	11550392.0
2013-11-06 12:00:00	AAPL	Stock	18.5632	18.5964	18.545	18.5479	8326528.0
2013-11-06 12:30:00	AAPL	Stock	18.5482	18.5711	18.5232	18.5291	9184140.0
2013-11-06 13:00:00	AAPL	Stock	18.5289	18.5814	18.5196	18.5801	6655992.0
2013-11-06 13:30:00	AAPL	Stock	18.5795	18.5804	18.5446	18.5796	5993736.0
2013-11-06 14:00:00	AAPL	Stock	18.5761	18.5964	18.5529	18.5939	7115192.0
2013-11-06 14:30:00	AAPL	Stock	18.59	18.6042	18.5682	18.5857	6933332.0
2013-11-06 15:00:00	AAPL	Stock	18.5875	18.6116	18.5711	18.5964	9202228.0
2013-11-06 15:30:00	AAPL	Stock	18.5968	18.6064	18.5786	18.6025	17042564.0
2013-11-06 16:00:00	AAPL	Stock	18.6021	18.6364	18.5446	18.5661	5202092.0
2013-11-06 16:30:00	AAPL	Stock	18.5661	18.6632	18.5636	18.5743	10958528.0
2013-11-06 17:00:00	AAPL	Stock	18.5732	18.6021	18.5714	18.575	1472492.0
2013-11-06 17:30:00	AAPL	Stock	18.5718	18.6021	18.55	18.5504	207508.0
2013-11-06 18:00:00	AAPL	Stock	18.6021	18.6021	18.5607	18.5786	48384.0
2013-11-06 18:30:00	AAPL	Stock	18.5571	18.5575	18.5464	18.5568	37772.0
2013-11-06 19:00:00	AAPL	Stock	18.5482	18.5668	18.5471	18.5668	45500.0
2013-11-06 19:30:00	AAPL	Stock	18.55	18.5561	18.5464	18.5464	171024.0
2013-11-06 05:00:00	MSFT	Stock	36.84	36.84	36.84	36.84	200.0
2013-11-06 05:30:00	MSFT	Stock	36.76	36.85	36.75	36.85	1600.0
2013-11-06 06:00:00	MSFT	Stock	36.85	36.9	36.75	36.86	7498.0
2013-11-06 06:30:00	MSFT	Stock	36.9	36.9	36.85	36.88	8141.0
2013-11-06 07:00:00	MSFT	Stock	36.86	36.91	36.83	36.91	27501.0
2013-11-06 07:30:00	MSFT	Stock	36.93	36.97	36.91	36.91	47521.0
2013-11-06 08:00:00	MSFT	Stock	36.87	36.97	36.53	36.9	76758.0
2013-11-06 08:30:00	MSFT	Stock	36.93	36.97	36.86	36.9	311679.0
2013-11-06 09:00:00	MSFT	Stock	36.91	37.44	36.89	37.19	1735029.0
2013-11-06 09:30:00	MSFT	Stock	37.24	37.77	37.06	37.665	17127792.0
2013-11-06 10:00:00	MSFT	Stock	37.66	37.765	37.54	37.57	10292128.0
2013-11-06 10:30:00	MSFT	Stock	37.55	37.71	37.43	37.65	4919312.0
2013-11-06 11:00:00	MSFT	Stock	37.66	37.7	37.51	37.7	4143142.0
2013-11-06 11:30:00	MSFT	Stock	37.695	38.04	37.69	37.985	6292515.0
2013-11-06 12:00:00	MSFT	Stock	37.99	38.082	37.92	37.955	5041606.0
2013-11-06 12:30:00	MSFT	Stock	37.955	37.96	37.83	37.925	4510605.0
2013-11-06 13:00:00	MSFT	Stock	37.92	37.992	37.86	37.967	3095332.0
2013-11-06 13:30:00	MSFT	Stock	37.96	37.97	37.85	37.855	1574418.0

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

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