PREVIEW / stock_1hour / 2023-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-29.parquet
  size:    1.3 MB
  rows:    60,139
  symbols: 1,578

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-06-29 04:00:00	AAPL	Stock	189.25	189.56	189.13	189.41	11990.0
2023-06-29 05:00:00	AAPL	Stock	189.53	189.65	189.4	189.61	6368.0
2023-06-29 06:00:00	AAPL	Stock	189.69	189.81	189.51	189.7	5778.0
2023-06-29 07:00:00	AAPL	Stock	189.65	189.85	189.6	189.83	32900.0
2023-06-29 08:00:00	AAPL	Stock	189.7596	189.91	189.21	189.35	232887.0
2023-06-29 09:00:00	AAPL	Stock	189.35	190.07	188.78	189.6993	7516507.0
2023-06-29 10:00:00	AAPL	Stock	189.7	189.975	188.94	189.33	6476536.0
2023-06-29 11:00:00	AAPL	Stock	189.34	189.91	189.26	189.78	3604553.0
2023-06-29 12:00:00	AAPL	Stock	189.78	189.9	189.19	189.345	2655271.0
2023-06-29 13:00:00	AAPL	Stock	189.34	189.57	189.11	189.44	2633514.0
2023-06-29 14:00:00	AAPL	Stock	189.44	189.79	189.18	189.7474	3070355.0
2023-06-29 15:00:00	AAPL	Stock	189.75	189.78	189.17	189.6	6274519.0
2023-06-29 16:00:00	AAPL	Stock	189.6	190.45	189.57	189.97	4694237.0
2023-06-29 17:00:00	AAPL	Stock	189.99	190.14	189.81	189.81	123461.0
2023-06-29 18:00:00	AAPL	Stock	189.81	190.19	189.7	190.18	103967.0
2023-06-29 19:00:00	AAPL	Stock	190.15	190.35	190.08	190.3	120303.0
2023-06-29 04:00:00	MSFT	Stock	336.25	336.25	334.74	335.36	4760.0
2023-06-29 05:00:00	MSFT	Stock	335.0	335.21	334.21	334.91	5605.0
2023-06-29 06:00:00	MSFT	Stock	334.66	335.7	334.51	335.7	2519.0
2023-06-29 07:00:00	MSFT	Stock	335.8	336.78	335.8	336.38	12423.0
2023-06-29 08:00:00	MSFT	Stock	335.66	337.48	334.8	335.16	34757.0
2023-06-29 09:00:00	MSFT	Stock	335.06	335.95	333.71	334.765	1668897.0
2023-06-29 10:00:00	MSFT	Stock	334.76	335.41	332.62	334.15	1829851.0
2023-06-29 11:00:00	MSFT	Stock	334.17	336.11	334.17	335.29	1469524.0
2023-06-29 12:00:00	MSFT	Stock	335.305	335.89	333.78	334.09	958314.0
2023-06-29 13:00:00	MSFT	Stock	334.08	334.7164	333.5	333.75	784163.0
2023-06-29 14:00:00	MSFT	Stock	333.7	334.85	333.28	334.74	974836.0
2023-06-29 15:00:00	MSFT	Stock	334.79	335.28	333.86	335.05	1742824.0
2023-06-29 16:00:00	MSFT	Stock	335.05	335.2272	334.53	334.72	2340963.0
2023-06-29 17:00:00	MSFT	Stock	334.89	334.92	334.7	334.7	588.0
2023-06-29 18:00:00	MSFT	Stock	334.9	335.1	334.7197	334.86	3975.0
2023-06-29 19:00:00	MSFT	Stock	334.86	335.5	334.76	335.39	3801.0
2023-06-29 04:00:00	NVDA	Stock	41.35	41.543	41.257	41.508	344250.0
2023-06-29 05:00:00	NVDA	Stock	41.502	41.55	41.46	41.535	126280.0
2023-06-29 06:00:00	NVDA	Stock	41.5	41.65	41.5	41.58	77950.0
2023-06-29 07:00:00	NVDA	Stock	41.58	41.63	41.505	41.53	352940.0
2023-06-29 08:00:00	NVDA	Stock	41.592	41.63	41.12	41.51	1991920.0
2023-06-29 09:00:00	NVDA	Stock	41.5245	41.6	41.054	41.12	41536950.0
2023-06-29 10:00:00	NVDA	Stock	41.1175	41.31	40.703	40.995	59976310.0
2023-06-29 11:00:00	NVDA	Stock	40.99	41.309	40.923	41.2085	36552800.0
2023-06-29 12:00:00	NVDA	Stock	41.206	41.291	40.88	40.9229	30021810.0
2023-06-29 13:00:00	NVDA	Stock	40.914	40.9868	40.706	40.7265	32714170.0
2023-06-29 14:00:00	NVDA	Stock	40.7265	40.826	40.6	40.799	36923230.0
2023-06-29 15:00:00	NVDA	Stock	40.8015	40.909	40.64	40.845	37596890.0
2023-06-29 16:00:00	NVDA	Stock	40.822	40.927	40.822	40.825	12507140.0
2023-06-29 17:00:00	NVDA	Stock	40.825	40.8474	40.75	40.766	171240.0
2023-06-29 18:00:00	NVDA	Stock	40.766	40.818	40.766	40.808	167150.0
2023-06-29 19:00:00	NVDA	Stock	40.801	40.94	40.792	40.938	485070.0
2023-06-29 04:00:00	AMZN	Stock	129.41	129.51	129.14	129.5	10200.0
2023-06-29 05:00:00	AMZN	Stock	129.41	129.71	129.31	129.6	18039.0

> showing 50 of 60,139 rows — these rows as CSV

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