PREVIEW / stock_1hour / 2023-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-14.parquet
  size:    1.4 MB
  rows:    60,558
  symbols: 1,572

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-07-14 04:00:00	AAPL	Stock	190.65	190.78	189.99	189.99	31529.0
2023-07-14 05:00:00	AAPL	Stock	189.99	190.05	189.88	189.95	22981.0
2023-07-14 06:00:00	AAPL	Stock	189.95	190.05	189.64	189.83	17912.0
2023-07-14 07:00:00	AAPL	Stock	190.0	190.14	189.75	189.86	49608.0
2023-07-14 08:00:00	AAPL	Stock	189.97	190.83	189.78	190.11	197872.0
2023-07-14 09:00:00	AAPL	Stock	190.05	191.0	189.9	190.81	4875974.0
2023-07-14 10:00:00	AAPL	Stock	190.79	191.1799	190.37	190.62	5353954.0
2023-07-14 11:00:00	AAPL	Stock	190.62	190.72	190.28	190.48	3403664.0
2023-07-14 12:00:00	AAPL	Stock	190.49	190.5	189.7226	190.0208	3228333.0
2023-07-14 13:00:00	AAPL	Stock	190.02	190.4172	189.63	190.215	2742811.0
2023-07-14 14:00:00	AAPL	Stock	190.215	190.565	189.98	190.04	2741468.0
2023-07-14 15:00:00	AAPL	Stock	190.04	190.74	189.78	190.72	6387105.0
2023-07-14 16:00:00	AAPL	Stock	190.73	190.81	190.3978	190.66	5210433.0
2023-07-14 17:00:00	AAPL	Stock	190.65	190.69	190.52	190.59	51932.0
2023-07-14 18:00:00	AAPL	Stock	190.58	190.75	190.58	190.75	23507.0
2023-07-14 19:00:00	AAPL	Stock	190.72	190.8	190.69	190.7	14048.0
2023-07-14 04:00:00	MSFT	Stock	345.0	349.94	345.0	348.5	38672.0
2023-07-14 05:00:00	MSFT	Stock	348.28	348.35	346.7	346.8	10757.0
2023-07-14 06:00:00	MSFT	Stock	347.17	348.0	347.01	347.57	11315.0
2023-07-14 07:00:00	MSFT	Stock	347.24	349.1	346.15	348.6	81331.0
2023-07-14 08:00:00	MSFT	Stock	346.92	349.57	344.4	347.95	278213.0
2023-07-14 09:00:00	MSFT	Stock	347.95	348.91	346.03	347.65	3505763.0
2023-07-14 10:00:00	MSFT	Stock	347.57	351.43	346.65	349.5965	5245901.0
2023-07-14 11:00:00	MSFT	Stock	349.615	350.39	348.95	349.32	1600727.0
2023-07-14 12:00:00	MSFT	Stock	349.36	349.38	346.51	347.05	1487997.0
2023-07-14 13:00:00	MSFT	Stock	347.025	347.06	345.57	346.2799	1343381.0
2023-07-14 14:00:00	MSFT	Stock	346.29	347.05	345.2151	345.2151	1280165.0
2023-07-14 15:00:00	MSFT	Stock	345.219	345.61	344.31	345.37	2844863.0
2023-07-14 16:00:00	MSFT	Stock	345.38	345.43	344.82	344.96	2889862.0
2023-07-14 17:00:00	MSFT	Stock	345.01	345.24	344.99	345.13	58745.0
2023-07-14 18:00:00	MSFT	Stock	345.2399	345.8659	345.18	345.77	11103.0
2023-07-14 19:00:00	MSFT	Stock	345.5	347.24	345.5	346.99	24726.0
2023-07-14 04:00:00	NVDA	Stock	46.49	46.498	46.3	46.428	449810.0
2023-07-14 05:00:00	NVDA	Stock	46.434	46.448	46.142	46.19	118540.0
2023-07-14 06:00:00	NVDA	Stock	46.21	46.339	46.21	46.251	293830.0
2023-07-14 07:00:00	NVDA	Stock	46.295	46.798	46.285	46.705	1790830.0
2023-07-14 08:00:00	NVDA	Stock	46.295	46.8	46.25	46.538	4638440.0
2023-07-14 09:00:00	NVDA	Stock	46.533	47.59	46.501	47.4	91581560.0
2023-07-14 10:00:00	NVDA	Stock	47.38	48.088	47.209	47.2135	107876080.0
2023-07-14 11:00:00	NVDA	Stock	47.2135	47.48	46.894	47.331	73016620.0
2023-07-14 12:00:00	NVDA	Stock	47.325	47.338	46.49	46.575	58526410.0
2023-07-14 13:00:00	NVDA	Stock	46.587	46.587	46.155	46.209	66302060.0
2023-07-14 14:00:00	NVDA	Stock	46.209	46.421	45.45	45.463	76670300.0
2023-07-14 15:00:00	NVDA	Stock	45.4525	45.502	45.06	45.469	91345960.0
2023-07-14 16:00:00	NVDA	Stock	45.469	45.525	45.432	45.505	15443780.0
2023-07-14 17:00:00	NVDA	Stock	45.5	45.51	45.46	45.488	397330.0
2023-07-14 18:00:00	NVDA	Stock	45.4856	45.549	45.43	45.512	484240.0
2023-07-14 19:00:00	NVDA	Stock	45.53	45.66	45.52	45.654	581280.0
2023-07-14 04:00:00	AMZN	Stock	134.5	134.69	134.04	134.04	31005.0
2023-07-14 05:00:00	AMZN	Stock	134.1	134.11	133.82	133.82	8209.0

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

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