PREVIEW / stock_30min / 2013-08-27

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-27.parquet
  size:    1.5 MB
  rows:    81,244
  symbols: 3,522

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-08-27 04:00:00	AAPL	Stock	17.9632	17.9643	17.9107	17.9107	61320.0
2013-08-27 04:30:00	AAPL	Stock	17.8743	17.8743	17.8511	17.8511	50736.0
2013-08-27 05:00:00	AAPL	Stock	17.85	17.85	17.85	17.85	5516.0
2013-08-27 05:30:00	AAPL	Stock	17.8568	17.8568	17.8214	17.8214	8456.0
2013-08-27 06:00:00	AAPL	Stock	17.8229	17.8229	17.8229	17.8229	2800.0
2013-08-27 06:30:00	AAPL	Stock	17.8064	17.8064	17.6811	17.7464	218120.0
2013-08-27 07:00:00	AAPL	Stock	17.7411	17.8218	17.7411	17.7868	803180.0
2013-08-27 07:30:00	AAPL	Stock	17.7875	17.8036	17.75	17.7946	341152.0
2013-08-27 08:00:00	AAPL	Stock	17.8	17.8571	17.7411	17.8071	1382388.0
2013-08-27 08:30:00	AAPL	Stock	17.8096	17.8257	17.7868	17.8071	1360520.0
2013-08-27 09:00:00	AAPL	Stock	17.81	17.8143	17.7704	17.7843	1116808.0
2013-08-27 09:30:00	AAPL	Stock	17.7711	17.9393	17.7582	17.9143	60924752.0
2013-08-27 10:00:00	AAPL	Stock	17.9121	17.9468	17.8057	17.8149	29218084.0
2013-08-27 10:30:00	AAPL	Stock	17.8189	17.8543	17.7975	17.8336	18131288.0
2013-08-27 11:00:00	AAPL	Stock	17.8364	17.8782	17.825	17.8675	11529280.0
2013-08-27 11:30:00	AAPL	Stock	17.8711	17.8821	17.8157	17.8425	9794120.0
2013-08-27 12:00:00	AAPL	Stock	17.8425	17.8425	17.7271	17.7443	20796048.0
2013-08-27 12:30:00	AAPL	Stock	17.7443	17.7618	17.615	17.644	35020188.0
2013-08-27 13:00:00	AAPL	Stock	17.6439	17.6446	17.4384	17.4736	59532004.0
2013-08-27 13:30:00	AAPL	Stock	17.4721	17.6036	17.4575	17.5357	37554384.0
2013-08-27 14:00:00	AAPL	Stock	17.5361	17.5361	17.4446	17.4829	25386872.0
2013-08-27 14:30:00	AAPL	Stock	17.4846	17.4964	17.4029	17.4893	26231380.0
2013-08-27 15:00:00	AAPL	Stock	17.4961	17.5318	17.4304	17.4554	22562540.0
2013-08-27 15:30:00	AAPL	Stock	17.4525	17.495	17.3679	17.4346	46586904.0
2013-08-27 16:00:00	AAPL	Stock	17.4329	17.8416	17.4	17.4039	11295984.0
2013-08-27 16:30:00	AAPL	Stock	17.4071	17.4329	17.4036	17.4286	385252.0
2013-08-27 17:00:00	AAPL	Stock	17.4371	17.4371	17.4036	17.4054	137452.0
2013-08-27 17:30:00	AAPL	Stock	17.4175	17.4395	17.4075	17.4107	243712.0
2013-08-27 18:00:00	AAPL	Stock	17.4168	17.4171	17.4071	17.4125	58268.0
2013-08-27 18:30:00	AAPL	Stock	17.4125	17.4143	17.4046	17.4082	60732.0
2013-08-27 19:00:00	AAPL	Stock	17.4071	17.4157	17.4043	17.4157	95956.0
2013-08-27 19:30:00	AAPL	Stock	17.4157	17.4157	17.3982	17.4036	237132.0
2013-08-27 04:00:00	MSFT	Stock	33.8	33.8	33.8	33.8	100.0
2013-08-27 06:00:00	MSFT	Stock	33.87	33.87	33.86	33.86	1200.0
2013-08-27 06:30:00	MSFT	Stock	33.78	33.78	33.75	33.75	2700.0
2013-08-27 07:00:00	MSFT	Stock	33.7	33.72	33.68	33.71	3900.0
2013-08-27 07:30:00	MSFT	Stock	33.7	33.76	33.69	33.72	11951.0
2013-08-27 08:00:00	MSFT	Stock	33.76	34.25	33.62	33.7	36620.0
2013-08-27 08:30:00	MSFT	Stock	33.7	33.7	33.57	33.7	40803.0
2013-08-27 09:00:00	MSFT	Stock	33.7	33.72	33.36	33.53	386103.0
2013-08-27 09:30:00	MSFT	Stock	33.53	34.1	33.36	33.893	13156365.0
2013-08-27 10:00:00	MSFT	Stock	33.89	33.916	33.64	33.68	4892063.0
2013-08-27 10:30:00	MSFT	Stock	33.68	33.77	33.55	33.68	3692208.0
2013-08-27 11:00:00	MSFT	Stock	33.68	33.75	33.575	33.73	3424550.0
2013-08-27 11:30:00	MSFT	Stock	33.73	33.79	33.61	33.615	2750533.0
2013-08-27 12:00:00	MSFT	Stock	33.61	33.62	33.5	33.51	2411209.0
2013-08-27 12:30:00	MSFT	Stock	33.515	33.62	33.44	33.55	3034985.0
2013-08-27 13:00:00	MSFT	Stock	33.555	33.58	33.38	33.412	1557001.0
2013-08-27 13:30:00	MSFT	Stock	33.414	33.57	33.38	33.42	2376061.0
2013-08-27 14:00:00	MSFT	Stock	33.42	33.44	33.24	33.284	2744912.0

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

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