PREVIEW / stock_1hour / 2023-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-01.parquet
  size:    1.4 MB
  rows:    63,196
  symbols: 1,896

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-02-01 04:00:00	AAPL	Stock	144.29	144.29	144.01	144.08	10600.0
2023-02-01 05:00:00	AAPL	Stock	144.14	144.18	143.9	143.93	11247.0
2023-02-01 06:00:00	AAPL	Stock	144.0	144.1	143.96	144.1	7836.0
2023-02-01 07:00:00	AAPL	Stock	144.06	144.4	144.05	144.34	55915.0
2023-02-01 08:00:00	AAPL	Stock	144.12	144.44	143.8	144.1761	178864.0
2023-02-01 09:00:00	AAPL	Stock	144.2	144.36	142.59	143.19	6161924.0
2023-02-01 10:00:00	AAPL	Stock	143.19	143.3999	142.35	142.59	7070976.0
2023-02-01 11:00:00	AAPL	Stock	142.59	143.02	142.255	142.34	4669651.0
2023-02-01 12:00:00	AAPL	Stock	142.34	142.44	141.72	142.19	5434867.0
2023-02-01 13:00:00	AAPL	Stock	142.18	142.71	141.84	142.48	4347731.0
2023-02-01 14:00:00	AAPL	Stock	142.4493	145.17	141.32	144.355	12841999.0
2023-02-01 15:00:00	AAPL	Stock	144.37	146.61	144.33	145.46	16336675.0
2023-02-01 16:00:00	AAPL	Stock	145.45	146.25	144.71	145.69	9776247.0
2023-02-01 17:00:00	AAPL	Stock	145.6899	146.2	145.62	145.99	207399.0
2023-02-01 18:00:00	AAPL	Stock	145.99	146.3	145.88	146.0	160408.0
2023-02-01 19:00:00	AAPL	Stock	146.0	146.1	145.62	146.07	138959.0
2023-02-01 04:00:00	MSFT	Stock	247.61	247.62	247.13	247.37	2749.0
2023-02-01 05:00:00	MSFT	Stock	247.45	247.45	246.95	246.98	1903.0
2023-02-01 06:00:00	MSFT	Stock	246.99	246.99	246.99	246.99	242.0
2023-02-01 07:00:00	MSFT	Stock	247.25	247.99	247.25	247.89	12453.0
2023-02-01 08:00:00	MSFT	Stock	247.2504	247.99	247.11	247.76	29410.0
2023-02-01 09:00:00	MSFT	Stock	247.86	248.4499	246.23	247.23	1556050.0
2023-02-01 10:00:00	MSFT	Stock	247.26	247.405	245.63	246.15	2546089.0
2023-02-01 11:00:00	MSFT	Stock	246.15	247.29	245.8	247.1899	1064224.0
2023-02-01 12:00:00	MSFT	Stock	247.2	247.318	246.72	246.91	956634.0
2023-02-01 13:00:00	MSFT	Stock	246.9	247.75	246.81	247.15	1188014.0
2023-02-01 14:00:00	MSFT	Stock	247.12	253.12	245.47	252.21	4235563.0
2023-02-01 15:00:00	MSFT	Stock	252.21	255.18	252.02	252.75	6214352.0
2023-02-01 16:00:00	MSFT	Stock	252.75	253.33	251.48	252.28	5538998.0
2023-02-01 17:00:00	MSFT	Stock	251.99	252.28	251.75	251.9	26957.0
2023-02-01 18:00:00	MSFT	Stock	252.17	252.75	251.9	252.29	67773.0
2023-02-01 19:00:00	MSFT	Stock	252.47	252.55	251.8	252.48	30565.0
2023-02-01 04:00:00	NVDA	Stock	19.404	19.504	19.398	19.5	83840.0
2023-02-01 05:00:00	NVDA	Stock	19.44	19.441	19.407	19.423	28840.0
2023-02-01 06:00:00	NVDA	Stock	19.438	19.501	19.438	19.479	84960.0
2023-02-01 07:00:00	NVDA	Stock	19.5	19.625	19.476	19.55	415530.0
2023-02-01 08:00:00	NVDA	Stock	19.6006	19.617	19.399	19.468	927550.0
2023-02-01 09:00:00	NVDA	Stock	19.48	20.0685	19.48	20.021	69223370.0
2023-02-01 10:00:00	NVDA	Stock	20.029	20.224	19.906	19.939	86797260.0
2023-02-01 11:00:00	NVDA	Stock	19.936	20.171	19.86	20.066	56026970.0
2023-02-01 12:00:00	NVDA	Stock	20.067	20.138	19.974	20.121	33870480.0
2023-02-01 13:00:00	NVDA	Stock	20.1215	20.2915	20.084	20.13	42969320.0
2023-02-01 14:00:00	NVDA	Stock	20.118	20.86	19.95	20.7348	110945350.0
2023-02-01 15:00:00	NVDA	Stock	20.7375	21.192	20.726	20.949	112224810.0
2023-02-01 16:00:00	NVDA	Stock	20.943	20.96	20.54	20.936	40638700.0
2023-02-01 17:00:00	NVDA	Stock	20.94	21.13	20.85	21.03	1047660.0
2023-02-01 18:00:00	NVDA	Stock	21.016	21.1	21.01	21.023	528030.0
2023-02-01 19:00:00	NVDA	Stock	21.027	21.068	20.888	21.068	846190.0
2023-02-01 04:00:00	AMZN	Stock	102.76	102.98	102.76	102.79	11560.0
2023-02-01 05:00:00	AMZN	Stock	102.71	102.85	102.46	102.51	12247.0

> showing 50 of 63,196 rows — these rows as CSV

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