PREVIEW / stock_1hour / 2023-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-28.parquet
  size:    1.3 MB
  rows:    57,881
  symbols: 1,443

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-08-28 04:00:00	AAPL	Stock	178.8	179.08	178.77	178.88	6332.0
2023-08-28 05:00:00	AAPL	Stock	178.9	178.9	178.49	178.52	12305.0
2023-08-28 06:00:00	AAPL	Stock	178.53	178.66	178.46	178.58	2917.0
2023-08-28 07:00:00	AAPL	Stock	178.57	179.08	178.57	179.08	18047.0
2023-08-28 08:00:00	AAPL	Stock	178.5684	179.8	178.5684	179.77	153262.0
2023-08-28 09:00:00	AAPL	Stock	179.78	180.28	178.92	179.29	4353576.0
2023-08-28 10:00:00	AAPL	Stock	179.29	179.93	178.68	179.015	5347361.0
2023-08-28 11:00:00	AAPL	Stock	179.01	179.13	178.545	178.91	3287484.0
2023-08-28 12:00:00	AAPL	Stock	178.9	179.61	178.7201	179.6	2483884.0
2023-08-28 13:00:00	AAPL	Stock	179.61	180.1399	179.1384	179.34	3772352.0
2023-08-28 14:00:00	AAPL	Stock	179.34	179.85	179.24	179.82	2576140.0
2023-08-28 15:00:00	AAPL	Stock	179.82	180.59	179.73	180.21	6279973.0
2023-08-28 16:00:00	AAPL	Stock	180.19	180.24	179.96	180.08	5549384.0
2023-08-28 17:00:00	AAPL	Stock	180.1	180.25	180.08	180.25	38192.0
2023-08-28 18:00:00	AAPL	Stock	180.23	180.4	180.23	180.38	18854.0
2023-08-28 19:00:00	AAPL	Stock	180.33	180.47	180.25	180.25	31864.0
2023-08-28 04:00:00	MSFT	Stock	323.15	323.88	322.74	323.72	6270.0
2023-08-28 05:00:00	MSFT	Stock	323.6	323.6	322.82	323.51	3007.0
2023-08-28 06:00:00	MSFT	Stock	323.01	323.5	323.01	323.5	529.0
2023-08-28 07:00:00	MSFT	Stock	323.55	323.84	323.5	323.84	1572.0
2023-08-28 08:00:00	MSFT	Stock	323.42	325.25	322.173	325.25	31414.0
2023-08-28 09:00:00	MSFT	Stock	325.25	326.15	322.3642	323.35	1333414.0
2023-08-28 10:00:00	MSFT	Stock	323.355	324.67	322.11	323.03	1390490.0
2023-08-28 11:00:00	MSFT	Stock	323.0354	323.5	322.04	322.84	940006.0
2023-08-28 12:00:00	MSFT	Stock	322.84	324.12	322.39	324.055	769715.0
2023-08-28 13:00:00	MSFT	Stock	324.05	325.0	321.9	322.21	869747.0
2023-08-28 14:00:00	MSFT	Stock	322.21	322.82	321.722	322.6	880660.0
2023-08-28 15:00:00	MSFT	Stock	322.62	324.07	322.23	323.74	1846443.0
2023-08-28 16:00:00	MSFT	Stock	323.7	323.98	323.7	323.8995	2179864.0
2023-08-28 17:00:00	MSFT	Stock	323.92	324.1001	323.92	324.1	7742.0
2023-08-28 18:00:00	MSFT	Stock	324.15	324.2	323.94	324.1	6963.0
2023-08-28 19:00:00	MSFT	Stock	324.08	324.08	323.8	323.8	2103.0
2023-08-28 04:00:00	NVDA	Stock	46.441	46.537	46.2	46.458	187580.0
2023-08-28 05:00:00	NVDA	Stock	46.455	46.47	46.329	46.329	103760.0
2023-08-28 06:00:00	NVDA	Stock	46.37	46.401	46.3	46.313	45530.0
2023-08-28 07:00:00	NVDA	Stock	46.302	46.35	45.892	45.986	686460.0
2023-08-28 08:00:00	NVDA	Stock	46.3	46.66	45.891	46.188	3669300.0
2023-08-28 09:00:00	NVDA	Stock	46.198	46.5	44.888	45.3779	88247830.0
2023-08-28 10:00:00	NVDA	Stock	45.3655	45.904	45.2662	45.561	86764970.0
2023-08-28 11:00:00	NVDA	Stock	45.572	46.024	45.485	45.742	65197580.0
2023-08-28 12:00:00	NVDA	Stock	45.741	46.361	45.693	46.3495	56100230.0
2023-08-28 13:00:00	NVDA	Stock	46.3503	46.963	46.34	46.495	87887560.0
2023-08-28 14:00:00	NVDA	Stock	46.4935	46.874	46.431	46.829	56248360.0
2023-08-28 15:00:00	NVDA	Stock	46.829	46.98	46.461	46.8268	73358630.0
2023-08-28 16:00:00	NVDA	Stock	46.817	46.84	46.658	46.687	14411380.0
2023-08-28 17:00:00	NVDA	Stock	46.717	46.73	46.641	46.7	624400.0
2023-08-28 18:00:00	NVDA	Stock	46.69	46.744	46.681	46.73	393530.0
2023-08-28 19:00:00	NVDA	Stock	46.707	46.707	46.6	46.6	763890.0
2023-08-28 04:00:00	AMZN	Stock	133.22	133.61	133.22	133.54	6418.0
2023-08-28 05:00:00	AMZN	Stock	133.55	133.57	133.42	133.56	3589.0

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

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