PREVIEW / stock_1hour / 2023-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-13.parquet
  size:    1.4 MB
  rows:    61,587
  symbols: 1,577

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-07-13 04:00:00	AAPL	Stock	190.55	190.86	190.55	190.85	17151.0
2023-07-13 05:00:00	AAPL	Stock	190.83	190.83	190.55	190.67	12285.0
2023-07-13 06:00:00	AAPL	Stock	190.68	190.86	190.65	190.72	6239.0
2023-07-13 07:00:00	AAPL	Stock	190.71	190.8	190.57	190.75	30703.0
2023-07-13 08:00:00	AAPL	Stock	190.69	191.1	190.15	190.95	243432.0
2023-07-13 09:00:00	AAPL	Stock	190.95	191.095	189.94	190.315	5561611.0
2023-07-13 10:00:00	AAPL	Stock	190.31	190.775	189.78	190.32	5247811.0
2023-07-13 11:00:00	AAPL	Stock	190.32	190.71	190.04	190.63	2942271.0
2023-07-13 12:00:00	AAPL	Stock	190.6301	190.845	190.33	190.42	2468861.0
2023-07-13 13:00:00	AAPL	Stock	190.41	190.76	190.3525	190.575	2141964.0
2023-07-13 14:00:00	AAPL	Stock	190.5797	190.8792	190.5	190.67	2424640.0
2023-07-13 15:00:00	AAPL	Stock	190.67	191.19	190.53	190.54	6840076.0
2023-07-13 16:00:00	AAPL	Stock	190.54	190.59	190.32	190.33	4687977.0
2023-07-13 17:00:00	AAPL	Stock	190.36	190.5	190.31	190.45	28621.0
2023-07-13 18:00:00	AAPL	Stock	190.45	190.55	190.33	190.44	23880.0
2023-07-13 19:00:00	AAPL	Stock	190.38	190.5	190.3	190.31	15520.0
2023-07-13 04:00:00	MSFT	Stock	339.12	339.24	338.54	339.14	2377.0
2023-07-13 05:00:00	MSFT	Stock	339.24	339.99	339.21	339.51	2448.0
2023-07-13 06:00:00	MSFT	Stock	339.91	340.04	339.17	339.17	2104.0
2023-07-13 07:00:00	MSFT	Stock	339.4	339.9	339.31	339.43	15390.0
2023-07-13 08:00:00	MSFT	Stock	339.44	340.28	338.46	339.1	87427.0
2023-07-13 09:00:00	MSFT	Stock	339.12	342.47	338.14	340.7081	2926224.0
2023-07-13 10:00:00	MSFT	Stock	340.74	341.53	339.73	341.425	1904773.0
2023-07-13 11:00:00	MSFT	Stock	341.44	341.934	340.69	341.095	1387989.0
2023-07-13 12:00:00	MSFT	Stock	341.12	342.17	340.88	341.14	1351042.0
2023-07-13 13:00:00	MSFT	Stock	341.14	341.43	340.54	341.065	933588.0
2023-07-13 14:00:00	MSFT	Stock	341.05	342.59	340.96	342.12	1493696.0
2023-07-13 15:00:00	MSFT	Stock	342.13	343.74	341.95	342.67	2298663.0
2023-07-13 16:00:00	MSFT	Stock	342.7	342.99	342.31	342.77	2521109.0
2023-07-13 17:00:00	MSFT	Stock	342.75	342.84	341.7	342.5	10228.0
2023-07-13 18:00:00	MSFT	Stock	342.55	342.93	342.5253	342.93	12250.0
2023-07-13 19:00:00	MSFT	Stock	342.71	342.9	342.0	342.8	6255.0
2023-07-13 04:00:00	NVDA	Stock	44.169	44.7	44.169	44.43	444110.0
2023-07-13 05:00:00	NVDA	Stock	44.45	44.602	44.431	44.45	295990.0
2023-07-13 06:00:00	NVDA	Stock	44.45	44.499	44.442	44.469	115450.0
2023-07-13 07:00:00	NVDA	Stock	44.455	44.484	44.28	44.36	1167190.0
2023-07-13 08:00:00	NVDA	Stock	44.4217	44.483	44.275	44.44	2818310.0
2023-07-13 09:00:00	NVDA	Stock	44.44	44.993	44.352	44.8145	67870320.0
2023-07-13 10:00:00	NVDA	Stock	44.8155	44.925	44.57	44.775	47015810.0
2023-07-13 11:00:00	NVDA	Stock	44.78	44.899	44.641	44.758	29582680.0
2023-07-13 12:00:00	NVDA	Stock	44.764	44.943	44.702	44.8943	23686180.0
2023-07-13 13:00:00	NVDA	Stock	44.892	45.119	44.84	45.0959	34550490.0
2023-07-13 14:00:00	NVDA	Stock	45.104	45.488	45.0586	45.475	40883510.0
2023-07-13 15:00:00	NVDA	Stock	45.475	46.155	45.472	45.981	85202400.0
2023-07-13 16:00:00	NVDA	Stock	45.981	46.19	45.97	46.155	18124650.0
2023-07-13 17:00:00	NVDA	Stock	46.158	46.4	46.149	46.335	1690020.0
2023-07-13 18:00:00	NVDA	Stock	46.34	46.426	46.307	46.355	1166570.0
2023-07-13 19:00:00	NVDA	Stock	46.347	46.428	46.333	46.425	926280.0
2023-07-13 04:00:00	AMZN	Stock	131.39	131.75	131.39	131.74	13540.0
2023-07-13 05:00:00	AMZN	Stock	131.8	132.3	131.74	132.1	27140.0

> showing 50 of 61,587 rows — these rows as CSV

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