PREVIEW / stock_1hour / 2023-05-26

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-26.parquet
  size:    1.3 MB
  rows:    59,407
  symbols: 1,652

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-05-26 04:00:00	AAPL	Stock	172.7	173.12	172.7	173.12	7389.0
2023-05-26 05:00:00	AAPL	Stock	173.31	173.31	173.0	173.0	2403.0
2023-05-26 06:00:00	AAPL	Stock	173.02	173.38	172.92	173.38	4101.0
2023-05-26 07:00:00	AAPL	Stock	173.3	173.5	173.3	173.44	23848.0
2023-05-26 08:00:00	AAPL	Stock	173.35	173.49	172.57	173.2842	134580.0
2023-05-26 09:00:00	AAPL	Stock	173.39	174.748	173.11	174.6	5248197.0
2023-05-26 10:00:00	AAPL	Stock	174.6	175.58	174.51	175.43	6983797.0
2023-05-26 11:00:00	AAPL	Stock	175.43	175.77	174.88	175.12	5369784.0
2023-05-26 12:00:00	AAPL	Stock	175.12	175.35	175.02	175.235	3759290.0
2023-05-26 13:00:00	AAPL	Stock	175.235	175.53	175.115	175.215	3328675.0
2023-05-26 14:00:00	AAPL	Stock	175.215	175.26	174.84	175.125	3482435.0
2023-05-26 15:00:00	AAPL	Stock	175.125	175.665	174.9601	175.38	8365139.0
2023-05-26 16:00:00	AAPL	Stock	175.38	175.68	175.31	175.64	7741428.0
2023-05-26 17:00:00	AAPL	Stock	175.64	175.65	175.5	175.5	12671.0
2023-05-26 18:00:00	AAPL	Stock	175.51	175.59	175.3	175.5	28136.0
2023-05-26 19:00:00	AAPL	Stock	175.46	175.5	175.43	175.5	16723.0
2023-05-26 04:00:00	MSFT	Stock	324.5	325.57	324.5	325.57	4134.0
2023-05-26 05:00:00	MSFT	Stock	324.81	324.9	324.8	324.9	1459.0
2023-05-26 06:00:00	MSFT	Stock	324.66	325.35	324.53	325.35	5394.0
2023-05-26 07:00:00	MSFT	Stock	325.22	325.4	324.22	324.92	24111.0
2023-05-26 08:00:00	MSFT	Stock	325.34	325.4536	323.0	324.49	88282.0
2023-05-26 09:00:00	MSFT	Stock	324.55	328.0	323.49	327.645	3650044.0
2023-05-26 10:00:00	MSFT	Stock	327.68	330.97	327.01	330.72	3653427.0
2023-05-26 11:00:00	MSFT	Stock	330.685	332.9641	329.84	332.8	4285115.0
2023-05-26 12:00:00	MSFT	Stock	332.78	332.84	331.2648	331.49	2377051.0
2023-05-26 13:00:00	MSFT	Stock	331.51	332.09	331.2901	331.8901	1739580.0
2023-05-26 14:00:00	MSFT	Stock	331.9	333.2301	331.4	332.66	1895353.0
2023-05-26 15:00:00	MSFT	Stock	332.66	333.4	332.22	332.86	3955972.0
2023-05-26 16:00:00	MSFT	Stock	332.86	333.43	332.75	333.25	4629987.0
2023-05-26 17:00:00	MSFT	Stock	333.2489	333.3	333.0	333.2	7114.0
2023-05-26 18:00:00	MSFT	Stock	333.25	333.3	333.0	333.15	5136.0
2023-05-26 19:00:00	MSFT	Stock	333.25	334.0	333.25	334.0	15949.0
2023-05-26 04:00:00	NVDA	Stock	37.84	38.102	37.767	38.039	125780.0
2023-05-26 05:00:00	NVDA	Stock	38.039	38.04	37.85	37.885	93660.0
2023-05-26 06:00:00	NVDA	Stock	37.9	38.2	37.9	38.174	297130.0
2023-05-26 07:00:00	NVDA	Stock	38.165	38.345	38.12	38.18	1082460.0
2023-05-26 08:00:00	NVDA	Stock	38.2	38.349	37.401	38.06	3201300.0
2023-05-26 09:00:00	NVDA	Stock	38.065	38.205	37.55	38.0155	87707850.0
2023-05-26 10:00:00	NVDA	Stock	38.018	38.758	37.86	38.5467	100237750.0
2023-05-26 11:00:00	NVDA	Stock	38.552	38.74	38.125	38.6495	89014670.0
2023-05-26 12:00:00	NVDA	Stock	38.6495	39.0169	38.502	38.8215	65951090.0
2023-05-26 13:00:00	NVDA	Stock	38.824	38.9005	38.627	38.888	39695890.0
2023-05-26 14:00:00	NVDA	Stock	38.889	38.998	38.75	38.853	47574510.0
2023-05-26 15:00:00	NVDA	Stock	38.857	39.17	38.825	38.924	78595040.0
2023-05-26 16:00:00	NVDA	Stock	38.946	39.15	38.901	38.972	41478400.0
2023-05-26 17:00:00	NVDA	Stock	38.975	39.045	38.95	38.98	441680.0
2023-05-26 18:00:00	NVDA	Stock	38.983	39.015	38.961	39.001	304500.0
2023-05-26 19:00:00	NVDA	Stock	39.0	39.04	38.998	39.022	451230.0
2023-05-26 04:00:00	AMZN	Stock	115.51	115.51	114.56	115.0	4817.0
2023-05-26 05:00:00	AMZN	Stock	115.06	115.14	115.0	115.14	2403.0

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

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