PREVIEW / stock_30min / 2011-10-07

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-07.parquet
  size:    1.4 MB
  rows:    72,645
  symbols: 3,477

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-07 04:30:00	AAPL	Stock	13.4996	13.4996	13.4925	13.4925	8400.0
2011-10-07 05:30:00	AAPL	Stock	13.4607	13.4607	13.4493	13.4493	11200.0
2011-10-07 06:00:00	AAPL	Stock	13.4461	13.4461	13.4236	13.4236	5600.0
2011-10-07 07:00:00	AAPL	Stock	13.4521	13.4521	13.4139	13.4246	80528.0
2011-10-07 07:30:00	AAPL	Stock	13.4107	13.435	13.4107	13.425	66920.0
2011-10-07 08:00:00	AAPL	Stock	13.4286	13.4461	13.4221	13.4443	555940.0
2011-10-07 08:30:00	AAPL	Stock	13.4561	13.545	13.4554	13.5036	5844496.0
2011-10-07 09:00:00	AAPL	Stock	13.5036	13.5104	13.4225	13.4225	2807532.0
2011-10-07 09:30:00	AAPL	Stock	13.4204	13.4907	13.3521	13.4525	70333648.0
2011-10-07 10:00:00	AAPL	Stock	13.4568	13.4718	13.3861	13.408	35837676.0
2011-10-07 10:30:00	AAPL	Stock	13.41	13.4282	13.3175	13.3218	44189460.0
2011-10-07 11:00:00	AAPL	Stock	13.3271	13.3364	13.1786	13.2111	63852432.0
2011-10-07 11:30:00	AAPL	Stock	13.2121	13.2589	13.1603	13.2089	61241404.0
2011-10-07 12:00:00	AAPL	Stock	13.2111	13.2764	13.17	13.2536	40285280.0
2011-10-07 12:30:00	AAPL	Stock	13.2507	13.2571	13.2096	13.2221	20770568.0
2011-10-07 13:00:00	AAPL	Stock	13.2196	13.2604	13.1964	13.2479	17175256.0
2011-10-07 13:30:00	AAPL	Stock	13.2489	13.2946	13.2107	13.281	17931872.0
2011-10-07 14:00:00	AAPL	Stock	13.2832	13.3179	13.2582	13.2704	26586756.0
2011-10-07 14:30:00	AAPL	Stock	13.2704	13.2854	13.2325	13.2696	20630372.0
2011-10-07 15:00:00	AAPL	Stock	13.2668	13.3429	13.2525	13.3396	27113604.0
2011-10-07 15:30:00	AAPL	Stock	13.3357	13.3461	13.1896	13.2075	56496496.0
2011-10-07 16:00:00	AAPL	Stock	13.199	13.295	13.1964	13.2143	16161628.0
2011-10-07 16:30:00	AAPL	Stock	13.2146	13.3342	13.2107	13.2125	463064.0
2011-10-07 17:00:00	AAPL	Stock	13.4775	13.4775	13.2107	13.2129	221200.0
2011-10-07 17:30:00	AAPL	Stock	13.2107	13.2132	13.2107	13.2132	24500.0
2011-10-07 18:00:00	AAPL	Stock	13.2139	13.2139	13.2071	13.2136	41888.0
2011-10-07 18:30:00	AAPL	Stock	13.2139	13.2143	13.2096	13.2107	47432.0
2011-10-07 19:00:00	AAPL	Stock	13.2125	13.2146	13.2111	13.2146	34300.0
2011-10-07 19:30:00	AAPL	Stock	13.2143	13.2225	13.2143	13.2225	72240.0
2011-10-07 07:00:00	MSFT	Stock	26.26	26.26	26.2	26.2	200.0
2011-10-07 07:30:00	MSFT	Stock	26.2	26.22	26.2	26.22	1050.0
2011-10-07 08:00:00	MSFT	Stock	26.2	26.2	26.15	26.2	6703.0
2011-10-07 08:30:00	MSFT	Stock	26.2	26.47	26.2	26.44	41979.0
2011-10-07 09:00:00	MSFT	Stock	26.4	26.45	26.29	26.33	27922.0
2011-10-07 09:30:00	MSFT	Stock	26.34	26.43	26.25	26.39	4532920.0
2011-10-07 10:00:00	MSFT	Stock	26.39	26.5	26.34	26.47	3655516.0
2011-10-07 10:30:00	MSFT	Stock	26.47	26.5	26.35	26.355	2959448.0
2011-10-07 11:00:00	MSFT	Stock	26.36	26.37	26.2	26.369	2924922.0
2011-10-07 11:30:00	MSFT	Stock	26.36	26.495	26.31	26.495	2879971.0
2011-10-07 12:00:00	MSFT	Stock	26.5	26.5	26.25	26.37	4714513.0
2011-10-07 12:30:00	MSFT	Stock	26.37	26.38	26.26	26.291	2940969.0
2011-10-07 13:00:00	MSFT	Stock	26.3	26.41	26.23	26.31	2338860.0
2011-10-07 13:30:00	MSFT	Stock	26.31	26.39	26.24	26.36	1625407.0
2011-10-07 14:00:00	MSFT	Stock	26.355	26.47	26.35	26.39	2317036.0
2011-10-07 14:30:00	MSFT	Stock	26.395	26.46	26.34	26.375	2445061.0
2011-10-07 15:00:00	MSFT	Stock	26.37	26.51	26.342	26.5	4562545.0
2011-10-07 15:30:00	MSFT	Stock	26.5	26.5	26.2	26.24	10668800.0
2011-10-07 16:00:00	MSFT	Stock	26.24	26.38	26.2	26.38	3237587.0
2011-10-07 16:30:00	MSFT	Stock	26.39	26.49	26.35	26.38	14675.0
2011-10-07 17:00:00	MSFT	Stock	26.32	26.32	26.32	26.32	1000.0

> showing 50 of 72,645 rows — these rows as CSV

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