PREVIEW / stock_1hour / 2017-10-16

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-16.parquet
  size:    1.1 MB
  rows:    48,269
  symbols: 2,952

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-10-16 04:00:00	AAPL	Stock	39.535	39.5625	39.4525	39.545	26956.0
2017-10-16 05:00:00	AAPL	Stock	39.5375	39.5425	39.5	39.5425	8796.0
2017-10-16 06:00:00	AAPL	Stock	39.5425	39.625	39.5425	39.6	68932.0
2017-10-16 07:00:00	AAPL	Stock	39.565	39.5825	39.525	39.5625	180900.0
2017-10-16 08:00:00	AAPL	Stock	39.575	39.5875	39.525	39.565	349212.0
2017-10-16 09:00:00	AAPL	Stock	39.5575	39.84	39.3375	39.7838	21988180.0
2017-10-16 10:00:00	AAPL	Stock	39.785	39.915	39.7575	39.835	18352052.0
2017-10-16 11:00:00	AAPL	Stock	39.8362	39.8625	39.7325	39.84	7388348.0
2017-10-16 12:00:00	AAPL	Stock	39.84	39.8898	39.7438	39.8575	6935704.0
2017-10-16 13:00:00	AAPL	Stock	39.8595	39.885	39.84	39.8625	4927692.0
2017-10-16 14:00:00	AAPL	Stock	39.8625	39.935	39.8575	39.9275	5977480.0
2017-10-16 15:00:00	AAPL	Stock	39.9265	40.0	39.9212	39.9675	15444536.0
2017-10-16 16:00:00	AAPL	Stock	39.97	40.0	39.9525	39.9875	6087460.0
2017-10-16 17:00:00	AAPL	Stock	39.9925	39.9925	39.9525	39.985	77884.0
2017-10-16 18:00:00	AAPL	Stock	39.9925	40.0	39.98	40.0	31092.0
2017-10-16 19:00:00	AAPL	Stock	40.0	40.0	39.9825	39.99	47224.0
2017-10-16 04:00:00	MSFT	Stock	77.22	77.22	77.22	77.22	200.0
2017-10-16 05:00:00	MSFT	Stock	77.37	77.37	77.37	77.37	718.0
2017-10-16 07:00:00	MSFT	Stock	77.5	77.6	77.5	77.6	777.0
2017-10-16 08:00:00	MSFT	Stock	77.62	77.65	77.62	77.65	634.0
2017-10-16 09:00:00	MSFT	Stock	77.55	77.81	77.32	77.726	1523881.0
2017-10-16 10:00:00	MSFT	Stock	77.72	77.725	77.365	77.52	2132061.0
2017-10-16 11:00:00	MSFT	Stock	77.52	77.64	77.45	77.61	1058668.0
2017-10-16 12:00:00	MSFT	Stock	77.61	77.68	77.43	77.5	1143328.0
2017-10-16 13:00:00	MSFT	Stock	77.504	77.6	77.415	77.425	1007100.0
2017-10-16 14:00:00	MSFT	Stock	77.427	77.61	77.42	77.585	728790.0
2017-10-16 15:00:00	MSFT	Stock	77.585	77.685	77.5	77.66	2122548.0
2017-10-16 16:00:00	MSFT	Stock	77.65	77.65	77.58	77.65	1352323.0
2017-10-16 17:00:00	MSFT	Stock	77.66	77.66	77.66	77.66	220.0
2017-10-16 19:00:00	MSFT	Stock	77.66	77.66	77.66	77.66	600.0
2017-10-16 04:00:00	NVDA	Stock	4.875	4.9418	4.875	4.9248	387680.0
2017-10-16 05:00:00	NVDA	Stock	4.9338	4.9338	4.9075	4.92	314040.0
2017-10-16 06:00:00	NVDA	Stock	4.9175	4.925	4.9133	4.9133	121080.0
2017-10-16 07:00:00	NVDA	Stock	4.9125	4.918	4.9	4.9075	692760.0
2017-10-16 08:00:00	NVDA	Stock	4.9038	4.9138	4.888	4.8983	2048560.0
2017-10-16 09:00:00	NVDA	Stock	4.8975	4.9062	4.8603	4.8795	82103800.0
2017-10-16 10:00:00	NVDA	Stock	4.8795	4.891	4.831	4.8583	93484000.0
2017-10-16 11:00:00	NVDA	Stock	4.8583	4.906	4.853	4.9045	70968120.0
2017-10-16 12:00:00	NVDA	Stock	4.9042	4.9188	4.8888	4.9175	58791000.0
2017-10-16 13:00:00	NVDA	Stock	4.9173	4.941	4.916	4.9322	61441800.0
2017-10-16 14:00:00	NVDA	Stock	4.933	4.95	4.9308	4.9429	53866280.0
2017-10-16 15:00:00	NVDA	Stock	4.9425	4.9512	4.9328	4.9478	63966200.0
2017-10-16 16:00:00	NVDA	Stock	4.9483	4.9513	4.9432	4.945	23815480.0
2017-10-16 17:00:00	NVDA	Stock	4.9415	4.95	4.9415	4.9485	946920.0
2017-10-16 18:00:00	NVDA	Stock	4.9498	4.9518	4.9475	4.9518	652880.0
2017-10-16 19:00:00	NVDA	Stock	4.9518	4.955	4.9513	4.9535	464640.0
2017-10-16 04:00:00	AMZN	Stock	50.3	50.3	50.3	50.3	11000.0
2017-10-16 06:00:00	AMZN	Stock	50.3	50.35	50.3	50.304	39680.0
2017-10-16 07:00:00	AMZN	Stock	50.3055	50.332	50.3	50.3	18700.0
2017-10-16 08:00:00	AMZN	Stock	50.33	50.418	50.309	50.4	85860.0

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

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