PREVIEW / stock_1hour / 2023-11-29

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-29.parquet
  size:    1.3 MB
  rows:    59,929
  symbols: 1,291

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-29 04:00:00	AAPL	Stock	189.9	190.3	189.8	190.3	22707.0
2023-11-29 05:00:00	AAPL	Stock	190.3	190.38	190.26	190.26	1777.0
2023-11-29 06:00:00	AAPL	Stock	190.22	190.46	190.17	190.46	7637.0
2023-11-29 07:00:00	AAPL	Stock	190.4	190.68	190.28	190.47	63566.0
2023-11-29 08:00:00	AAPL	Stock	190.36	191.03	189.72	190.7	136239.0
2023-11-29 09:00:00	AAPL	Stock	190.76	192.09	190.4434	191.74	4493829.0
2023-11-29 10:00:00	AAPL	Stock	191.74	191.82	190.6	190.925	4705360.0
2023-11-29 11:00:00	AAPL	Stock	190.935	190.955	189.9103	189.92	4247628.0
2023-11-29 12:00:00	AAPL	Stock	189.9201	189.93	189.52	189.7022	2655963.0
2023-11-29 13:00:00	AAPL	Stock	189.71	189.755	189.18	189.465	2400624.0
2023-11-29 14:00:00	AAPL	Stock	189.47	189.5	189.05	189.33	2518831.0
2023-11-29 15:00:00	AAPL	Stock	189.33	189.445	188.97	189.35	5131482.0
2023-11-29 16:00:00	AAPL	Stock	189.37	189.56	189.31	189.37	4618545.0
2023-11-29 17:00:00	AAPL	Stock	189.39	189.489	189.39	189.48	15720.0
2023-11-29 18:00:00	AAPL	Stock	189.45	189.55	189.41	189.5	13943.0
2023-11-29 19:00:00	AAPL	Stock	189.45	189.63	189.43	189.61	25750.0
2023-11-29 04:00:00	MSFT	Stock	382.97	384.21	382.97	383.54	6018.0
2023-11-29 05:00:00	MSFT	Stock	384.1	384.6	383.86	384.02	5416.0
2023-11-29 06:00:00	MSFT	Stock	384.15	384.15	383.89	384.03	2184.0
2023-11-29 07:00:00	MSFT	Stock	384.18	385.4	384.18	384.7	26649.0
2023-11-29 08:00:00	MSFT	Stock	384.5	385.5	382.74	384.75	53651.0
2023-11-29 09:00:00	MSFT	Stock	384.66	384.76	381.215	381.6	2858552.0
2023-11-29 10:00:00	MSFT	Stock	381.625	381.95	378.69	379.69	3497026.0
2023-11-29 11:00:00	MSFT	Stock	379.68	379.7025	377.44	378.41	2457851.0
2023-11-29 12:00:00	MSFT	Stock	378.41	379.11	377.75	379.09	1183810.0
2023-11-29 13:00:00	MSFT	Stock	379.12	379.4699	378.55	378.97	1177817.0
2023-11-29 14:00:00	MSFT	Stock	378.96	380.016	378.69	379.88	1427554.0
2023-11-29 15:00:00	MSFT	Stock	379.9	379.95	378.54	378.86	2548541.0
2023-11-29 16:00:00	MSFT	Stock	378.86	379.35	378.65	379.12	2846938.0
2023-11-29 17:00:00	MSFT	Stock	379.06	379.12	379.0	379.01	7065.0
2023-11-29 18:00:00	MSFT	Stock	378.9	379.08	378.81	378.9	5195.0
2023-11-29 19:00:00	MSFT	Stock	378.92	379.51	378.86	379.0	8233.0
2023-11-29 04:00:00	NVDA	Stock	48.03	48.194	48.03	48.18	88550.0
2023-11-29 05:00:00	NVDA	Stock	48.185	48.303	48.17	48.292	117550.0
2023-11-29 06:00:00	NVDA	Stock	48.272	48.385	48.244	48.375	144370.0
2023-11-29 07:00:00	NVDA	Stock	48.346	48.372	48.163	48.222	843060.0
2023-11-29 08:00:00	NVDA	Stock	48.25	48.375	47.9	48.35	3076680.0
2023-11-29 09:00:00	NVDA	Stock	48.35	48.762	48.123	48.63	49714270.0
2023-11-29 10:00:00	NVDA	Stock	48.632	48.673	48.163	48.512	56758290.0
2023-11-29 11:00:00	NVDA	Stock	48.506	48.5193	47.86	48.083	40212420.0
2023-11-29 12:00:00	NVDA	Stock	48.087	48.267	47.966	48.185	23229370.0
2023-11-29 13:00:00	NVDA	Stock	48.1845	48.258	48.026	48.2193	19396790.0
2023-11-29 14:00:00	NVDA	Stock	48.22	48.281	48.04	48.2675	21941980.0
2023-11-29 15:00:00	NVDA	Stock	48.27	48.3	48.066	48.135	31715630.0
2023-11-29 16:00:00	NVDA	Stock	48.12	48.157	48.081	48.11	17790060.0
2023-11-29 17:00:00	NVDA	Stock	48.1	48.124	48.081	48.12	190760.0
2023-11-29 18:00:00	NVDA	Stock	48.12	48.125	48.105	48.125	209720.0
2023-11-29 19:00:00	NVDA	Stock	48.125	48.158	48.116	48.14	168660.0
2023-11-29 04:00:00	AMZN	Stock	146.88	147.63	146.8	147.6	11990.0
2023-11-29 05:00:00	AMZN	Stock	147.59	147.69	147.5	147.64	11002.0

> showing 50 of 59,929 rows — these rows as CSV

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