PREVIEW / stock_1hour / 2023-12-01

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-01.parquet
  size:    1.3 MB
  rows:    59,874
  symbols: 1,262

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-12-01 04:00:00	AAPL	Stock	189.98	190.28	189.97	190.08	11034.0
2023-12-01 05:00:00	AAPL	Stock	190.08	190.1	189.87	189.87	5407.0
2023-12-01 06:00:00	AAPL	Stock	189.85	190.06	189.85	189.95	2395.0
2023-12-01 07:00:00	AAPL	Stock	189.95	189.97	189.55	189.61	39958.0
2023-12-01 08:00:00	AAPL	Stock	189.75	190.15	189.51	189.54	62608.0
2023-12-01 09:00:00	AAPL	Stock	189.54	190.49	189.23	189.96	4084051.0
2023-12-01 10:00:00	AAPL	Stock	189.97	190.5	189.913	190.34	4939465.0
2023-12-01 11:00:00	AAPL	Stock	190.35	191.25	190.18	191.04	5626436.0
2023-12-01 12:00:00	AAPL	Stock	191.045	191.54	190.9601	191.4982	3120199.0
2023-12-01 13:00:00	AAPL	Stock	191.5	191.56	190.8201	191.17	2723099.0
2023-12-01 14:00:00	AAPL	Stock	191.18	191.34	190.91	191.28	2535069.0
2023-12-01 15:00:00	AAPL	Stock	191.265	191.38	190.8816	191.26	5451212.0
2023-12-01 16:00:00	AAPL	Stock	191.25	191.34	191.06	191.15	4833003.0
2023-12-01 17:00:00	AAPL	Stock	191.14	191.32	191.06	191.32	53619.0
2023-12-01 18:00:00	AAPL	Stock	191.29	191.32	191.15	191.25	60054.0
2023-12-01 19:00:00	AAPL	Stock	191.28	191.33	191.27	191.33	9040.0
2023-12-01 04:00:00	MSFT	Stock	378.68	379.43	378.48	379.0	11460.0
2023-12-01 05:00:00	MSFT	Stock	379.02	379.2	378.84	378.84	2015.0
2023-12-01 06:00:00	MSFT	Stock	378.53	378.85	378.5	378.5	1883.0
2023-12-01 07:00:00	MSFT	Stock	378.41	378.51	377.79	378.2	16448.0
2023-12-01 08:00:00	MSFT	Stock	378.5217	378.69	377.8	378.3	28655.0
2023-12-01 09:00:00	MSFT	Stock	378.21	378.67	375.31	375.336	2118755.0
2023-12-01 10:00:00	MSFT	Stock	375.31	376.455	371.31	372.372	4529516.0
2023-12-01 11:00:00	MSFT	Stock	372.38	373.38	371.53	373.14	3274133.0
2023-12-01 12:00:00	MSFT	Stock	373.13	375.3	372.25	374.66	2404838.0
2023-12-01 13:00:00	MSFT	Stock	374.6474	374.8456	372.83	373.09	1825311.0
2023-12-01 14:00:00	MSFT	Stock	373.09	375.28	372.8	375.17	1691156.0
2023-12-01 15:00:00	MSFT	Stock	375.1543	375.5799	373.7	374.44	3013524.0
2023-12-01 16:00:00	MSFT	Stock	374.51	374.51	373.56	374.13	3042618.0
2023-12-01 17:00:00	MSFT	Stock	374.06	374.51	374.0	374.48	105110.0
2023-12-01 18:00:00	MSFT	Stock	374.31	374.48	374.1	374.1	9118.0
2023-12-01 19:00:00	MSFT	Stock	374.04	374.48	374.04	374.38	5846.0
2023-12-01 04:00:00	NVDA	Stock	46.764	46.989	46.764	46.902	150310.0
2023-12-01 05:00:00	NVDA	Stock	46.891	46.935	46.85	46.924	37640.0
2023-12-01 06:00:00	NVDA	Stock	46.892	46.976	46.892	46.899	133880.0
2023-12-01 07:00:00	NVDA	Stock	46.882	46.9	46.44	46.457	649530.0
2023-12-01 08:00:00	NVDA	Stock	46.512	46.936	46.44	46.549	1047930.0
2023-12-01 09:00:00	NVDA	Stock	46.52	46.994	46.187	46.591	51646440.0
2023-12-01 10:00:00	NVDA	Stock	46.599	46.825	46.218	46.539	49436030.0
2023-12-01 11:00:00	NVDA	Stock	46.542	47.08	46.409	47.003	42736750.0
2023-12-01 12:00:00	NVDA	Stock	47.009	47.2	46.781	47.097	30102170.0
2023-12-01 13:00:00	NVDA	Stock	47.107	47.132	46.752	46.8072	24689930.0
2023-12-01 14:00:00	NVDA	Stock	46.816	46.88	46.679	46.82	27829150.0
2023-12-01 15:00:00	NVDA	Stock	46.82	46.836	46.657	46.753	27754450.0
2023-12-01 16:00:00	NVDA	Stock	46.748	46.765	46.705	46.747	11253440.0
2023-12-01 17:00:00	NVDA	Stock	46.747	46.765	46.733	46.733	3466870.0
2023-12-01 18:00:00	NVDA	Stock	46.75	46.76	46.741	46.75	163600.0
2023-12-01 19:00:00	NVDA	Stock	46.76	46.81	46.75	46.81	241210.0
2023-12-01 04:00:00	AMZN	Stock	146.21	146.35	146.1	146.22	6109.0
2023-12-01 05:00:00	AMZN	Stock	146.22	146.23	145.99	146.0	1560.0

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

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