PREVIEW / stock_30min / 2011-07-27

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-27.parquet
  size:    1.5 MB
  rows:    77,920
  symbols: 3,544

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
2011-07-27 05:30:00	AAPL	Stock	14.4214	14.4214	14.4214	14.4214	2800.0
2011-07-27 06:30:00	AAPL	Stock	14.4018	14.4018	14.4018	14.4018	14000.0
2011-07-27 07:00:00	AAPL	Stock	14.4011	14.4229	14.3929	14.3929	173600.0
2011-07-27 07:30:00	AAPL	Stock	14.3921	14.3986	14.3714	14.3714	114324.0
2011-07-27 08:00:00	AAPL	Stock	14.3714	14.375	14.3214	14.3454	1576204.0
2011-07-27 08:30:00	AAPL	Stock	14.3325	14.34	14.2857	14.3029	2332204.0
2011-07-27 09:00:00	AAPL	Stock	14.2982	14.3214	14.2857	14.3068	2027424.0
2011-07-27 09:30:00	AAPL	Stock	14.3054	14.38	14.2071	14.2336	104003088.0
2011-07-27 10:00:00	AAPL	Stock	14.2375	14.2629	14.0457	14.0779	115872540.0
2011-07-27 10:30:00	AAPL	Stock	14.0779	14.2107	14.0268	14.2025	78205064.0
2011-07-27 11:00:00	AAPL	Stock	14.2018	14.2107	14.1479	14.1893	38662176.0
2011-07-27 11:30:00	AAPL	Stock	14.1893	14.2029	14.1272	14.1411	27590192.0
2011-07-27 12:00:00	AAPL	Stock	14.1411	14.1575	14.1	14.1375	26867204.0
2011-07-27 12:30:00	AAPL	Stock	14.1371	14.1561	14.1	14.1077	26133660.0
2011-07-27 13:00:00	AAPL	Stock	14.1075	14.1496	14.0982	14.1089	16093056.0
2011-07-27 13:30:00	AAPL	Stock	14.1079	14.1436	14.0825	14.1319	20118952.0
2011-07-27 14:00:00	AAPL	Stock	14.1314	14.1357	14.0732	14.0764	19907468.0
2011-07-27 14:30:00	AAPL	Stock	14.075	14.0979	14.0468	14.0875	36968092.0
2011-07-27 15:00:00	AAPL	Stock	14.0857	14.1071	14.0054	14.0525	52085404.0
2011-07-27 15:30:00	AAPL	Stock	14.0529	14.0836	14.0089	14.0207	62282388.0
2011-07-27 16:00:00	AAPL	Stock	14.0204	14.1954	14.0071	14.0104	21626388.0
2011-07-27 16:30:00	AAPL	Stock	14.0139	14.0536	14.0018	14.0079	446684.0
2011-07-27 17:00:00	AAPL	Stock	14.0089	14.0204	13.9821	13.9821	899024.0
2011-07-27 17:30:00	AAPL	Stock	13.9814	13.9904	13.975	13.975	387912.0
2011-07-27 18:00:00	AAPL	Stock	13.9786	14.0211	13.9643	13.9714	616980.0
2011-07-27 18:30:00	AAPL	Stock	13.9732	13.9943	13.9682	13.9911	200368.0
2011-07-27 19:00:00	AAPL	Stock	13.9821	13.9911	13.9754	13.9911	286804.0
2011-07-27 19:30:00	AAPL	Stock	13.9911	13.9982	13.9686	13.975	367108.0
2011-07-27 07:00:00	MSFT	Stock	27.96	27.96	27.93	27.93	400.0
2011-07-27 07:30:00	MSFT	Stock	27.92	27.99	27.92	27.99	1100.0
2011-07-27 08:00:00	MSFT	Stock	27.95	27.98	27.9	27.9	7771.0
2011-07-27 08:30:00	MSFT	Stock	27.88	27.9	27.82	27.88	24383.0
2011-07-27 09:00:00	MSFT	Stock	27.85	27.94	27.85	27.87	104530.0
2011-07-27 09:30:00	MSFT	Stock	27.89	27.985	27.51	27.9	7428191.0
2011-07-27 10:00:00	MSFT	Stock	27.9	27.905	27.71	27.754	7170698.0
2011-07-27 10:30:00	MSFT	Stock	27.755	27.78	27.57	27.64	7100003.0
2011-07-27 11:00:00	MSFT	Stock	27.645	27.8	27.61	27.794	4067002.0
2011-07-27 11:30:00	MSFT	Stock	27.8	27.85	27.64	27.66	3803615.0
2011-07-27 12:00:00	MSFT	Stock	27.665	27.705	27.62	27.652	3628784.0
2011-07-27 12:30:00	MSFT	Stock	27.655	27.69	27.58	27.605	2310113.0
2011-07-27 13:00:00	MSFT	Stock	27.61	27.69	27.57	27.59	2058545.0
2011-07-27 13:30:00	MSFT	Stock	27.59	27.71	27.56	27.66	2982256.0
2011-07-27 14:00:00	MSFT	Stock	27.665	27.67	27.47	27.491	5826054.0
2011-07-27 14:30:00	MSFT	Stock	27.495	27.51	27.39	27.43	4267238.0
2011-07-27 15:00:00	MSFT	Stock	27.425	27.45	27.2	27.29	6512331.0
2011-07-27 15:30:00	MSFT	Stock	27.28	27.38	27.25	27.34	9350849.0
2011-07-27 16:00:00	MSFT	Stock	27.33	28.07	27.28	27.34	3304692.0
2011-07-27 16:30:00	MSFT	Stock	27.33	27.35	27.294	27.35	38240.0
2011-07-27 17:00:00	MSFT	Stock	27.33	27.35	27.29	27.29	139980.0
2011-07-27 17:30:00	MSFT	Stock	27.29	27.3	27.29	27.3	2072.0

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

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