PREVIEW / stock_30min / 2011-11-11

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-11.parquet
  size:    1.4 MB
  rows:    73,600
  symbols: 3,502

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
2011-11-11 04:00:00	AAPL	Stock	13.8393	13.8393	13.8393	13.8393	2800.0
2011-11-11 05:30:00	AAPL	Stock	13.8214	13.8214	13.8214	13.8214	2800.0
2011-11-11 06:30:00	AAPL	Stock	13.8143	13.8143	13.8143	13.8143	2800.0
2011-11-11 07:00:00	AAPL	Stock	13.8107	13.8214	13.8104	13.8175	62748.0
2011-11-11 07:30:00	AAPL	Stock	13.8214	13.8375	13.8086	13.8375	340788.0
2011-11-11 08:00:00	AAPL	Stock	13.8375	13.9093	13.7786	13.8886	2090312.0
2011-11-11 08:30:00	AAPL	Stock	13.8911	13.8979	13.8682	13.8696	1898428.0
2011-11-11 09:00:00	AAPL	Stock	13.8664	13.8843	13.7964	13.8111	5087404.0
2011-11-11 09:30:00	AAPL	Stock	13.8096	13.8129	13.5807	13.6414	121197468.0
2011-11-11 10:00:00	AAPL	Stock	13.6414	13.7304	13.6157	13.6361	76529600.0
2011-11-11 10:30:00	AAPL	Stock	13.6368	13.6843	13.62	13.6444	44987376.0
2011-11-11 11:00:00	AAPL	Stock	13.6461	13.6811	13.6382	13.6643	28649404.0
2011-11-11 11:30:00	AAPL	Stock	13.6643	13.7975	13.6629	13.7632	53316424.0
2011-11-11 12:00:00	AAPL	Stock	13.7636	13.8821	13.7607	13.85	52265864.0
2011-11-11 12:30:00	AAPL	Stock	13.8507	13.8571	13.8	13.8254	24774120.0
2011-11-11 13:00:00	AAPL	Stock	13.8254	13.8389	13.7264	13.7371	39737516.0
2011-11-11 13:30:00	AAPL	Stock	13.7379	13.7457	13.6904	13.6968	35996240.0
2011-11-11 14:00:00	AAPL	Stock	13.6996	13.7425	13.6857	13.6996	26180616.0
2011-11-11 14:30:00	AAPL	Stock	13.6989	13.7202	13.6536	13.6732	38940272.0
2011-11-11 15:00:00	AAPL	Stock	13.6732	13.7089	13.655	13.7029	32097296.0
2011-11-11 15:30:00	AAPL	Stock	13.7029	13.7382	13.6704	13.7382	55383104.0
2011-11-11 16:00:00	AAPL	Stock	13.7354	13.7367	13.6521	13.7214	10065160.0
2011-11-11 16:30:00	AAPL	Stock	13.7214	13.7364	13.6902	13.7214	674072.0
2011-11-11 17:00:00	AAPL	Stock	13.725	13.7282	13.7214	13.7275	101780.0
2011-11-11 17:30:00	AAPL	Stock	13.7279	13.7321	13.7143	13.7164	169624.0
2011-11-11 18:00:00	AAPL	Stock	13.7179	13.7364	13.7143	13.7279	43428.0
2011-11-11 18:30:00	AAPL	Stock	13.7271	13.7296	13.7221	13.7296	16800.0
2011-11-11 19:00:00	AAPL	Stock	13.7243	13.7293	13.7129	13.7293	176848.0
2011-11-11 19:30:00	AAPL	Stock	13.7143	13.7182	13.7143	13.7182	96880.0
2011-11-11 07:30:00	MSFT	Stock	26.45	26.45	26.45	26.45	500.0
2011-11-11 08:00:00	MSFT	Stock	26.37	26.52	26.37	26.52	21650.0
2011-11-11 08:30:00	MSFT	Stock	26.52	26.52	26.46	26.47	8011.0
2011-11-11 09:00:00	MSFT	Stock	26.49	26.62	26.48	26.58	101387.0
2011-11-11 09:30:00	MSFT	Stock	26.57	26.81	26.57	26.73	5794466.0
2011-11-11 10:00:00	MSFT	Stock	26.73	26.85	26.73	26.79	3190512.0
2011-11-11 10:30:00	MSFT	Stock	26.8	26.96	26.8	26.96	2593370.0
2011-11-11 11:00:00	MSFT	Stock	26.96	26.98	26.9	26.974	2208945.0
2011-11-11 11:30:00	MSFT	Stock	26.98	27.075	26.975	27.004	3834674.0
2011-11-11 12:00:00	MSFT	Stock	27.005	27.07	26.94	26.97	1992697.0
2011-11-11 12:30:00	MSFT	Stock	26.97	26.99	26.94	26.985	1099424.0
2011-11-11 13:00:00	MSFT	Stock	26.985	27.05	26.98	26.98	1656092.0
2011-11-11 13:30:00	MSFT	Stock	26.98	27.05	26.96	26.98	1437640.0
2011-11-11 14:00:00	MSFT	Stock	26.98	27.04	26.97	27.02	1472030.0
2011-11-11 14:30:00	MSFT	Stock	27.02	27.04	26.94	26.97	1510560.0
2011-11-11 15:00:00	MSFT	Stock	26.97	27.0	26.92	26.99	2299883.0
2011-11-11 15:30:00	MSFT	Stock	26.99	27.0	26.9	26.915	5925064.0
2011-11-11 16:00:00	MSFT	Stock	26.92	26.98	26.79	26.87	2275428.0
2011-11-11 16:30:00	MSFT	Stock	26.87	26.99	26.87	26.91	52375.0
2011-11-11 17:00:00	MSFT	Stock	26.89	26.89	26.88	26.88	800.0
2011-11-11 17:30:00	MSFT	Stock	26.9	26.92	26.85	26.85	6810.0

> showing 50 of 73,600 rows — these rows as CSV

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