PREVIEW / stock_1hour / 2013-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-08.parquet
  size:    1.0 MB
  rows:    47,851
  symbols: 3,547

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-11-08 04:00:00	AAPL	Stock	18.3496	18.3496	18.3496	18.3496	2800.0
2013-11-08 05:00:00	AAPL	Stock	18.3393	18.3393	18.3393	18.3393	2800.0
2013-11-08 06:00:00	AAPL	Stock	18.35	18.375	18.35	18.3571	46424.0
2013-11-08 07:00:00	AAPL	Stock	18.3571	18.3807	18.3221	18.3336	202552.0
2013-11-08 08:00:00	AAPL	Stock	18.3325	18.3732	18.27	18.3732	5714044.0
2013-11-08 09:00:00	AAPL	Stock	18.3679	18.4229	18.3068	18.3357	37734816.0
2013-11-08 10:00:00	AAPL	Stock	18.3336	18.5125	18.3304	18.5002	53896976.0
2013-11-08 11:00:00	AAPL	Stock	18.5016	18.5661	18.4754	18.545	30243388.0
2013-11-08 12:00:00	AAPL	Stock	18.5468	18.5618	18.5296	18.5496	17577560.0
2013-11-08 13:00:00	AAPL	Stock	18.5496	18.5971	18.5286	18.5889	22198484.0
2013-11-08 14:00:00	AAPL	Stock	18.5904	18.6118	18.5714	18.605	17638264.0
2013-11-08 15:00:00	AAPL	Stock	18.605	18.6064	18.5589	18.5925	46381832.0
2013-11-08 16:00:00	AAPL	Stock	18.5929	18.6171	18.4962	18.6075	34004488.0
2013-11-08 17:00:00	AAPL	Stock	18.5982	18.6118	18.5982	18.61	252980.0
2013-11-08 18:00:00	AAPL	Stock	18.5929	18.6143	18.5914	18.6068	531468.0
2013-11-08 19:00:00	AAPL	Stock	18.6	18.6071	18.595	18.6071	166516.0
2013-11-08 07:00:00	MSFT	Stock	37.54	37.54	37.52	37.52	1000.0
2013-11-08 08:00:00	MSFT	Stock	37.53	37.72	37.38	37.49	107903.0
2013-11-08 09:00:00	MSFT	Stock	37.47	37.77	37.35	37.4	5866943.0
2013-11-08 10:00:00	MSFT	Stock	37.39	37.69	37.34	37.6	6235618.0
2013-11-08 11:00:00	MSFT	Stock	37.61	37.64	37.46	37.56	3693803.0
2013-11-08 12:00:00	MSFT	Stock	37.56	37.61	37.53	37.56	3489144.0
2013-11-08 13:00:00	MSFT	Stock	37.565	37.6	37.53	37.55	2464089.0
2013-11-08 14:00:00	MSFT	Stock	37.556	37.63	37.55	37.599	2386770.0
2013-11-08 15:00:00	MSFT	Stock	37.6	37.78	37.492	37.78	9254640.0
2013-11-08 16:00:00	MSFT	Stock	37.78	37.788	37.578	37.71	2767921.0
2013-11-08 17:00:00	MSFT	Stock	37.71	37.74	37.562	37.74	28640.0
2013-11-08 18:00:00	MSFT	Stock	37.74	37.78	37.74	37.74	4762.0
2013-11-08 19:00:00	MSFT	Stock	37.73	37.74	37.69	37.74	620.0
2013-11-08 05:00:00	NVDA	Stock	0.3682	0.3682	0.3682	0.3682	8000.0
2013-11-08 07:00:00	NVDA	Stock	0.3703	0.3703	0.37	0.37	32000.0
2013-11-08 08:00:00	NVDA	Stock	0.3688	0.3735	0.3688	0.3735	4557600.0
2013-11-08 09:00:00	NVDA	Stock	0.3725	0.3808	0.3652	0.377	106331080.0
2013-11-08 10:00:00	NVDA	Stock	0.377	0.384	0.3765	0.3835	142026160.0
2013-11-08 11:00:00	NVDA	Stock	0.3833	0.3841	0.3775	0.38	98308920.0
2013-11-08 12:00:00	NVDA	Stock	0.3798	0.383	0.3798	0.3819	34362440.0
2013-11-08 13:00:00	NVDA	Stock	0.3819	0.3848	0.3808	0.3831	57448520.0
2013-11-08 14:00:00	NVDA	Stock	0.3833	0.387	0.3818	0.3864	62803560.0
2013-11-08 15:00:00	NVDA	Stock	0.3865	0.3902	0.386	0.389	197759720.0
2013-11-08 16:00:00	NVDA	Stock	0.389	0.3891	0.3825	0.3891	24235360.0
2013-11-08 17:00:00	NVDA	Stock	0.3641	0.3885	0.3641	0.3885	326400.0
2013-11-08 19:00:00	NVDA	Stock	0.3862	0.3862	0.3862	0.3862	16000.0
2013-11-08 05:00:00	AMZN	Stock	17.2745	17.2745	17.2745	17.2745	2000.0
2013-11-08 06:00:00	AMZN	Stock	17.275	17.28	17.25	17.25	16820.0
2013-11-08 07:00:00	AMZN	Stock	17.25	17.25	17.25	17.25	10000.0
2013-11-08 08:00:00	AMZN	Stock	17.178	17.225	17.136	17.185	382580.0
2013-11-08 09:00:00	AMZN	Stock	17.1965	17.4145	17.1965	17.222	10344340.0
2013-11-08 10:00:00	AMZN	Stock	17.2285	17.4635	17.202	17.3738	9619420.0
2013-11-08 11:00:00	AMZN	Stock	17.3715	17.45	17.3465	17.408	6000600.0
2013-11-08 12:00:00	AMZN	Stock	17.4043	17.5	17.4043	17.5	4865480.0

> showing 50 of 47,851 rows — these rows as CSV

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