PREVIEW / stock_1hour / 2024-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-01-12.parquet
  size:    1.3 MB
  rows:    58,375
  symbols: 1,171

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
2024-01-12 04:00:00	AAPL	Stock	185.27	185.8	185.27	185.55	15302.0
2024-01-12 05:00:00	AAPL	Stock	185.51	185.61	185.11	185.26	5197.0
2024-01-12 06:00:00	AAPL	Stock	185.25	185.26	184.5	184.75	17762.0
2024-01-12 07:00:00	AAPL	Stock	184.75	185.3	184.65	185.15	41975.0
2024-01-12 08:00:00	AAPL	Stock	184.82	185.73	184.75	185.49	116600.0
2024-01-12 09:00:00	AAPL	Stock	185.45	186.74	185.4	185.75	4202943.0
2024-01-12 10:00:00	AAPL	Stock	185.77	186.305	185.19	185.695	4519745.0
2024-01-12 11:00:00	AAPL	Stock	185.705	186.06	185.39	185.5724	3613347.0
2024-01-12 12:00:00	AAPL	Stock	185.57	185.85	185.43	185.6228	2244647.0
2024-01-12 13:00:00	AAPL	Stock	185.63	185.94	185.5802	185.89	1944518.0
2024-01-12 14:00:00	AAPL	Stock	185.895	186.0669	185.26	185.315	3131016.0
2024-01-12 15:00:00	AAPL	Stock	185.31	185.98	185.22	185.92	5481504.0
2024-01-12 16:00:00	AAPL	Stock	185.91	185.99	185.7369	185.85	7299871.0
2024-01-12 17:00:00	AAPL	Stock	185.82	185.92	185.64	185.8	207402.0
2024-01-12 18:00:00	AAPL	Stock	185.8	185.8	185.66	185.66	5633.0
2024-01-12 19:00:00	AAPL	Stock	185.7	185.7	185.59	185.63	22216.0
2024-01-12 04:00:00	MSFT	Stock	383.23	384.67	383.23	383.63	2662.0
2024-01-12 05:00:00	MSFT	Stock	383.3	383.9	383.3	383.74	2099.0
2024-01-12 06:00:00	MSFT	Stock	383.94	383.94	382.52	382.9	2773.0
2024-01-12 07:00:00	MSFT	Stock	383.2	383.8	383.2	383.63	10302.0
2024-01-12 08:00:00	MSFT	Stock	383.1	385.5	383.01	385.35	67246.0
2024-01-12 09:00:00	MSFT	Stock	385.33	387.1847	384.63	385.3	2059773.0
2024-01-12 10:00:00	MSFT	Stock	385.305	387.01	384.65	387.0083	2142247.0
2024-01-12 11:00:00	MSFT	Stock	387.0	388.48	386.31	386.42	1928105.0
2024-01-12 12:00:00	MSFT	Stock	386.45	387.48	386.1353	387.264	977774.0
2024-01-12 13:00:00	MSFT	Stock	387.28	388.4	387.28	388.3	1137421.0
2024-01-12 14:00:00	MSFT	Stock	388.3	388.68	387.6	387.92	1159603.0
2024-01-12 15:00:00	MSFT	Stock	387.92	388.68	387.22	388.41	2113572.0
2024-01-12 16:00:00	MSFT	Stock	388.41	388.87	388.1971	388.34	3898716.0
2024-01-12 17:00:00	MSFT	Stock	388.33	388.34	388.11	388.18	12750.0
2024-01-12 18:00:00	MSFT	Stock	388.1491	388.22	388.08	388.22	4017.0
2024-01-12 19:00:00	MSFT	Stock	388.17	388.4	388.1	388.1	5692.0
2024-01-12 04:00:00	NVDA	Stock	54.731	54.731	54.5	54.502	167640.0
2024-01-12 05:00:00	NVDA	Stock	54.515	54.6	54.452	54.502	129100.0
2024-01-12 06:00:00	NVDA	Stock	54.53	54.543	54.226	54.325	77020.0
2024-01-12 07:00:00	NVDA	Stock	54.389	54.499	54.355	54.4	353280.0
2024-01-12 08:00:00	NVDA	Stock	54.42	54.739	54.256	54.647	3064670.0
2024-01-12 09:00:00	NVDA	Stock	54.65	54.97	54.355	54.719	49496290.0
2024-01-12 10:00:00	NVDA	Stock	54.727	54.8955	54.3301	54.4675	63586030.0
2024-01-12 11:00:00	NVDA	Stock	54.465	54.819	54.422	54.5525	40353050.0
2024-01-12 12:00:00	NVDA	Stock	54.553	54.7	54.514	54.6273	23518980.0
2024-01-12 13:00:00	NVDA	Stock	54.622	54.823	54.581	54.783	21705330.0
2024-01-12 14:00:00	NVDA	Stock	54.7795	54.9143	54.605	54.6906	30087190.0
2024-01-12 15:00:00	NVDA	Stock	54.693	54.748	54.54	54.708	30479010.0
2024-01-12 16:00:00	NVDA	Stock	54.7095	54.76	54.686	54.71	18092490.0
2024-01-12 17:00:00	NVDA	Stock	54.716	54.72	54.675	54.71	252350.0
2024-01-12 18:00:00	NVDA	Stock	54.71	54.725	54.68	54.68	131090.0
2024-01-12 19:00:00	NVDA	Stock	54.682	54.725	54.662	54.7122	259290.0
2024-01-12 04:00:00	AMZN	Stock	154.52	155.09	154.09	154.41	7349.0
2024-01-12 05:00:00	AMZN	Stock	154.45	154.69	154.45	154.53	5184.0

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

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