PREVIEW / stock_1hour / 2022-11-30

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-30.parquet
  size:    1.4 MB
  rows:    62,594
  symbols: 2,107

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
2022-11-30 04:00:00	AAPL	Stock	143.5	143.82	141.5	142.31	51187.0
2022-11-30 05:00:00	AAPL	Stock	142.34	142.38	142.2	142.28	13831.0
2022-11-30 06:00:00	AAPL	Stock	142.17	142.2	141.96	142.1	12110.0
2022-11-30 07:00:00	AAPL	Stock	142.07	142.14	141.86	141.9	77390.0
2022-11-30 08:00:00	AAPL	Stock	142.0106	142.14	140.818	141.36	433049.0
2022-11-30 09:00:00	AAPL	Stock	141.33	142.37	140.55	141.9607	7932983.0
2022-11-30 10:00:00	AAPL	Stock	141.96	142.17	140.99	141.18	7289577.0
2022-11-30 11:00:00	AAPL	Stock	141.19	142.015	141.07	141.56	5340604.0
2022-11-30 12:00:00	AAPL	Stock	141.565	141.61	140.68	141.2509	5209877.0
2022-11-30 13:00:00	AAPL	Stock	141.25	144.46	141.13	144.19	10076390.0
2022-11-30 14:00:00	AAPL	Stock	144.18	146.53	144.15	146.09	14269472.0
2022-11-30 15:00:00	AAPL	Stock	146.1	148.03	145.99	148.01	18342628.0
2022-11-30 16:00:00	AAPL	Stock	148.01	148.72	147.71	148.15	26318173.0
2022-11-30 17:00:00	AAPL	Stock	148.1501	148.2	148.0	148.05	90939.0
2022-11-30 18:00:00	AAPL	Stock	148.17	148.29	148.0	148.2	69809.0
2022-11-30 19:00:00	AAPL	Stock	148.16	148.25	147.91	148.18	62107.0
2022-11-30 04:00:00	MSFT	Stock	241.3	241.81	240.48	240.48	1512.0
2022-11-30 05:00:00	MSFT	Stock	241.0	241.3	241.0	241.3	300.0
2022-11-30 06:00:00	MSFT	Stock	241.28	241.55	241.28	241.55	200.0
2022-11-30 07:00:00	MSFT	Stock	241.44	241.44	241.13	241.36	6054.0
2022-11-30 08:00:00	MSFT	Stock	241.3	243.42	238.1	240.8	26212.0
2022-11-30 09:00:00	MSFT	Stock	240.72	243.94	239.86	243.47	1910961.0
2022-11-30 10:00:00	MSFT	Stock	243.47	243.82	240.945	241.05	1847036.0
2022-11-30 11:00:00	MSFT	Stock	241.06	242.25	240.56	242.06	1501252.0
2022-11-30 12:00:00	MSFT	Stock	242.08	242.4801	241.27	241.87	1057281.0
2022-11-30 13:00:00	MSFT	Stock	241.86	246.94	241.42	246.55	3052431.0
2022-11-30 14:00:00	MSFT	Stock	246.55	250.71	246.5	250.52	4141091.0
2022-11-30 15:00:00	MSFT	Stock	250.535	255.33	250.1705	255.16	8515942.0
2022-11-30 16:00:00	MSFT	Stock	255.14	255.65	254.0	255.02	14363104.0
2022-11-30 17:00:00	MSFT	Stock	255.1	255.3998	254.9	255.0	15153.0
2022-11-30 18:00:00	MSFT	Stock	255.0	255.23	255.0	255.18	18901.0
2022-11-30 19:00:00	MSFT	Stock	255.29	255.48	254.9	255.0	7532.0
2022-11-30 04:00:00	NVDA	Stock	15.686	15.747	15.686	15.721	37730.0
2022-11-30 05:00:00	NVDA	Stock	15.724	15.726	15.714	15.721	6100.0
2022-11-30 06:00:00	NVDA	Stock	15.72	15.726	15.72	15.726	3000.0
2022-11-30 07:00:00	NVDA	Stock	15.722	15.722	15.69	15.69	44360.0
2022-11-30 08:00:00	NVDA	Stock	15.7016	15.727	15.5503	15.564	825050.0
2022-11-30 09:00:00	NVDA	Stock	15.551	15.979	15.551	15.687	41891830.0
2022-11-30 10:00:00	NVDA	Stock	15.694	15.834	15.597	15.754	45704250.0
2022-11-30 11:00:00	NVDA	Stock	15.757	15.9246	15.744	15.8738	35598100.0
2022-11-30 12:00:00	NVDA	Stock	15.8753	15.905	15.6653	15.758	28640640.0
2022-11-30 13:00:00	NVDA	Stock	15.758	16.2	15.73	16.172	54779990.0
2022-11-30 14:00:00	NVDA	Stock	16.1755	16.554	16.168	16.456	86035550.0
2022-11-30 15:00:00	NVDA	Stock	16.454	16.93	16.428	16.928	108106310.0
2022-11-30 16:00:00	NVDA	Stock	16.928	17.02	16.9	17.002	71168210.0
2022-11-30 17:00:00	NVDA	Stock	17.023	17.047	16.923	17.0301	730640.0
2022-11-30 18:00:00	NVDA	Stock	17.045	17.06	17.01	17.029	374750.0
2022-11-30 19:00:00	NVDA	Stock	17.02	17.055	17.02	17.055	266040.0
2022-11-30 04:00:00	AMZN	Stock	92.72	92.93	92.61	92.69	16679.0
2022-11-30 05:00:00	AMZN	Stock	92.69	92.78	92.66	92.75	5104.0

> showing 50 of 62,594 rows — these rows as CSV

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