PREVIEW / stock_30min / 2012-08-06

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-06.parquet
  size:    1.4 MB
  rows:    73,275
  symbols: 3,463

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
2012-08-06 06:00:00	AAPL	Stock	22.0661	22.0661	22.0554	22.0554	44800.0
2012-08-06 06:30:00	AAPL	Stock	22.0661	22.0661	22.0589	22.0589	25200.0
2012-08-06 07:00:00	AAPL	Stock	22.0589	22.1014	22.0554	22.0661	340816.0
2012-08-06 07:30:00	AAPL	Stock	22.075	22.0964	22.0664	22.0946	226156.0
2012-08-06 08:00:00	AAPL	Stock	22.0875	22.0921	22.0714	22.0789	927640.0
2012-08-06 08:30:00	AAPL	Stock	22.0825	22.0861	22.0689	22.0743	547176.0
2012-08-06 09:00:00	AAPL	Stock	22.0743	22.0918	22.0361	22.0393	1415540.0
2012-08-06 09:30:00	AAPL	Stock	22.0411	22.1029	21.9736	22.0646	44500876.0
2012-08-06 10:00:00	AAPL	Stock	22.0622	22.1154	22.0536	22.1018	23944340.0
2012-08-06 10:30:00	AAPL	Stock	22.1029	22.2286	22.0922	22.2032	49165536.0
2012-08-06 11:00:00	AAPL	Stock	22.2006	22.2364	22.1889	22.216	22526616.0
2012-08-06 11:30:00	AAPL	Stock	22.2157	22.2604	22.2054	22.2585	18624312.0
2012-08-06 12:00:00	AAPL	Stock	22.2585	22.2618	22.2411	22.25	11997608.0
2012-08-06 12:30:00	AAPL	Stock	22.2486	22.3093	22.2414	22.3059	18054148.0
2012-08-06 13:00:00	AAPL	Stock	22.3036	22.3167	22.2736	22.2782	14628684.0
2012-08-06 13:30:00	AAPL	Stock	22.2793	22.2882	22.245	22.2768	16253636.0
2012-08-06 14:00:00	AAPL	Stock	22.2761	22.3089	22.2714	22.2969	9795604.0
2012-08-06 14:30:00	AAPL	Stock	22.295	22.3	22.2518	22.2675	10469984.0
2012-08-06 15:00:00	AAPL	Stock	22.2654	22.2857	22.2554	22.2832	10998316.0
2012-08-06 15:30:00	AAPL	Stock	22.2832	22.285	22.1986	22.2315	31166072.0
2012-08-06 16:00:00	AAPL	Stock	22.2306	22.2627	22.1931	22.2096	5442752.0
2012-08-06 16:30:00	AAPL	Stock	22.2121	22.2935	22.1092	22.2125	123284.0
2012-08-06 17:00:00	AAPL	Stock	22.2136	22.2136	22.2075	22.2132	35896.0
2012-08-06 17:30:00	AAPL	Stock	22.2104	22.2193	22.2086	22.2193	65688.0
2012-08-06 18:00:00	AAPL	Stock	22.2179	22.2179	22.2107	22.2118	87248.0
2012-08-06 18:30:00	AAPL	Stock	22.2143	22.2196	22.2143	22.2186	37520.0
2012-08-06 19:00:00	AAPL	Stock	22.2196	22.22	22.2179	22.2179	57652.0
2012-08-06 19:30:00	AAPL	Stock	22.2196	22.2207	22.2143	22.2143	119140.0
2012-08-06 08:00:00	MSFT	Stock	29.92	29.98	29.92	29.97	7424.0
2012-08-06 08:30:00	MSFT	Stock	29.96	29.98	29.96	29.98	1700.0
2012-08-06 09:00:00	MSFT	Stock	29.98	30.03	29.92	29.97	49356.0
2012-08-06 09:30:00	MSFT	Stock	30.0	30.03	29.81	30.005	3810042.0
2012-08-06 10:00:00	MSFT	Stock	30.02	30.11	29.985	30.01	3276469.0
2012-08-06 10:30:00	MSFT	Stock	30.017	30.05	29.9	29.975	2288588.0
2012-08-06 11:00:00	MSFT	Stock	29.98	30.0	29.93	29.95	1230330.0
2012-08-06 11:30:00	MSFT	Stock	29.955	30.02	29.94	29.985	1228108.0
2012-08-06 12:00:00	MSFT	Stock	29.98	30.02	29.95	29.972	1038331.0
2012-08-06 12:30:00	MSFT	Stock	29.98	30.08	29.97	30.06	1230816.0
2012-08-06 13:00:00	MSFT	Stock	30.06	30.09	30.02	30.03	1269338.0
2012-08-06 13:30:00	MSFT	Stock	30.03	30.05	30.0	30.018	898401.0
2012-08-06 14:00:00	MSFT	Stock	30.02	30.07	29.98	30.06	1158033.0
2012-08-06 14:30:00	MSFT	Stock	30.069	30.08	30.03	30.05	1062791.0
2012-08-06 15:00:00	MSFT	Stock	30.05	30.09	30.01	30.085	2305343.0
2012-08-06 15:30:00	MSFT	Stock	30.08	30.09	29.9	29.95	4001535.0
2012-08-06 16:00:00	MSFT	Stock	29.94	30.003	29.88	29.88	2321921.0
2012-08-06 16:30:00	MSFT	Stock	29.93	30.073	29.92	29.92	19270.0
2012-08-06 17:00:00	MSFT	Stock	29.93	29.93	29.89	29.9	310.0
2012-08-06 17:30:00	MSFT	Stock	29.93	29.93	29.89	29.89	600.0
2012-08-06 19:00:00	MSFT	Stock	29.9	29.9	29.9	29.9	1550.0
2012-08-06 19:30:00	MSFT	Stock	29.9	29.9	29.9	29.9	500.0

> showing 50 of 73,275 rows — these rows as CSV

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