PREVIEW / stock_1hour / 2011-06-06

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-06.parquet
  size:    960 KB
  rows:    46,075
  symbols: 3,562

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-06 07:00:00	AAPL	Stock	12.2857	12.3286	12.2857	12.3179	219520.0
2011-06-06 08:00:00	AAPL	Stock	12.3125	12.3711	12.2961	12.3429	2738344.0
2011-06-06 09:00:00	AAPL	Stock	12.3532	12.3778	12.3096	12.3686	55939156.0
2011-06-06 10:00:00	AAPL	Stock	12.3689	12.3946	12.2679	12.3	68354608.0
2011-06-06 11:00:00	AAPL	Stock	12.2993	12.3532	12.2861	12.3071	27906452.0
2011-06-06 12:00:00	AAPL	Stock	12.3061	12.3196	12.2554	12.2907	26851272.0
2011-06-06 13:00:00	AAPL	Stock	12.2907	12.3171	12.1368	12.1429	93792608.0
2011-06-06 14:00:00	AAPL	Stock	12.1454	12.2139	12.0946	12.1161	77285768.0
2011-06-06 15:00:00	AAPL	Stock	12.1161	12.1389	12.0646	12.0734	98057792.0
2011-06-06 16:00:00	AAPL	Stock	12.0732	12.2233	12.0436	12.0514	7028700.0
2011-06-06 17:00:00	AAPL	Stock	12.2705	12.2705	12.0082	12.0186	2207968.0
2011-06-06 18:00:00	AAPL	Stock	12.0186	12.0729	12.0143	12.0318	356272.0
2011-06-06 19:00:00	AAPL	Stock	12.0318	12.0357	12.0279	12.0357	253988.0
2011-06-06 07:00:00	MSFT	Stock	23.89	23.89	23.86	23.86	2151.0
2011-06-06 08:00:00	MSFT	Stock	23.89	23.94	23.87	23.94	121233.0
2011-06-06 09:00:00	MSFT	Stock	23.93	23.97	23.77	23.89	6588963.0
2011-06-06 10:00:00	MSFT	Stock	23.9	24.06	23.84	24.013	7944188.0
2011-06-06 11:00:00	MSFT	Stock	24.015	24.19	24.01	24.16	6440350.0
2011-06-06 12:00:00	MSFT	Stock	24.155	24.16	24.08	24.135	3656242.0
2011-06-06 13:00:00	MSFT	Stock	24.14	24.25	24.07	24.075	4159002.0
2011-06-06 14:00:00	MSFT	Stock	24.08	24.17	24.07	24.17	4646059.0
2011-06-06 15:00:00	MSFT	Stock	24.17	24.18	23.99	23.99	10863267.0
2011-06-06 16:00:00	MSFT	Stock	23.99	24.108	23.986	24.03	9769815.0
2011-06-06 17:00:00	MSFT	Stock	24.103	24.103	24.0	24.0	45393.0
2011-06-06 18:00:00	MSFT	Stock	24.01	24.01	23.98	23.98	30740.0
2011-06-06 19:00:00	MSFT	Stock	23.96	23.96	23.95	23.95	22100.0
2011-06-06 06:00:00	NVDA	Stock	0.462	0.462	0.462	0.462	8000.0
2011-06-06 07:00:00	NVDA	Stock	0.462	0.462	0.462	0.462	44000.0
2011-06-06 08:00:00	NVDA	Stock	0.462	0.464	0.462	0.464	212320.0
2011-06-06 09:00:00	NVDA	Stock	0.464	0.465	0.4598	0.4633	48391640.0
2011-06-06 10:00:00	NVDA	Stock	0.4633	0.4638	0.4562	0.4588	56622880.0
2011-06-06 11:00:00	NVDA	Stock	0.4585	0.4618	0.4558	0.4568	57676200.0
2011-06-06 12:00:00	NVDA	Stock	0.4568	0.4572	0.4552	0.4561	30389720.0
2011-06-06 13:00:00	NVDA	Stock	0.456	0.4585	0.4541	0.4548	57751040.0
2011-06-06 14:00:00	NVDA	Stock	0.455	0.456	0.4515	0.4521	57938360.0
2011-06-06 15:00:00	NVDA	Stock	0.4522	0.4535	0.4512	0.452	101427320.0
2011-06-06 16:00:00	NVDA	Stock	0.4518	0.4566	0.45	0.45	24328680.0
2011-06-06 17:00:00	NVDA	Stock	0.4542	0.4542	0.4542	0.4542	956000.0
2011-06-06 18:00:00	NVDA	Stock	0.4502	0.4532	0.4502	0.4532	200000.0
2011-06-06 19:00:00	NVDA	Stock	0.452	0.4532	0.4505	0.4532	78000.0
2011-06-06 08:00:00	AMZN	Stock	9.405	9.425	9.405	9.425	8000.0
2011-06-06 09:00:00	AMZN	Stock	9.425	9.4925	9.381	9.4498	13739340.0
2011-06-06 10:00:00	AMZN	Stock	9.449	9.4525	9.3292	9.344	11950280.0
2011-06-06 11:00:00	AMZN	Stock	9.3448	9.4	9.3338	9.3435	6586080.0
2011-06-06 12:00:00	AMZN	Stock	9.3405	9.3705	9.306	9.325	5653440.0
2011-06-06 13:00:00	AMZN	Stock	9.323	9.349	9.279	9.2905	7858900.0
2011-06-06 14:00:00	AMZN	Stock	9.291	9.3235	9.268	9.2788	6802300.0
2011-06-06 15:00:00	AMZN	Stock	9.276	9.302	9.259	9.285	19680120.0
2011-06-06 16:00:00	AMZN	Stock	9.285	9.3471	9.2701	9.2701	1800360.0
2011-06-06 17:00:00	AMZN	Stock	9.301	9.301	9.2725	9.28	60600.0

> showing 50 of 46,075 rows — these rows as CSV

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