PREVIEW / stock_1hour / 2018-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-01.parquet
  size:    1.1 MB
  rows:    49,773
  symbols: 2,878

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
2018-03-01 04:00:00	AAPL	Stock	44.8425	44.8425	44.5	44.5	16956.0
2018-03-01 05:00:00	AAPL	Stock	44.5325	44.6225	44.45	44.475	115876.0
2018-03-01 06:00:00	AAPL	Stock	44.475	44.535	44.275	44.32	36196.0
2018-03-01 07:00:00	AAPL	Stock	44.35	44.455	44.325	44.4125	276548.0
2018-03-01 08:00:00	AAPL	Stock	44.3875	44.7325	44.325	44.6775	631456.0
2018-03-01 09:00:00	AAPL	Stock	44.69	44.84	44.3725	44.4775	19236584.0
2018-03-01 10:00:00	AAPL	Stock	44.485	44.9438	44.4125	44.5975	23132864.0
2018-03-01 11:00:00	AAPL	Stock	44.595	44.7425	44.5425	44.5825	11666348.0
2018-03-01 12:00:00	AAPL	Stock	44.585	44.6075	43.945	43.9925	21198824.0
2018-03-01 13:00:00	AAPL	Stock	43.9925	43.9938	43.3175	43.3225	31477624.0
2018-03-01 14:00:00	AAPL	Stock	43.3225	43.775	43.165	43.7365	29881852.0
2018-03-01 15:00:00	AAPL	Stock	43.7375	43.9675	43.48	43.7375	29000036.0
2018-03-01 16:00:00	AAPL	Stock	43.75	43.825	43.7325	43.7975	8596288.0
2018-03-01 17:00:00	AAPL	Stock	43.78	43.825	43.765	43.7875	107108.0
2018-03-01 18:00:00	AAPL	Stock	43.7675	43.82	43.7375	43.75	48128.0
2018-03-01 19:00:00	AAPL	Stock	43.75	43.8225	43.7175	43.7975	87976.0
2018-03-01 04:00:00	MSFT	Stock	94.01	94.2	94.01	94.2	287.0
2018-03-01 05:00:00	MSFT	Stock	94.04	94.04	93.85	93.85	2300.0
2018-03-01 06:00:00	MSFT	Stock	94.16	94.16	93.52	93.52	800.0
2018-03-01 07:00:00	MSFT	Stock	93.74	93.75	93.59	93.66	13528.0
2018-03-01 08:00:00	MSFT	Stock	93.85	94.3	93.7	94.2	60294.0
2018-03-01 09:00:00	MSFT	Stock	94.19	94.57	92.55	92.56	3906183.0
2018-03-01 10:00:00	MSFT	Stock	92.57	94.035	92.351	92.94	3891509.0
2018-03-01 11:00:00	MSFT	Stock	92.94	93.77	92.88	93.62	2514035.0
2018-03-01 12:00:00	MSFT	Stock	93.62	93.66	92.76	93.05	2555209.0
2018-03-01 13:00:00	MSFT	Stock	93.04	93.1	92.25	92.28	4244059.0
2018-03-01 14:00:00	MSFT	Stock	92.28	92.69	91.84	92.54	5423416.0
2018-03-01 15:00:00	MSFT	Stock	92.53	93.35	92.31	92.84	7217388.0
2018-03-01 16:00:00	MSFT	Stock	92.85	93.02	92.82	92.98	3912937.0
2018-03-01 17:00:00	MSFT	Stock	92.99	92.99	92.85	92.88	3708.0
2018-03-01 18:00:00	MSFT	Stock	92.9	92.99	92.9	92.9	2320.0
2018-03-01 19:00:00	MSFT	Stock	92.91	93.0	92.9	93.0	3608.0
2018-03-01 04:00:00	NVDA	Stock	6.0528	6.0528	6.0402	6.0438	16880.0
2018-03-01 06:00:00	NVDA	Stock	6.038	6.038	6.0	6.0058	314200.0
2018-03-01 07:00:00	NVDA	Stock	6.0125	6.0438	6.0125	6.0312	579520.0
2018-03-01 08:00:00	NVDA	Stock	6.0312	6.07	6.025	6.0628	1282880.0
2018-03-01 09:00:00	NVDA	Stock	6.0685	6.1023	5.8878	5.9122	126942560.0
2018-03-01 10:00:00	NVDA	Stock	5.9118	5.991	5.8925	5.908	144259240.0
2018-03-01 11:00:00	NVDA	Stock	5.9065	5.9558	5.8958	5.9442	88724080.0
2018-03-01 12:00:00	NVDA	Stock	5.9438	5.9458	5.882	5.893	70336200.0
2018-03-01 13:00:00	NVDA	Stock	5.891	5.8912	5.7643	5.7664	156923160.0
2018-03-01 14:00:00	NVDA	Stock	5.7676	5.8062	5.7031	5.7958	165461480.0
2018-03-01 15:00:00	NVDA	Stock	5.7955	5.8362	5.7595	5.8045	179690960.0
2018-03-01 16:00:00	NVDA	Stock	5.7995	5.811	5.7892	5.8075	3690600.0
2018-03-01 17:00:00	NVDA	Stock	5.8531	5.8531	5.8053	5.8175	127295720.0
2018-03-01 18:00:00	NVDA	Stock	5.8175	5.8208	5.8112	5.8192	204640.0
2018-03-01 19:00:00	NVDA	Stock	5.8198	5.824	5.8175	5.8175	189240.0
2018-03-01 04:00:00	AMZN	Stock	76.5425	76.5425	76.088	76.088	6380.0
2018-03-01 05:00:00	AMZN	Stock	75.65	75.65	75.6	75.6455	61140.0
2018-03-01 06:00:00	AMZN	Stock	75.55	75.55	75.35	75.35	22580.0

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

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