PREVIEW / stock_30min / 2013-07-22

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-22.parquet
  size:    1.5 MB
  rows:    79,296
  symbols: 3,511

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-07-22 05:00:00	AAPL	Stock	15.2039	15.2039	15.2039	15.2039	2800.0
2013-07-22 05:30:00	AAPL	Stock	15.2086	15.2086	15.2086	15.2086	2800.0
2013-07-22 06:30:00	AAPL	Stock	15.2093	15.2093	15.2032	15.2082	25900.0
2013-07-22 07:00:00	AAPL	Stock	15.1893	15.2143	15.1893	15.1964	26880.0
2013-07-22 07:30:00	AAPL	Stock	15.2086	15.27	15.2086	15.2582	331996.0
2013-07-22 08:00:00	AAPL	Stock	15.2468	15.2607	15.2143	15.2236	766724.0
2013-07-22 08:30:00	AAPL	Stock	15.2307	15.2482	15.2232	15.2471	492632.0
2013-07-22 09:00:00	AAPL	Stock	15.2446	15.3571	15.2329	15.3389	3815728.0
2013-07-22 09:30:00	AAPL	Stock	15.3318	15.3482	15.1953	15.2443	51371852.0
2013-07-22 10:00:00	AAPL	Stock	15.2496	15.3286	15.2175	15.3054	21217504.0
2013-07-22 10:30:00	AAPL	Stock	15.3093	15.3286	15.2696	15.2854	14313908.0
2013-07-22 11:00:00	AAPL	Stock	15.2843	15.2986	15.2346	15.2436	10699248.0
2013-07-22 11:30:00	AAPL	Stock	15.2461	15.2711	15.2371	15.2467	6700848.0
2013-07-22 12:00:00	AAPL	Stock	15.2441	15.2657	15.2386	15.2475	6421128.0
2013-07-22 12:30:00	AAPL	Stock	15.2511	15.2621	15.2344	15.2404	7779940.0
2013-07-22 13:00:00	AAPL	Stock	15.24	15.2421	15.2107	15.2186	7159824.0
2013-07-22 13:30:00	AAPL	Stock	15.2186	15.2321	15.2019	15.2289	6401640.0
2013-07-22 14:00:00	AAPL	Stock	15.2289	15.25	15.225	15.2382	6318088.0
2013-07-22 14:30:00	AAPL	Stock	15.2382	15.2743	15.237	15.2671	8362508.0
2013-07-22 15:00:00	AAPL	Stock	15.2663	15.2671	15.2489	15.2568	4673424.0
2013-07-22 15:30:00	AAPL	Stock	15.2564	15.2643	15.1964	15.2221	15846488.0
2013-07-22 16:00:00	AAPL	Stock	15.2254	15.2596	15.2089	15.2314	28673792.0
2013-07-22 16:30:00	AAPL	Stock	15.23	15.2329	15.215	15.2254	171444.0
2013-07-22 17:00:00	AAPL	Stock	15.2214	15.2254	15.2029	15.2071	96880.0
2013-07-22 17:30:00	AAPL	Stock	15.2071	15.2357	15.2036	15.2321	113344.0
2013-07-22 18:00:00	AAPL	Stock	15.2321	15.25	15.2318	15.2357	110936.0
2013-07-22 18:30:00	AAPL	Stock	15.2357	15.2357	15.2321	15.2321	31332.0
2013-07-22 19:00:00	AAPL	Stock	15.2329	15.2421	15.2321	15.2332	23128.0
2013-07-22 19:30:00	AAPL	Stock	15.2429	15.2454	15.2357	15.2393	40180.0
2013-07-22 05:30:00	MSFT	Stock	31.65	31.66	31.65	31.66	640.0
2013-07-22 06:30:00	MSFT	Stock	31.67	31.7	31.67	31.7	4800.0
2013-07-22 07:00:00	MSFT	Stock	31.7	31.78	31.66	31.74	24004.0
2013-07-22 07:30:00	MSFT	Stock	31.71	31.75	31.71	31.71	23960.0
2013-07-22 08:00:00	MSFT	Stock	31.71	31.78	31.6	31.64	152235.0
2013-07-22 08:30:00	MSFT	Stock	31.64	31.64	31.51	31.55	60933.0
2013-07-22 09:00:00	MSFT	Stock	31.54	31.98	31.48	31.78	1217082.0
2013-07-22 09:30:00	MSFT	Stock	31.72	31.96	31.6	31.64	19170119.0
2013-07-22 10:00:00	MSFT	Stock	31.635	31.89	31.62	31.82	6565186.0
2013-07-22 10:30:00	MSFT	Stock	31.824	31.96	31.82	31.89	6902558.0
2013-07-22 11:00:00	MSFT	Stock	31.89	31.92	31.75	31.8	3249216.0
2013-07-22 11:30:00	MSFT	Stock	31.805	31.84	31.76	31.76	2288655.0
2013-07-22 12:00:00	MSFT	Stock	31.76	31.84	31.76	31.835	2558368.0
2013-07-22 12:30:00	MSFT	Stock	31.831	31.835	31.77	31.795	2209330.0
2013-07-22 13:00:00	MSFT	Stock	31.795	31.82	31.77	31.775	2483212.0
2013-07-22 13:30:00	MSFT	Stock	31.775	31.78	31.7	31.74	3008945.0
2013-07-22 14:00:00	MSFT	Stock	31.74	31.8	31.71	31.796	2872185.0
2013-07-22 14:30:00	MSFT	Stock	31.793	31.91	31.76	31.876	3861300.0
2013-07-22 15:00:00	MSFT	Stock	31.88	31.91	31.84	31.91	3985535.0
2013-07-22 15:30:00	MSFT	Stock	31.9	32.0	31.85	32.0	9173597.0
2013-07-22 16:00:00	MSFT	Stock	32.0	32.01	31.817	31.93	7282583.0

> showing 50 of 79,296 rows — these rows as CSV

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