PREVIEW / stock_1hour / 2017-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-23.parquet
  size:    1.0 MB
  rows:    48,185
  symbols: 3,123

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
2017-01-23 04:00:00	AAPL	Stock	29.875	29.95	29.875	29.95	8820.0
2017-01-23 06:00:00	AAPL	Stock	29.955	29.955	29.9425	29.9425	7816.0
2017-01-23 07:00:00	AAPL	Stock	29.9425	29.9625	29.9	29.9375	78128.0
2017-01-23 08:00:00	AAPL	Stock	29.9475	29.9675	29.9125	29.9625	249440.0
2017-01-23 09:00:00	AAPL	Stock	29.96	30.2025	29.945	30.0625	18500708.0
2017-01-23 10:00:00	AAPL	Stock	30.0618	30.1175	29.9575	29.9712	14804056.0
2017-01-23 11:00:00	AAPL	Stock	29.9725	30.0088	29.9425	29.9812	9886656.0
2017-01-23 12:00:00	AAPL	Stock	29.98	30.0342	29.97	30.0072	6481232.0
2017-01-23 13:00:00	AAPL	Stock	30.005	30.045	29.9922	30.015	5261956.0
2017-01-23 14:00:00	AAPL	Stock	30.015	30.03	29.9875	30.0088	5874924.0
2017-01-23 15:00:00	AAPL	Stock	30.0075	30.0525	29.9975	30.0225	11561600.0
2017-01-23 16:00:00	AAPL	Stock	30.02	30.0275	30.0175	30.02	4456204.0
2017-01-23 17:00:00	AAPL	Stock	30.0325	30.045	30.02	30.045	66796.0
2017-01-23 18:00:00	AAPL	Stock	30.0325	30.0325	30.0275	30.0275	13520.0
2017-01-23 19:00:00	AAPL	Stock	30.035	30.0475	30.0325	30.0475	49468.0
2017-01-23 04:00:00	MSFT	Stock	63.0	63.0	63.0	63.0	230.0
2017-01-23 05:00:00	MSFT	Stock	62.74	62.74	62.74	62.74	100.0
2017-01-23 07:00:00	MSFT	Stock	62.75	62.75	62.74	62.75	2200.0
2017-01-23 08:00:00	MSFT	Stock	62.85	62.85	62.78	62.8	5531.0
2017-01-23 09:00:00	MSFT	Stock	62.75	63.116	62.7	62.829	2532668.0
2017-01-23 10:00:00	MSFT	Stock	62.825	62.9	62.67	62.76	2737724.0
2017-01-23 11:00:00	MSFT	Stock	62.77	62.78	62.57	62.67	2152834.0
2017-01-23 12:00:00	MSFT	Stock	62.68	62.82	62.64	62.81	1385957.0
2017-01-23 13:00:00	MSFT	Stock	62.802	62.94	62.77	62.855	1779632.0
2017-01-23 14:00:00	MSFT	Stock	62.85	62.92	62.75	62.91	1818072.0
2017-01-23 15:00:00	MSFT	Stock	62.905	63.025	62.89	62.98	5631662.0
2017-01-23 16:00:00	MSFT	Stock	62.96	63.03	62.91	62.96	2953982.0
2017-01-23 17:00:00	MSFT	Stock	63.0	63.0	62.96	62.98	3345.0
2017-01-23 18:00:00	MSFT	Stock	62.98	62.99	62.96	62.99	2243.0
2017-01-23 19:00:00	MSFT	Stock	62.99	63.03	62.96	63.03	1477.0
2017-01-23 04:00:00	NVDA	Stock	2.6003	2.6003	2.6003	2.6003	16000.0
2017-01-23 05:00:00	NVDA	Stock	2.6003	2.6003	2.6003	2.6003	18800.0
2017-01-23 07:00:00	NVDA	Stock	2.6005	2.6005	2.585	2.5888	138200.0
2017-01-23 08:00:00	NVDA	Stock	2.5933	2.6003	2.5875	2.5908	537880.0
2017-01-23 09:00:00	NVDA	Stock	2.5902	2.6475	2.59	2.6223	84680600.0
2017-01-23 10:00:00	NVDA	Stock	2.622	2.6248	2.5952	2.603	51878120.0
2017-01-23 11:00:00	NVDA	Stock	2.6029	2.623	2.597	2.6116	40906960.0
2017-01-23 12:00:00	NVDA	Stock	2.6118	2.622	2.6062	2.6199	28184560.0
2017-01-23 13:00:00	NVDA	Stock	2.6199	2.6392	2.6192	2.6317	41390520.0
2017-01-23 14:00:00	NVDA	Stock	2.6315	2.6328	2.6225	2.6263	30280200.0
2017-01-23 15:00:00	NVDA	Stock	2.627	2.63	2.6223	2.6272	54968760.0
2017-01-23 16:00:00	NVDA	Stock	2.6272	2.6272	2.6223	2.6272	14129040.0
2017-01-23 17:00:00	NVDA	Stock	2.6278	2.632	2.6263	2.6263	90720.0
2017-01-23 18:00:00	NVDA	Stock	2.6272	2.6315	2.6263	2.6263	3602160.0
2017-01-23 19:00:00	NVDA	Stock	2.6263	2.6312	2.6263	2.63	38000.0
2017-01-23 07:00:00	AMZN	Stock	40.335	40.335	40.335	40.335	10000.0
2017-01-23 08:00:00	AMZN	Stock	40.335	40.343	40.305	40.314	49400.0
2017-01-23 09:00:00	AMZN	Stock	40.328	40.639	40.254	40.5595	9163000.0
2017-01-23 10:00:00	AMZN	Stock	40.54	40.635	40.4793	40.5505	5918760.0
2017-01-23 11:00:00	AMZN	Stock	40.5495	40.5904	40.44	40.4855	3961000.0

> showing 50 of 48,185 rows — these rows as CSV

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