PREVIEW / stock_30min / 2014-02-26

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-26.parquet
  size:    1.6 MB
  rows:    81,429
  symbols: 3,535

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
2014-02-26 04:00:00	AAPL	Stock	18.6429	18.6429	18.5532	18.5714	16800.0
2014-02-26 04:30:00	AAPL	Stock	18.5714	18.5714	18.5214	18.525	108864.0
2014-02-26 05:00:00	AAPL	Stock	18.5357	18.5357	18.5357	18.5357	2800.0
2014-02-26 05:30:00	AAPL	Stock	18.5429	18.5868	18.5429	18.5821	36400.0
2014-02-26 06:00:00	AAPL	Stock	18.5714	18.5714	18.5671	18.5671	11200.0
2014-02-26 06:30:00	AAPL	Stock	18.5768	18.6071	18.5768	18.6071	37044.0
2014-02-26 07:00:00	AAPL	Stock	18.6071	18.6429	18.6071	18.6379	146244.0
2014-02-26 07:30:00	AAPL	Stock	18.6171	18.6607	18.6164	18.66	180600.0
2014-02-26 08:00:00	AAPL	Stock	18.62	18.7232	18.62	18.7143	437052.0
2014-02-26 08:30:00	AAPL	Stock	18.7143	18.75	18.6725	18.7429	682752.0
2014-02-26 09:00:00	AAPL	Stock	18.7407	18.7407	18.6964	18.6964	411684.0
2014-02-26 09:30:00	AAPL	Stock	18.6964	18.75	18.4829	18.4843	43509340.0
2014-02-26 10:00:00	AAPL	Stock	18.4843	18.5954	18.4821	18.5568	33135228.0
2014-02-26 10:30:00	AAPL	Stock	18.5546	18.5746	18.4961	18.5021	14589652.0
2014-02-26 11:00:00	AAPL	Stock	18.5019	18.5679	18.4943	18.5632	13302016.0
2014-02-26 11:30:00	AAPL	Stock	18.5661	18.5761	18.5086	18.5218	10539452.0
2014-02-26 12:00:00	AAPL	Stock	18.5207	18.5589	18.5179	18.5364	7095928.0
2014-02-26 12:30:00	AAPL	Stock	18.5368	18.56	18.5357	18.5536	7778148.0
2014-02-26 13:00:00	AAPL	Stock	18.555	18.5586	18.5161	18.54	7396116.0
2014-02-26 13:30:00	AAPL	Stock	18.5411	18.5436	18.5036	18.5123	9978892.0
2014-02-26 14:00:00	AAPL	Stock	18.5139	18.5321	18.4468	18.4478	16099188.0
2014-02-26 14:30:00	AAPL	Stock	18.45	18.4821	18.4339	18.4821	12628168.0
2014-02-26 15:00:00	AAPL	Stock	18.4821	18.4821	18.4143	18.4386	18266248.0
2014-02-26 15:30:00	AAPL	Stock	18.4421	18.4821	18.4364	18.4762	25437608.0
2014-02-26 16:00:00	AAPL	Stock	18.4768	18.645	18.4321	18.4321	3951080.0
2014-02-26 16:30:00	AAPL	Stock	18.4443	18.4768	18.44	18.44	125244.0
2014-02-26 17:00:00	AAPL	Stock	18.4464	18.4768	18.4375	18.4554	215264.0
2014-02-26 17:30:00	AAPL	Stock	18.4554	18.4771	18.4554	18.4643	80052.0
2014-02-26 18:00:00	AAPL	Stock	18.4639	18.4732	18.4639	18.4732	31332.0
2014-02-26 18:30:00	AAPL	Stock	18.4696	18.4696	18.4643	18.4686	52920.0
2014-02-26 19:00:00	AAPL	Stock	18.4707	18.4707	18.465	18.465	16800.0
2014-02-26 19:30:00	AAPL	Stock	18.4671	18.4696	18.4336	18.4336	75908.0
2014-02-26 08:00:00	MSFT	Stock	37.6	37.65	37.6	37.65	3198.0
2014-02-26 08:30:00	MSFT	Stock	37.58	37.63	37.58	37.61	1200.0
2014-02-26 09:00:00	MSFT	Stock	37.79	37.79	37.59	37.59	600.0
2014-02-26 09:30:00	MSFT	Stock	37.62	37.73	37.58	37.64	2273703.0
2014-02-26 10:00:00	MSFT	Stock	37.65	37.67	37.51	37.615	3309713.0
2014-02-26 10:30:00	MSFT	Stock	37.62	37.74	37.58	37.64	4582196.0
2014-02-26 11:00:00	MSFT	Stock	37.64	37.66	37.55	37.64	1325836.0
2014-02-26 11:30:00	MSFT	Stock	37.633	37.66	37.5	37.545	3170348.0
2014-02-26 12:00:00	MSFT	Stock	37.545	37.55	37.5	37.506	887438.0
2014-02-26 12:30:00	MSFT	Stock	37.51	37.54	37.48	37.485	1834207.0
2014-02-26 13:00:00	MSFT	Stock	37.49	37.54	37.42	37.53	4200101.0
2014-02-26 13:30:00	MSFT	Stock	37.53	37.54	37.5	37.505	1315498.0
2014-02-26 14:00:00	MSFT	Stock	37.51	37.51	37.19	37.2	4187057.0
2014-02-26 14:30:00	MSFT	Stock	37.21	37.49	37.2	37.46	2781480.0
2014-02-26 15:00:00	MSFT	Stock	37.47	37.51	37.375	37.44	2092595.0
2014-02-26 15:30:00	MSFT	Stock	37.435	37.5	37.4	37.47	4201325.0
2014-02-26 16:00:00	MSFT	Stock	37.47	37.504	37.421	37.47	3382981.0
2014-02-26 16:30:00	MSFT	Stock	37.47	37.47	37.46	37.46	12833.0

> showing 50 of 81,429 rows — these rows as CSV

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