PREVIEW / stock_1hour / 2021-11-10

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-10.parquet
  size:    1.5 MB
  rows:    67,510
  symbols: 2,708

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
2021-11-10 04:00:00	AAPL	Stock	150.72	150.72	150.16	150.29	7615.0
2021-11-10 05:00:00	AAPL	Stock	150.18	150.18	149.92	150.04	9576.0
2021-11-10 06:00:00	AAPL	Stock	150.13	150.19	149.83	149.94	13625.0
2021-11-10 07:00:00	AAPL	Stock	149.95	150.37	149.94	150.28	84494.0
2021-11-10 08:00:00	AAPL	Stock	150.29	150.5	149.96	150.21	528516.0
2021-11-10 09:00:00	AAPL	Stock	150.22	150.4	147.95	149.02	11489878.0
2021-11-10 10:00:00	AAPL	Stock	149.03	149.61	148.72	148.97	6607246.0
2021-11-10 11:00:00	AAPL	Stock	148.975	149.08	148.68	149.07	3976735.0
2021-11-10 12:00:00	AAPL	Stock	149.07	149.19	148.795	149.18	3084755.0
2021-11-10 13:00:00	AAPL	Stock	149.17	149.18	148.33	148.505	4885089.0
2021-11-10 14:00:00	AAPL	Stock	148.5	148.53	147.933	148.15	5917960.0
2021-11-10 15:00:00	AAPL	Stock	148.16	148.2975	147.85	147.92	9298692.0
2021-11-10 16:00:00	AAPL	Stock	148.1	150.81	147.84	147.99	7436607.0
2021-11-10 17:00:00	AAPL	Stock	147.96	148.16	147.92	148.14	46982.0
2021-11-10 18:00:00	AAPL	Stock	148.14	148.2	147.9	147.92	35328.0
2021-11-10 19:00:00	AAPL	Stock	147.98	148.28	147.94	148.15	56981.0
2021-11-10 04:00:00	MSFT	Stock	336.0	336.0	335.8	335.8	329.0
2021-11-10 05:00:00	MSFT	Stock	335.05	335.05	334.51	334.97	454.0
2021-11-10 06:00:00	MSFT	Stock	334.94	335.4	334.76	335.04	20671.0
2021-11-10 07:00:00	MSFT	Stock	334.96	335.6	334.94	335.25	20849.0
2021-11-10 08:00:00	MSFT	Stock	334.9116	335.89	334.12	334.7021	65972.0
2021-11-10 09:00:00	MSFT	Stock	334.71	335.45	331.11	332.86	2538806.0
2021-11-10 10:00:00	MSFT	Stock	332.87	333.98	332.55	333.09	1659204.0
2021-11-10 11:00:00	MSFT	Stock	333.08	333.72	331.63	332.44	1337222.0
2021-11-10 12:00:00	MSFT	Stock	332.445	332.856	332.12	332.8	835044.0
2021-11-10 13:00:00	MSFT	Stock	332.78	332.83	329.93	330.405	2087455.0
2021-11-10 14:00:00	MSFT	Stock	330.395	331.645	329.92	330.87	1654776.0
2021-11-10 15:00:00	MSFT	Stock	330.9	331.64	330.4454	330.77	2400137.0
2021-11-10 16:00:00	MSFT	Stock	330.56	331.32	330.56	331.32	3933296.0
2021-11-10 17:00:00	MSFT	Stock	331.34	331.4	330.8	331.18	10758.0
2021-11-10 18:00:00	MSFT	Stock	331.15	331.15	330.52	330.82	14748.0
2021-11-10 19:00:00	MSFT	Stock	330.98	331.55	330.98	331.25	12922.0
2021-11-10 04:00:00	NVDA	Stock	30.48	30.48	30.074	30.316	295960.0
2021-11-10 05:00:00	NVDA	Stock	30.34	30.34	30.005	30.127	323480.0
2021-11-10 06:00:00	NVDA	Stock	30.101	30.25	29.956	29.97	232560.0
2021-11-10 07:00:00	NVDA	Stock	29.97	30.013	29.3	29.312	1755710.0
2021-11-10 08:00:00	NVDA	Stock	29.851	29.999	29.123	29.355	4976440.0
2021-11-10 09:00:00	NVDA	Stock	29.365	30.297	28.778	30.252	96979050.0
2021-11-10 10:00:00	NVDA	Stock	30.2519	30.85	30.077	30.081	84935470.0
2021-11-10 11:00:00	NVDA	Stock	30.09	30.303	29.831	30.1335	51596330.0
2021-11-10 12:00:00	NVDA	Stock	30.133	30.16	29.855	30.031	33929040.0
2021-11-10 13:00:00	NVDA	Stock	30.0285	30.055	29.505	29.556	43115950.0
2021-11-10 14:00:00	NVDA	Stock	29.546	29.739	29.106	29.374	56971580.0
2021-11-10 15:00:00	NVDA	Stock	29.373	29.698	29.3175	29.44	50619040.0
2021-11-10 16:00:00	NVDA	Stock	29.459	29.495	29.365	29.45	29188850.0
2021-11-10 17:00:00	NVDA	Stock	29.435	29.459	29.4	29.4	228020.0
2021-11-10 18:00:00	NVDA	Stock	29.399	29.459	29.36	29.45	338790.0
2021-11-10 19:00:00	NVDA	Stock	29.43	29.849	29.43	29.849	780310.0
2021-11-10 05:00:00	AMZN	Stock	178.575	178.575	178.4055	178.4055	8540.0
2021-11-10 06:00:00	AMZN	Stock	178.518	178.518	178.25	178.25	4000.0

> showing 50 of 67,510 rows — these rows as CSV

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