PREVIEW / stock_1hour / 2012-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-05.parquet
  size:    923 KB
  rows:    43,703
  symbols: 3,467

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
2012-11-05 04:00:00	AAPL	Stock	20.6	20.6	20.4943	20.4943	30436.0
2012-11-05 05:00:00	AAPL	Stock	20.4679	20.5179	20.4679	20.5179	37660.0
2012-11-05 06:00:00	AAPL	Stock	20.5179	20.5604	20.5125	20.5304	66304.0
2012-11-05 07:00:00	AAPL	Stock	20.5179	20.5357	20.3818	20.4343	1328600.0
2012-11-05 08:00:00	AAPL	Stock	20.4446	20.8929	20.4286	20.8771	13595204.0
2012-11-05 09:00:00	AAPL	Stock	20.8846	20.9918	20.7393	20.8771	104036352.0
2012-11-05 10:00:00	AAPL	Stock	20.8764	20.9675	20.7586	20.9554	69906060.0
2012-11-05 11:00:00	AAPL	Stock	20.9511	20.9786	20.8404	20.8798	47350940.0
2012-11-05 12:00:00	AAPL	Stock	20.8814	20.8907	20.6361	20.7111	61019756.0
2012-11-05 13:00:00	AAPL	Stock	20.7121	20.8375	20.6286	20.6911	52162264.0
2012-11-05 14:00:00	AAPL	Stock	20.6896	20.8929	20.6679	20.8359	54312608.0
2012-11-05 15:00:00	AAPL	Stock	20.8375	20.9532	20.7739	20.8793	74738188.0
2012-11-05 16:00:00	AAPL	Stock	20.8857	20.9196	20.8039	20.8964	21168896.0
2012-11-05 17:00:00	AAPL	Stock	20.8964	20.9096	20.8571	20.8764	414008.0
2012-11-05 18:00:00	AAPL	Stock	20.8607	20.8754	20.8571	20.8754	105504.0
2012-11-05 19:00:00	AAPL	Stock	20.8764	20.8782	20.8554	20.8571	87920.0
2012-11-05 05:00:00	MSFT	Stock	29.5	29.5	29.5	29.5	200.0
2012-11-05 06:00:00	MSFT	Stock	29.55	29.55	29.5	29.5	300.0
2012-11-05 08:00:00	MSFT	Stock	29.59	29.6	29.5	29.57	11210.0
2012-11-05 09:00:00	MSFT	Stock	29.56	29.74	29.35	29.44	4129062.0
2012-11-05 10:00:00	MSFT	Stock	29.43	29.56	29.33	29.49	5543782.0
2012-11-05 11:00:00	MSFT	Stock	29.49	29.5	29.37	29.42	4708521.0
2012-11-05 12:00:00	MSFT	Stock	29.42	29.51	29.4	29.47	4970286.0
2012-11-05 13:00:00	MSFT	Stock	29.47	29.5	29.42	29.435	3926858.0
2012-11-05 14:00:00	MSFT	Stock	29.435	29.59	29.4	29.585	3995157.0
2012-11-05 15:00:00	MSFT	Stock	29.585	29.73	29.57	29.63	7998920.0
2012-11-05 16:00:00	MSFT	Stock	29.63	29.669	29.462	29.55	2153410.0
2012-11-05 17:00:00	MSFT	Stock	29.56	29.63	29.56	29.6	1489.0
2012-11-05 18:00:00	MSFT	Stock	29.55	29.55	29.55	29.55	100.0
2012-11-05 19:00:00	MSFT	Stock	29.6	29.65	29.6	29.64	824.0
2012-11-05 06:00:00	NVDA	Stock	0.3038	0.3038	0.3038	0.3038	4000.0
2012-11-05 09:00:00	NVDA	Stock	0.3115	0.3183	0.3115	0.318	47087440.0
2012-11-05 10:00:00	NVDA	Stock	0.3183	0.3203	0.3165	0.32	75538320.0
2012-11-05 11:00:00	NVDA	Stock	0.32	0.323	0.3198	0.3219	59542680.0
2012-11-05 12:00:00	NVDA	Stock	0.3218	0.325	0.3215	0.3223	58146480.0
2012-11-05 13:00:00	NVDA	Stock	0.3223	0.3233	0.3213	0.3228	27491960.0
2012-11-05 14:00:00	NVDA	Stock	0.3225	0.325	0.3223	0.3249	40317920.0
2012-11-05 15:00:00	NVDA	Stock	0.325	0.3268	0.3245	0.3258	118282560.0
2012-11-05 16:00:00	NVDA	Stock	0.3255	0.3275	0.3227	0.3248	16540600.0
2012-11-05 17:00:00	NVDA	Stock	0.3258	0.3263	0.3248	0.3248	52000.0
2012-11-05 18:00:00	NVDA	Stock	0.3248	0.325	0.3248	0.325	40000.0
2012-11-05 07:00:00	AMZN	Stock	11.575	11.575	11.575	11.575	5600.0
2012-11-05 09:00:00	AMZN	Stock	11.6075	11.676	11.5055	11.5485	6958460.0
2012-11-05 10:00:00	AMZN	Stock	11.543	11.6735	11.511	11.6522	5677960.0
2012-11-05 11:00:00	AMZN	Stock	11.6585	11.665	11.5965	11.609	3202140.0
2012-11-05 12:00:00	AMZN	Stock	11.611	11.6223	11.5535	11.5695	2633040.0
2012-11-05 13:00:00	AMZN	Stock	11.565	11.652	11.565	11.649	3284980.0
2012-11-05 14:00:00	AMZN	Stock	11.6495	11.7005	11.644	11.6725	4507200.0
2012-11-05 15:00:00	AMZN	Stock	11.676	11.7415	11.6665	11.7195	8429140.0
2012-11-05 16:00:00	AMZN	Stock	11.7091	11.7192	11.5876	11.7165	1375260.0

> showing 50 of 43,703 rows — these rows as CSV

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