PREVIEW / stock_30min / 2013-03-12

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-12.parquet
  size:    1.5 MB
  rows:    77,054
  symbols: 3,465

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-03-12 04:00:00	AAPL	Stock	15.5382	15.5382	15.5382	15.5382	2800.0
2013-03-12 05:00:00	AAPL	Stock	15.5625	15.5786	15.5539	15.5707	39200.0
2013-03-12 05:30:00	AAPL	Stock	15.5893	15.5893	15.5604	15.5604	8400.0
2013-03-12 06:00:00	AAPL	Stock	15.5875	15.5893	15.5721	15.5721	19600.0
2013-03-12 06:30:00	AAPL	Stock	15.5893	15.5893	15.5804	15.5857	8400.0
2013-03-12 07:00:00	AAPL	Stock	15.5854	15.5857	15.4993	15.525	284004.0
2013-03-12 07:30:00	AAPL	Stock	15.525	15.5536	15.4679	15.4696	548072.0
2013-03-12 08:00:00	AAPL	Stock	15.4925	15.6068	15.4861	15.5071	1124984.0
2013-03-12 08:30:00	AAPL	Stock	15.5071	15.5464	15.4993	15.5057	1588272.0
2013-03-12 09:00:00	AAPL	Stock	15.5104	15.5704	15.4821	15.5643	3153668.0
2013-03-12 09:30:00	AAPL	Stock	15.5571	15.6743	15.4821	15.5954	79380308.0
2013-03-12 10:00:00	AAPL	Stock	15.595	15.6293	15.4496	15.485	44051420.0
2013-03-12 10:30:00	AAPL	Stock	15.485	15.5064	15.3871	15.4482	44304708.0
2013-03-12 11:00:00	AAPL	Stock	15.4514	15.4525	15.3439	15.3514	36801996.0
2013-03-12 11:30:00	AAPL	Stock	15.3522	15.45	15.3314	15.4146	33706596.0
2013-03-12 12:00:00	AAPL	Stock	15.4157	15.4192	15.3571	15.3675	17266312.0
2013-03-12 12:30:00	AAPL	Stock	15.3664	15.4375	15.3664	15.4207	16550912.0
2013-03-12 13:00:00	AAPL	Stock	15.4189	15.4789	15.4082	15.4339	22967616.0
2013-03-12 13:30:00	AAPL	Stock	15.4321	15.4439	15.3664	15.39	16397332.0
2013-03-12 14:00:00	AAPL	Stock	15.3914	15.3961	15.3393	15.3446	21236852.0
2013-03-12 14:30:00	AAPL	Stock	15.3489	15.3732	15.3161	15.3246	18172616.0
2013-03-12 15:00:00	AAPL	Stock	15.3218	15.4064	15.3214	15.3582	29939140.0
2013-03-12 15:30:00	AAPL	Stock	15.3606	15.3714	15.2704	15.3036	46568480.0
2013-03-12 16:00:00	AAPL	Stock	15.3036	15.4362	15.2929	15.3011	25842264.0
2013-03-12 16:30:00	AAPL	Stock	15.2943	15.6458	15.2882	15.2918	252868.0
2013-03-12 17:00:00	AAPL	Stock	15.2914	15.3011	15.2679	15.2679	702408.0
2013-03-12 17:30:00	AAPL	Stock	15.2686	15.2743	15.2521	15.2639	376964.0
2013-03-12 18:00:00	AAPL	Stock	15.2675	15.2675	15.2464	15.2614	251692.0
2013-03-12 18:30:00	AAPL	Stock	15.2579	15.275	15.2579	15.275	162484.0
2013-03-12 19:00:00	AAPL	Stock	15.2732	15.2775	15.2643	15.2643	54516.0
2013-03-12 19:30:00	AAPL	Stock	15.2654	15.2668	15.2511	15.2554	367836.0
2013-03-12 07:30:00	MSFT	Stock	27.84	27.84	27.84	27.84	500.0
2013-03-12 08:00:00	MSFT	Stock	27.84	27.84	27.71	27.78	4215.0
2013-03-12 08:30:00	MSFT	Stock	27.8	27.81	27.8	27.81	1600.0
2013-03-12 09:00:00	MSFT	Stock	27.77	27.88	27.74	27.83	12600.0
2013-03-12 09:30:00	MSFT	Stock	27.84	27.91	27.76	27.87	3010618.0
2013-03-12 10:00:00	MSFT	Stock	27.87	27.88	27.75	27.79	2754977.0
2013-03-12 10:30:00	MSFT	Stock	27.78	27.8	27.74	27.76	2357874.0
2013-03-12 11:00:00	MSFT	Stock	27.76	27.77	27.64	27.66	4934299.0
2013-03-12 11:30:00	MSFT	Stock	27.66	27.75	27.64	27.735	3603441.0
2013-03-12 12:00:00	MSFT	Stock	27.738	27.75	27.7	27.73	1464043.0
2013-03-12 12:30:00	MSFT	Stock	27.73	27.8	27.71	27.782	2065638.0
2013-03-12 13:00:00	MSFT	Stock	27.787	27.8	27.76	27.785	1060558.0
2013-03-12 13:30:00	MSFT	Stock	27.78	27.805	27.74	27.754	2096940.0
2013-03-12 14:00:00	MSFT	Stock	27.76	27.79	27.74	27.76	1809917.0
2013-03-12 14:30:00	MSFT	Stock	27.76	27.81	27.74	27.78	1939517.0
2013-03-12 15:00:00	MSFT	Stock	27.784	27.91	27.78	27.9	2700687.0
2013-03-12 15:30:00	MSFT	Stock	27.9	27.95	27.86	27.92	5269077.0
2013-03-12 16:00:00	MSFT	Stock	27.92	27.93	27.759	27.91	1860482.0
2013-03-12 16:30:00	MSFT	Stock	27.93	27.93	27.716	27.716	16480.0

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

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