PREVIEW / stock_30min / 2011-10-20

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-20.parquet
  size:    1.3 MB
  rows:    71,663
  symbols: 3,479

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-10-20 04:00:00	AAPL	Stock	14.2586	14.2679	14.25	14.2679	19600.0
2011-10-20 04:30:00	AAPL	Stock	14.3093	14.3307	14.3093	14.3307	36400.0
2011-10-20 05:30:00	AAPL	Stock	14.3561	14.3561	14.3143	14.3143	140000.0
2011-10-20 06:00:00	AAPL	Stock	14.3214	14.3214	14.3143	14.3179	22400.0
2011-10-20 06:30:00	AAPL	Stock	14.3107	14.3118	14.3107	14.3118	14000.0
2011-10-20 07:00:00	AAPL	Stock	14.3036	14.3036	14.2579	14.2682	87304.0
2011-10-20 07:30:00	AAPL	Stock	14.2857	14.3179	14.2693	14.2693	180992.0
2011-10-20 08:00:00	AAPL	Stock	14.2846	14.3036	14.25	14.2675	1297800.0
2011-10-20 08:30:00	AAPL	Stock	14.2675	14.2996	14.2271	14.2839	1433712.0
2011-10-20 09:00:00	AAPL	Stock	14.2857	14.2921	14.2396	14.2857	2221688.0
2011-10-20 09:30:00	AAPL	Stock	14.2857	14.2982	14.1111	14.1889	96783064.0
2011-10-20 10:00:00	AAPL	Stock	14.1893	14.2529	14.1565	14.2089	59462648.0
2011-10-20 10:30:00	AAPL	Stock	14.2089	14.2664	14.1961	14.2102	39875388.0
2011-10-20 11:00:00	AAPL	Stock	14.2082	14.2125	14.125	14.1764	44516948.0
2011-10-20 11:30:00	AAPL	Stock	14.1775	14.1957	14.1429	14.1532	23827384.0
2011-10-20 12:00:00	AAPL	Stock	14.1536	14.175	14.0875	14.1404	37308236.0
2011-10-20 12:30:00	AAPL	Stock	14.1378	14.1414	14.0789	14.1179	29828540.0
2011-10-20 13:00:00	AAPL	Stock	14.1184	14.1871	14.0832	14.1573	35929964.0
2011-10-20 13:30:00	AAPL	Stock	14.1536	14.1782	14.1307	14.1456	24399844.0
2011-10-20 14:00:00	AAPL	Stock	14.1432	14.1671	14.1154	14.1166	20793724.0
2011-10-20 14:30:00	AAPL	Stock	14.1175	14.1964	14.1119	14.1764	31249036.0
2011-10-20 15:00:00	AAPL	Stock	14.1761	14.18	14.1118	14.1229	24526320.0
2011-10-20 15:30:00	AAPL	Stock	14.1232	14.1393	14.0911	14.1232	51243640.0
2011-10-20 16:00:00	AAPL	Stock	14.1191	14.1668	14.0964	14.1182	13538588.0
2011-10-20 16:30:00	AAPL	Stock	14.1229	14.1229	14.1161	14.1193	1729448.0
2011-10-20 17:00:00	AAPL	Stock	14.1182	14.1357	14.1132	14.1357	441812.0
2011-10-20 17:30:00	AAPL	Stock	14.1379	14.1429	14.1221	14.1221	65100.0
2011-10-20 18:00:00	AAPL	Stock	14.1186	14.1304	14.1182	14.1229	195748.0
2011-10-20 18:30:00	AAPL	Stock	14.1218	14.1261	14.1214	14.1221	79996.0
2011-10-20 19:00:00	AAPL	Stock	14.1261	14.1261	14.1214	14.1214	31752.0
2011-10-20 19:30:00	AAPL	Stock	14.1214	14.125	14.1186	14.1232	122248.0
2011-10-20 05:00:00	MSFT	Stock	27.19	27.19	27.19	27.19	600.0
2011-10-20 05:30:00	MSFT	Stock	27.19	27.19	27.19	27.19	2400.0
2011-10-20 06:00:00	MSFT	Stock	27.19	27.19	27.19	27.19	900.0
2011-10-20 06:30:00	MSFT	Stock	27.18	27.18	27.18	27.18	6200.0
2011-10-20 07:00:00	MSFT	Stock	27.2	27.2	27.18	27.18	1000.0
2011-10-20 07:30:00	MSFT	Stock	27.26	27.26	27.23	27.23	2000.0
2011-10-20 08:00:00	MSFT	Stock	27.24	27.3	27.23	27.29	26426.0
2011-10-20 08:30:00	MSFT	Stock	27.26	27.34	27.25	27.33	38604.0
2011-10-20 09:00:00	MSFT	Stock	27.34	27.37	27.12	27.23	86707.0
2011-10-20 09:30:00	MSFT	Stock	27.24	27.34	26.75	26.75	6607033.0
2011-10-20 10:00:00	MSFT	Stock	26.76	26.89	26.62	26.75	7163930.0
2011-10-20 10:30:00	MSFT	Stock	26.759	26.93	26.61	26.61	5180869.0
2011-10-20 11:00:00	MSFT	Stock	26.61	26.71	26.51	26.654	4574091.0
2011-10-20 11:30:00	MSFT	Stock	26.66	26.67	26.4	26.54	4407382.0
2011-10-20 12:00:00	MSFT	Stock	26.55	26.55	26.45	26.532	3962842.0
2011-10-20 12:30:00	MSFT	Stock	26.54	26.76	26.51	26.72	3737838.0
2011-10-20 13:00:00	MSFT	Stock	26.73	26.95	26.72	26.9	4577912.0
2011-10-20 13:30:00	MSFT	Stock	26.91	26.95	26.83	26.87	4188454.0
2011-10-20 14:00:00	MSFT	Stock	26.87	26.95	26.86	26.92	2704477.0

> showing 50 of 71,663 rows — these rows as CSV

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