PREVIEW / stock_1hour / 2019-11-12

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-12.parquet
  size:    1.1 MB
  rows:    49,303
  symbols: 2,489

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
2019-11-12 04:00:00	AAPL	Stock	65.55	65.65	65.52	65.5625	30832.0
2019-11-12 05:00:00	AAPL	Stock	65.5625	65.6375	65.5625	65.6375	28692.0
2019-11-12 06:00:00	AAPL	Stock	65.68	65.6925	65.6	65.625	27172.0
2019-11-12 07:00:00	AAPL	Stock	65.65	65.65	65.5775	65.61	80120.0
2019-11-12 08:00:00	AAPL	Stock	65.5925	65.645	65.2775	65.315	767788.0
2019-11-12 09:00:00	AAPL	Stock	65.325	65.5625	65.26	65.3425	11466364.0
2019-11-12 10:00:00	AAPL	Stock	65.3425	65.555	65.23	65.355	14553328.0
2019-11-12 11:00:00	AAPL	Stock	65.3558	65.67	65.2675	65.47	9517036.0
2019-11-12 12:00:00	AAPL	Stock	65.4725	65.625	65.435	65.5425	6430852.0
2019-11-12 13:00:00	AAPL	Stock	65.54	65.6975	65.525	65.6787	5756272.0
2019-11-12 14:00:00	AAPL	Stock	65.6775	65.6775	65.285	65.4225	8808812.0
2019-11-12 15:00:00	AAPL	Stock	65.4225	65.5325	65.3825	65.495	9161452.0
2019-11-12 16:00:00	AAPL	Stock	65.49	65.5375	65.3775	65.475	7643344.0
2019-11-12 17:00:00	AAPL	Stock	65.495	65.4975	65.4475	65.455	48872.0
2019-11-12 18:00:00	AAPL	Stock	65.455	65.455	65.4125	65.4475	22064.0
2019-11-12 19:00:00	AAPL	Stock	65.45	65.45	65.3775	65.425	56288.0
2019-11-12 04:00:00	MSFT	Stock	146.6	146.6	146.23	146.23	600.0
2019-11-12 05:00:00	MSFT	Stock	146.63	146.63	146.63	146.63	202.0
2019-11-12 06:00:00	MSFT	Stock	146.47	146.47	146.4	146.4	1099.0
2019-11-12 07:00:00	MSFT	Stock	146.5	146.59	146.47	146.48	3662.0
2019-11-12 08:00:00	MSFT	Stock	146.5	146.53	146.36	146.45	17541.0
2019-11-12 09:00:00	MSFT	Stock	146.45	147.16	146.06	147.12	2082380.0
2019-11-12 10:00:00	MSFT	Stock	147.13	147.49	146.91	147.355	2405845.0
2019-11-12 11:00:00	MSFT	Stock	147.36	147.57	147.11	147.22	1585543.0
2019-11-12 12:00:00	MSFT	Stock	147.21	147.5	146.95	147.45	1374445.0
2019-11-12 13:00:00	MSFT	Stock	147.46	147.48	147.12	147.2	1047460.0
2019-11-12 14:00:00	MSFT	Stock	147.205	147.22	146.5	146.745	1884935.0
2019-11-12 15:00:00	MSFT	Stock	146.75	147.2	146.71	147.08	2433748.0
2019-11-12 16:00:00	MSFT	Stock	147.07	147.14	147.02	147.05	2525443.0
2019-11-12 17:00:00	MSFT	Stock	147.01	147.13	146.97	147.0	404501.0
2019-11-12 18:00:00	MSFT	Stock	147.0	147.0	146.92	146.96	3033.0
2019-11-12 19:00:00	MSFT	Stock	146.97	146.97	146.79	146.79	3870.0
2019-11-12 04:00:00	NVDA	Stock	5.2083	5.2083	5.2	5.2	19680.0
2019-11-12 05:00:00	NVDA	Stock	5.222	5.2475	5.222	5.2475	45760.0
2019-11-12 06:00:00	NVDA	Stock	5.245	5.262	5.245	5.2518	95160.0
2019-11-12 07:00:00	NVDA	Stock	5.25	5.2625	5.243	5.25	1027320.0
2019-11-12 08:00:00	NVDA	Stock	5.2563	5.2625	5.2438	5.2488	1408040.0
2019-11-12 09:00:00	NVDA	Stock	5.2485	5.285	5.2308	5.2388	44073760.0
2019-11-12 10:00:00	NVDA	Stock	5.2388	5.2963	5.2365	5.291	50622280.0
2019-11-12 11:00:00	NVDA	Stock	5.2913	5.2965	5.2513	5.2572	31547280.0
2019-11-12 12:00:00	NVDA	Stock	5.2572	5.264	5.2358	5.2456	30018280.0
2019-11-12 13:00:00	NVDA	Stock	5.2459	5.2645	5.2453	5.258	19285760.0
2019-11-12 14:00:00	NVDA	Stock	5.2572	5.26	5.2078	5.2192	34974720.0
2019-11-12 15:00:00	NVDA	Stock	5.2195	5.2508	5.2181	5.2403	32407200.0
2019-11-12 16:00:00	NVDA	Stock	5.2403	5.25	5.23	5.2312	3467040.0
2019-11-12 17:00:00	NVDA	Stock	5.2312	5.24	5.23	5.235	162560.0
2019-11-12 18:00:00	NVDA	Stock	5.235	5.2378	5.235	5.2378	84040.0
2019-11-12 19:00:00	NVDA	Stock	5.2375	5.239	5.2288	5.2362	245560.0
2019-11-12 04:00:00	AMZN	Stock	88.7	88.7	88.5	88.5	17860.0
2019-11-12 05:00:00	AMZN	Stock	88.55	88.55	88.525	88.525	6360.0

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

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