PREVIEW / stock_30min / 2011-06-09

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-09.parquet
  size:    1.4 MB
  rows:    74,709
  symbols: 3,550

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-06-09 04:00:00	AAPL	Stock	11.9054	11.9125	11.9054	11.9125	11200.0
2011-06-09 04:30:00	AAPL	Stock	11.91	11.91	11.91	11.91	2800.0
2011-06-09 06:30:00	AAPL	Stock	11.9054	11.9054	11.9054	11.9054	5600.0
2011-06-09 07:00:00	AAPL	Stock	11.8929	11.8929	11.8929	11.8929	2800.0
2011-06-09 07:30:00	AAPL	Stock	11.8896	11.8929	11.8896	11.8929	28000.0
2011-06-09 08:00:00	AAPL	Stock	11.8911	11.8996	11.875	11.88	281120.0
2011-06-09 08:30:00	AAPL	Stock	11.8793	11.9054	11.8571	11.8825	1075368.0
2011-06-09 09:00:00	AAPL	Stock	11.8893	11.9011	11.875	11.8989	673988.0
2011-06-09 09:30:00	AAPL	Stock	11.9014	11.9025	11.8125	11.8774	52610068.0
2011-06-09 10:00:00	AAPL	Stock	11.8779	11.8779	11.8143	11.8382	33574660.0
2011-06-09 10:30:00	AAPL	Stock	11.838	11.8729	11.8214	11.8568	24874808.0
2011-06-09 11:00:00	AAPL	Stock	11.8561	11.8954	11.8304	11.843	21520492.0
2011-06-09 11:30:00	AAPL	Stock	11.8404	11.8636	11.8286	11.8348	14064232.0
2011-06-09 12:00:00	AAPL	Stock	11.8339	11.8597	11.8307	11.8496	9796500.0
2011-06-09 12:30:00	AAPL	Stock	11.8493	11.8839	11.8411	11.8654	13355440.0
2011-06-09 13:00:00	AAPL	Stock	11.8639	11.8782	11.8582	11.8611	7019796.0
2011-06-09 13:30:00	AAPL	Stock	11.8629	11.8711	11.8475	11.8481	9493344.0
2011-06-09 14:00:00	AAPL	Stock	11.8482	11.8725	11.8464	11.8636	8532132.0
2011-06-09 14:30:00	AAPL	Stock	11.8614	11.8782	11.8518	11.8746	10700200.0
2011-06-09 15:00:00	AAPL	Stock	11.875	11.9168	11.8679	11.8839	23244676.0
2011-06-09 15:30:00	AAPL	Stock	11.8843	11.8929	11.8393	11.8393	31634008.0
2011-06-09 16:00:00	AAPL	Stock	11.8396	11.8626	11.8271	11.83	10598420.0
2011-06-09 16:30:00	AAPL	Stock	11.8296	11.8863	11.8268	11.8332	253204.0
2011-06-09 17:00:00	AAPL	Stock	11.8329	11.8332	11.8321	11.8332	22428.0
2011-06-09 17:30:00	AAPL	Stock	11.8304	11.8329	11.8304	11.8329	12432.0
2011-06-09 18:00:00	AAPL	Stock	11.8332	11.8389	11.8325	11.8325	77420.0
2011-06-09 18:30:00	AAPL	Stock	11.8321	11.8346	11.8271	11.8304	57120.0
2011-06-09 19:00:00	AAPL	Stock	11.8339	11.8364	11.8321	11.8321	152936.0
2011-06-09 19:30:00	AAPL	Stock	11.8364	11.8375	11.8271	11.8271	115836.0
2011-06-09 07:00:00	MSFT	Stock	24.02	24.02	24.02	24.02	100.0
2011-06-09 07:30:00	MSFT	Stock	24.02	24.02	24.02	24.02	200.0
2011-06-09 08:00:00	MSFT	Stock	24.04	24.04	24.02	24.04	4400.0
2011-06-09 08:30:00	MSFT	Stock	24.03	24.07	24.01	24.02	24975.0
2011-06-09 09:00:00	MSFT	Stock	24.01	24.03	23.99	24.01	59756.0
2011-06-09 09:30:00	MSFT	Stock	24.01	24.02	23.82	23.9	5174993.0
2011-06-09 10:00:00	MSFT	Stock	23.9	23.95	23.84	23.858	4083937.0
2011-06-09 10:30:00	MSFT	Stock	23.85	23.92	23.85	23.892	2104730.0
2011-06-09 11:00:00	MSFT	Stock	23.9	23.93	23.87	23.925	2444248.0
2011-06-09 11:30:00	MSFT	Stock	23.93	23.98	23.9	23.97	2165558.0
2011-06-09 12:00:00	MSFT	Stock	23.972	24.0	23.94	23.94	1219701.0
2011-06-09 12:30:00	MSFT	Stock	23.94	23.99	23.94	23.955	889720.0
2011-06-09 13:00:00	MSFT	Stock	23.955	23.99	23.92	23.925	1455342.0
2011-06-09 13:30:00	MSFT	Stock	23.93	23.96	23.92	23.94	1458554.0
2011-06-09 14:00:00	MSFT	Stock	23.93	23.97	23.92	23.96	1355415.0
2011-06-09 14:30:00	MSFT	Stock	23.96	24.0	23.93	24.0	1365007.0
2011-06-09 15:00:00	MSFT	Stock	24.0	24.04	23.99	24.02	6083450.0
2011-06-09 15:30:00	MSFT	Stock	24.02	24.04	23.94	23.94	8848230.0
2011-06-09 16:00:00	MSFT	Stock	23.94	23.97	23.89	23.96	3681944.0
2011-06-09 16:30:00	MSFT	Stock	23.982	23.982	23.982	23.982	5900.0
2011-06-09 17:00:00	MSFT	Stock	23.96	23.96	23.93	23.93	3668.0

> showing 50 of 74,709 rows — these rows as CSV

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