PREVIEW / stock_1hour / 2023-09-01

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-01.parquet
  size:    1.3 MB
  rows:    58,311
  symbols: 1,444

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-09-01 04:00:00	AAPL	Stock	188.32	188.32	188.15	188.23	7584.0
2023-09-01 05:00:00	AAPL	Stock	188.28	188.5	188.28	188.36	14754.0
2023-09-01 06:00:00	AAPL	Stock	188.37	188.63	188.35	188.46	10978.0
2023-09-01 07:00:00	AAPL	Stock	188.49	188.7	188.45	188.46	36624.0
2023-09-01 08:00:00	AAPL	Stock	188.65	189.39	188.03	189.18	353317.0
2023-09-01 09:00:00	AAPL	Stock	189.18	189.92	188.28	188.94	5717801.0
2023-09-01 10:00:00	AAPL	Stock	188.92	189.49	188.311	188.4	6480956.0
2023-09-01 11:00:00	AAPL	Stock	188.4	188.895	188.35	188.525	3610692.0
2023-09-01 12:00:00	AAPL	Stock	188.51	189.27	188.4801	189.175	3431725.0
2023-09-01 13:00:00	AAPL	Stock	189.17	189.32	188.85	189.17	2442724.0
2023-09-01 14:00:00	AAPL	Stock	189.175	189.2	188.52	188.8899	2929915.0
2023-09-01 15:00:00	AAPL	Stock	188.88	189.54	188.75	189.47	5765840.0
2023-09-01 16:00:00	AAPL	Stock	189.47	189.47	189.01	189.24	6427171.0
2023-09-01 17:00:00	AAPL	Stock	189.23	189.24	189.14	189.22	34456.0
2023-09-01 18:00:00	AAPL	Stock	189.218	189.34	189.19	189.25	11587.0
2023-09-01 19:00:00	AAPL	Stock	189.25	189.3	189.2	189.2999	14008.0
2023-09-01 04:00:00	MSFT	Stock	328.43	328.67	328.41	328.49	1932.0
2023-09-01 05:00:00	MSFT	Stock	328.6	328.6	328.44	328.55	1034.0
2023-09-01 06:00:00	MSFT	Stock	328.55	328.75	328.55	328.75	577.0
2023-09-01 07:00:00	MSFT	Stock	328.91	328.95	328.49	328.78	3265.0
2023-09-01 08:00:00	MSFT	Stock	328.76	332.0	328.13	331.0	105845.0
2023-09-01 09:00:00	MSFT	Stock	330.98	332.0	327.45	329.0038	1691773.0
2023-09-01 10:00:00	MSFT	Stock	328.97	330.1	327.8	328.065	1692179.0
2023-09-01 11:00:00	MSFT	Stock	328.05	329.0	327.57	327.63	918130.0
2023-09-01 12:00:00	MSFT	Stock	327.62	328.33	327.48	328.07	784605.0
2023-09-01 13:00:00	MSFT	Stock	328.065	328.31	326.78	327.563	774483.0
2023-09-01 14:00:00	MSFT	Stock	327.59	327.9094	326.92	327.83	595165.0
2023-09-01 15:00:00	MSFT	Stock	327.8201	328.74	327.59	328.66	1291815.0
2023-09-01 16:00:00	MSFT	Stock	328.66	328.66	328.1	328.4	2590010.0
2023-09-01 17:00:00	MSFT	Stock	328.41	328.41	328.0	328.0	2221.0
2023-09-01 18:00:00	MSFT	Stock	327.9996	328.2868	327.8	328.0164	5161.0
2023-09-01 19:00:00	MSFT	Stock	328.19	328.2	328.0	328.09	2782.0
2023-09-01 04:00:00	NVDA	Stock	49.3	49.302	49.2	49.278	61020.0
2023-09-01 05:00:00	NVDA	Stock	49.3	49.302	49.25	49.25	9190.0
2023-09-01 06:00:00	NVDA	Stock	49.24	49.29	49.235	49.235	15160.0
2023-09-01 07:00:00	NVDA	Stock	49.243	49.534	49.243	49.456	726000.0
2023-09-01 08:00:00	NVDA	Stock	49.266	49.78	49.159	49.743	4616400.0
2023-09-01 09:00:00	NVDA	Stock	49.748	49.885	48.463	48.9085	71669810.0
2023-09-01 10:00:00	NVDA	Stock	48.9225	49.025	48.31	48.341	75300420.0
2023-09-01 11:00:00	NVDA	Stock	48.3435	48.61	48.1416	48.287	55018420.0
2023-09-01 12:00:00	NVDA	Stock	48.274	48.799	48.239	48.744	36655210.0
2023-09-01 13:00:00	NVDA	Stock	48.742	48.796	48.5021	48.657	30490310.0
2023-09-01 14:00:00	NVDA	Stock	48.657	48.718	48.35	48.618	31868760.0
2023-09-01 15:00:00	NVDA	Stock	48.6175	48.67	48.425	48.507	42176860.0
2023-09-01 16:00:00	NVDA	Stock	48.509	48.515	48.475	48.496	13213790.0
2023-09-01 17:00:00	NVDA	Stock	48.498	48.507	48.456	48.4773	401460.0
2023-09-01 18:00:00	NVDA	Stock	48.4937	48.52	48.475	48.495	184560.0
2023-09-01 19:00:00	NVDA	Stock	48.486	48.5	48.46	48.477	216690.0
2023-09-01 04:00:00	AMZN	Stock	138.47	138.47	138.26	138.35	10115.0
2023-09-01 05:00:00	AMZN	Stock	138.35	138.55	138.32	138.42	9089.0

> showing 50 of 58,311 rows — these rows as CSV

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