PREVIEW / stock_30min / 2011-08-03

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-03.parquet
  size:    1.4 MB
  rows:    76,333
  symbols: 3,530

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-08-03 04:00:00	AAPL	Stock	13.9254	13.9464	13.9054	13.9464	16800.0
2011-08-03 04:30:00	AAPL	Stock	13.9464	13.9464	13.9286	13.9286	44800.0
2011-08-03 05:00:00	AAPL	Stock	13.9446	13.9568	13.9446	13.9568	19600.0
2011-08-03 05:30:00	AAPL	Stock	13.9571	13.9571	13.9	13.9293	65800.0
2011-08-03 06:00:00	AAPL	Stock	13.9304	13.9571	13.9229	13.9329	58800.0
2011-08-03 06:30:00	AAPL	Stock	13.9464	14.0093	13.9346	13.975	184380.0
2011-08-03 07:00:00	AAPL	Stock	13.975	13.98	13.9471	13.95	262332.0
2011-08-03 07:30:00	AAPL	Stock	13.9514	13.9514	13.9279	13.9464	362908.0
2011-08-03 08:00:00	AAPL	Stock	13.9532	14.0168	13.9207	14.0064	2214968.0
2011-08-03 08:30:00	AAPL	Stock	14.0068	14.0236	13.9936	14.0068	995820.0
2011-08-03 09:00:00	AAPL	Stock	14.0104	14.0129	13.9579	13.9643	1295280.0
2011-08-03 09:30:00	AAPL	Stock	13.9636	14.0086	13.8961	14.0039	79195060.0
2011-08-03 10:00:00	AAPL	Stock	14.0039	14.0314	13.7893	13.8522	89287492.0
2011-08-03 10:30:00	AAPL	Stock	13.8521	13.8682	13.6514	13.8654	122092516.0
2011-08-03 11:00:00	AAPL	Stock	13.8678	13.9232	13.8225	13.875	71377684.0
2011-08-03 11:30:00	AAPL	Stock	13.87	13.9525	13.8689	13.9043	42331380.0
2011-08-03 12:00:00	AAPL	Stock	13.9071	13.9132	13.8357	13.8764	28400120.0
2011-08-03 12:30:00	AAPL	Stock	13.8771	13.9443	13.8589	13.9225	27807024.0
2011-08-03 13:00:00	AAPL	Stock	13.9207	13.96	13.8932	13.9596	27321168.0
2011-08-03 13:30:00	AAPL	Stock	13.9596	14.0554	13.9521	14.0114	53402412.0
2011-08-03 14:00:00	AAPL	Stock	14.0114	14.0407	13.9386	13.9479	46615100.0
2011-08-03 14:30:00	AAPL	Stock	13.9478	13.9954	13.9329	13.9771	34515152.0
2011-08-03 15:00:00	AAPL	Stock	13.9761	14.0243	13.9393	13.9961	39154948.0
2011-08-03 15:30:00	AAPL	Stock	13.9971	14.0357	13.9646	14.0204	47964168.0
2011-08-03 16:00:00	AAPL	Stock	14.0179	14.0454	13.736	13.736	7165676.0
2011-08-03 16:30:00	AAPL	Stock	14.0204	14.0204	13.8241	14.0068	7674324.0
2011-08-03 17:00:00	AAPL	Stock	14.0029	14.0207	14.0025	14.0146	179088.0
2011-08-03 17:30:00	AAPL	Stock	14.0129	14.0175	14.0071	14.0175	86800.0
2011-08-03 18:00:00	AAPL	Stock	14.015	14.0214	14.0111	14.0214	228760.0
2011-08-03 18:30:00	AAPL	Stock	14.0211	14.0357	14.0179	14.0354	153300.0
2011-08-03 19:00:00	AAPL	Stock	14.0354	14.0382	14.0329	14.0382	65800.0
2011-08-03 19:30:00	AAPL	Stock	14.0414	14.0536	14.0407	14.0536	369292.0
2011-08-03 04:00:00	MSFT	Stock	26.8	26.8	26.8	26.8	400.0
2011-08-03 05:00:00	MSFT	Stock	26.87	26.87	26.87	26.87	400.0
2011-08-03 05:30:00	MSFT	Stock	26.78	26.78	26.77	26.77	800.0
2011-08-03 06:30:00	MSFT	Stock	26.81	26.81	26.81	26.81	500.0
2011-08-03 07:30:00	MSFT	Stock	26.8	26.82	26.79	26.82	800.0
2011-08-03 08:00:00	MSFT	Stock	26.8	27.04	26.8	26.94	14735.0
2011-08-03 08:30:00	MSFT	Stock	26.9	26.94	26.9	26.9	4960.0
2011-08-03 09:00:00	MSFT	Stock	26.9	27.0	26.83	26.85	103281.0
2011-08-03 09:30:00	MSFT	Stock	26.83	26.93	26.63	26.898	5464890.0
2011-08-03 10:00:00	MSFT	Stock	26.89	26.95	26.61	26.725	5255546.0
2011-08-03 10:30:00	MSFT	Stock	26.725	26.725	26.48	26.59	7278624.0
2011-08-03 11:00:00	MSFT	Stock	26.59	26.77	26.53	26.7	5590898.0
2011-08-03 11:30:00	MSFT	Stock	26.7	26.78	26.66	26.692	4157828.0
2011-08-03 12:00:00	MSFT	Stock	26.69	26.705	26.5	26.555	3014973.0
2011-08-03 12:30:00	MSFT	Stock	26.553	26.64	26.5	26.61	2741492.0
2011-08-03 13:00:00	MSFT	Stock	26.61	26.72	26.52	26.71	2914086.0
2011-08-03 13:30:00	MSFT	Stock	26.71	26.89	26.71	26.748	4528594.0
2011-08-03 14:00:00	MSFT	Stock	26.75	26.81	26.67	26.69	3456580.0

> showing 50 of 76,333 rows — these rows as CSV

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