PREVIEW / stock_1hour / 2011-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-20.parquet
  size:    944 KB
  rows:    44,936
  symbols: 3,532

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-20 04:00:00	AAPL	Stock	14.0579	14.0579	13.95	13.9639	285992.0
2011-07-20 05:00:00	AAPL	Stock	13.9643	14.0111	13.9361	14.0075	324688.0
2011-07-20 06:00:00	AAPL	Stock	14.0071	14.125	14.0071	14.1071	1647408.0
2011-07-20 07:00:00	AAPL	Stock	14.1111	14.2654	14.1071	14.2364	6012496.0
2011-07-20 08:00:00	AAPL	Stock	14.2364	14.2611	14.1646	14.2582	14717696.0
2011-07-20 09:00:00	AAPL	Stock	14.2532	14.2704	13.8254	13.9	330444800.0
2011-07-20 10:00:00	AAPL	Stock	13.9	13.9393	13.7857	13.8768	184631188.0
2011-07-20 11:00:00	AAPL	Stock	13.8773	13.9639	13.815	13.8343	112811468.0
2011-07-20 12:00:00	AAPL	Stock	13.8357	13.8729	13.815	13.8454	59423840.0
2011-07-20 13:00:00	AAPL	Stock	13.8459	13.9161	13.8346	13.91	50875188.0
2011-07-20 14:00:00	AAPL	Stock	13.9079	13.9339	13.8657	13.875	62659744.0
2011-07-20 15:00:00	AAPL	Stock	13.8739	13.8914	13.8061	13.8214	98585536.0
2011-07-20 16:00:00	AAPL	Stock	13.8214	13.9127	13.7871	13.7911	8267028.0
2011-07-20 17:00:00	AAPL	Stock	13.7911	13.8411	13.7543	13.7679	1160208.0
2011-07-20 18:00:00	AAPL	Stock	13.7679	13.8239	13.7643	13.8214	955528.0
2011-07-20 19:00:00	AAPL	Stock	13.8214	13.83	13.8036	13.8246	351848.0
2011-07-20 04:00:00	MSFT	Stock	27.6	27.62	27.6	27.62	707.0
2011-07-20 06:00:00	MSFT	Stock	27.53	27.53	27.53	27.53	100.0
2011-07-20 07:00:00	MSFT	Stock	27.64	27.64	27.56	27.56	4145.0
2011-07-20 08:00:00	MSFT	Stock	27.5	27.583	27.42	27.45	70028.0
2011-07-20 09:00:00	MSFT	Stock	27.44	27.44	27.11	27.24	6125162.0
2011-07-20 10:00:00	MSFT	Stock	27.24	27.26	27.05	27.18	7865805.0
2011-07-20 11:00:00	MSFT	Stock	27.185	27.24	27.02	27.025	6724212.0
2011-07-20 12:00:00	MSFT	Stock	27.03	27.13	27.0	27.08	4210361.0
2011-07-20 13:00:00	MSFT	Stock	27.08	27.18	27.06	27.121	3717853.0
2011-07-20 14:00:00	MSFT	Stock	27.125	27.17	27.015	27.05	4985439.0
2011-07-20 15:00:00	MSFT	Stock	27.045	27.09	26.98	27.05	10340436.0
2011-07-20 16:00:00	MSFT	Stock	27.06	27.15	26.88	27.0	2011881.0
2011-07-20 17:00:00	MSFT	Stock	27.0	27.08	26.9	26.94	172754.0
2011-07-20 18:00:00	MSFT	Stock	26.94	27.06	26.94	26.98	43483.0
2011-07-20 19:00:00	MSFT	Stock	27.0	27.449	26.97	27.04	26290.0
2011-07-20 07:00:00	NVDA	Stock	0.36	0.36	0.36	0.36	4000.0
2011-07-20 08:00:00	NVDA	Stock	0.3567	0.3582	0.3567	0.3575	239640.0
2011-07-20 09:00:00	NVDA	Stock	0.3575	0.3588	0.3502	0.3525	76528720.0
2011-07-20 10:00:00	NVDA	Stock	0.3525	0.3578	0.3502	0.357	167227600.0
2011-07-20 11:00:00	NVDA	Stock	0.357	0.3572	0.3513	0.3515	72416400.0
2011-07-20 12:00:00	NVDA	Stock	0.3515	0.353	0.35	0.352	62783040.0
2011-07-20 13:00:00	NVDA	Stock	0.3522	0.3538	0.3515	0.3529	53807440.0
2011-07-20 14:00:00	NVDA	Stock	0.353	0.3533	0.351	0.352	63530080.0
2011-07-20 15:00:00	NVDA	Stock	0.3519	0.3525	0.3505	0.351	126803840.0
2011-07-20 16:00:00	NVDA	Stock	0.351	0.3538	0.3505	0.3508	15771160.0
2011-07-20 17:00:00	NVDA	Stock	0.3508	0.351	0.35	0.35	2941120.0
2011-07-20 18:00:00	NVDA	Stock	0.3488	0.349	0.3488	0.3488	102000.0
2011-07-20 19:00:00	NVDA	Stock	0.35	0.3505	0.35	0.3505	238000.0
2011-07-20 04:00:00	AMZN	Stock	10.9365	10.9365	10.9365	10.9365	2000.0
2011-07-20 06:00:00	AMZN	Stock	11.0005	11.0005	10.995	10.995	6000.0
2011-07-20 07:00:00	AMZN	Stock	11.002	11.002	10.98	10.995	119000.0
2011-07-20 08:00:00	AMZN	Stock	10.9925	10.9925	10.9196	10.975	224240.0
2011-07-20 09:00:00	AMZN	Stock	10.985	11.05	10.853	10.916	15366840.0
2011-07-20 10:00:00	AMZN	Stock	10.911	10.9165	10.765	10.8015	14207640.0

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

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