PREVIEW / stock_30min / 2011-09-14

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-14.parquet
  size:    1.4 MB
  rows:    75,029
  symbols: 3,496

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-09-14 04:00:00	AAPL	Stock	13.7143	13.7143	13.6929	13.6929	8400.0
2011-09-14 04:30:00	AAPL	Stock	13.6893	13.6893	13.6893	13.6893	2800.0
2011-09-14 05:00:00	AAPL	Stock	13.6964	13.7054	13.6964	13.7054	14000.0
2011-09-14 05:30:00	AAPL	Stock	13.735	13.735	13.7232	13.7286	19600.0
2011-09-14 06:00:00	AAPL	Stock	13.725	13.7539	13.725	13.7539	5600.0
2011-09-14 06:30:00	AAPL	Stock	13.7564	13.8107	13.7564	13.8107	51800.0
2011-09-14 07:00:00	AAPL	Stock	13.81	13.87	13.81	13.8196	450576.0
2011-09-14 07:30:00	AAPL	Stock	13.8164	13.8482	13.8089	13.8264	635040.0
2011-09-14 08:00:00	AAPL	Stock	13.8343	13.845	13.8079	13.8143	1210804.0
2011-09-14 08:30:00	AAPL	Stock	13.8093	13.8343	13.8	13.8214	1239336.0
2011-09-14 09:00:00	AAPL	Stock	13.8182	13.8393	13.8036	13.82	1449448.0
2011-09-14 09:30:00	AAPL	Stock	13.8221	13.8914	13.8086	13.8725	75628448.0
2011-09-14 10:00:00	AAPL	Stock	13.8725	13.8818	13.7771	13.835	62179824.0
2011-09-14 10:30:00	AAPL	Stock	13.8361	13.8868	13.8339	13.8625	38263736.0
2011-09-14 11:00:00	AAPL	Stock	13.86	13.9275	13.8525	13.9239	36671796.0
2011-09-14 11:30:00	AAPL	Stock	13.9232	13.9286	13.8932	13.9207	24482500.0
2011-09-14 12:00:00	AAPL	Stock	13.9214	13.9275	13.8732	13.9043	22420692.0
2011-09-14 12:30:00	AAPL	Stock	13.9043	13.9286	13.9007	13.9046	17290896.0
2011-09-14 13:00:00	AAPL	Stock	13.9037	13.9271	13.9004	13.9161	15510152.0
2011-09-14 13:30:00	AAPL	Stock	13.9157	13.9575	13.9111	13.9307	32891852.0
2011-09-14 14:00:00	AAPL	Stock	13.9307	13.9796	13.9282	13.9668	32978176.0
2011-09-14 14:30:00	AAPL	Stock	13.9657	13.9761	13.9464	13.9707	27498548.0
2011-09-14 15:00:00	AAPL	Stock	13.9721	14.0	13.9643	13.9936	48525316.0
2011-09-14 15:30:00	AAPL	Stock	13.9935	14.0075	13.8943	13.9029	78202880.0
2011-09-14 16:00:00	AAPL	Stock	13.9039	13.9568	13.7364	13.9568	11320792.0
2011-09-14 16:30:00	AAPL	Stock	13.8996	14.001	13.8194	13.9036	1112776.0
2011-09-14 17:00:00	AAPL	Stock	13.8932	13.8932	13.8804	13.8804	178612.0
2011-09-14 17:30:00	AAPL	Stock	13.8793	13.8946	13.8793	13.8929	37464.0
2011-09-14 18:00:00	AAPL	Stock	13.8957	13.9036	13.8871	13.8871	149660.0
2011-09-14 18:30:00	AAPL	Stock	13.8893	13.8989	13.8893	13.8968	114520.0
2011-09-14 19:00:00	AAPL	Stock	13.8989	13.9032	13.8971	13.9029	76272.0
2011-09-14 19:30:00	AAPL	Stock	13.9029	13.9057	13.8996	13.9	155932.0
2011-09-14 04:00:00	MSFT	Stock	26.0	26.0	26.0	26.0	200.0
2011-09-14 07:00:00	MSFT	Stock	26.23	26.23	26.23	26.23	100.0
2011-09-14 07:30:00	MSFT	Stock	26.17	26.26	26.17	26.26	500.0
2011-09-14 08:00:00	MSFT	Stock	26.2	26.26	26.2	26.23	28700.0
2011-09-14 08:30:00	MSFT	Stock	26.21	26.24	26.16	26.2	11439.0
2011-09-14 09:00:00	MSFT	Stock	26.2	26.23	26.16	26.16	18194.0
2011-09-14 09:30:00	MSFT	Stock	26.17	26.25	26.02	26.18	4911743.0
2011-09-14 10:00:00	MSFT	Stock	26.19	26.19	25.89	25.97	6571777.0
2011-09-14 10:30:00	MSFT	Stock	25.973	26.07	25.9	26.06	6000369.0
2011-09-14 11:00:00	MSFT	Stock	26.06	26.25	25.99	26.24	4560966.0
2011-09-14 11:30:00	MSFT	Stock	26.24	26.34	26.16	26.33	2825619.0
2011-09-14 12:00:00	MSFT	Stock	26.34	26.37	26.255	26.263	2818710.0
2011-09-14 12:30:00	MSFT	Stock	26.27	26.34	26.22	26.235	3588206.0
2011-09-14 13:00:00	MSFT	Stock	26.23	26.29	26.22	26.29	2362717.0
2011-09-14 13:30:00	MSFT	Stock	26.286	26.43	26.27	26.34	3537006.0
2011-09-14 14:00:00	MSFT	Stock	26.35	26.48	26.34	26.45	3473595.0
2011-09-14 14:30:00	MSFT	Stock	26.45	26.58	26.39	26.56	4328659.0
2011-09-14 15:00:00	MSFT	Stock	26.57	26.79	26.57	26.775	4893350.0

> showing 50 of 75,029 rows — these rows as CSV

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