PREVIEW / stock_1hour / 2023-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-17.parquet
  size:    1.3 MB
  rows:    59,391
  symbols: 1,465

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-08-17 04:00:00	AAPL	Stock	176.51	176.86	176.51	176.8	11532.0
2023-08-17 05:00:00	AAPL	Stock	176.76	176.78	176.65	176.68	4987.0
2023-08-17 06:00:00	AAPL	Stock	176.7	176.89	176.51	176.65	11100.0
2023-08-17 07:00:00	AAPL	Stock	176.65	176.79	176.58	176.74	30321.0
2023-08-17 08:00:00	AAPL	Stock	176.65	176.99	176.1	176.94	374964.0
2023-08-17 09:00:00	AAPL	Stock	176.92	177.5054	175.23	175.625	6292953.0
2023-08-17 10:00:00	AAPL	Stock	175.625	175.63	173.885	174.09	10380010.0
2023-08-17 11:00:00	AAPL	Stock	174.1	174.67	173.83	174.63	4458748.0
2023-08-17 12:00:00	AAPL	Stock	174.64	175.065	174.41	175.065	3565716.0
2023-08-17 13:00:00	AAPL	Stock	175.07	175.09	174.08	174.215	3635502.0
2023-08-17 14:00:00	AAPL	Stock	174.22	174.35	173.715	173.94	4164448.0
2023-08-17 15:00:00	AAPL	Stock	173.93	174.89	173.48	173.99	8859442.0
2023-08-17 16:00:00	AAPL	Stock	174.0	174.1	173.31	173.4	5419555.0
2023-08-17 17:00:00	AAPL	Stock	173.4	174.0	173.12	173.36	173529.0
2023-08-17 18:00:00	AAPL	Stock	173.36	173.49	173.13	173.3063	50286.0
2023-08-17 19:00:00	AAPL	Stock	173.28	173.65	173.26	173.3999	40274.0
2023-08-17 04:00:00	MSFT	Stock	319.32	322.0	319.32	320.0	3407.0
2023-08-17 05:00:00	MSFT	Stock	320.28	320.29	320.16	320.26	1072.0
2023-08-17 06:00:00	MSFT	Stock	320.19	320.53	320.19	320.36	6575.0
2023-08-17 07:00:00	MSFT	Stock	320.34	320.55	320.2	320.55	7587.0
2023-08-17 08:00:00	MSFT	Stock	320.4	321.28	318.14	321.11	51403.0
2023-08-17 09:00:00	MSFT	Stock	321.11	321.87	318.7001	319.85	1604279.0
2023-08-17 10:00:00	MSFT	Stock	319.85	320.22	318.73	319.45	1576202.0
2023-08-17 11:00:00	MSFT	Stock	319.49	319.81	318.68	319.68	1437418.0
2023-08-17 12:00:00	MSFT	Stock	319.69	320.82	319.04	320.81	1070825.0
2023-08-17 13:00:00	MSFT	Stock	320.81	320.905	318.45	318.7726	1130704.0
2023-08-17 14:00:00	MSFT	Stock	318.76	319.4	318.33	318.672	1259016.0
2023-08-17 15:00:00	MSFT	Stock	318.62	318.88	316.21	316.88	3311169.0
2023-08-17 16:00:00	MSFT	Stock	316.84	316.89	315.99	316.23	3659186.0
2023-08-17 17:00:00	MSFT	Stock	316.2	316.2	315.87	315.89	11156.0
2023-08-17 18:00:00	MSFT	Stock	316.18	316.18	315.58	315.6512	7780.0
2023-08-17 19:00:00	MSFT	Stock	315.94	316.3	315.67	315.67	7679.0
2023-08-17 04:00:00	NVDA	Stock	43.6	43.845	43.57	43.79	128320.0
2023-08-17 05:00:00	NVDA	Stock	43.835	43.949	43.835	43.9	76130.0
2023-08-17 06:00:00	NVDA	Stock	43.9	43.94	43.808	43.808	89850.0
2023-08-17 07:00:00	NVDA	Stock	43.8	43.88	43.725	43.845	356000.0
2023-08-17 08:00:00	NVDA	Stock	43.53	43.989	43.486	43.985	2881090.0
2023-08-17 09:00:00	NVDA	Stock	43.985	44.062	43.476	43.799	56147120.0
2023-08-17 10:00:00	NVDA	Stock	43.784	43.888	43.27	43.462	65015620.0
2023-08-17 11:00:00	NVDA	Stock	43.4677	43.58	43.2757	43.442	39341980.0
2023-08-17 12:00:00	NVDA	Stock	43.442	43.85	43.342	43.7914	33603460.0
2023-08-17 13:00:00	NVDA	Stock	43.7914	43.824	43.46	43.6501	28726770.0
2023-08-17 14:00:00	NVDA	Stock	43.655	43.714	43.375	43.4	30921800.0
2023-08-17 15:00:00	NVDA	Stock	43.397	43.452	43.001	43.343	60988510.0
2023-08-17 16:00:00	NVDA	Stock	43.344	43.406	43.125	43.198	24071840.0
2023-08-17 17:00:00	NVDA	Stock	43.1824	43.2755	43.153	43.22	429350.0
2023-08-17 18:00:00	NVDA	Stock	43.237	43.239	43.05	43.127	491110.0
2023-08-17 19:00:00	NVDA	Stock	43.127	43.248	43.127	43.23	575810.0
2023-08-17 04:00:00	AMZN	Stock	134.62	135.18	134.62	135.05	9478.0
2023-08-17 05:00:00	AMZN	Stock	134.92	135.01	134.73	134.85	6363.0

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

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