PREVIEW / stock_30min / 2011-02-03

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-03.parquet
  size:    1.4 MB
  rows:    74,705
  symbols: 3,522

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-02-03 06:00:00	AAPL	Stock	12.2911	12.2911	12.2911	12.2911	2800.0
2011-02-03 07:00:00	AAPL	Stock	12.2664	12.2775	12.2607	12.2746	54600.0
2011-02-03 07:30:00	AAPL	Stock	12.2693	12.2693	12.2621	12.2621	36400.0
2011-02-03 08:00:00	AAPL	Stock	12.2711	12.2711	12.2386	12.2504	786856.0
2011-02-03 08:30:00	AAPL	Stock	12.2571	12.2821	12.2571	12.2679	482496.0
2011-02-03 09:00:00	AAPL	Stock	12.2643	12.2857	12.2593	12.2786	527800.0
2011-02-03 09:30:00	AAPL	Stock	12.2768	12.2829	12.2349	12.245	39751068.0
2011-02-03 10:00:00	AAPL	Stock	12.2436	12.2564	12.0911	12.1536	91701652.0
2011-02-03 10:30:00	AAPL	Stock	12.1536	12.1989	12.1339	12.1875	38588844.0
2011-02-03 11:00:00	AAPL	Stock	12.1889	12.2443	12.1625	12.2318	33551308.0
2011-02-03 11:30:00	AAPL	Stock	12.2321	12.2668	12.2286	12.2536	32167436.0
2011-02-03 12:00:00	AAPL	Stock	12.2536	12.2668	12.2464	12.2582	18214196.0
2011-02-03 12:30:00	AAPL	Stock	12.2582	12.2621	12.2339	12.2621	14874132.0
2011-02-03 13:00:00	AAPL	Stock	12.2611	12.2654	12.2464	12.2514	10512376.0
2011-02-03 13:30:00	AAPL	Stock	12.2507	12.2543	12.2164	12.2411	19283376.0
2011-02-03 14:00:00	AAPL	Stock	12.2404	12.2614	12.2325	12.2509	14444808.0
2011-02-03 14:30:00	AAPL	Stock	12.2518	12.2782	12.25	12.2701	18420136.0
2011-02-03 15:00:00	AAPL	Stock	12.2689	12.2943	12.2682	12.2762	22379616.0
2011-02-03 15:30:00	AAPL	Stock	12.2761	12.2893	12.2632	12.2646	27432888.0
2011-02-03 16:00:00	AAPL	Stock	12.2657	12.2711	12.2197	12.2643	5010264.0
2011-02-03 16:30:00	AAPL	Stock	12.2643	12.2657	12.2621	12.2632	97076.0
2011-02-03 17:00:00	AAPL	Stock	12.2625	12.2643	12.2621	12.2625	228452.0
2011-02-03 17:30:00	AAPL	Stock	12.2625	12.2625	12.2589	12.2589	36400.0
2011-02-03 18:00:00	AAPL	Stock	12.2607	12.2657	12.2554	12.2554	172872.0
2011-02-03 18:30:00	AAPL	Stock	12.2554	12.2554	12.25	12.2504	103600.0
2011-02-03 19:00:00	AAPL	Stock	12.2514	12.2536	12.2411	12.2411	154280.0
2011-02-03 19:30:00	AAPL	Stock	12.2368	12.2571	12.2361	12.25	166040.0
2011-02-03 04:00:00	MSFT	Stock	27.95	27.95	27.95	27.95	100.0
2011-02-03 07:00:00	MSFT	Stock	27.95	27.95	27.95	27.95	400.0
2011-02-03 08:00:00	MSFT	Stock	27.92	27.93	27.92	27.93	5365.0
2011-02-03 08:30:00	MSFT	Stock	27.94	28.11	27.94	28.11	53418.0
2011-02-03 09:00:00	MSFT	Stock	28.1	28.12	27.95	27.95	166253.0
2011-02-03 09:30:00	MSFT	Stock	27.95	27.97	27.65	27.71	5686182.0
2011-02-03 10:00:00	MSFT	Stock	27.715	27.75	27.54	27.66	5040925.0
2011-02-03 10:30:00	MSFT	Stock	27.67	27.73	27.61	27.71	3250185.0
2011-02-03 11:00:00	MSFT	Stock	27.718	27.73	27.58	27.61	4827543.0
2011-02-03 11:30:00	MSFT	Stock	27.61	27.72	27.6	27.64	3980045.0
2011-02-03 12:00:00	MSFT	Stock	27.631	27.695	27.63	27.64	2630252.0
2011-02-03 12:30:00	MSFT	Stock	27.65	27.66	27.59	27.62	2794282.0
2011-02-03 13:00:00	MSFT	Stock	27.62	27.62	27.59	27.61	2169927.0
2011-02-03 13:30:00	MSFT	Stock	27.61	27.61	27.58	27.6	2366724.0
2011-02-03 14:00:00	MSFT	Stock	27.6	27.64	27.59	27.608	2474548.0
2011-02-03 14:30:00	MSFT	Stock	27.6	27.62	27.58	27.59	2569368.0
2011-02-03 15:00:00	MSFT	Stock	27.59	27.64	27.58	27.63	5408613.0
2011-02-03 15:30:00	MSFT	Stock	27.63	27.74	27.62	27.65	12072835.0
2011-02-03 16:00:00	MSFT	Stock	27.65	27.69	27.64	27.68	4217937.0
2011-02-03 16:30:00	MSFT	Stock	27.68	27.7	27.64	27.66	82954.0
2011-02-03 17:00:00	MSFT	Stock	27.95	27.95	27.65	27.65	8100.0
2011-02-03 17:30:00	MSFT	Stock	27.68	27.7	27.68	27.68	2100.0
2011-02-03 18:00:00	MSFT	Stock	27.65	27.65	27.65	27.65	12253.0

> showing 50 of 74,705 rows — these rows as CSV

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