PREVIEW / stock_30min / 2011-09-28

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-28.parquet
  size:    1.4 MB
  rows:    73,913
  symbols: 3,483

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-09-28 04:00:00	AAPL	Stock	14.2664	14.3929	14.2664	14.3393	30520.0
2011-09-28 04:30:00	AAPL	Stock	14.3214	14.3214	14.3214	14.3214	13972.0
2011-09-28 05:00:00	AAPL	Stock	14.3357	14.35	14.3336	14.35	8400.0
2011-09-28 05:30:00	AAPL	Stock	14.3893	14.3971	14.3893	14.3971	16800.0
2011-09-28 06:00:00	AAPL	Stock	14.3782	14.4157	14.3782	14.4157	63336.0
2011-09-28 06:30:00	AAPL	Stock	14.3929	14.4107	14.3825	14.4104	28000.0
2011-09-28 07:00:00	AAPL	Stock	14.4107	14.4107	14.3214	14.3393	358008.0
2011-09-28 07:30:00	AAPL	Stock	14.3343	14.3343	14.2786	14.2964	561960.0
2011-09-28 08:00:00	AAPL	Stock	14.2904	14.325	14.2521	14.2771	1501472.0
2011-09-28 08:30:00	AAPL	Stock	14.2775	14.3025	14.2282	14.2729	2511908.0
2011-09-28 09:00:00	AAPL	Stock	14.2689	14.3304	14.2668	14.2882	2553488.0
2011-09-28 09:30:00	AAPL	Stock	14.2921	14.4193	14.2028	14.3864	87365600.0
2011-09-28 10:00:00	AAPL	Stock	14.3857	14.3968	14.3264	14.3425	48826036.0
2011-09-28 10:30:00	AAPL	Stock	14.345	14.3839	14.3214	14.362	38021256.0
2011-09-28 11:00:00	AAPL	Stock	14.3571	14.3732	14.2929	14.3279	25012652.0
2011-09-28 11:30:00	AAPL	Stock	14.3214	14.3821	14.3036	14.3693	21715456.0
2011-09-28 12:00:00	AAPL	Stock	14.3689	14.3796	14.2964	14.3082	18492320.0
2011-09-28 12:30:00	AAPL	Stock	14.3068	14.3571	14.2786	14.3514	19161660.0
2011-09-28 13:00:00	AAPL	Stock	14.3468	14.3493	14.2857	14.2914	14029960.0
2011-09-28 13:30:00	AAPL	Stock	14.2898	14.3125	14.2354	14.2611	21156632.0
2011-09-28 14:00:00	AAPL	Stock	14.2586	14.2775	14.2232	14.2561	20012692.0
2011-09-28 14:30:00	AAPL	Stock	14.2521	14.2896	14.2321	14.2582	18434948.0
2011-09-28 15:00:00	AAPL	Stock	14.2582	14.3393	14.245	14.2593	28840308.0
2011-09-28 15:30:00	AAPL	Stock	14.2595	14.26	14.1611	14.1757	48428576.0
2011-09-28 16:00:00	AAPL	Stock	14.1761	14.3082	14.1729	14.1875	8603616.0
2011-09-28 16:30:00	AAPL	Stock	14.1907	14.2402	14.1686	14.1789	519260.0
2011-09-28 17:00:00	AAPL	Stock	14.1786	14.1786	14.1686	14.1686	376740.0
2011-09-28 17:30:00	AAPL	Stock	14.1693	14.1786	14.1618	14.17	197512.0
2011-09-28 18:00:00	AAPL	Stock	14.1675	14.1789	14.1607	14.1675	158396.0
2011-09-28 18:30:00	AAPL	Stock	14.1611	14.1786	14.1586	14.1779	80304.0
2011-09-28 19:00:00	AAPL	Stock	14.1661	14.1661	14.15	14.1504	45192.0
2011-09-28 19:30:00	AAPL	Stock	14.1657	14.1682	14.1429	14.1621	136752.0
2011-09-28 07:30:00	MSFT	Stock	25.76	25.76	25.76	25.76	200.0
2011-09-28 08:00:00	MSFT	Stock	25.76	25.76	25.76	25.76	200.0
2011-09-28 08:30:00	MSFT	Stock	25.82	25.86	25.73	25.8	18386.0
2011-09-28 09:00:00	MSFT	Stock	25.78	25.98	25.78	25.93	89702.0
2011-09-28 09:30:00	MSFT	Stock	25.93	26.37	25.9	26.18	8940303.0
2011-09-28 10:00:00	MSFT	Stock	26.18	26.185	25.91	25.97	6364422.0
2011-09-28 10:30:00	MSFT	Stock	25.97	26.055	25.84	25.985	5175821.0
2011-09-28 11:00:00	MSFT	Stock	25.985	26.07	25.93	26.03	3638569.0
2011-09-28 11:30:00	MSFT	Stock	26.03	26.15	25.94	26.108	2508174.0
2011-09-28 12:00:00	MSFT	Stock	26.108	26.13	26.0	26.06	2205352.0
2011-09-28 12:30:00	MSFT	Stock	26.063	26.07	25.93	26.011	2273109.0
2011-09-28 13:00:00	MSFT	Stock	26.01	26.03	25.86	25.88	2126886.0
2011-09-28 13:30:00	MSFT	Stock	25.88	25.92	25.73	25.785	4383735.0
2011-09-28 14:00:00	MSFT	Stock	25.785	25.905	25.77	25.85	2865050.0
2011-09-28 14:30:00	MSFT	Stock	25.85	25.915	25.81	25.895	2839653.0
2011-09-28 15:00:00	MSFT	Stock	25.89	25.97	25.81	25.825	3540637.0
2011-09-28 15:30:00	MSFT	Stock	25.83	25.84	25.51	25.55	9687388.0
2011-09-28 16:00:00	MSFT	Stock	25.54	25.928	25.54	25.56	2763420.0

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

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