PREVIEW / stock_1hour / 2023-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-04.parquet
  size:    1.3 MB
  rows:    59,095
  symbols: 1,481

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-04 04:00:00	AAPL	Stock	187.31	188.92	187.04	187.81	75542.0
2023-08-04 05:00:00	AAPL	Stock	187.83	188.0	187.51	187.51	30077.0
2023-08-04 06:00:00	AAPL	Stock	187.58	187.75	187.22	187.37	35890.0
2023-08-04 07:00:00	AAPL	Stock	187.42	187.44	186.22	186.65	251095.0
2023-08-04 08:00:00	AAPL	Stock	187.31	191.17	185.01	186.01	1486086.0
2023-08-04 09:00:00	AAPL	Stock	186.0	187.38	183.25	185.295	21901815.0
2023-08-04 10:00:00	AAPL	Stock	185.3	185.77	184.27	185.36	12865681.0
2023-08-04 11:00:00	AAPL	Stock	185.37	186.375	184.93	185.6	8347263.0
2023-08-04 12:00:00	AAPL	Stock	185.605	185.68	185.08	185.22	4444028.0
2023-08-04 13:00:00	AAPL	Stock	185.23	185.26	184.79	184.91	6352851.0
2023-08-04 14:00:00	AAPL	Stock	184.91	184.915	182.07	182.35	13979437.0
2023-08-04 15:00:00	AAPL	Stock	182.355	183.24	181.92	181.99	15380040.0
2023-08-04 16:00:00	AAPL	Stock	182.0	182.2	181.72	182.13	8517857.0
2023-08-04 17:00:00	AAPL	Stock	182.09	182.17	181.81	181.84	164426.0
2023-08-04 18:00:00	AAPL	Stock	181.86	181.91	181.83	181.89	56063.0
2023-08-04 19:00:00	AAPL	Stock	181.9	182.05	181.85	182.05	71270.0
2023-08-04 04:00:00	MSFT	Stock	329.96	331.0	329.61	330.2	5487.0
2023-08-04 05:00:00	MSFT	Stock	330.32	330.58	330.27	330.27	1447.0
2023-08-04 06:00:00	MSFT	Stock	330.24	330.24	329.51	329.83	5486.0
2023-08-04 07:00:00	MSFT	Stock	329.8	330.0	328.66	329.29	25409.0
2023-08-04 08:00:00	MSFT	Stock	329.2	331.48	328.8	331.15	129636.0
2023-08-04 09:00:00	MSFT	Stock	331.15	335.14	329.83	330.5081	4112951.0
2023-08-04 10:00:00	MSFT	Stock	330.474	332.4299	328.975	331.74	2251628.0
2023-08-04 11:00:00	MSFT	Stock	331.78	333.54	331.55	332.89	1412940.0
2023-08-04 12:00:00	MSFT	Stock	332.9	334.2999	332.62	333.82	1360152.0
2023-08-04 13:00:00	MSFT	Stock	333.82	333.97	331.5937	331.8954	1116579.0
2023-08-04 14:00:00	MSFT	Stock	331.83	331.8552	328.8	329.03	1711537.0
2023-08-04 15:00:00	MSFT	Stock	328.96	329.4	327.24	327.8	2621092.0
2023-08-04 16:00:00	MSFT	Stock	327.8	328.18	327.61	327.79	2027494.0
2023-08-04 17:00:00	MSFT	Stock	327.723	327.92	327.57	327.57	12771.0
2023-08-04 18:00:00	MSFT	Stock	327.5641	327.8467	327.56	327.78	2886.0
2023-08-04 19:00:00	MSFT	Stock	327.78	328.0	327.6	327.78	4426.0
2023-08-04 04:00:00	NVDA	Stock	44.9	45.081	44.9	45.081	102840.0
2023-08-04 05:00:00	NVDA	Stock	45.064	45.15	45.046	45.115	186770.0
2023-08-04 06:00:00	NVDA	Stock	45.082	45.108	44.95	44.95	63600.0
2023-08-04 07:00:00	NVDA	Stock	44.988	44.99	44.73	44.798	403880.0
2023-08-04 08:00:00	NVDA	Stock	44.96	45.14	44.5193	44.897	2196230.0
2023-08-04 09:00:00	NVDA	Stock	44.885	45.642	44.722	44.74	50428270.0
2023-08-04 10:00:00	NVDA	Stock	44.741	45.147	44.393	45.043	50539360.0
2023-08-04 11:00:00	NVDA	Stock	45.052	45.322	45.008	45.219	27546120.0
2023-08-04 12:00:00	NVDA	Stock	45.224	45.567	45.116	45.501	26893300.0
2023-08-04 13:00:00	NVDA	Stock	45.509	45.53	45.105	45.174	23020660.0
2023-08-04 14:00:00	NVDA	Stock	45.174	45.185	44.542	44.588	37976880.0
2023-08-04 15:00:00	NVDA	Stock	44.5884	44.828	44.534	44.689	34391390.0
2023-08-04 16:00:00	NVDA	Stock	44.68	44.691	44.571	44.6	10843480.0
2023-08-04 17:00:00	NVDA	Stock	44.6	44.651	44.553	44.6	216500.0
2023-08-04 18:00:00	NVDA	Stock	44.6	44.607	44.585	44.586	81880.0
2023-08-04 19:00:00	NVDA	Stock	44.586	44.607	44.557	44.585	210330.0
2023-08-04 04:00:00	AMZN	Stock	139.91	140.71	138.0	139.88	430890.0
2023-08-04 05:00:00	AMZN	Stock	139.89	140.68	139.65	140.5	103696.0

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

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