PREVIEW / stock_1hour / 2018-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-03.parquet
  size:    1.1 MB
  rows:    49,418
  symbols: 2,879

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-04-03 04:00:00	AAPL	Stock	41.875	41.875	41.7	41.8225	14512.0
2018-04-03 05:00:00	AAPL	Stock	41.775	41.84	41.775	41.775	6496.0
2018-04-03 06:00:00	AAPL	Stock	41.795	41.92	41.7875	41.9	11480.0
2018-04-03 07:00:00	AAPL	Stock	41.845	41.8625	41.7925	41.8625	170576.0
2018-04-03 08:00:00	AAPL	Stock	41.8625	42.045	41.67	42.025	598860.0
2018-04-03 09:00:00	AAPL	Stock	42.0225	42.0375	41.6025	41.675	15647256.0
2018-04-03 10:00:00	AAPL	Stock	41.68	41.6888	41.22	41.6175	21315000.0
2018-04-03 11:00:00	AAPL	Stock	41.6225	41.9	41.425	41.425	13065768.0
2018-04-03 12:00:00	AAPL	Stock	41.43	41.6225	41.34	41.53	7904208.0
2018-04-03 13:00:00	AAPL	Stock	41.534	41.7925	41.44	41.7338	7065684.0
2018-04-03 14:00:00	AAPL	Stock	41.735	41.92	41.4025	41.8675	9093860.0
2018-04-03 15:00:00	AAPL	Stock	41.865	42.1865	41.7925	42.0975	21017920.0
2018-04-03 16:00:00	AAPL	Stock	42.0975	42.135	42.075	42.1	8925236.0
2018-04-03 17:00:00	AAPL	Stock	42.1	42.1125	42.0025	42.0125	69912.0
2018-04-03 18:00:00	AAPL	Stock	42.0125	42.0475	42.0	42.0025	35816.0
2018-04-03 19:00:00	AAPL	Stock	42.0075	42.0375	41.925	42.0	41768.0
2018-04-03 04:00:00	MSFT	Stock	88.95	88.95	88.95	88.95	500.0
2018-04-03 05:00:00	MSFT	Stock	89.16	89.28	89.16	89.28	700.0
2018-04-03 06:00:00	MSFT	Stock	89.17	89.17	89.14	89.14	800.0
2018-04-03 07:00:00	MSFT	Stock	89.05	89.3	89.0	89.18	11159.0
2018-04-03 08:00:00	MSFT	Stock	89.1	89.6	88.52	89.52	122751.0
2018-04-03 09:00:00	MSFT	Stock	89.52	89.91	88.33	88.48	4082124.0
2018-04-03 10:00:00	MSFT	Stock	88.48	89.54	87.89	89.46	6041961.0
2018-04-03 11:00:00	MSFT	Stock	89.46	90.05	88.62	88.64	4273960.0
2018-04-03 12:00:00	MSFT	Stock	88.65	88.98	88.2	88.59	2429171.0
2018-04-03 13:00:00	MSFT	Stock	88.6	89.23	88.39	89.055	2331990.0
2018-04-03 14:00:00	MSFT	Stock	89.06	89.25	88.07	89.19	3389959.0
2018-04-03 15:00:00	MSFT	Stock	89.18	89.95	89.03	89.72	6234687.0
2018-04-03 16:00:00	MSFT	Stock	89.71	89.89	89.53	89.75	4352862.0
2018-04-03 17:00:00	MSFT	Stock	89.74	89.74	89.62	89.65	3973.0
2018-04-03 18:00:00	MSFT	Stock	89.65	89.65	89.55	89.6	7114.0
2018-04-03 19:00:00	MSFT	Stock	89.54	89.59	89.41	89.44	4833.0
2018-04-03 04:00:00	NVDA	Stock	5.55	5.5723	5.55	5.57	73560.0
2018-04-03 05:00:00	NVDA	Stock	5.5568	5.5875	5.5538	5.5688	107800.0
2018-04-03 06:00:00	NVDA	Stock	5.5862	5.61	5.5862	5.6	70840.0
2018-04-03 07:00:00	NVDA	Stock	5.5875	5.612	5.5838	5.6065	1334640.0
2018-04-03 08:00:00	NVDA	Stock	5.6062	5.6985	5.5263	5.6925	7970240.0
2018-04-03 09:00:00	NVDA	Stock	5.6808	5.7588	5.607	5.633	150296760.0
2018-04-03 10:00:00	NVDA	Stock	5.6352	5.6922	5.5555	5.6814	123985360.0
2018-04-03 11:00:00	NVDA	Stock	5.682	5.7117	5.5837	5.5837	66991000.0
2018-04-03 12:00:00	NVDA	Stock	5.5873	5.63	5.57	5.604	43856000.0
2018-04-03 13:00:00	NVDA	Stock	5.606	5.6438	5.5873	5.614	46613960.0
2018-04-03 14:00:00	NVDA	Stock	5.6128	5.6368	5.5338	5.6185	74539200.0
2018-04-03 15:00:00	NVDA	Stock	5.6181	5.675	5.5925	5.6338	118971920.0
2018-04-03 16:00:00	NVDA	Stock	5.6338	5.6375	5.6263	5.6338	12222960.0
2018-04-03 17:00:00	NVDA	Stock	5.6325	5.634	5.63	5.6313	606720.0
2018-04-03 18:00:00	NVDA	Stock	5.6313	5.6338	5.6225	5.6275	473040.0
2018-04-03 19:00:00	NVDA	Stock	5.6275	5.6322	5.6125	5.6128	1020680.0
2018-04-03 04:00:00	AMZN	Stock	68.6495	68.6495	68.2	68.245	31700.0
2018-04-03 05:00:00	AMZN	Stock	68.412	68.412	68.2435	68.2435	15500.0

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

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