PREVIEW / stock_30min / 2013-06-17

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-17.parquet
  size:    1.5 MB
  rows:    79,849
  symbols: 3,526

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-06-17 04:00:00	AAPL	Stock	15.4361	15.4661	15.3571	15.4661	34356.0
2013-06-17 04:30:00	AAPL	Stock	15.4657	15.4657	15.4657	15.4657	2800.0
2013-06-17 05:30:00	AAPL	Stock	15.4664	15.4664	15.4664	15.4664	2800.0
2013-06-17 06:00:00	AAPL	Stock	15.4679	15.4732	15.4664	15.4664	8400.0
2013-06-17 06:30:00	AAPL	Stock	15.4696	15.4704	15.4664	15.4693	21056.0
2013-06-17 07:00:00	AAPL	Stock	15.4671	15.4814	15.4514	15.4554	120400.0
2013-06-17 07:30:00	AAPL	Stock	15.4514	15.4679	15.4175	15.4396	519092.0
2013-06-17 08:00:00	AAPL	Stock	15.4421	15.4679	15.4011	15.4218	927304.0
2013-06-17 08:30:00	AAPL	Stock	15.4286	15.4625	15.4214	15.4286	609784.0
2013-06-17 09:00:00	AAPL	Stock	15.4271	15.4286	15.4032	15.4107	698264.0
2013-06-17 09:30:00	AAPL	Stock	15.4086	15.4518	15.3701	15.4057	45627316.0
2013-06-17 10:00:00	AAPL	Stock	15.4061	15.525	15.3771	15.4975	37958536.0
2013-06-17 10:30:00	AAPL	Stock	15.4975	15.5239	15.48	15.5072	19943868.0
2013-06-17 11:00:00	AAPL	Stock	15.5089	15.5243	15.4739	15.4993	15826720.0
2013-06-17 11:30:00	AAPL	Stock	15.5	15.5068	15.44	15.4632	14913304.0
2013-06-17 12:00:00	AAPL	Stock	15.4614	15.4993	15.4525	15.4939	5794488.0
2013-06-17 12:30:00	AAPL	Stock	15.4929	15.4996	15.47	15.4993	8560020.0
2013-06-17 13:00:00	AAPL	Stock	15.4977	15.5607	15.4977	15.5432	19374880.0
2013-06-17 13:30:00	AAPL	Stock	15.5421	15.5589	15.5293	15.5387	8556352.0
2013-06-17 14:00:00	AAPL	Stock	15.5411	15.5518	15.4593	15.4739	15456112.0
2013-06-17 14:30:00	AAPL	Stock	15.4736	15.4786	15.3929	15.4329	17628548.0
2013-06-17 15:00:00	AAPL	Stock	15.435	15.45	15.408	15.4379	11932480.0
2013-06-17 15:30:00	AAPL	Stock	15.4346	15.4643	15.42	15.4318	25125128.0
2013-06-17 16:00:00	AAPL	Stock	15.4286	15.4996	15.4204	15.4286	6853784.0
2013-06-17 16:30:00	AAPL	Stock	15.4286	15.435	15.4286	15.435	728280.0
2013-06-17 17:00:00	AAPL	Stock	15.4307	15.435	15.4304	15.4304	51548.0
2013-06-17 17:30:00	AAPL	Stock	15.4318	15.4318	15.4286	15.4307	136500.0
2013-06-17 18:00:00	AAPL	Stock	15.4314	15.4318	15.425	15.4304	130060.0
2013-06-17 18:30:00	AAPL	Stock	15.4221	15.4286	15.4221	15.425	14000.0
2013-06-17 19:30:00	AAPL	Stock	15.425	15.4304	15.425	15.4304	23072.0
2013-06-17 04:00:00	MSFT	Stock	34.54	34.54	34.54	34.54	100.0
2013-06-17 05:30:00	MSFT	Stock	34.6	34.61	34.6	34.61	800.0
2013-06-17 06:00:00	MSFT	Stock	34.62	34.62	34.62	34.62	400.0
2013-06-17 07:30:00	MSFT	Stock	34.6	34.62	34.6	34.62	2046.0
2013-06-17 08:00:00	MSFT	Stock	34.54	34.63	34.54	34.62	5636.0
2013-06-17 08:30:00	MSFT	Stock	34.59	34.62	34.54	34.61	5174.0
2013-06-17 09:00:00	MSFT	Stock	34.6	34.74	34.58	34.71	45679.0
2013-06-17 09:30:00	MSFT	Stock	34.69	34.98	34.63	34.82	6021408.0
2013-06-17 10:00:00	MSFT	Stock	34.82	34.87	34.785	34.83	4271536.0
2013-06-17 10:30:00	MSFT	Stock	34.83	34.94	34.83	34.93	2372095.0
2013-06-17 11:00:00	MSFT	Stock	34.93	35.02	34.91	35.0	4237901.0
2013-06-17 11:30:00	MSFT	Stock	35.01	35.02	34.96	34.99	5046381.0
2013-06-17 12:00:00	MSFT	Stock	35.0	35.04	34.975	35.025	3439318.0
2013-06-17 12:30:00	MSFT	Stock	35.03	35.13	35.012	35.128	2725178.0
2013-06-17 13:00:00	MSFT	Stock	35.12	35.15	35.09	35.13	1480249.0
2013-06-17 13:30:00	MSFT	Stock	35.125	35.16	35.12	35.131	930798.0
2013-06-17 14:00:00	MSFT	Stock	35.14	35.15	34.95	34.984	1820029.0
2013-06-17 14:30:00	MSFT	Stock	34.984	35.005	34.7	34.775	2894315.0
2013-06-17 15:00:00	MSFT	Stock	34.77	34.88	34.745	34.87	1875777.0
2013-06-17 15:30:00	MSFT	Stock	34.87	35.02	34.864	34.99	5607304.0

> showing 50 of 79,849 rows — these rows as CSV

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