PREVIEW / stock_1hour / 2015-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-31.parquet
  size:    1.1 MB
  rows:    49,004
  symbols: 3,526

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
2015-03-31 04:00:00	AAPL	Stock	31.5875	31.6	31.565	31.6	9008.0
2015-03-31 06:00:00	AAPL	Stock	31.5225	31.5225	31.3775	31.47	39220.0
2015-03-31 07:00:00	AAPL	Stock	31.47	31.475	31.4275	31.45	149280.0
2015-03-31 08:00:00	AAPL	Stock	31.4475	31.55	31.4225	31.5125	866132.0
2015-03-31 09:00:00	AAPL	Stock	31.515	31.6225	31.3	31.4125	26079632.0
2015-03-31 10:00:00	AAPL	Stock	31.4075	31.46	31.2325	31.25	26763924.0
2015-03-31 11:00:00	AAPL	Stock	31.2475	31.4125	31.2425	31.2675	19293032.0
2015-03-31 12:00:00	AAPL	Stock	31.2675	31.3375	31.245	31.3	9625012.0
2015-03-31 13:00:00	AAPL	Stock	31.3025	31.38	31.3	31.33	9665512.0
2015-03-31 14:00:00	AAPL	Stock	31.3275	31.38	31.2875	31.3375	10208016.0
2015-03-31 15:00:00	AAPL	Stock	31.3362	31.3375	31.0888	31.1125	37573604.0
2015-03-31 16:00:00	AAPL	Stock	31.12	31.308	31.1055	31.2922	15946244.0
2015-03-31 17:00:00	AAPL	Stock	31.1175	31.125	31.1125	31.1225	102396.0
2015-03-31 18:00:00	AAPL	Stock	31.1248	31.17	31.115	31.1175	131344.0
2015-03-31 19:00:00	AAPL	Stock	31.13	31.1425	31.1125	31.1325	104776.0
2015-03-31 04:00:00	MSFT	Stock	40.9	40.9	40.85	40.85	698.0
2015-03-31 07:00:00	MSFT	Stock	40.68	40.75	40.59	40.68	2700.0
2015-03-31 08:00:00	MSFT	Stock	40.76	40.84	40.67	40.83	17965.0
2015-03-31 09:00:00	MSFT	Stock	40.83	40.94	40.56	40.616	4539310.0
2015-03-31 10:00:00	MSFT	Stock	40.61	40.83	40.58	40.76	3939982.0
2015-03-31 11:00:00	MSFT	Stock	40.77	40.82	40.58	40.59	4426097.0
2015-03-31 12:00:00	MSFT	Stock	40.59	40.77	40.54	40.745	3205093.0
2015-03-31 13:00:00	MSFT	Stock	40.742	40.99	40.73	40.845	2878764.0
2015-03-31 14:00:00	MSFT	Stock	40.84	41.03	40.83	41.03	2039730.0
2015-03-31 15:00:00	MSFT	Stock	41.025	41.025	40.63	40.65	7257984.0
2015-03-31 16:00:00	MSFT	Stock	40.655	40.776	40.6	40.748	5126472.0
2015-03-31 17:00:00	MSFT	Stock	40.7	40.7	40.655	40.67	31032.0
2015-03-31 18:00:00	MSFT	Stock	40.7	40.75	40.65	40.75	1645.0
2015-03-31 19:00:00	MSFT	Stock	40.661	40.661	40.66	40.66	502.0
2015-03-31 09:00:00	NVDA	Stock	0.5308	0.5358	0.5285	0.529	28940360.0
2015-03-31 10:00:00	NVDA	Stock	0.5287	0.5295	0.5269	0.5276	27397200.0
2015-03-31 11:00:00	NVDA	Stock	0.5278	0.53	0.5278	0.5291	42431280.0
2015-03-31 12:00:00	NVDA	Stock	0.529	0.529	0.5258	0.5272	34903440.0
2015-03-31 13:00:00	NVDA	Stock	0.5272	0.5285	0.5268	0.5282	52406240.0
2015-03-31 14:00:00	NVDA	Stock	0.5281	0.5285	0.527	0.528	35496000.0
2015-03-31 15:00:00	NVDA	Stock	0.5279	0.528	0.5228	0.5232	76289320.0
2015-03-31 16:00:00	NVDA	Stock	0.5231	0.527	0.5229	0.5235	24214920.0
2015-03-31 17:00:00	NVDA	Stock	0.5231	0.5242	0.5231	0.5231	3268760.0
2015-03-31 18:00:00	NVDA	Stock	0.5232	0.525	0.5232	0.525	110000.0
2015-03-31 19:00:00	NVDA	Stock	0.5238	0.5275	0.5238	0.5275	160000.0
2015-03-31 04:00:00	AMZN	Stock	18.716	18.716	18.716	18.716	15200.0
2015-03-31 08:00:00	AMZN	Stock	18.625	18.651	18.598	18.65	18560.0
2015-03-31 09:00:00	AMZN	Stock	18.6505	18.767	18.6325	18.676	3348560.0
2015-03-31 10:00:00	AMZN	Stock	18.668	18.7465	18.644	18.7195	6496200.0
2015-03-31 11:00:00	AMZN	Stock	18.7175	18.849	18.7165	18.8085	4642580.0
2015-03-31 12:00:00	AMZN	Stock	18.8045	18.869	18.775	18.862	3911620.0
2015-03-31 13:00:00	AMZN	Stock	18.8586	18.885	18.7905	18.797	5345560.0
2015-03-31 14:00:00	AMZN	Stock	18.8	18.8285	18.755	18.775	2913740.0
2015-03-31 15:00:00	AMZN	Stock	18.7795	18.7795	18.5755	18.6055	11866340.0
2015-03-31 16:00:00	AMZN	Stock	18.605	18.7396	18.6046	18.6325	8697320.0

> showing 50 of 49,004 rows — these rows as CSV

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