PREVIEW / stock_1hour / 2023-12-13

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-13.parquet
  size:    1.4 MB
  rows:    61,561
  symbols: 1,305

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-12-13 04:00:00	AAPL	Stock	194.51	194.75	194.51	194.6	4750.0
2023-12-13 05:00:00	AAPL	Stock	194.65	194.65	194.41	194.51	6618.0
2023-12-13 06:00:00	AAPL	Stock	194.51	195.36	194.51	195.36	44710.0
2023-12-13 07:00:00	AAPL	Stock	195.18	195.46	195.0	195.4	37025.0
2023-12-13 08:00:00	AAPL	Stock	195.1	196.19	194.53	195.89	299692.0
2023-12-13 09:00:00	AAPL	Stock	195.83	196.58	194.71	195.91	6658244.0
2023-12-13 10:00:00	AAPL	Stock	195.9	196.7381	195.8	196.322	6392583.0
2023-12-13 11:00:00	AAPL	Stock	196.33	196.46	195.65	195.9501	4156562.0
2023-12-13 12:00:00	AAPL	Stock	195.955	196.11	195.48	196.095	2915450.0
2023-12-13 13:00:00	AAPL	Stock	196.095	196.92	196.05	196.47	4547149.0
2023-12-13 14:00:00	AAPL	Stock	196.48	198.0	196.48	197.91	9842926.0
2023-12-13 15:00:00	AAPL	Stock	197.915	197.98	196.57	197.88	11401493.0
2023-12-13 16:00:00	AAPL	Stock	197.88	197.98	197.51	197.86	10000672.0
2023-12-13 17:00:00	AAPL	Stock	197.85	198.24	197.7	198.1	358223.0
2023-12-13 18:00:00	AAPL	Stock	198.1	198.14	197.76	197.88	141360.0
2023-12-13 19:00:00	AAPL	Stock	197.95	198.78	197.84	198.53	122821.0
2023-12-13 04:00:00	MSFT	Stock	374.7	375.41	374.67	375.2	2363.0
2023-12-13 05:00:00	MSFT	Stock	375.1	375.15	374.9	374.9	2349.0
2023-12-13 06:00:00	MSFT	Stock	375.08	376.64	375.08	376.57	24553.0
2023-12-13 07:00:00	MSFT	Stock	376.29	376.55	375.96	375.96	10031.0
2023-12-13 08:00:00	MSFT	Stock	376.4779	377.65	374.61	377.4448	109908.0
2023-12-13 09:00:00	MSFT	Stock	377.6	377.69	375.55	375.89	2459348.0
2023-12-13 10:00:00	MSFT	Stock	375.87	375.9	374.95	375.16	2244690.0
2023-12-13 11:00:00	MSFT	Stock	375.18	375.34	373.16	374.05	1774042.0
2023-12-13 12:00:00	MSFT	Stock	374.07	374.7218	373.84	374.06	999473.0
2023-12-13 13:00:00	MSFT	Stock	374.0195	374.0195	373.206	373.206	876531.0
2023-12-13 14:00:00	MSFT	Stock	373.2	375.68	373.1863	374.44	2478692.0
2023-12-13 15:00:00	MSFT	Stock	374.46	374.64	370.77	374.245	4640808.0
2023-12-13 16:00:00	MSFT	Stock	374.31	374.5	373.2	373.75	5241015.0
2023-12-13 17:00:00	MSFT	Stock	374.07	374.37	373.45	374.15	143246.0
2023-12-13 18:00:00	MSFT	Stock	374.24	374.54	374.22	374.4	34999.0
2023-12-13 19:00:00	MSFT	Stock	374.4	375.56	374.4	375.5399	38692.0
2023-12-13 04:00:00	NVDA	Stock	47.68	47.68	47.615	47.645	17370.0
2023-12-13 05:00:00	NVDA	Stock	47.615	47.615	47.375	47.5	64050.0
2023-12-13 06:00:00	NVDA	Stock	47.44	47.55	47.44	47.51	79550.0
2023-12-13 07:00:00	NVDA	Stock	47.512	47.603	47.511	47.53	285990.0
2023-12-13 08:00:00	NVDA	Stock	47.53	47.689	47.425	47.521	1385230.0
2023-12-13 09:00:00	NVDA	Stock	47.522	48.382	47.444	48.3515	60506460.0
2023-12-13 10:00:00	NVDA	Stock	48.352	48.594	48.131	48.185	60665220.0
2023-12-13 11:00:00	NVDA	Stock	48.177	48.357	48.107	48.1342	37235670.0
2023-12-13 12:00:00	NVDA	Stock	48.138	48.168	47.801	47.8897	28548530.0
2023-12-13 13:00:00	NVDA	Stock	47.889	48.057	47.805	48.0011	19491440.0
2023-12-13 14:00:00	NVDA	Stock	48.004	48.532	48.004	48.36	62010820.0
2023-12-13 15:00:00	NVDA	Stock	48.368	48.487	47.78	48.09	48748200.0
2023-12-13 16:00:00	NVDA	Stock	48.088	48.18	47.981	48.0101	22542630.0
2023-12-13 17:00:00	NVDA	Stock	48.01	48.177	48.01	48.174	363460.0
2023-12-13 18:00:00	NVDA	Stock	48.177	48.31	48.088	48.297	474030.0
2023-12-13 19:00:00	NVDA	Stock	48.3	48.463	48.29	48.402	1053640.0
2023-12-13 04:00:00	AMZN	Stock	147.72	147.85	147.72	147.8	3467.0
2023-12-13 05:00:00	AMZN	Stock	147.74	147.74	147.41	147.49	3749.0

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

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