PREVIEW / stock_1hour / 2023-11-28

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-28.parquet
  size:    1.3 MB
  rows:    58,421
  symbols: 1,297

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-28 04:00:00	AAPL	Stock	189.9	189.92	189.75	189.92	7821.0
2023-11-28 05:00:00	AAPL	Stock	189.87	189.98	189.86	189.98	6208.0
2023-11-28 06:00:00	AAPL	Stock	190.0	190.13	189.89	189.89	7772.0
2023-11-28 07:00:00	AAPL	Stock	190.01	190.07	189.63	189.63	19411.0
2023-11-28 08:00:00	AAPL	Stock	190.05	190.1	189.41	190.08	80915.0
2023-11-28 09:00:00	AAPL	Stock	190.06	190.27	189.4	189.72	3446052.0
2023-11-28 10:00:00	AAPL	Stock	189.715	190.61	189.715	190.145	4934509.0
2023-11-28 11:00:00	AAPL	Stock	190.145	191.08	190.08	190.71	3774165.0
2023-11-28 12:00:00	AAPL	Stock	190.715	190.81	190.225	190.3	2395450.0
2023-11-28 13:00:00	AAPL	Stock	190.3	190.3	189.76	189.91	3296507.0
2023-11-28 14:00:00	AAPL	Stock	189.915	190.11	189.66	190.035	2534296.0
2023-11-28 15:00:00	AAPL	Stock	190.05	190.4	189.585	190.39	5676422.0
2023-11-28 16:00:00	AAPL	Stock	190.39	190.45	189.0	189.35	5586239.0
2023-11-28 17:00:00	AAPL	Stock	189.39	190.4	189.23	189.5	75260.0
2023-11-28 18:00:00	AAPL	Stock	189.46	189.8012	189.45	189.77	29272.0
2023-11-28 19:00:00	AAPL	Stock	189.77	189.95	189.55	189.94	13752.0
2023-11-28 04:00:00	MSFT	Stock	378.51	378.52	378.32	378.52	2402.0
2023-11-28 05:00:00	MSFT	Stock	378.61	379.1	378.61	379.1	558.0
2023-11-28 06:00:00	MSFT	Stock	378.55	378.55	378.32	378.32	2297.0
2023-11-28 07:00:00	MSFT	Stock	378.42	378.7	377.8	377.9	16031.0
2023-11-28 08:00:00	MSFT	Stock	378.5	379.25	377.0	377.9489	43929.0
2023-11-28 09:00:00	MSFT	Stock	377.95	381.97	377.22	380.32	2666340.0
2023-11-28 10:00:00	MSFT	Stock	380.3299	382.77	379.96	381.755	2429514.0
2023-11-28 11:00:00	MSFT	Stock	381.79	383.0	381.295	382.31	1329294.0
2023-11-28 12:00:00	MSFT	Stock	382.32	382.76	381.35	381.9484	1021873.0
2023-11-28 13:00:00	MSFT	Stock	381.95	382.19	380.72	381.13	1084868.0
2023-11-28 14:00:00	MSFT	Stock	381.18	381.61	380.51	381.4201	1151216.0
2023-11-28 15:00:00	MSFT	Stock	381.46	382.76	380.735	382.7	2260482.0
2023-11-28 16:00:00	MSFT	Stock	382.69	383.09	382.25	382.54	2816644.0
2023-11-28 17:00:00	MSFT	Stock	382.56	382.59	382.1834	382.44	18951.0
2023-11-28 18:00:00	MSFT	Stock	382.3	382.678	382.25	382.47	8694.0
2023-11-28 19:00:00	MSFT	Stock	382.4	382.9	382.33	382.6	10931.0
2023-11-28 04:00:00	NVDA	Stock	48.125	48.184	48.096	48.158	36280.0
2023-11-28 05:00:00	NVDA	Stock	48.188	48.252	48.188	48.236	22550.0
2023-11-28 06:00:00	NVDA	Stock	48.242	48.282	48.235	48.242	26810.0
2023-11-28 07:00:00	NVDA	Stock	48.235	48.415	48.225	48.228	456570.0
2023-11-28 08:00:00	NVDA	Stock	48.275	48.425	48.1	48.344	1124190.0
2023-11-28 09:00:00	NVDA	Stock	48.34	48.366	47.657	47.764	43473800.0
2023-11-28 10:00:00	NVDA	Stock	47.771	47.876	47.473	47.694	64510960.0
2023-11-28 11:00:00	NVDA	Stock	47.6885	48.156	47.609	48.0554	48112650.0
2023-11-28 12:00:00	NVDA	Stock	48.055	48.178	47.819	47.8925	33188540.0
2023-11-28 13:00:00	NVDA	Stock	47.899	47.904	47.606	47.719	30618470.0
2023-11-28 14:00:00	NVDA	Stock	47.711	47.734	47.535	47.7036	32998810.0
2023-11-28 15:00:00	NVDA	Stock	47.707	47.829	47.522	47.827	36977240.0
2023-11-28 16:00:00	NVDA	Stock	47.815	47.831	47.75	47.774	16119650.0
2023-11-28 17:00:00	NVDA	Stock	47.7603	47.783	47.76	47.762	149740.0
2023-11-28 18:00:00	NVDA	Stock	47.76	47.77	47.713	47.76	232600.0
2023-11-28 19:00:00	NVDA	Stock	47.765	47.785	47.746	47.78	202500.0
2023-11-28 04:00:00	AMZN	Stock	146.64	147.74	146.64	147.62	5919.0
2023-11-28 05:00:00	AMZN	Stock	147.73	147.91	147.73	147.91	1406.0

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

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