PREVIEW / stock_1hour / 2019-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-06.parquet
  size:    1.1 MB
  rows:    49,310
  symbols: 2,555

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-09-06 04:00:00	AAPL	Stock	53.3025	53.3375	53.285	53.3375	10312.0
2019-09-06 05:00:00	AAPL	Stock	53.315	53.5175	53.315	53.4125	31940.0
2019-09-06 06:00:00	AAPL	Stock	53.2525	53.3675	53.2275	53.3675	22628.0
2019-09-06 07:00:00	AAPL	Stock	53.4425	53.4725	53.325	53.47	161332.0
2019-09-06 08:00:00	AAPL	Stock	53.3502	53.5675	53.2675	53.4125	378220.0
2019-09-06 09:00:00	AAPL	Stock	53.415	53.605	53.22	53.265	11704892.0
2019-09-06 10:00:00	AAPL	Stock	53.265	53.34	53.1275	53.271	10446888.0
2019-09-06 11:00:00	AAPL	Stock	53.27	53.34	53.1375	53.1725	5505836.0
2019-09-06 12:00:00	AAPL	Stock	53.1725	53.2825	53.1325	53.2775	4832224.0
2019-09-06 13:00:00	AAPL	Stock	53.275	53.4875	53.2675	53.47	6258244.0
2019-09-06 14:00:00	AAPL	Stock	53.4712	53.4815	53.3762	53.4062	4555108.0
2019-09-06 15:00:00	AAPL	Stock	53.4075	53.4975	53.2725	53.3175	11513412.0
2019-09-06 16:00:00	AAPL	Stock	53.305	53.3925	53.3	53.3875	5950712.0
2019-09-06 17:00:00	AAPL	Stock	53.35	53.3725	53.2775	53.3625	45560.0
2019-09-06 18:00:00	AAPL	Stock	53.3625	53.3975	53.3625	53.3975	12612.0
2019-09-06 19:00:00	AAPL	Stock	53.3875	53.4375	53.38	53.425	29660.0
2019-09-06 04:00:00	MSFT	Stock	140.3	140.3	140.1	140.1	996.0
2019-09-06 05:00:00	MSFT	Stock	140.3	140.51	140.15	140.15	2605.0
2019-09-06 06:00:00	MSFT	Stock	140.12	140.12	140.05	140.1	1357.0
2019-09-06 07:00:00	MSFT	Stock	140.3	140.5	140.3	140.5	7910.0
2019-09-06 08:00:00	MSFT	Stock	140.51	140.66	139.864	140.01	55665.0
2019-09-06 09:00:00	MSFT	Stock	139.91	140.24	138.41	139.065	2758381.0
2019-09-06 10:00:00	MSFT	Stock	139.07	139.64	138.895	139.41	2362830.0
2019-09-06 11:00:00	MSFT	Stock	139.41	139.46	138.975	139.03	1695957.0
2019-09-06 12:00:00	MSFT	Stock	139.02	139.06	138.2	138.79	2084569.0
2019-09-06 13:00:00	MSFT	Stock	138.8	139.46	138.76	139.42	1446899.0
2019-09-06 14:00:00	MSFT	Stock	139.42	139.66	139.28	139.635	1160784.0
2019-09-06 15:00:00	MSFT	Stock	139.63	139.71	138.985	139.13	3175648.0
2019-09-06 16:00:00	MSFT	Stock	139.1	139.1	138.935	139.1	2422347.0
2019-09-06 17:00:00	MSFT	Stock	139.15	139.15	138.98	139.1	7149.0
2019-09-06 18:00:00	MSFT	Stock	139.09	139.1	139.0	139.05	4191.0
2019-09-06 19:00:00	MSFT	Stock	139.05	139.17	139.02	139.17	4293.0
2019-09-06 04:00:00	NVDA	Stock	4.4975	4.4995	4.49	4.4912	122480.0
2019-09-06 05:00:00	NVDA	Stock	4.492	4.5045	4.4862	4.4862	186920.0
2019-09-06 06:00:00	NVDA	Stock	4.4838	4.4862	4.4838	4.4862	20000.0
2019-09-06 07:00:00	NVDA	Stock	4.4925	4.496	4.4865	4.4932	155560.0
2019-09-06 08:00:00	NVDA	Stock	4.4865	4.495	4.455	4.4663	1585920.0
2019-09-06 09:00:00	NVDA	Stock	4.4663	4.4845	4.4308	4.4363	62388600.0
2019-09-06 10:00:00	NVDA	Stock	4.4355	4.4622	4.428	4.4453	50660080.0
2019-09-06 11:00:00	NVDA	Stock	4.4452	4.4655	4.4433	4.4576	27793560.0
2019-09-06 12:00:00	NVDA	Stock	4.4576	4.465	4.4445	4.4536	22028280.0
2019-09-06 13:00:00	NVDA	Stock	4.4542	4.521	4.4525	4.521	52465360.0
2019-09-06 14:00:00	NVDA	Stock	4.522	4.5273	4.4975	4.5006	42228840.0
2019-09-06 15:00:00	NVDA	Stock	4.5013	4.5045	4.4583	4.4655	68465040.0
2019-09-06 16:00:00	NVDA	Stock	4.4663	4.4702	4.4625	4.4675	8478040.0
2019-09-06 17:00:00	NVDA	Stock	4.4688	4.469	4.4672	4.4675	99800.0
2019-09-06 18:00:00	NVDA	Stock	4.4672	4.475	4.4665	4.475	67960.0
2019-09-06 19:00:00	NVDA	Stock	4.475	4.475	4.4688	4.4695	172360.0
2019-09-06 04:00:00	AMZN	Stock	92.1	92.1	92.1	92.1	5000.0
2019-09-06 05:00:00	AMZN	Stock	92.3	92.35	92.05	92.125	53100.0

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

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