PREVIEW / stock_1hour / 2017-11-30

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-30.parquet
  size:    1.1 MB
  rows:    50,886
  symbols: 2,957

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-11-30 04:00:00	AAPL	Stock	42.3	42.4425	42.3	42.4275	23000.0
2017-11-30 05:00:00	AAPL	Stock	42.4725	42.55	42.45	42.55	27704.0
2017-11-30 06:00:00	AAPL	Stock	42.57	42.595	42.54	42.5625	24692.0
2017-11-30 07:00:00	AAPL	Stock	42.575	42.605	42.505	42.6	260600.0
2017-11-30 08:00:00	AAPL	Stock	42.605	42.71	42.515	42.685	560804.0
2017-11-30 09:00:00	AAPL	Stock	42.68	42.91	42.11	42.5	23603244.0
2017-11-30 10:00:00	AAPL	Stock	42.5075	42.7725	42.4888	42.61	17782128.0
2017-11-30 11:00:00	AAPL	Stock	42.61	42.875	42.585	42.7425	11429100.0
2017-11-30 12:00:00	AAPL	Stock	42.7425	42.875	42.6925	42.8235	8992008.0
2017-11-30 13:00:00	AAPL	Stock	42.8225	42.97	42.8075	42.955	10733924.0
2017-11-30 14:00:00	AAPL	Stock	42.955	42.9878	42.8825	42.9335	7277616.0
2017-11-30 15:00:00	AAPL	Stock	42.935	43.035	42.8125	42.9375	19270512.0
2017-11-30 16:00:00	AAPL	Stock	42.9425	42.9755	42.775	42.945	23185128.0
2017-11-30 17:00:00	AAPL	Stock	42.93	42.95	42.9275	42.94	31384.0
2017-11-30 18:00:00	AAPL	Stock	42.95	42.9625	42.925	42.925	35628.0
2017-11-30 19:00:00	AAPL	Stock	42.925	42.93	42.8725	42.8725	90260.0
2017-11-30 07:00:00	MSFT	Stock	83.51	83.94	83.44	83.5	12835.0
2017-11-30 08:00:00	MSFT	Stock	83.7	83.7	83.32	83.5	39459.0
2017-11-30 09:00:00	MSFT	Stock	83.49	84.03	83.34	83.87	3115655.0
2017-11-30 10:00:00	MSFT	Stock	83.88	84.02	83.555	83.64	2956321.0
2017-11-30 11:00:00	MSFT	Stock	83.64	83.94	83.59	83.91	1872597.0
2017-11-30 12:00:00	MSFT	Stock	83.91	84.52	83.87	84.28	2628507.0
2017-11-30 13:00:00	MSFT	Stock	84.28	84.41	84.1	84.25	2210327.0
2017-11-30 14:00:00	MSFT	Stock	84.24	84.275	84.01	84.195	2025053.0
2017-11-30 15:00:00	MSFT	Stock	84.2	84.26	83.9	84.09	5169065.0
2017-11-30 16:00:00	MSFT	Stock	84.17	84.22	84.01	84.17	9700922.0
2017-11-30 17:00:00	MSFT	Stock	84.01	84.15	84.01	84.15	4236.0
2017-11-30 18:00:00	MSFT	Stock	84.03	84.03	84.03	84.03	100.0
2017-11-30 19:00:00	MSFT	Stock	84.14	84.14	83.95	84.03	1227.0
2017-11-30 04:00:00	NVDA	Stock	4.95	4.95	4.9435	4.9462	34600.0
2017-11-30 05:00:00	NVDA	Stock	4.9438	4.9625	4.9438	4.9625	146520.0
2017-11-30 06:00:00	NVDA	Stock	4.97	4.9848	4.97	4.9755	289640.0
2017-11-30 07:00:00	NVDA	Stock	4.9752	4.9853	4.9538	4.9725	2107000.0
2017-11-30 08:00:00	NVDA	Stock	4.9695	4.9925	4.956	4.9788	6958480.0
2017-11-30 09:00:00	NVDA	Stock	4.9788	4.9958	4.9163	4.9509	137322000.0
2017-11-30 10:00:00	NVDA	Stock	4.9535	5.067	4.9392	5.028	190208880.0
2017-11-30 11:00:00	NVDA	Stock	5.0275	5.0402	4.9483	4.9925	107414120.0
2017-11-30 12:00:00	NVDA	Stock	4.9945	5.0115	4.9625	4.9812	72824240.0
2017-11-30 13:00:00	NVDA	Stock	4.982	5.0013	4.9778	4.9922	40453360.0
2017-11-30 14:00:00	NVDA	Stock	4.9905	5.0288	4.9828	5.0085	52188480.0
2017-11-30 15:00:00	NVDA	Stock	5.0085	5.0233	4.9853	5.015	92324400.0
2017-11-30 16:00:00	NVDA	Stock	5.0145	5.0178	5.0013	5.0082	32786600.0
2017-11-30 17:00:00	NVDA	Stock	5.0178	5.02	5.012	5.016	448440.0
2017-11-30 18:00:00	NVDA	Stock	5.0162	5.0245	5.0125	5.0132	425920.0
2017-11-30 19:00:00	NVDA	Stock	5.015	5.0188	5.0052	5.0075	163040.0
2017-11-30 05:00:00	AMZN	Stock	58.1285	58.386	58.1285	58.386	18760.0
2017-11-30 06:00:00	AMZN	Stock	58.4455	58.5	58.4455	58.5	10000.0
2017-11-30 07:00:00	AMZN	Stock	58.4635	58.55	58.3945	58.435	206400.0
2017-11-30 08:00:00	AMZN	Stock	58.52	58.628	58.4	58.449	697480.0
2017-11-30 09:00:00	AMZN	Stock	58.4585	58.645	58.0	58.3215	15575180.0

> showing 50 of 50,886 rows — these rows as CSV

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