PREVIEW / stock_1hour / 2023-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-06.parquet
  size:    1.3 MB
  rows:    59,192
  symbols: 1,332

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-11-06 04:00:00	AAPL	Stock	177.03	177.2	176.75	176.96	24126.0
2023-11-06 05:00:00	AAPL	Stock	176.95	176.98	176.8	176.86	5341.0
2023-11-06 06:00:00	AAPL	Stock	176.79	176.83	176.58	176.83	11153.0
2023-11-06 07:00:00	AAPL	Stock	176.8	176.83	176.32	176.41	104847.0
2023-11-06 08:00:00	AAPL	Stock	176.8	177.2	176.07	176.3	252967.0
2023-11-06 09:00:00	AAPL	Stock	176.23	178.75	176.01	178.58	9632963.0
2023-11-06 10:00:00	AAPL	Stock	178.59	179.06	177.9	178.755	8066384.0
2023-11-06 11:00:00	AAPL	Stock	178.75	179.43	178.72	179.26	5732257.0
2023-11-06 12:00:00	AAPL	Stock	179.255	179.265	178.64	178.89	3936277.0
2023-11-06 13:00:00	AAPL	Stock	178.89	178.8936	178.01	178.3503	3962087.0
2023-11-06 14:00:00	AAPL	Stock	178.36	179.22	178.1199	179.2101	4140751.0
2023-11-06 15:00:00	AAPL	Stock	179.21	179.33	178.7	179.29	8027533.0
2023-11-06 16:00:00	AAPL	Stock	179.3	179.3	178.97	179.09	5880268.0
2023-11-06 17:00:00	AAPL	Stock	179.09	179.16	179.04	179.06	29554.0
2023-11-06 18:00:00	AAPL	Stock	179.07	179.07	178.91	178.98	16282.0
2023-11-06 19:00:00	AAPL	Stock	178.95	178.98	178.85	178.98	13712.0
2023-11-06 04:00:00	MSFT	Stock	353.33	353.5	353.1	353.5	4260.0
2023-11-06 05:00:00	MSFT	Stock	353.73	353.75	353.4	353.65	3373.0
2023-11-06 06:00:00	MSFT	Stock	353.6	353.93	353.47	353.77	3955.0
2023-11-06 07:00:00	MSFT	Stock	353.77	353.8	353.5	353.7	26060.0
2023-11-06 08:00:00	MSFT	Stock	352.05	353.8	352.05	353.55	71300.0
2023-11-06 09:00:00	MSFT	Stock	353.55	356.8	353.29	356.04	2950864.0
2023-11-06 10:00:00	MSFT	Stock	356.09	357.4	355.48	357.0227	2473444.0
2023-11-06 11:00:00	MSFT	Stock	357.0	357.54	356.23	356.845	1139399.0
2023-11-06 12:00:00	MSFT	Stock	356.8	356.82	355.28	355.54	1425313.0
2023-11-06 13:00:00	MSFT	Stock	355.59	355.9	353.81	355.89	1556827.0
2023-11-06 14:00:00	MSFT	Stock	355.92	356.0	354.78	355.75	1249266.0
2023-11-06 15:00:00	MSFT	Stock	355.77	356.67	355.02	356.64	2098029.0
2023-11-06 16:00:00	MSFT	Stock	356.63	357.0	356.23	356.35	3751199.0
2023-11-06 17:00:00	MSFT	Stock	356.32	356.6	356.28	356.45	8375.0
2023-11-06 18:00:00	MSFT	Stock	356.4899	356.4899	356.12	356.22	7292.0
2023-11-06 19:00:00	MSFT	Stock	356.0801	356.45	356.0801	356.37	4944.0
2023-11-06 04:00:00	NVDA	Stock	45.25	45.557	45.228	45.52	184220.0
2023-11-06 05:00:00	NVDA	Stock	45.539	45.619	45.48	45.531	99940.0
2023-11-06 06:00:00	NVDA	Stock	45.53	45.549	45.466	45.486	72780.0
2023-11-06 07:00:00	NVDA	Stock	45.526	45.74	45.461	45.55	929570.0
2023-11-06 08:00:00	NVDA	Stock	45.5	45.777	45.0	45.24	2083470.0
2023-11-06 09:00:00	NVDA	Stock	45.246	45.935	45.202	45.6745	67058490.0
2023-11-06 10:00:00	NVDA	Stock	45.675	45.757	45.311	45.614	54083460.0
2023-11-06 11:00:00	NVDA	Stock	45.619	45.754	45.518	45.601	31568560.0
2023-11-06 12:00:00	NVDA	Stock	45.5951	45.615	45.168	45.337	34682460.0
2023-11-06 13:00:00	NVDA	Stock	45.337	45.345	44.899	45.2635	38189900.0
2023-11-06 14:00:00	NVDA	Stock	45.27	45.636	45.16	45.6307	33707470.0
2023-11-06 15:00:00	NVDA	Stock	45.632	45.7687	45.485	45.7557	42657170.0
2023-11-06 16:00:00	NVDA	Stock	45.759	45.768	45.66	45.696	13253600.0
2023-11-06 17:00:00	NVDA	Stock	45.6851	45.7	45.617	45.67	265420.0
2023-11-06 18:00:00	NVDA	Stock	45.648	45.66	45.601	45.614	204530.0
2023-11-06 19:00:00	NVDA	Stock	45.602	45.645	45.59	45.622	364760.0
2023-11-06 04:00:00	AMZN	Stock	138.35	138.85	138.35	138.73	9084.0
2023-11-06 05:00:00	AMZN	Stock	138.71	138.76	138.62	138.62	4786.0

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

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