PREVIEW / stock_1hour / 2023-10-13

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-13.parquet
  size:    1.3 MB
  rows:    57,929
  symbols: 1,361

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-10-13 04:00:00	AAPL	Stock	181.05	181.12	180.65	180.8	11204.0
2023-10-13 05:00:00	AAPL	Stock	180.73	180.73	180.22	180.22	15048.0
2023-10-13 06:00:00	AAPL	Stock	180.32	180.37	180.04	180.25	16174.0
2023-10-13 07:00:00	AAPL	Stock	180.35	180.45	180.11	180.25	26925.0
2023-10-13 08:00:00	AAPL	Stock	180.1512	181.23	180.1	181.05	97898.0
2023-10-13 09:00:00	AAPL	Stock	181.03	181.93	180.92	181.17	4290131.0
2023-10-13 10:00:00	AAPL	Stock	181.15	181.26	179.3701	179.625	5469604.0
2023-10-13 11:00:00	AAPL	Stock	179.62	179.69	178.47	178.61	5089981.0
2023-10-13 12:00:00	AAPL	Stock	178.6	179.47	178.5301	179.06	3588288.0
2023-10-13 13:00:00	AAPL	Stock	179.06	179.105	178.14	178.82	4620489.0
2023-10-13 14:00:00	AAPL	Stock	178.82	179.54	178.69	179.3399	4465159.0
2023-10-13 15:00:00	AAPL	Stock	179.33	179.74	178.52	178.87	7089667.0
2023-10-13 16:00:00	AAPL	Stock	178.88	178.9	178.55	178.65	6247002.0
2023-10-13 17:00:00	AAPL	Stock	178.6502	178.85	178.54	178.57	87034.0
2023-10-13 18:00:00	AAPL	Stock	178.58	178.65	178.5367	178.64	12107.0
2023-10-13 19:00:00	AAPL	Stock	178.64	178.64	178.4	178.41	11017.0
2023-10-13 04:00:00	MSFT	Stock	331.8	331.8	331.03	331.03	1404.0
2023-10-13 05:00:00	MSFT	Stock	330.77	330.77	328.88	328.88	3810.0
2023-10-13 06:00:00	MSFT	Stock	329.29	329.6	329.29	329.41	3012.0
2023-10-13 07:00:00	MSFT	Stock	329.7	330.04	329.51	330.04	3318.0
2023-10-13 08:00:00	MSFT	Stock	329.77	331.52	329.48	331.28	25620.0
2023-10-13 09:00:00	MSFT	Stock	331.441	333.83	331.0	333.49	1855309.0
2023-10-13 10:00:00	MSFT	Stock	333.53	333.75	330.12	330.19	2149842.0
2023-10-13 11:00:00	MSFT	Stock	330.15	330.4	327.6	327.86	1682099.0
2023-10-13 12:00:00	MSFT	Stock	327.86	328.78	327.1	328.245	1192378.0
2023-10-13 13:00:00	MSFT	Stock	328.22	328.38	326.36	328.22	932222.0
2023-10-13 14:00:00	MSFT	Stock	328.2	329.13	327.7982	328.9486	894994.0
2023-10-13 15:00:00	MSFT	Stock	328.97	329.61	326.97	327.69	2065454.0
2023-10-13 16:00:00	MSFT	Stock	327.68	328.26	327.68	327.83	3872880.0
2023-10-13 17:00:00	MSFT	Stock	327.84	327.924	327.73	327.81	3000.0
2023-10-13 18:00:00	MSFT	Stock	327.8	328.0	327.73	327.75	6572.0
2023-10-13 19:00:00	MSFT	Stock	327.73	327.73	327.3	327.5	1456.0
2023-10-13 04:00:00	NVDA	Stock	46.8	46.881	46.766	46.797	71450.0
2023-10-13 05:00:00	NVDA	Stock	46.788	46.788	46.43	46.43	105590.0
2023-10-13 06:00:00	NVDA	Stock	46.425	46.65	46.353	46.635	124770.0
2023-10-13 07:00:00	NVDA	Stock	46.6	46.78	46.6	46.688	399640.0
2023-10-13 08:00:00	NVDA	Stock	46.632	46.974	46.632	46.93	1540540.0
2023-10-13 09:00:00	NVDA	Stock	46.945	47.116	46.541	46.876	40374570.0
2023-10-13 10:00:00	NVDA	Stock	46.859	46.929	46.4025	46.438	51306440.0
2023-10-13 11:00:00	NVDA	Stock	46.441	46.474	45.955	46.0585	59548840.0
2023-10-13 12:00:00	NVDA	Stock	46.062	46.203	45.881	46.028	34757410.0
2023-10-13 13:00:00	NVDA	Stock	46.013	46.0435	45.405	45.5374	47370050.0
2023-10-13 14:00:00	NVDA	Stock	45.5435	45.65	45.28	45.5676	40298390.0
2023-10-13 15:00:00	NVDA	Stock	45.57	45.757	45.355	45.458	66070560.0
2023-10-13 16:00:00	NVDA	Stock	45.477	45.4779	45.351	45.386	19158260.0
2023-10-13 17:00:00	NVDA	Stock	45.383	45.388	45.37	45.372	217480.0
2023-10-13 18:00:00	NVDA	Stock	45.375	45.375	45.27	45.283	522070.0
2023-10-13 19:00:00	NVDA	Stock	45.279	45.279	45.17	45.19	577030.0
2023-10-13 04:00:00	AMZN	Stock	132.43	132.48	131.71	131.87	8157.0
2023-10-13 05:00:00	AMZN	Stock	131.87	131.87	131.24	131.24	14392.0

> showing 50 of 57,929 rows — these rows as CSV

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