PREVIEW / stock_1hour / 2023-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-05.parquet
  size:    1.3 MB
  rows:    57,806
  symbols: 1,396

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-10-05 04:00:00	AAPL	Stock	173.23	173.4	172.92	172.92	5030.0
2023-10-05 05:00:00	AAPL	Stock	172.9	173.09	172.8	173.05	27719.0
2023-10-05 06:00:00	AAPL	Stock	173.08	173.51	173.08	173.48	5932.0
2023-10-05 07:00:00	AAPL	Stock	173.41	173.85	173.34	173.77	30869.0
2023-10-05 08:00:00	AAPL	Stock	173.69	174.1106	172.8	173.3	149354.0
2023-10-05 09:00:00	AAPL	Stock	173.27	174.408	173.0	173.8723	4686937.0
2023-10-05 10:00:00	AAPL	Stock	173.87	173.875	172.68	173.0	6134985.0
2023-10-05 11:00:00	AAPL	Stock	173.0	173.83	172.83	173.4801	5122403.0
2023-10-05 12:00:00	AAPL	Stock	173.485	174.03	173.36	173.947	3421248.0
2023-10-05 13:00:00	AAPL	Stock	173.9446	175.03	173.645	174.89	5039380.0
2023-10-05 14:00:00	AAPL	Stock	174.88	175.45	174.75	175.33	4573206.0
2023-10-05 15:00:00	AAPL	Stock	175.335	175.39	174.84	174.97	6014235.0
2023-10-05 16:00:00	AAPL	Stock	174.97	174.98	174.72	174.8398	5994241.0
2023-10-05 17:00:00	AAPL	Stock	174.91	174.91	174.76	174.7697	34539.0
2023-10-05 18:00:00	AAPL	Stock	174.77	174.84	174.76	174.77	9613.0
2023-10-05 19:00:00	AAPL	Stock	174.78	174.81	174.67	174.75	18569.0
2023-10-05 04:00:00	MSFT	Stock	318.96	319.03	318.9	319.03	812.0
2023-10-05 05:00:00	MSFT	Stock	318.11	318.13	318.0	318.0	914.0
2023-10-05 06:00:00	MSFT	Stock	318.45	319.1	318.45	318.85	640.0
2023-10-05 07:00:00	MSFT	Stock	319.01	320.21	319.01	320.18	8950.0
2023-10-05 08:00:00	MSFT	Stock	319.53	320.4	317.77	318.35	44681.0
2023-10-05 09:00:00	MSFT	Stock	318.4704	319.98	316.62	317.44	1483856.0
2023-10-05 10:00:00	MSFT	Stock	317.47	317.58	314.9	315.37	1583447.0
2023-10-05 11:00:00	MSFT	Stock	315.33	317.34	315.01	316.505	1318178.0
2023-10-05 12:00:00	MSFT	Stock	316.5767	317.45	316.44	316.767	1004833.0
2023-10-05 13:00:00	MSFT	Stock	316.75	317.815	316.08	317.64	954048.0
2023-10-05 14:00:00	MSFT	Stock	317.64	319.06	317.49	319.0349	1039703.0
2023-10-05 15:00:00	MSFT	Stock	318.98	319.91	318.31	319.37	2272609.0
2023-10-05 16:00:00	MSFT	Stock	319.37	319.42	318.72	318.9	2890589.0
2023-10-05 17:00:00	MSFT	Stock	319.2	319.36	319.02	319.03	3765.0
2023-10-05 18:00:00	MSFT	Stock	319.26	319.27	318.98	319.12	9858.0
2023-10-05 19:00:00	MSFT	Stock	319.12	319.23	318.9	318.97	1827.0
2023-10-05 04:00:00	NVDA	Stock	43.945	44.08	43.915	43.961	130590.0
2023-10-05 05:00:00	NVDA	Stock	43.952	44.041	43.931	44.033	25170.0
2023-10-05 06:00:00	NVDA	Stock	44.012	44.172	44.012	44.129	99580.0
2023-10-05 07:00:00	NVDA	Stock	44.136	44.371	44.103	44.371	583990.0
2023-10-05 08:00:00	NVDA	Stock	44.222	44.421	43.942	44.116	2364870.0
2023-10-05 09:00:00	NVDA	Stock	44.109	44.49	43.915	44.235	49814180.0
2023-10-05 10:00:00	NVDA	Stock	44.237	44.5264	43.888	44.15	61094680.0
2023-10-05 11:00:00	NVDA	Stock	44.152	44.461	44.09	44.32	37334740.0
2023-10-05 12:00:00	NVDA	Stock	44.319	44.593	44.3	44.537	32212670.0
2023-10-05 13:00:00	NVDA	Stock	44.538	44.709	44.313	44.708	29860390.0
2023-10-05 14:00:00	NVDA	Stock	44.708	44.9	44.685	44.857	37122110.0
2023-10-05 15:00:00	NVDA	Stock	44.8565	44.888	44.614	44.68	38132820.0
2023-10-05 16:00:00	NVDA	Stock	44.67	44.712	44.58	44.645	13994830.0
2023-10-05 17:00:00	NVDA	Stock	44.659	44.715	44.65	44.685	243440.0
2023-10-05 18:00:00	NVDA	Stock	44.687	44.699	44.665	44.685	138040.0
2023-10-05 19:00:00	NVDA	Stock	44.68	44.709	44.638	44.65	352130.0
2023-10-05 04:00:00	AMZN	Stock	126.49	126.81	126.09	126.25	26812.0
2023-10-05 05:00:00	AMZN	Stock	126.3	126.66	126.3	126.66	30084.0

> showing 50 of 57,806 rows — these rows as CSV

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