PREVIEW / stock_1hour / 2015-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-07.parquet
  size:    1.1 MB
  rows:    49,441
  symbols: 3,501

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-07-07 04:00:00	AAPL	Stock	31.61	31.7475	31.61	31.695	37600.0
2015-07-07 05:00:00	AAPL	Stock	31.6625	31.6725	31.6	31.6025	24460.0
2015-07-07 06:00:00	AAPL	Stock	31.625	31.6275	31.6	31.61	15444.0
2015-07-07 07:00:00	AAPL	Stock	31.595	31.595	31.4875	31.4875	85728.0
2015-07-07 08:00:00	AAPL	Stock	31.4875	31.595	31.4125	31.5125	463664.0
2015-07-07 09:00:00	AAPL	Stock	31.5125	31.5375	31.335	31.355	16717644.0
2015-07-07 10:00:00	AAPL	Stock	31.3525	31.36	31.0862	31.1615	33978372.0
2015-07-07 11:00:00	AAPL	Stock	31.1625	31.185	30.9425	31.1308	31095612.0
2015-07-07 12:00:00	AAPL	Stock	31.1325	31.2375	31.04	31.215	17138144.0
2015-07-07 13:00:00	AAPL	Stock	31.2175	31.325	31.1675	31.2325	16307972.0
2015-07-07 14:00:00	AAPL	Stock	31.2338	31.43	31.1925	31.4218	17771792.0
2015-07-07 15:00:00	AAPL	Stock	31.4212	31.4375	31.3175	31.4225	27114456.0
2015-07-07 16:00:00	AAPL	Stock	31.4225	31.435	31.225	31.4	5567088.0
2015-07-07 17:00:00	AAPL	Stock	31.4	31.405	31.36	31.3775	63460.0
2015-07-07 18:00:00	AAPL	Stock	31.38	31.38	31.3525	31.38	54836.0
2015-07-07 19:00:00	AAPL	Stock	31.395	31.4225	31.34	31.345	578592.0
2015-07-07 05:00:00	MSFT	Stock	44.82	44.82	44.82	44.82	300.0
2015-07-07 06:00:00	MSFT	Stock	44.51	44.51	44.5	44.5	800.0
2015-07-07 07:00:00	MSFT	Stock	44.5	44.5	44.5	44.5	500.0
2015-07-07 08:00:00	MSFT	Stock	44.5	45.66	44.5	44.62	27798.0
2015-07-07 09:00:00	MSFT	Stock	44.55	44.55	43.85	43.89	4164088.0
2015-07-07 10:00:00	MSFT	Stock	43.885	43.94	43.64	43.655	6820066.0
2015-07-07 11:00:00	MSFT	Stock	43.66	43.75	43.32	43.64	5925416.0
2015-07-07 12:00:00	MSFT	Stock	43.64	44.03	43.52	43.98	4181247.0
2015-07-07 13:00:00	MSFT	Stock	43.985	44.19	43.925	43.95	2786050.0
2015-07-07 14:00:00	MSFT	Stock	43.95	44.38	43.85	44.37	2997780.0
2015-07-07 15:00:00	MSFT	Stock	44.37	44.47	44.2	44.3	5593475.0
2015-07-07 16:00:00	MSFT	Stock	44.29	44.32	43.93	44.22	2162668.0
2015-07-07 17:00:00	MSFT	Stock	44.22	44.22	44.2	44.21	525.0
2015-07-07 19:00:00	MSFT	Stock	44.2	44.2	44.16	44.16	3115.0
2015-07-07 08:00:00	NVDA	Stock	0.505	0.5125	0.5048	0.5098	74920.0
2015-07-07 09:00:00	NVDA	Stock	0.5048	0.5048	0.4794	0.481	93302280.0
2015-07-07 10:00:00	NVDA	Stock	0.4809	0.4872	0.479	0.4855	185164360.0
2015-07-07 11:00:00	NVDA	Stock	0.4855	0.4898	0.4845	0.4881	91315120.0
2015-07-07 12:00:00	NVDA	Stock	0.4883	0.4938	0.4872	0.4928	29164240.0
2015-07-07 13:00:00	NVDA	Stock	0.4928	0.4932	0.4905	0.4928	35774200.0
2015-07-07 14:00:00	NVDA	Stock	0.4926	0.4969	0.4912	0.4961	43028400.0
2015-07-07 15:00:00	NVDA	Stock	0.4961	0.4972	0.4932	0.4946	87639920.0
2015-07-07 16:00:00	NVDA	Stock	0.4948	0.4948	0.4948	0.4948	20925680.0
2015-07-07 17:00:00	NVDA	Stock	0.495	0.4951	0.4945	0.4951	64680.0
2015-07-07 18:00:00	NVDA	Stock	0.495	0.495	0.495	0.495	14600.0
2015-07-07 19:00:00	NVDA	Stock	0.4948	0.4948	0.4948	0.4948	4000.0
2015-07-07 05:00:00	AMZN	Stock	21.913	21.9135	21.913	21.9135	4460.0
2015-07-07 07:00:00	AMZN	Stock	21.875	21.875	21.8725	21.8725	18000.0
2015-07-07 08:00:00	AMZN	Stock	21.8695	21.9165	21.855	21.9165	65900.0
2015-07-07 09:00:00	AMZN	Stock	21.867	21.869	21.6835	21.696	3380660.0
2015-07-07 10:00:00	AMZN	Stock	21.701	21.718	21.2785	21.5125	12134980.0
2015-07-07 11:00:00	AMZN	Stock	21.5085	21.565	21.375	21.5405	5790700.0
2015-07-07 12:00:00	AMZN	Stock	21.5495	21.7588	21.4975	21.6805	6448880.0
2015-07-07 13:00:00	AMZN	Stock	21.689	21.72	21.6055	21.636	14869040.0

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

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