PREVIEW / stock_1hour / 2022-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-17.parquet
  size:    1.4 MB
  rows:    61,281
  symbols: 2,083

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
2022-11-17 04:00:00	AAPL	Stock	148.98	149.26	148.21	148.34	21834.0
2022-11-17 05:00:00	AAPL	Stock	148.49	148.68	147.65	147.75	19049.0
2022-11-17 06:00:00	AAPL	Stock	147.73	148.15	147.41	147.8	25062.0
2022-11-17 07:00:00	AAPL	Stock	147.87	147.87	146.72	147.0	91336.0
2022-11-17 08:00:00	AAPL	Stock	147.85	149.97	145.81	145.88	415102.0
2022-11-17 09:00:00	AAPL	Stock	145.87	148.0399	145.66	147.49	6645242.0
2022-11-17 10:00:00	AAPL	Stock	147.4891	148.81	147.3204	148.15	7663560.0
2022-11-17 11:00:00	AAPL	Stock	148.14	150.0554	148.09	149.995	8691905.0
2022-11-17 12:00:00	AAPL	Stock	149.9901	151.3499	149.61	151.16	8159319.0
2022-11-17 13:00:00	AAPL	Stock	151.1582	151.48	150.7908	151.085	6701810.0
2022-11-17 14:00:00	AAPL	Stock	151.085	151.17	149.555	150.2208	10094948.0
2022-11-17 15:00:00	AAPL	Stock	150.2104	150.85	149.53	150.75	11387097.0
2022-11-17 16:00:00	AAPL	Stock	150.72	151.14	150.25	151.08	12350259.0
2022-11-17 17:00:00	AAPL	Stock	151.0801	151.17	150.72	151.03	104228.0
2022-11-17 18:00:00	AAPL	Stock	151.05	151.17	150.73	150.74	46244.0
2022-11-17 19:00:00	AAPL	Stock	150.72	151.07	150.7	150.9	42515.0
2022-11-17 04:00:00	MSFT	Stock	242.0	242.0	240.58	240.7	18468.0
2022-11-17 05:00:00	MSFT	Stock	240.76	241.2	239.82	240.0	18179.0
2022-11-17 06:00:00	MSFT	Stock	240.0	240.57	239.48	240.45	7860.0
2022-11-17 07:00:00	MSFT	Stock	240.49	240.53	239.12	239.12	18400.0
2022-11-17 08:00:00	MSFT	Stock	240.5944	240.5944	237.8	237.9	66589.0
2022-11-17 09:00:00	MSFT	Stock	237.7	240.58	237.33	239.83	2195981.0
2022-11-17 10:00:00	MSFT	Stock	239.775	241.53	239.31	240.22	1782707.0
2022-11-17 11:00:00	MSFT	Stock	240.22	242.6532	239.92	242.58	1926895.0
2022-11-17 12:00:00	MSFT	Stock	242.63	243.15	241.52	242.59	2077733.0
2022-11-17 13:00:00	MSFT	Stock	242.595	243.25	242.15	242.55	1199723.0
2022-11-17 14:00:00	MSFT	Stock	242.54	242.81	241.27	241.84	1514253.0
2022-11-17 15:00:00	MSFT	Stock	241.84	242.2	240.23	241.7	2726904.0
2022-11-17 16:00:00	MSFT	Stock	241.68	242.48	241.68	242.31	4016383.0
2022-11-17 17:00:00	MSFT	Stock	242.33	242.48	241.68	242.25	8716.0
2022-11-17 18:00:00	MSFT	Stock	242.43	242.48	241.85	241.9	6848.0
2022-11-17 19:00:00	MSFT	Stock	241.9	241.92	241.77	241.77	4427.0
2022-11-17 04:00:00	NVDA	Stock	16.236	16.409	16.236	16.27	553390.0
2022-11-17 05:00:00	NVDA	Stock	16.296	16.318	16.105	16.15	369780.0
2022-11-17 06:00:00	NVDA	Stock	16.15	16.214	16.056	16.14	443900.0
2022-11-17 07:00:00	NVDA	Stock	16.155	16.228	15.94	15.976	1671890.0
2022-11-17 08:00:00	NVDA	Stock	16.155	16.229	15.621	15.64	8400340.0
2022-11-17 09:00:00	NVDA	Stock	15.633	16.134	15.585	15.906	115519680.0
2022-11-17 10:00:00	NVDA	Stock	15.9072	16.266	15.843	15.972	119186540.0
2022-11-17 11:00:00	NVDA	Stock	15.972	16.0458	15.773	15.937	88428790.0
2022-11-17 12:00:00	NVDA	Stock	15.94	15.97	15.744	15.937	65370720.0
2022-11-17 13:00:00	NVDA	Stock	15.941	15.978	15.705	15.775	51469210.0
2022-11-17 14:00:00	NVDA	Stock	15.777	15.804	15.627	15.676	49704790.0
2022-11-17 15:00:00	NVDA	Stock	15.6765	15.716	15.535	15.68	71416180.0
2022-11-17 16:00:00	NVDA	Stock	15.682	15.757	15.671	15.749	18852450.0
2022-11-17 17:00:00	NVDA	Stock	15.75	15.775	15.677	15.768	710450.0
2022-11-17 18:00:00	NVDA	Stock	15.775	15.783	15.751	15.755	230920.0
2022-11-17 19:00:00	NVDA	Stock	15.75	15.778	15.73	15.73	348110.0
2022-11-17 04:00:00	AMZN	Stock	97.68	97.68	97.0	97.1	13305.0
2022-11-17 05:00:00	AMZN	Stock	97.16	97.25	96.25	96.36	26459.0

> showing 50 of 61,281 rows — these rows as CSV

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