PREVIEW / stock_30min / 2011-06-20

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-20.parquet
  size:    1.4 MB
  rows:    76,352
  symbols: 3,549

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-06-20 04:00:00	AAPL	Stock	11.5	11.5	11.35	11.35	8400.0
2011-06-20 04:30:00	AAPL	Stock	11.3954	11.3954	11.3529	11.3529	5796.0
2011-06-20 05:00:00	AAPL	Stock	11.4	11.4	11.4	11.4	2800.0
2011-06-20 06:00:00	AAPL	Stock	11.3875	11.3875	11.3875	11.3875	2800.0
2011-06-20 06:30:00	AAPL	Stock	11.4104	11.4104	11.4104	11.4104	5600.0
2011-06-20 07:00:00	AAPL	Stock	11.3932	11.3932	11.3757	11.385	168140.0
2011-06-20 07:30:00	AAPL	Stock	11.3779	11.3779	11.3393	11.3464	546812.0
2011-06-20 08:00:00	AAPL	Stock	11.3511	11.3571	11.2911	11.3186	1918028.0
2011-06-20 08:30:00	AAPL	Stock	11.3161	11.3504	11.3071	11.3343	1547140.0
2011-06-20 09:00:00	AAPL	Stock	11.3339	11.3571	11.3268	11.3364	1867068.0
2011-06-20 09:30:00	AAPL	Stock	11.3325	11.3364	11.2321	11.2789	103766572.0
2011-06-20 10:00:00	AAPL	Stock	11.2796	11.2911	11.0893	11.1813	113955016.0
2011-06-20 10:30:00	AAPL	Stock	11.1828	11.2464	11.165	11.1682	67308808.0
2011-06-20 11:00:00	AAPL	Stock	11.1664	11.1879	11.1429	11.1639	38548104.0
2011-06-20 11:30:00	AAPL	Stock	11.1618	11.2221	11.1339	11.2011	43853768.0
2011-06-20 12:00:00	AAPL	Stock	11.204	11.3066	11.2014	11.3057	43420804.0
2011-06-20 12:30:00	AAPL	Stock	11.3054	11.3164	11.2411	11.2483	35437248.0
2011-06-20 13:00:00	AAPL	Stock	11.2461	11.28	11.2446	11.2646	16739240.0
2011-06-20 13:30:00	AAPL	Stock	11.2627	11.2893	11.2343	11.2413	18813116.0
2011-06-20 14:00:00	AAPL	Stock	11.2422	11.2668	11.2264	11.2324	15755012.0
2011-06-20 14:30:00	AAPL	Stock	11.2321	11.3464	11.2286	11.3389	39338488.0
2011-06-20 15:00:00	AAPL	Stock	11.3375	11.338	11.2346	11.2375	34544552.0
2011-06-20 15:30:00	AAPL	Stock	11.2386	11.2642	11.2186	11.2614	42635320.0
2011-06-20 16:00:00	AAPL	Stock	11.2614	11.3027	11.235	11.2639	9185316.0
2011-06-20 16:30:00	AAPL	Stock	11.2593	11.2954	11.2427	11.2571	326760.0
2011-06-20 17:00:00	AAPL	Stock	11.2554	11.2564	11.2439	11.2564	165816.0
2011-06-20 17:30:00	AAPL	Stock	11.25	11.2518	11.2482	11.2518	30240.0
2011-06-20 18:00:00	AAPL	Stock	11.2568	11.2614	11.25	11.2554	661024.0
2011-06-20 18:30:00	AAPL	Stock	11.2504	11.2571	11.2504	11.2507	56952.0
2011-06-20 19:00:00	AAPL	Stock	11.2586	11.2625	11.2511	11.2625	91728.0
2011-06-20 19:30:00	AAPL	Stock	11.2639	11.2857	11.2639	11.2768	208992.0
2011-06-20 07:00:00	MSFT	Stock	24.18	24.18	24.18	24.18	1000.0
2011-06-20 07:30:00	MSFT	Stock	24.18	24.2	24.13	24.17	5900.0
2011-06-20 08:00:00	MSFT	Stock	24.17	24.25	24.15	24.18	8200.0
2011-06-20 08:30:00	MSFT	Stock	24.18	24.18	24.13	24.13	5865.0
2011-06-20 09:00:00	MSFT	Stock	24.15	24.19	24.14	24.19	40231.0
2011-06-20 09:30:00	MSFT	Stock	24.19	24.342	24.16	24.34	6038052.0
2011-06-20 10:00:00	MSFT	Stock	24.33	24.46	24.3	24.43	3815927.0
2011-06-20 10:30:00	MSFT	Stock	24.435	24.52	24.41	24.49	5680867.0
2011-06-20 11:00:00	MSFT	Stock	24.49	24.52	24.44	24.515	3065482.0
2011-06-20 11:30:00	MSFT	Stock	24.52	24.66	24.48	24.642	4620808.0
2011-06-20 12:00:00	MSFT	Stock	24.65	24.655	24.57	24.595	3696532.0
2011-06-20 12:30:00	MSFT	Stock	24.592	24.62	24.56	24.57	2055170.0
2011-06-20 13:00:00	MSFT	Stock	24.575	24.65	24.54	24.595	3462073.0
2011-06-20 13:30:00	MSFT	Stock	24.6	24.6	24.52	24.525	2272425.0
2011-06-20 14:00:00	MSFT	Stock	24.528	24.57	24.51	24.56	2208123.0
2011-06-20 14:30:00	MSFT	Stock	24.56	24.61	24.55	24.58	2578316.0
2011-06-20 15:00:00	MSFT	Stock	24.59	24.61	24.5	24.54	3836850.0
2011-06-20 15:30:00	MSFT	Stock	24.56	24.57	24.46	24.46	7593057.0
2011-06-20 16:00:00	MSFT	Stock	24.47	24.585	24.47	24.475	2514734.0

> showing 50 of 76,352 rows — these rows as CSV

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