PREVIEW / stock_1hour / 2023-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-06.parquet
  size:    1.3 MB
  rows:    58,233
  symbols: 1,428

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-09-06 04:00:00	AAPL	Stock	188.8	188.8	188.02	188.2	42483.0
2023-09-06 05:00:00	AAPL	Stock	188.16	188.46	188.13	188.44	18953.0
2023-09-06 06:00:00	AAPL	Stock	188.4	188.48	188.21	188.38	24834.0
2023-09-06 07:00:00	AAPL	Stock	188.48	188.82	188.38	188.5	78378.0
2023-09-06 08:00:00	AAPL	Stock	188.46	189.5	188.15	188.4	240045.0
2023-09-06 09:00:00	AAPL	Stock	188.37	188.85	186.5	186.54	7975248.0
2023-09-06 10:00:00	AAPL	Stock	186.53	186.53	183.93	184.0188	14143775.0
2023-09-06 11:00:00	AAPL	Stock	184.02	184.31	183.53	184.15	6575283.0
2023-09-06 12:00:00	AAPL	Stock	184.145	184.32	182.8	183.115	6005912.0
2023-09-06 13:00:00	AAPL	Stock	183.115	183.42	182.67	182.9699	5294656.0
2023-09-06 14:00:00	AAPL	Stock	182.9656	183.01	182.13	182.2	6465389.0
2023-09-06 15:00:00	AAPL	Stock	182.19	183.02	181.47	182.9	14839339.0
2023-09-06 16:00:00	AAPL	Stock	182.88	183.0	182.73	182.75	7590161.0
2023-09-06 17:00:00	AAPL	Stock	182.7501	182.83	182.32	182.65	142223.0
2023-09-06 18:00:00	AAPL	Stock	182.7	182.84	182.65	182.6601	39349.0
2023-09-06 19:00:00	AAPL	Stock	182.68	182.8	182.56	182.56	50390.0
2023-09-06 04:00:00	MSFT	Stock	332.6	332.71	332.24	332.47	1941.0
2023-09-06 05:00:00	MSFT	Stock	332.68	332.68	332.5	332.5	400.0
2023-09-06 06:00:00	MSFT	Stock	332.55	332.73	332.39	332.39	1175.0
2023-09-06 07:00:00	MSFT	Stock	332.45	332.47	331.88	331.95	8127.0
2023-09-06 08:00:00	MSFT	Stock	332.2	334.5	331.7289	332.6182	17900.0
2023-09-06 09:00:00	MSFT	Stock	332.4296	334.46	331.9	333.74	1530005.0
2023-09-06 10:00:00	MSFT	Stock	333.68	333.7	331.251	331.35	1949791.0
2023-09-06 11:00:00	MSFT	Stock	331.375	332.41	331.02	331.86	1063801.0
2023-09-06 12:00:00	MSFT	Stock	331.85	332.15	330.18	330.76	1007322.0
2023-09-06 13:00:00	MSFT	Stock	330.75	331.69	330.28	331.2	790460.0
2023-09-06 14:00:00	MSFT	Stock	331.2316	332.27	331.13	331.93	757772.0
2023-09-06 15:00:00	MSFT	Stock	331.94	333.29	331.3	332.89	2110726.0
2023-09-06 16:00:00	MSFT	Stock	332.9	333.45	332.87	333.04	2530280.0
2023-09-06 17:00:00	MSFT	Stock	333.0	333.52	333.0	333.2	13600.0
2023-09-06 18:00:00	MSFT	Stock	333.35	333.35	332.72	333.15	2114.0
2023-09-06 19:00:00	MSFT	Stock	333.0	333.5	332.89	333.5	6188.0
2023-09-06 04:00:00	NVDA	Stock	48.374	48.438	48.25	48.361	77710.0
2023-09-06 05:00:00	NVDA	Stock	48.348	48.348	48.33	48.33	5650.0
2023-09-06 06:00:00	NVDA	Stock	48.35	48.471	48.35	48.471	41970.0
2023-09-06 07:00:00	NVDA	Stock	48.463	48.62	48.45	48.55	677040.0
2023-09-06 08:00:00	NVDA	Stock	48.498	48.626	48.335	48.39	1091860.0
2023-09-06 09:00:00	NVDA	Stock	48.375	48.549	47.714	47.7165	45770470.0
2023-09-06 10:00:00	NVDA	Stock	47.714	47.717	46.825	46.907	96677670.0
2023-09-06 11:00:00	NVDA	Stock	46.907	47.047	46.651	46.818	50628000.0
2023-09-06 12:00:00	NVDA	Stock	46.824	46.873	46.58	46.742	37532880.0
2023-09-06 13:00:00	NVDA	Stock	46.7415	47.191	46.678	47.0829	42314230.0
2023-09-06 14:00:00	NVDA	Stock	47.086	47.137	46.925	46.989	27203360.0
2023-09-06 15:00:00	NVDA	Stock	46.988	47.099	46.85	47.063	44688380.0
2023-09-06 16:00:00	NVDA	Stock	47.061	47.077	46.923	46.965	11559950.0
2023-09-06 17:00:00	NVDA	Stock	46.9633	47.015	46.9633	47.009	236110.0
2023-09-06 18:00:00	NVDA	Stock	47.012	47.025	46.965	46.985	186550.0
2023-09-06 19:00:00	NVDA	Stock	46.967	47.018	46.96	46.987	391940.0
2023-09-06 04:00:00	AMZN	Stock	136.32	136.5	136.3	136.39	4153.0
2023-09-06 05:00:00	AMZN	Stock	136.47	136.55	136.43	136.5	920.0

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

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