PREVIEW / stock_1hour / 2017-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-05.parquet
  size:    1.1 MB
  rows:    48,138
  symbols: 2,962

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-05 04:00:00	AAPL	Stock	38.41	38.41	38.41	38.41	400.0
2017-10-05 05:00:00	AAPL	Stock	38.375	38.375	38.375	38.375	2296.0
2017-10-05 06:00:00	AAPL	Stock	38.35	38.375	38.35	38.375	3624.0
2017-10-05 07:00:00	AAPL	Stock	38.395	38.45	38.39	38.45	11884.0
2017-10-05 08:00:00	AAPL	Stock	38.45	38.5675	38.42	38.5475	276060.0
2017-10-05 09:00:00	AAPL	Stock	38.56	38.8405	38.51	38.7475	14947040.0
2017-10-05 10:00:00	AAPL	Stock	38.7475	38.83	38.655	38.6725	13120672.0
2017-10-05 11:00:00	AAPL	Stock	38.6725	38.75	38.6475	38.71	7157788.0
2017-10-05 12:00:00	AAPL	Stock	38.7118	38.8175	38.695	38.7225	6535544.0
2017-10-05 13:00:00	AAPL	Stock	38.7262	38.7625	38.695	38.715	5665608.0
2017-10-05 14:00:00	AAPL	Stock	38.715	38.8125	38.68	38.8125	6184532.0
2017-10-05 15:00:00	AAPL	Stock	38.8125	38.86	38.7985	38.85	14504268.0
2017-10-05 16:00:00	AAPL	Stock	38.8475	38.855	38.7525	38.8425	7620452.0
2017-10-05 17:00:00	AAPL	Stock	38.8475	38.8475	38.8075	38.825	36376.0
2017-10-05 18:00:00	AAPL	Stock	38.845	38.845	38.805	38.825	35440.0
2017-10-05 19:00:00	AAPL	Stock	38.835	38.835	38.8075	38.81	22396.0
2017-10-05 04:00:00	MSFT	Stock	74.93	75.25	74.93	75.25	8607.0
2017-10-05 05:00:00	MSFT	Stock	75.25	75.25	75.25	75.25	3961.0
2017-10-05 06:00:00	MSFT	Stock	75.25	75.32	75.17	75.28	4903.0
2017-10-05 07:00:00	MSFT	Stock	75.19	75.44	75.19	75.36	9233.0
2017-10-05 08:00:00	MSFT	Stock	75.18	75.53	75.18	75.41	29956.0
2017-10-05 09:00:00	MSFT	Stock	75.41	75.53	74.96	75.05	2708723.0
2017-10-05 10:00:00	MSFT	Stock	75.05	75.24	74.97	75.2	1833200.0
2017-10-05 11:00:00	MSFT	Stock	75.205	75.596	75.2	75.52	1978397.0
2017-10-05 12:00:00	MSFT	Stock	75.52	75.78	75.5	75.68	1850813.0
2017-10-05 13:00:00	MSFT	Stock	75.685	75.99	75.675	75.99	1614834.0
2017-10-05 14:00:00	MSFT	Stock	75.98	76.0	75.86	75.985	2077746.0
2017-10-05 15:00:00	MSFT	Stock	75.99	76.12	75.94	75.97	4496651.0
2017-10-05 16:00:00	MSFT	Stock	75.97	76.03	75.95	76.0	2323183.0
2017-10-05 17:00:00	MSFT	Stock	76.0	76.07	75.98	75.98	14642.0
2017-10-05 18:00:00	MSFT	Stock	76.07	76.07	75.99	75.99	1261.0
2017-10-05 19:00:00	MSFT	Stock	75.99	76.04	75.99	76.0	480.0
2017-10-05 05:00:00	NVDA	Stock	4.5325	4.5325	4.5325	4.5325	11200.0
2017-10-05 06:00:00	NVDA	Stock	4.5325	4.54	4.5325	4.5385	123960.0
2017-10-05 07:00:00	NVDA	Stock	4.533	4.539	4.53	4.5388	538720.0
2017-10-05 08:00:00	NVDA	Stock	4.5388	4.5475	4.5338	4.5462	1544840.0
2017-10-05 09:00:00	NVDA	Stock	4.542	4.55	4.5005	4.5025	80751000.0
2017-10-05 10:00:00	NVDA	Stock	4.502	4.5383	4.5014	4.5148	67369720.0
2017-10-05 11:00:00	NVDA	Stock	4.515	4.5168	4.4942	4.5055	52891920.0
2017-10-05 12:00:00	NVDA	Stock	4.5058	4.523	4.5014	4.5082	38420800.0
2017-10-05 13:00:00	NVDA	Stock	4.508	4.511	4.4968	4.5058	29915640.0
2017-10-05 14:00:00	NVDA	Stock	4.505	4.5105	4.489	4.5063	39524800.0
2017-10-05 15:00:00	NVDA	Stock	4.5072	4.5225	4.5068	4.518	62912480.0
2017-10-05 16:00:00	NVDA	Stock	4.5193	4.5205	4.4942	4.5165	11215280.0
2017-10-05 17:00:00	NVDA	Stock	4.5165	4.5175	4.5127	4.5162	85640.0
2017-10-05 18:00:00	NVDA	Stock	4.5175	4.5218	4.5175	4.5218	387240.0
2017-10-05 19:00:00	NVDA	Stock	4.52	4.52	4.5175	4.5175	419840.0
2017-10-05 05:00:00	AMZN	Stock	48.35	48.35	48.35	48.35	3480.0
2017-10-05 06:00:00	AMZN	Stock	48.3775	48.3775	48.3775	48.3775	6120.0
2017-10-05 08:00:00	AMZN	Stock	48.3725	48.5585	48.3725	48.51	320360.0

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

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