PREVIEW / stock_1hour / 2023-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-20.parquet
  size:    1.3 MB
  rows:    59,219
  symbols: 1,281

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-20 04:00:00	AAPL	Stock	189.52	189.6	188.92	189.57	21037.0
2023-11-20 05:00:00	AAPL	Stock	189.55	189.68	189.5	189.67	13923.0
2023-11-20 06:00:00	AAPL	Stock	189.67	189.88	189.58	189.59	8571.0
2023-11-20 07:00:00	AAPL	Stock	189.67	189.68	189.4	189.5	16911.0
2023-11-20 08:00:00	AAPL	Stock	189.68	190.25	189.13	190.15	159296.0
2023-11-20 09:00:00	AAPL	Stock	190.13	191.669	189.55	191.22	5969770.0
2023-11-20 10:00:00	AAPL	Stock	191.22	191.3687	190.43	191.1121	5311502.0
2023-11-20 11:00:00	AAPL	Stock	191.12	191.37	191.0101	191.3199	3406922.0
2023-11-20 12:00:00	AAPL	Stock	191.32	191.55	191.08	191.15	2773916.0
2023-11-20 13:00:00	AAPL	Stock	191.16	191.8	191.13	191.6825	3779373.0
2023-11-20 14:00:00	AAPL	Stock	191.685	191.77	191.33	191.59	2887698.0
2023-11-20 15:00:00	AAPL	Stock	191.59	191.905	191.16	191.5	6220937.0
2023-11-20 16:00:00	AAPL	Stock	191.5	191.52	191.41	191.5	8268384.0
2023-11-20 17:00:00	AAPL	Stock	191.45	191.54	191.45	191.5	27320.0
2023-11-20 18:00:00	AAPL	Stock	191.53	191.62	191.47	191.51	18471.0
2023-11-20 19:00:00	AAPL	Stock	191.54	191.65	191.46	191.65	11011.0
2023-11-20 04:00:00	MSFT	Stock	374.07	379.97	369.2	379.3	276519.0
2023-11-20 05:00:00	MSFT	Stock	379.4	379.4	375.78	375.97	100718.0
2023-11-20 06:00:00	MSFT	Stock	375.61	377.99	373.88	377.3	151787.0
2023-11-20 07:00:00	MSFT	Stock	377.3	377.39	373.41	373.75	408048.0
2023-11-20 08:00:00	MSFT	Stock	377.27	379.3822	359.86	371.8	1078996.0
2023-11-20 09:00:00	MSFT	Stock	372.0	377.1	367.17	375.515	8089969.0
2023-11-20 10:00:00	MSFT	Stock	375.525	375.65	371.8	374.445	4419367.0
2023-11-20 11:00:00	MSFT	Stock	374.5	376.69	374.09	375.9068	3356478.0
2023-11-20 12:00:00	MSFT	Stock	375.92	377.53	375.58	376.76	2965456.0
2023-11-20 13:00:00	MSFT	Stock	376.79	378.81	376.55	377.73	2949341.0
2023-11-20 14:00:00	MSFT	Stock	377.74	378.87	376.8773	378.4237	2488247.0
2023-11-20 15:00:00	MSFT	Stock	378.42	378.83	377.2	377.61	3914998.0
2023-11-20 16:00:00	MSFT	Stock	377.64	377.71	376.8	377.43	3977448.0
2023-11-20 17:00:00	MSFT	Stock	377.44	378.38	377.44	378.25	52314.0
2023-11-20 18:00:00	MSFT	Stock	378.4	378.7	378.0811	378.5001	33510.0
2023-11-20 19:00:00	MSFT	Stock	378.6	378.63	378.0001	378.48	21725.0
2023-11-20 04:00:00	NVDA	Stock	49.497	49.68	49.462	49.64	169940.0
2023-11-20 05:00:00	NVDA	Stock	49.64	49.64	49.505	49.56	51000.0
2023-11-20 06:00:00	NVDA	Stock	49.531	49.63	49.5	49.615	126930.0
2023-11-20 07:00:00	NVDA	Stock	49.573	49.67	49.541	49.66	1253760.0
2023-11-20 08:00:00	NVDA	Stock	49.64	49.715	49.114	49.58	2365520.0
2023-11-20 09:00:00	NVDA	Stock	49.5834	49.649	49.181	49.568	46218450.0
2023-11-20 10:00:00	NVDA	Stock	49.57	49.96	49.5161	49.7524	59746330.0
2023-11-20 11:00:00	NVDA	Stock	49.759	49.875	49.612	49.8205	30831980.0
2023-11-20 12:00:00	NVDA	Stock	49.815	49.8873	49.721	49.729	21463640.0
2023-11-20 13:00:00	NVDA	Stock	49.733	50.113	49.72	50.07	37104230.0
2023-11-20 14:00:00	NVDA	Stock	50.07	50.495	50.068	50.471	42794270.0
2023-11-20 15:00:00	NVDA	Stock	50.471	50.548	50.327	50.409	41845480.0
2023-11-20 16:00:00	NVDA	Stock	50.409	50.6	50.3819	50.488	24322380.0
2023-11-20 17:00:00	NVDA	Stock	50.5	50.54	50.409	50.47	759180.0
2023-11-20 18:00:00	NVDA	Stock	50.461	50.572	50.387	50.502	939630.0
2023-11-20 19:00:00	NVDA	Stock	50.502	50.575	50.501	50.559	825200.0
2023-11-20 04:00:00	AMZN	Stock	144.81	145.39	144.78	145.22	26288.0
2023-11-20 05:00:00	AMZN	Stock	145.22	145.26	144.88	144.97	16175.0

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

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