PREVIEW / stock_1hour / 2023-11-15

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-15.parquet
  size:    1.3 MB
  rows:    60,170
  symbols: 1,319

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
2023-11-15 04:00:00	AAPL	Stock	187.82	187.86	187.7	187.78	8225.0
2023-11-15 05:00:00	AAPL	Stock	187.8	188.05	187.8	188.01	6423.0
2023-11-15 06:00:00	AAPL	Stock	187.95	188.09	187.95	188.0	2772.0
2023-11-15 07:00:00	AAPL	Stock	187.97	188.52	187.97	188.3	85018.0
2023-11-15 08:00:00	AAPL	Stock	188.1009	188.88	187.44	187.86	207414.0
2023-11-15 09:00:00	AAPL	Stock	187.89	188.7	187.44	188.24	5722625.0
2023-11-15 10:00:00	AAPL	Stock	188.225	189.24	187.85	189.175	6552138.0
2023-11-15 11:00:00	AAPL	Stock	189.175	189.5	188.61	188.759	5710429.0
2023-11-15 12:00:00	AAPL	Stock	188.76	189.17	188.53	188.7997	3518901.0
2023-11-15 13:00:00	AAPL	Stock	188.79	189.08	188.465	188.94	3253885.0
2023-11-15 14:00:00	AAPL	Stock	188.95	188.96	188.17	188.3126	3041278.0
2023-11-15 15:00:00	AAPL	Stock	188.32	188.56	187.78	188.09	6785514.0
2023-11-15 16:00:00	AAPL	Stock	188.11	188.28	187.84	188.1	8271896.0
2023-11-15 17:00:00	AAPL	Stock	188.1	188.18	188.01	188.0217	44459.0
2023-11-15 18:00:00	AAPL	Stock	188.07	189.64	188.07	189.0	65906.0
2023-11-15 19:00:00	AAPL	Stock	188.85	189.0	188.63	188.7	32413.0
2023-11-15 04:00:00	MSFT	Stock	371.6	371.94	371.31	371.37	16517.0
2023-11-15 05:00:00	MSFT	Stock	371.7	372.66	371.7	372.66	3082.0
2023-11-15 06:00:00	MSFT	Stock	372.51	372.8	372.27	372.8	10011.0
2023-11-15 07:00:00	MSFT	Stock	372.75	372.8	371.54	372.35	48822.0
2023-11-15 08:00:00	MSFT	Stock	372.7	373.48	369.52	371.7	113113.0
2023-11-15 09:00:00	MSFT	Stock	371.77	373.13	369.62	370.41	2544220.0
2023-11-15 10:00:00	MSFT	Stock	370.38	371.53	369.04	369.6	2149114.0
2023-11-15 11:00:00	MSFT	Stock	369.64	371.04	368.42	369.31	2406099.0
2023-11-15 12:00:00	MSFT	Stock	369.3	369.67	368.05	368.11	1592605.0
2023-11-15 13:00:00	MSFT	Stock	368.1	370.0	367.11	369.77	1835925.0
2023-11-15 14:00:00	MSFT	Stock	369.77	370.38	369.1	369.98	1280378.0
2023-11-15 15:00:00	MSFT	Stock	369.95	370.37	369.22	369.67	2623342.0
2023-11-15 16:00:00	MSFT	Stock	369.68	370.09	369.1015	369.67	4192640.0
2023-11-15 17:00:00	MSFT	Stock	369.81	370.0	369.67	369.7	9665.0
2023-11-15 18:00:00	MSFT	Stock	369.93	370.8	369.91	370.8	18894.0
2023-11-15 19:00:00	MSFT	Stock	370.8	371.24	370.8	371.1	23921.0
2023-11-15 04:00:00	NVDA	Stock	49.9	50.002	49.867	49.94	227880.0
2023-11-15 05:00:00	NVDA	Stock	49.95	50.08	49.937	50.011	84670.0
2023-11-15 06:00:00	NVDA	Stock	50.0	50.029	49.95	50.02	53530.0
2023-11-15 07:00:00	NVDA	Stock	50.02	50.126	49.981	50.045	1234910.0
2023-11-15 08:00:00	NVDA	Stock	49.705	50.19	49.656	49.985	5149580.0
2023-11-15 09:00:00	NVDA	Stock	49.978	49.985	48.664	48.868	68545100.0
2023-11-15 10:00:00	NVDA	Stock	48.8705	49.437	48.823	49.13	62848530.0
2023-11-15 11:00:00	NVDA	Stock	49.132	49.33	48.821	48.848	39866110.0
2023-11-15 12:00:00	NVDA	Stock	48.85	48.914	48.521	48.723	44214050.0
2023-11-15 13:00:00	NVDA	Stock	48.723	48.841	48.2	48.7989	50408530.0
2023-11-15 14:00:00	NVDA	Stock	48.794	48.999	48.661	48.8195	31865850.0
2023-11-15 15:00:00	NVDA	Stock	48.8242	48.939	48.661	48.909	35735040.0
2023-11-15 16:00:00	NVDA	Stock	48.911	48.911	48.498	48.664	16488770.0
2023-11-15 17:00:00	NVDA	Stock	48.65	48.715	48.624	48.698	316110.0
2023-11-15 18:00:00	NVDA	Stock	48.699	48.742	48.67	48.742	319040.0
2023-11-15 19:00:00	NVDA	Stock	48.727	48.815	48.675	48.79	436070.0
2023-11-15 04:00:00	AMZN	Stock	146.75	146.78	146.53	146.53	10357.0
2023-11-15 05:00:00	AMZN	Stock	146.6	146.94	146.6	146.94	15334.0

> showing 50 of 60,170 rows — these rows as CSV

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