PREVIEW / stock_30min / 2013-08-28

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-28.parquet
  size:    1.5 MB
  rows:    78,992
  symbols: 3,513

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-28 04:00:00	AAPL	Stock	17.4107	17.4214	17.3843	17.3929	66640.0
2013-08-28 04:30:00	AAPL	Stock	17.4	17.4	17.3757	17.3757	49084.0
2013-08-28 05:00:00	AAPL	Stock	17.4	17.4018	17.3879	17.3879	23688.0
2013-08-28 05:30:00	AAPL	Stock	17.375	17.375	17.375	17.375	11200.0
2013-08-28 06:00:00	AAPL	Stock	17.3732	17.3732	17.3368	17.3464	14000.0
2013-08-28 06:30:00	AAPL	Stock	17.3464	17.3529	17.3271	17.3529	137564.0
2013-08-28 07:00:00	AAPL	Stock	17.3529	17.3686	17.3393	17.3639	146496.0
2013-08-28 07:30:00	AAPL	Stock	17.3418	17.3479	17.3236	17.3332	298816.0
2013-08-28 08:00:00	AAPL	Stock	17.3539	17.4496	17.3236	17.4304	880656.0
2013-08-28 08:30:00	AAPL	Stock	17.4286	17.4882	17.4143	17.4286	2421412.0
2013-08-28 09:00:00	AAPL	Stock	17.4286	17.4489	17.3593	17.3661	1486940.0
2013-08-28 09:30:00	AAPL	Stock	17.3571	17.6368	17.3571	17.5894	68186692.0
2013-08-28 10:00:00	AAPL	Stock	17.5901	17.6193	17.4757	17.5389	41551272.0
2013-08-28 10:30:00	AAPL	Stock	17.5389	17.6168	17.5361	17.6107	17890124.0
2013-08-28 11:00:00	AAPL	Stock	17.6111	17.6152	17.5089	17.52	18283692.0
2013-08-28 11:30:00	AAPL	Stock	17.5129	17.5784	17.4825	17.5639	13185984.0
2013-08-28 12:00:00	AAPL	Stock	17.5682	17.5868	17.5468	17.5755	8383620.0
2013-08-28 12:30:00	AAPL	Stock	17.5775	17.6343	17.5714	17.6221	13682368.0
2013-08-28 13:00:00	AAPL	Stock	17.6239	17.7071	17.6239	17.6732	24082156.0
2013-08-28 13:30:00	AAPL	Stock	17.6732	17.6925	17.6111	17.6411	13673436.0
2013-08-28 14:00:00	AAPL	Stock	17.6429	17.6768	17.5896	17.5946	14219828.0
2013-08-28 14:30:00	AAPL	Stock	17.5932	17.6346	17.5893	17.6046	10251164.0
2013-08-28 15:00:00	AAPL	Stock	17.605	17.6496	17.5896	17.6179	11782344.0
2013-08-28 15:30:00	AAPL	Stock	17.6179	17.6411	17.5096	17.525	31346028.0
2013-08-28 16:00:00	AAPL	Stock	17.5239	17.5765	17.5111	17.5193	9601592.0
2013-08-28 16:30:00	AAPL	Stock	17.5239	17.5274	17.5154	17.5239	2604252.0
2013-08-28 17:00:00	AAPL	Stock	17.5189	17.5214	17.5	17.5018	112224.0
2013-08-28 17:30:00	AAPL	Stock	17.5043	17.5146	17.5036	17.5143	185276.0
2013-08-28 18:00:00	AAPL	Stock	17.5111	17.5189	17.5111	17.5143	37128.0
2013-08-28 18:30:00	AAPL	Stock	17.5129	17.5214	17.5054	17.5057	95984.0
2013-08-28 19:00:00	AAPL	Stock	17.5057	17.5118	17.5018	17.5018	89292.0
2013-08-28 19:30:00	AAPL	Stock	17.5021	17.5054	17.4957	17.5036	212044.0
2013-08-28 06:00:00	MSFT	Stock	33.17	33.3	33.16	33.3	9715.0
2013-08-28 06:30:00	MSFT	Stock	33.3	33.3	33.3	33.3	967.0
2013-08-28 07:30:00	MSFT	Stock	33.37	33.37	33.17	33.26	3213.0
2013-08-28 08:00:00	MSFT	Stock	33.26	33.39	33.16	33.39	5941.0
2013-08-28 08:30:00	MSFT	Stock	33.45	33.45	33.37	33.4	27375.0
2013-08-28 09:00:00	MSFT	Stock	33.4	33.42	33.35	33.42	42693.0
2013-08-28 09:30:00	MSFT	Stock	33.41	33.6	33.24	33.39	5956524.0
2013-08-28 10:00:00	MSFT	Stock	33.39	33.48	33.31	33.37	3049729.0
2013-08-28 10:30:00	MSFT	Stock	33.375	33.43	33.26	33.26	2699982.0
2013-08-28 11:00:00	MSFT	Stock	33.26	33.37	33.22	33.26	4224834.0
2013-08-28 11:30:00	MSFT	Stock	33.26	33.38	33.25	33.32	2895073.0
2013-08-28 12:00:00	MSFT	Stock	33.312	33.33	33.21	33.252	2563177.0
2013-08-28 12:30:00	MSFT	Stock	33.26	33.32	33.24	33.25	2571129.0
2013-08-28 13:00:00	MSFT	Stock	33.26	33.31	33.22	33.23	1422436.0
2013-08-28 13:30:00	MSFT	Stock	33.24	33.28	33.21	33.26	1441322.0
2013-08-28 14:00:00	MSFT	Stock	33.26	33.31	33.12	33.12	2363587.0
2013-08-28 14:30:00	MSFT	Stock	33.128	33.16	33.03	33.07	2192404.0
2013-08-28 15:00:00	MSFT	Stock	33.07	33.175	33.03	33.035	3132089.0

> showing 50 of 78,992 rows — these rows as CSV

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