PREVIEW / stock_1hour / 2023-11-21

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-21.parquet
  size:    1.3 MB
  rows:    58,311
  symbols: 1,306

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-21 04:00:00	AAPL	Stock	191.41	191.41	191.1	191.12	4650.0
2023-11-21 05:00:00	AAPL	Stock	191.2	191.2	191.18	191.18	354.0
2023-11-21 06:00:00	AAPL	Stock	191.2	191.25	190.92	191.13	11453.0
2023-11-21 07:00:00	AAPL	Stock	191.15	191.44	191.05	191.15	21748.0
2023-11-21 08:00:00	AAPL	Stock	191.15	191.54	190.59	190.6	145102.0
2023-11-21 09:00:00	AAPL	Stock	190.58	191.52	190.495	190.82	4548408.0
2023-11-21 10:00:00	AAPL	Stock	190.835	191.08	190.07	190.2475	5295523.0
2023-11-21 11:00:00	AAPL	Stock	190.25	190.31	189.74	190.2219	3495585.0
2023-11-21 12:00:00	AAPL	Stock	190.235	190.595	190.09	190.53	2520952.0
2023-11-21 13:00:00	AAPL	Stock	190.529	190.6	190.04	190.42	2533903.0
2023-11-21 14:00:00	AAPL	Stock	190.41	190.615	190.19	190.5175	2394468.0
2023-11-21 15:00:00	AAPL	Stock	190.51	190.73	190.29	190.65	5371562.0
2023-11-21 16:00:00	AAPL	Stock	190.64	190.77	190.25	190.56	4295081.0
2023-11-21 17:00:00	AAPL	Stock	190.57	190.75	190.47	190.66	21827.0
2023-11-21 18:00:00	AAPL	Stock	190.62	190.62	190.37	190.51	24132.0
2023-11-21 19:00:00	AAPL	Stock	190.55	190.59	190.3	190.3	25895.0
2023-11-21 04:00:00	MSFT	Stock	378.83	379.0	378.24	378.83	7014.0
2023-11-21 05:00:00	MSFT	Stock	378.8	379.6	378.8	378.99	3173.0
2023-11-21 06:00:00	MSFT	Stock	379.0	379.0	376.93	377.0	14361.0
2023-11-21 07:00:00	MSFT	Stock	377.48	377.85	375.48	375.55	55963.0
2023-11-21 08:00:00	MSFT	Stock	375.5	379.6	374.11	374.57	138011.0
2023-11-21 09:00:00	MSFT	Stock	374.44	376.88	373.55	375.015	2763434.0
2023-11-21 10:00:00	MSFT	Stock	375.01	375.25	371.12	372.2453	3393401.0
2023-11-21 11:00:00	MSFT	Stock	372.245	372.53	371.22	372.4401	1682381.0
2023-11-21 12:00:00	MSFT	Stock	372.47	373.53	371.64	372.58	2173744.0
2023-11-21 13:00:00	MSFT	Stock	372.58	372.58	371.14	372.1349	1827628.0
2023-11-21 14:00:00	MSFT	Stock	372.14	373.0	371.72	372.56	1232748.0
2023-11-21 15:00:00	MSFT	Stock	372.56	373.25	372.2382	373.08	2297826.0
2023-11-21 16:00:00	MSFT	Stock	373.09	374.65	370.3159	373.27	2476741.0
2023-11-21 17:00:00	MSFT	Stock	373.4	374.9	371.3426	372.57	106099.0
2023-11-21 18:00:00	MSFT	Stock	372.34	372.5	370.8	371.5	50973.0
2023-11-21 19:00:00	MSFT	Stock	371.6	373.49	371.6	373.49	26977.0
2023-11-21 04:00:00	NVDA	Stock	50.48	50.602	50.44	50.5	144550.0
2023-11-21 05:00:00	NVDA	Stock	50.499	50.59	50.486	50.535	121640.0
2023-11-21 06:00:00	NVDA	Stock	50.542	50.548	50.38	50.406	192540.0
2023-11-21 07:00:00	NVDA	Stock	50.42	50.478	50.237	50.3	874120.0
2023-11-21 08:00:00	NVDA	Stock	50.47	50.518	50.011	50.021	2940430.0
2023-11-21 09:00:00	NVDA	Stock	50.034	50.517	49.877	50.0	57487420.0
2023-11-21 10:00:00	NVDA	Stock	49.989	50.081	49.222	49.765	81113470.0
2023-11-21 11:00:00	NVDA	Stock	49.781	49.836	49.482	49.6239	39534360.0
2023-11-21 12:00:00	NVDA	Stock	49.6292	49.797	49.482	49.6855	33298190.0
2023-11-21 13:00:00	NVDA	Stock	49.691	49.9588	49.59	49.944	29113050.0
2023-11-21 14:00:00	NVDA	Stock	49.946	50.12	49.862	50.021	39944380.0
2023-11-21 15:00:00	NVDA	Stock	50.021	50.099	49.818	49.9895	53053480.0
2023-11-21 16:00:00	NVDA	Stock	49.944	50.917	46.8	49.46	51991780.0
2023-11-21 17:00:00	NVDA	Stock	49.45	49.944	49.1	49.355	18146150.0
2023-11-21 18:00:00	NVDA	Stock	49.357	49.454	49.1	49.1894	6668820.0
2023-11-21 19:00:00	NVDA	Stock	49.199	49.234	49.0	49.075	4483880.0
2023-11-21 04:00:00	AMZN	Stock	146.21	146.21	145.9	145.92	5438.0
2023-11-21 05:00:00	AMZN	Stock	145.91	146.16	145.9	146.13	3990.0

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

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