PREVIEW / stock_1hour / 2023-01-30

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-30.parquet
  size:    1.4 MB
  rows:    62,501
  symbols: 1,928

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-01-30 04:00:00	AAPL	Stock	145.54	145.54	143.92	144.13	48782.0
2023-01-30 05:00:00	AAPL	Stock	144.12	144.16	143.97	144.0	12725.0
2023-01-30 06:00:00	AAPL	Stock	144.03	144.07	143.56	143.93	22152.0
2023-01-30 07:00:00	AAPL	Stock	143.95	144.89	143.95	144.8	80090.0
2023-01-30 08:00:00	AAPL	Stock	144.31	145.64	144.0	144.859	360751.0
2023-01-30 09:00:00	AAPL	Stock	144.8573	145.55	144.171	145.185	7074896.0
2023-01-30 10:00:00	AAPL	Stock	145.18	145.35	143.37	143.995	8251474.0
2023-01-30 11:00:00	AAPL	Stock	143.99	144.32	143.5	144.1882	5063451.0
2023-01-30 12:00:00	AAPL	Stock	144.18	144.26	143.15	143.415	5592074.0
2023-01-30 13:00:00	AAPL	Stock	143.41	143.82	143.01	143.375	4447140.0
2023-01-30 14:00:00	AAPL	Stock	143.3703	143.5899	142.881	143.19	5564402.0
2023-01-30 15:00:00	AAPL	Stock	143.19	143.52	142.85	143.03	9984039.0
2023-01-30 16:00:00	AAPL	Stock	143.0	143.4584	142.9967	143.11	8308944.0
2023-01-30 17:00:00	AAPL	Stock	143.12	144.9	142.94	142.95	35292.0
2023-01-30 18:00:00	AAPL	Stock	143.06	143.32	143.03	143.2	27796.0
2023-01-30 19:00:00	AAPL	Stock	143.2	143.2	143.0	143.0	26958.0
2023-01-30 04:00:00	MSFT	Stock	246.0	246.49	245.0	245.3	6363.0
2023-01-30 05:00:00	MSFT	Stock	245.2	245.34	245.16	245.24	2465.0
2023-01-30 06:00:00	MSFT	Stock	245.24	245.24	244.14	244.27	5853.0
2023-01-30 07:00:00	MSFT	Stock	244.86	245.0	244.41	244.77	49257.0
2023-01-30 08:00:00	MSFT	Stock	244.9011	247.8	244.03	244.55	49193.0
2023-01-30 09:00:00	MSFT	Stock	244.55	245.6	243.56	244.76	2492535.0
2023-01-30 10:00:00	MSFT	Stock	244.72	245.0472	242.26	242.992	2941888.0
2023-01-30 11:00:00	MSFT	Stock	243.0	244.08	242.695	243.67	1592661.0
2023-01-30 12:00:00	MSFT	Stock	243.67	244.1099	242.62	242.94	1356643.0
2023-01-30 13:00:00	MSFT	Stock	242.94	243.58	242.47	242.8945	1330644.0
2023-01-30 14:00:00	MSFT	Stock	242.8868	243.17	242.2	242.62	1429887.0
2023-01-30 15:00:00	MSFT	Stock	242.615	243.61	242.2192	242.76	3332516.0
2023-01-30 16:00:00	MSFT	Stock	242.71	243.2685	242.5	242.5	4950282.0
2023-01-30 17:00:00	MSFT	Stock	242.8	244.33	242.55	242.55	95517.0
2023-01-30 18:00:00	MSFT	Stock	242.7	243.5	242.69	243.5	9691.0
2023-01-30 19:00:00	MSFT	Stock	243.2	243.3	242.98	243.3	6546.0
2023-01-30 04:00:00	NVDA	Stock	20.085	20.085	19.865	19.9	173990.0
2023-01-30 05:00:00	NVDA	Stock	19.885	19.92	19.867	19.889	53070.0
2023-01-30 06:00:00	NVDA	Stock	19.89	19.89	19.81	19.815	111080.0
2023-01-30 07:00:00	NVDA	Stock	19.815	20.023	19.815	20.014	657120.0
2023-01-30 08:00:00	NVDA	Stock	19.849	20.3141	19.8395	19.95	1868790.0
2023-01-30 09:00:00	NVDA	Stock	19.955	20.14	19.8175	19.9246	62490690.0
2023-01-30 10:00:00	NVDA	Stock	19.925	19.9795	19.425	19.603	79134620.0
2023-01-30 11:00:00	NVDA	Stock	19.6	19.7115	19.516	19.6389	48424290.0
2023-01-30 12:00:00	NVDA	Stock	19.637	19.677	19.398	19.4455	44794740.0
2023-01-30 13:00:00	NVDA	Stock	19.446	19.571	19.3525	19.4167	40804390.0
2023-01-30 14:00:00	NVDA	Stock	19.417	19.459	19.358	19.408	29587070.0
2023-01-30 15:00:00	NVDA	Stock	19.407	19.444	19.15	19.161	66646640.0
2023-01-30 16:00:00	NVDA	Stock	19.162	19.4733	19.15	19.175	24243910.0
2023-01-30 17:00:00	NVDA	Stock	19.169	19.957	19.131	19.14	955590.0
2023-01-30 18:00:00	NVDA	Stock	19.152	19.185	19.145	19.181	344810.0
2023-01-30 19:00:00	NVDA	Stock	19.184	19.185	19.14	19.14	205460.0
2023-01-30 04:00:00	AMZN	Stock	100.8	102.08	100.24	100.4	56698.0
2023-01-30 05:00:00	AMZN	Stock	100.35	101.0	100.31	100.8	57421.0

> showing 50 of 62,501 rows — these rows as CSV

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