PREVIEW / stock_1hour / 2023-09-05

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-05.parquet
  size:    1.3 MB
  rows:    59,541
  symbols: 1,440

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-05 04:00:00	AAPL	Stock	188.5	189.2	187.31	187.65	56054.0
2023-09-05 05:00:00	AAPL	Stock	187.66	188.0	187.6	187.68	18876.0
2023-09-05 06:00:00	AAPL	Stock	187.66	187.79	187.54	187.6	35436.0
2023-09-05 07:00:00	AAPL	Stock	187.65	187.88	187.47	187.78	63601.0
2023-09-05 08:00:00	AAPL	Stock	187.53	189.75	187.45	187.67	480084.0
2023-09-05 09:00:00	AAPL	Stock	187.67	188.63	187.2	188.06	6517786.0
2023-09-05 10:00:00	AAPL	Stock	188.06	189.31	187.82	189.05	6636495.0
2023-09-05 11:00:00	AAPL	Stock	189.06	189.61	188.98	189.4	4464749.0
2023-09-05 12:00:00	AAPL	Stock	189.409	189.81	189.3702	189.64	2712753.0
2023-09-05 13:00:00	AAPL	Stock	189.65	189.6999	189.16	189.435	2108740.0
2023-09-05 14:00:00	AAPL	Stock	189.44	189.95	189.32	189.94	2577381.0
2023-09-05 15:00:00	AAPL	Stock	189.93	189.98	189.47	189.7	5253016.0
2023-09-05 16:00:00	AAPL	Stock	189.7	189.78	189.51	189.56	4836955.0
2023-09-05 17:00:00	AAPL	Stock	189.55	189.59	189.54	189.55	11368.0
2023-09-05 18:00:00	AAPL	Stock	189.55	189.73	189.5	189.73	24216.0
2023-09-05 19:00:00	AAPL	Stock	189.7	189.75	189.53	189.7	19129.0
2023-09-05 04:00:00	MSFT	Stock	327.57	327.57	326.55	326.85	3127.0
2023-09-05 05:00:00	MSFT	Stock	326.8	327.19	326.78	327.0	3532.0
2023-09-05 06:00:00	MSFT	Stock	327.18	327.4	327.11	327.4	2347.0
2023-09-05 07:00:00	MSFT	Stock	327.39	327.46	326.87	327.3	6880.0
2023-09-05 08:00:00	MSFT	Stock	327.3	328.76	326.85	328.46	26645.0
2023-09-05 09:00:00	MSFT	Stock	328.25	330.8705	327.3	329.055	1602823.0
2023-09-05 10:00:00	MSFT	Stock	329.08	332.06	328.66	331.88	1701086.0
2023-09-05 11:00:00	MSFT	Stock	331.89	334.85	331.89	332.86	2150787.0
2023-09-05 12:00:00	MSFT	Stock	332.86	334.12	332.81	333.395	840418.0
2023-09-05 13:00:00	MSFT	Stock	333.42	334.08	332.75	333.6985	771775.0
2023-09-05 14:00:00	MSFT	Stock	333.7	334.23	333.28	334.21	691852.0
2023-09-05 15:00:00	MSFT	Stock	334.21	334.31	333.28	333.58	1616170.0
2023-09-05 16:00:00	MSFT	Stock	333.57	333.57	332.867	332.867	3122982.0
2023-09-05 17:00:00	MSFT	Stock	332.9975	333.16	332.82	333.16	3112.0
2023-09-05 18:00:00	MSFT	Stock	333.05	333.55	332.98	333.32	7202.0
2023-09-05 19:00:00	MSFT	Stock	333.14	333.3	332.93	333.1	2609.0
2023-09-05 04:00:00	NVDA	Stock	48.51	48.51	47.91	48.025	360990.0
2023-09-05 05:00:00	NVDA	Stock	48.03	48.199	47.98	48.161	102110.0
2023-09-05 06:00:00	NVDA	Stock	48.154	48.2	48.148	48.15	86790.0
2023-09-05 07:00:00	NVDA	Stock	48.179	48.2	48.049	48.135	403340.0
2023-09-05 08:00:00	NVDA	Stock	48.2	48.7	47.9392	48.2	1478680.0
2023-09-05 09:00:00	NVDA	Stock	48.2	48.789	47.86	48.25	58494870.0
2023-09-05 10:00:00	NVDA	Stock	48.25	48.59	47.964	48.4369	59298840.0
2023-09-05 11:00:00	NVDA	Stock	48.437	48.668	48.104	48.267	39155240.0
2023-09-05 12:00:00	NVDA	Stock	48.2568	48.54	48.22	48.438	24819610.0
2023-09-05 13:00:00	NVDA	Stock	48.4395	48.572	48.3149	48.4712	20657980.0
2023-09-05 14:00:00	NVDA	Stock	48.478	48.8	48.458	48.7342	30177070.0
2023-09-05 15:00:00	NVDA	Stock	48.743	48.8508	48.52	48.549	38968450.0
2023-09-05 16:00:00	NVDA	Stock	48.541	48.572	48.461	48.475	13814650.0
2023-09-05 17:00:00	NVDA	Stock	48.4708	48.49	48.4	48.461	227320.0
2023-09-05 18:00:00	NVDA	Stock	48.42	48.479	48.403	48.42	155360.0
2023-09-05 19:00:00	NVDA	Stock	48.412	48.428	48.371	48.39	317420.0
2023-09-05 04:00:00	AMZN	Stock	138.01	138.01	137.03	137.25	13453.0
2023-09-05 05:00:00	AMZN	Stock	137.4	137.55	137.35	137.5	2185.0

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

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