PREVIEW / stock_1hour / 2013-05-06

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-06.parquet
  size:    980 KB
  rows:    45,545
  symbols: 3,486

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
2013-05-06 04:00:00	AAPL	Stock	16.1071	16.1386	16.1071	16.1354	22400.0
2013-05-06 05:00:00	AAPL	Stock	16.1375	16.1375	16.105	16.105	5600.0
2013-05-06 06:00:00	AAPL	Stock	16.1071	16.1161	16.1071	16.1161	22064.0
2013-05-06 07:00:00	AAPL	Stock	16.1143	16.21	16.1143	16.1964	624316.0
2013-05-06 08:00:00	AAPL	Stock	16.1914	16.345	16.1246	16.3164	5278084.0
2013-05-06 09:00:00	AAPL	Stock	16.3104	16.4714	16.2254	16.4514	114983680.0
2013-05-06 10:00:00	AAPL	Stock	16.4518	16.4582	16.345	16.3514	85490552.0
2013-05-06 11:00:00	AAPL	Stock	16.3475	16.4603	16.3236	16.4387	56936656.0
2013-05-06 12:00:00	AAPL	Stock	16.4382	16.5064	16.4343	16.4956	44141804.0
2013-05-06 13:00:00	AAPL	Stock	16.4975	16.5036	16.4654	16.48	24183600.0
2013-05-06 14:00:00	AAPL	Stock	16.48	16.4928	16.4261	16.4396	29702092.0
2013-05-06 15:00:00	AAPL	Stock	16.44	16.5071	16.4296	16.4559	64118572.0
2013-05-06 16:00:00	AAPL	Stock	16.4539	16.4821	16.4212	16.475	33444628.0
2013-05-06 17:00:00	AAPL	Stock	16.4661	16.48	16.4607	16.4714	246092.0
2013-05-06 18:00:00	AAPL	Stock	16.4696	16.4764	16.4696	16.4764	305256.0
2013-05-06 19:00:00	AAPL	Stock	16.475	16.4836	16.4696	16.475	264404.0
2013-05-06 04:00:00	MSFT	Stock	33.49	33.49	33.49	33.49	600.0
2013-05-06 05:00:00	MSFT	Stock	33.4	33.4	33.4	33.4	500.0
2013-05-06 06:00:00	MSFT	Stock	33.4	33.4	33.4	33.4	656.0
2013-05-06 07:00:00	MSFT	Stock	33.36	33.4	33.36	33.4	409.0
2013-05-06 08:00:00	MSFT	Stock	33.4	33.41	33.38	33.39	30035.0
2013-05-06 09:00:00	MSFT	Stock	33.39	33.47	33.25	33.37	4130506.0
2013-05-06 10:00:00	MSFT	Stock	33.38	33.45	33.27	33.4	3844854.0
2013-05-06 11:00:00	MSFT	Stock	33.4	33.47	33.38	33.448	2900537.0
2013-05-06 12:00:00	MSFT	Stock	33.45	33.73	33.44	33.72	6362381.0
2013-05-06 13:00:00	MSFT	Stock	33.715	33.91	33.67	33.91	5517110.0
2013-05-06 14:00:00	MSFT	Stock	33.9	33.91	33.75	33.825	5046855.0
2013-05-06 15:00:00	MSFT	Stock	33.825	33.84	33.64	33.75	7441571.0
2013-05-06 16:00:00	MSFT	Stock	33.75	33.759	33.416	33.75	2993441.0
2013-05-06 17:00:00	MSFT	Stock	33.71	33.72	33.7	33.72	2505.0
2013-05-06 18:00:00	MSFT	Stock	33.73	33.74	33.73	33.73	4000.0
2013-05-06 19:00:00	MSFT	Stock	33.75	33.75	33.72	33.72	400.0
2013-05-06 08:00:00	NVDA	Stock	0.349	0.3495	0.3488	0.3488	184000.0
2013-05-06 09:00:00	NVDA	Stock	0.3482	0.3482	0.3438	0.3453	34689600.0
2013-05-06 10:00:00	NVDA	Stock	0.3453	0.3482	0.345	0.3468	33337160.0
2013-05-06 11:00:00	NVDA	Stock	0.3468	0.3478	0.3465	0.347	20053280.0
2013-05-06 12:00:00	NVDA	Stock	0.347	0.3475	0.3462	0.3462	15650360.0
2013-05-06 13:00:00	NVDA	Stock	0.3465	0.3485	0.3458	0.3482	23440080.0
2013-05-06 14:00:00	NVDA	Stock	0.3485	0.3486	0.3478	0.3482	18799040.0
2013-05-06 15:00:00	NVDA	Stock	0.3482	0.3482	0.3458	0.346	56897160.0
2013-05-06 16:00:00	NVDA	Stock	0.346	0.346	0.3453	0.3458	13878600.0
2013-05-06 18:00:00	NVDA	Stock	0.3462	0.3462	0.3453	0.3453	36000.0
2013-05-06 04:00:00	AMZN	Stock	12.905	12.915	12.905	12.915	6000.0
2013-05-06 05:00:00	AMZN	Stock	12.9425	12.9425	12.92	12.92	6000.0
2013-05-06 06:00:00	AMZN	Stock	12.92	12.92	12.916	12.916	14000.0
2013-05-06 08:00:00	AMZN	Stock	12.9245	12.949	12.906	12.906	53000.0
2013-05-06 09:00:00	AMZN	Stock	12.93	12.975	12.7805	12.791	9165880.0
2013-05-06 10:00:00	AMZN	Stock	12.7918	12.836	12.671	12.6888	12784700.0
2013-05-06 11:00:00	AMZN	Stock	12.688	12.8465	12.675	12.841	8239480.0
2013-05-06 12:00:00	AMZN	Stock	12.837	12.8535	12.7815	12.7923	3324920.0

> showing 50 of 45,545 rows — these rows as CSV

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