PREVIEW / stock_30min / 2013-01-10

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-10.parquet
  size:    1.4 MB
  rows:    77,086
  symbols: 3,467

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-01-10 04:00:00	AAPL	Stock	18.4854	18.4854	18.4854	18.4854	2800.0
2013-01-10 04:30:00	AAPL	Stock	18.5293	18.5293	18.5004	18.515	95956.0
2013-01-10 05:00:00	AAPL	Stock	18.5154	18.5157	18.5154	18.5157	39200.0
2013-01-10 05:30:00	AAPL	Stock	18.5157	18.5357	18.5157	18.5321	106904.0
2013-01-10 06:00:00	AAPL	Stock	18.5357	18.5536	18.5321	18.5536	175280.0
2013-01-10 06:30:00	AAPL	Stock	18.6	18.6071	18.575	18.5893	316596.0
2013-01-10 07:00:00	AAPL	Stock	18.5779	18.6236	18.5625	18.5982	1259328.0
2013-01-10 07:30:00	AAPL	Stock	18.5996	18.7429	18.595	18.7357	1865416.0
2013-01-10 08:00:00	AAPL	Stock	18.7346	18.9929	18.6786	18.9246	9342648.0
2013-01-10 08:30:00	AAPL	Stock	18.9196	18.9514	18.8646	18.8875	4547060.0
2013-01-10 09:00:00	AAPL	Stock	18.89	18.9464	18.8596	18.875	3769836.0
2013-01-10 09:30:00	AAPL	Stock	18.875	18.8829	18.5982	18.6764	106379140.0
2013-01-10 10:00:00	AAPL	Stock	18.6721	18.6854	18.495	18.5064	65873696.0
2013-01-10 10:30:00	AAPL	Stock	18.5086	18.5793	18.4761	18.5245	39709068.0
2013-01-10 11:00:00	AAPL	Stock	18.5229	18.5429	18.4414	18.5181	38400516.0
2013-01-10 11:30:00	AAPL	Stock	18.515	18.5604	18.4868	18.5035	23190636.0
2013-01-10 12:00:00	AAPL	Stock	18.5029	18.5082	18.4286	18.4914	25004448.0
2013-01-10 12:30:00	AAPL	Stock	18.4954	18.5025	18.4114	18.4336	26553968.0
2013-01-10 13:00:00	AAPL	Stock	18.4339	18.5179	18.42	18.5086	23226252.0
2013-01-10 13:30:00	AAPL	Stock	18.5096	18.5096	18.45	18.4787	13124020.0
2013-01-10 14:00:00	AAPL	Stock	18.4787	18.4925	18.4225	18.4511	15779904.0
2013-01-10 14:30:00	AAPL	Stock	18.4564	18.6786	18.4386	18.6211	55431068.0
2013-01-10 15:00:00	AAPL	Stock	18.6207	18.7489	18.5993	18.7421	55206368.0
2013-01-10 15:30:00	AAPL	Stock	18.7421	18.7707	18.6796	18.6957	64214976.0
2013-01-10 16:00:00	AAPL	Stock	18.7029	18.7143	18.4652	18.7139	12379892.0
2013-01-10 16:30:00	AAPL	Stock	18.7143	18.7286	18.5889	18.7229	1245160.0
2013-01-10 17:00:00	AAPL	Stock	18.7229	18.7286	18.7161	18.7179	196812.0
2013-01-10 17:30:00	AAPL	Stock	18.7196	18.7275	18.7186	18.7232	147700.0
2013-01-10 18:00:00	AAPL	Stock	18.7236	18.7414	18.7214	18.7332	373772.0
2013-01-10 18:30:00	AAPL	Stock	18.7307	18.7411	18.7264	18.7264	152572.0
2013-01-10 19:00:00	AAPL	Stock	18.7318	18.7318	18.7196	18.7196	156240.0
2013-01-10 19:30:00	AAPL	Stock	18.7186	18.7286	18.7161	18.7214	361508.0
2013-01-10 04:00:00	MSFT	Stock	26.61	26.61	26.45	26.45	1590.0
2013-01-10 04:30:00	MSFT	Stock	26.5	26.5	26.5	26.5	200.0
2013-01-10 05:00:00	MSFT	Stock	26.5	26.5	26.5	26.5	1000.0
2013-01-10 06:00:00	MSFT	Stock	26.5	26.58	26.49	26.55	25224.0
2013-01-10 06:30:00	MSFT	Stock	26.5	26.52	26.5	26.52	7000.0
2013-01-10 07:00:00	MSFT	Stock	26.55	26.55	26.5	26.5	14870.0
2013-01-10 07:30:00	MSFT	Stock	26.51	26.51	26.39	26.45	48686.0
2013-01-10 08:00:00	MSFT	Stock	26.45	26.59	26.39	26.55	208786.0
2013-01-10 08:30:00	MSFT	Stock	26.57	26.7	26.45	26.52	247263.0
2013-01-10 09:00:00	MSFT	Stock	26.55	26.71	26.54	26.65	211088.0
2013-01-10 09:30:00	MSFT	Stock	26.67	26.98	26.59	26.87	8709753.0
2013-01-10 10:00:00	MSFT	Stock	26.875	26.88	26.64	26.64	3786417.0
2013-01-10 10:30:00	MSFT	Stock	26.65	26.65	26.45	26.495	6360402.0
2013-01-10 11:00:00	MSFT	Stock	26.49	26.5	26.38	26.477	5245418.0
2013-01-10 11:30:00	MSFT	Stock	26.475	26.49	26.4	26.42	3540919.0
2013-01-10 12:00:00	MSFT	Stock	26.43	26.45	26.4	26.42	3779802.0
2013-01-10 12:30:00	MSFT	Stock	26.426	26.44	26.3	26.32	6092792.0
2013-01-10 13:00:00	MSFT	Stock	26.32	26.4	26.29	26.35	5227080.0

> showing 50 of 77,086 rows — these rows as CSV

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