PREVIEW / stock_1hour / 2011-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-28.parquet
  size:    945 KB
  rows:    44,473
  symbols: 3,528

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-07-28 04:00:00	AAPL	Stock	13.9682	14.0543	13.9682	14.0543	15400.0
2011-07-28 05:00:00	AAPL	Stock	14.025	14.0354	13.9839	13.9839	56000.0
2011-07-28 06:00:00	AAPL	Stock	13.99	13.9946	13.95	13.9946	122500.0
2011-07-28 07:00:00	AAPL	Stock	14.0	14.05	13.9782	14.0186	620956.0
2011-07-28 08:00:00	AAPL	Stock	14.0232	14.0857	13.9557	14.0554	7823676.0
2011-07-28 09:00:00	AAPL	Stock	14.0554	14.0711	13.8618	13.9804	114412116.0
2011-07-28 10:00:00	AAPL	Stock	13.9818	14.1143	13.9439	14.0879	115220224.0
2011-07-28 11:00:00	AAPL	Stock	14.0859	14.1782	14.0789	14.1607	75597928.0
2011-07-28 12:00:00	AAPL	Stock	14.1596	14.1707	14.1107	14.1299	54395712.0
2011-07-28 13:00:00	AAPL	Stock	14.1307	14.1529	14.1211	14.1439	27827884.0
2011-07-28 14:00:00	AAPL	Stock	14.1461	14.1464	13.9821	14.0725	85257396.0
2011-07-28 15:00:00	AAPL	Stock	14.0721	14.0752	13.9793	13.9968	85648528.0
2011-07-28 16:00:00	AAPL	Stock	13.9993	14.0449	13.9532	13.9707	20893964.0
2011-07-28 17:00:00	AAPL	Stock	13.9714	13.9904	13.9525	13.9821	728672.0
2011-07-28 18:00:00	AAPL	Stock	13.9768	13.9936	13.9679	13.9804	127820.0
2011-07-28 19:00:00	AAPL	Stock	13.9821	13.9854	13.9625	13.9682	378448.0
2011-07-28 05:00:00	MSFT	Stock	27.25	27.25	27.2	27.2	10000.0
2011-07-28 06:00:00	MSFT	Stock	27.17	27.2	27.07	27.07	3100.0
2011-07-28 07:00:00	MSFT	Stock	27.18	27.25	27.14	27.25	7400.0
2011-07-28 08:00:00	MSFT	Stock	27.22	27.4	27.17	27.34	35950.0
2011-07-28 09:00:00	MSFT	Stock	27.35	27.715	27.21	27.564	7246264.0
2011-07-28 10:00:00	MSFT	Stock	27.56	27.78	27.45	27.74	15229074.0
2011-07-28 11:00:00	MSFT	Stock	27.74	28.05	27.7	28.01	14153912.0
2011-07-28 12:00:00	MSFT	Stock	28.01	28.07	27.94	28.008	6879051.0
2011-07-28 13:00:00	MSFT	Stock	28.005	28.044	27.93	27.985	6519958.0
2011-07-28 14:00:00	MSFT	Stock	27.981	27.995	27.805	27.84	6207797.0
2011-07-28 15:00:00	MSFT	Stock	27.84	27.92	27.71	27.73	19517126.0
2011-07-28 16:00:00	MSFT	Stock	27.72	27.837	27.65	27.65	2835282.0
2011-07-28 17:00:00	MSFT	Stock	27.65	27.65	27.6	27.6	1400.0
2011-07-28 18:00:00	MSFT	Stock	27.6	27.72	27.6	27.64	39843.0
2011-07-28 19:00:00	MSFT	Stock	27.64	27.64	27.64	27.64	3300.0
2011-07-28 08:00:00	NVDA	Stock	0.3462	0.3462	0.3442	0.3453	206800.0
2011-07-28 09:00:00	NVDA	Stock	0.3453	0.3473	0.3398	0.346	73090960.0
2011-07-28 10:00:00	NVDA	Stock	0.3459	0.348	0.3438	0.346	101320040.0
2011-07-28 11:00:00	NVDA	Stock	0.346	0.35	0.346	0.3486	73791520.0
2011-07-28 12:00:00	NVDA	Stock	0.3486	0.3515	0.3478	0.3515	65849760.0
2011-07-28 13:00:00	NVDA	Stock	0.3515	0.353	0.3498	0.3518	84914880.0
2011-07-28 14:00:00	NVDA	Stock	0.3518	0.352	0.348	0.3482	109802840.0
2011-07-28 15:00:00	NVDA	Stock	0.348	0.348	0.3445	0.3458	119934840.0
2011-07-28 16:00:00	NVDA	Stock	0.3458	0.3478	0.3448	0.3458	12727120.0
2011-07-28 17:00:00	NVDA	Stock	0.346	0.346	0.3455	0.346	37000.0
2011-07-28 18:00:00	NVDA	Stock	0.3455	0.3455	0.3455	0.3455	16000.0
2011-07-28 19:00:00	NVDA	Stock	0.3455	0.3455	0.3448	0.3448	10000.0
2011-07-28 06:00:00	AMZN	Stock	11.095	11.1	11.095	11.095	22000.0
2011-07-28 07:00:00	AMZN	Stock	11.1495	11.1495	11.112	11.112	4000.0
2011-07-28 08:00:00	AMZN	Stock	11.1115	11.15	11.0535	11.1345	155300.0
2011-07-28 09:00:00	AMZN	Stock	11.13	11.2	11.0115	11.0835	17129020.0
2011-07-28 10:00:00	AMZN	Stock	11.09	11.2375	11.0745	11.23	20394740.0
2011-07-28 11:00:00	AMZN	Stock	11.2275	11.2975	11.2	11.292	13888400.0
2011-07-28 12:00:00	AMZN	Stock	11.2935	11.295	11.2305	11.2645	9679320.0

> showing 50 of 44,473 rows — these rows as CSV

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