PREVIEW / stock_1hour / 2023-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-28.parquet
  size:    1.3 MB
  rows:    59,870
  symbols: 1,529

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-28 04:00:00	AAPL	Stock	194.03	194.67	194.03	194.67	17281.0
2023-07-28 05:00:00	AAPL	Stock	194.55	194.9	194.44	194.9	7524.0
2023-07-28 06:00:00	AAPL	Stock	194.9	194.9	194.65	194.88	6364.0
2023-07-28 07:00:00	AAPL	Stock	194.76	194.79	194.6	194.69	28268.0
2023-07-28 08:00:00	AAPL	Stock	194.75	195.2	193.84	195.05	189580.0
2023-07-28 09:00:00	AAPL	Stock	195.05	195.98	194.14	195.65	5277834.0
2023-07-28 10:00:00	AAPL	Stock	195.66	196.15	195.31	195.72	5473963.0
2023-07-28 11:00:00	AAPL	Stock	195.73	196.626	195.7	196.51	3955872.0
2023-07-28 12:00:00	AAPL	Stock	196.52	196.52	195.88	195.945	2846205.0
2023-07-28 13:00:00	AAPL	Stock	195.94	195.95	195.03	195.725	2959341.0
2023-07-28 14:00:00	AAPL	Stock	195.73	196.2	195.545	195.93	2838056.0
2023-07-28 15:00:00	AAPL	Stock	195.925	196.15	195.42	195.84	6668032.0
2023-07-28 16:00:00	AAPL	Stock	195.83	195.86	195.44	195.66	7095508.0
2023-07-28 17:00:00	AAPL	Stock	195.66	195.83	195.63	195.77	348520.0
2023-07-28 18:00:00	AAPL	Stock	195.73	195.86	195.73	195.85	16259.0
2023-07-28 19:00:00	AAPL	Stock	195.85	195.94	195.78	195.89	13874.0
2023-07-28 04:00:00	MSFT	Stock	332.01	333.33	332.01	333.0	7409.0
2023-07-28 05:00:00	MSFT	Stock	332.91	333.2	332.9	333.2	6155.0
2023-07-28 06:00:00	MSFT	Stock	333.4	334.05	333.4	334.01	9686.0
2023-07-28 07:00:00	MSFT	Stock	333.84	333.85	333.11	333.33	32749.0
2023-07-28 08:00:00	MSFT	Stock	333.87	333.885	332.0	333.36	128407.0
2023-07-28 09:00:00	MSFT	Stock	333.22	337.07	332.97	335.67	4186653.0
2023-07-28 10:00:00	MSFT	Stock	335.72	337.66	335.1401	336.24	3210957.0
2023-07-28 11:00:00	MSFT	Stock	336.26	340.01	336.26	339.25	2696787.0
2023-07-28 12:00:00	MSFT	Stock	339.1701	339.4	338.07	338.69	1786067.0
2023-07-28 13:00:00	MSFT	Stock	338.65	338.7599	336.93	338.65	1407208.0
2023-07-28 14:00:00	MSFT	Stock	338.61	339.26	337.44	338.95	1426756.0
2023-07-28 15:00:00	MSFT	Stock	338.94	339.39	337.71	338.35	2934290.0
2023-07-28 16:00:00	MSFT	Stock	338.37	338.37	337.54	338.0	3853903.0
2023-07-28 17:00:00	MSFT	Stock	337.98	338.37	337.78	338.0	152053.0
2023-07-28 18:00:00	MSFT	Stock	337.99	338.3	337.99	338.24	8171.0
2023-07-28 19:00:00	MSFT	Stock	338.25	338.34	338.05	338.1	6299.0
2023-07-28 04:00:00	NVDA	Stock	46.48	46.7	46.385	46.459	166200.0
2023-07-28 05:00:00	NVDA	Stock	46.436	46.55	46.408	46.536	69670.0
2023-07-28 06:00:00	NVDA	Stock	46.59	46.59	46.52	46.55	62890.0
2023-07-28 07:00:00	NVDA	Stock	46.53	46.78	46.478	46.6	886570.0
2023-07-28 08:00:00	NVDA	Stock	46.5	46.76	46.12	46.603	2013650.0
2023-07-28 09:00:00	NVDA	Stock	46.6039	46.7465	46.381	46.4966	36587290.0
2023-07-28 10:00:00	NVDA	Stock	46.505	46.923	46.504	46.7445	43403790.0
2023-07-28 11:00:00	NVDA	Stock	46.748	47.027	46.599	46.918	33468340.0
2023-07-28 12:00:00	NVDA	Stock	46.915	46.963	46.711	46.771	26592980.0
2023-07-28 13:00:00	NVDA	Stock	46.766	46.766	46.41	46.7053	28884030.0
2023-07-28 14:00:00	NVDA	Stock	46.705	46.765	46.4544	46.601	23817900.0
2023-07-28 15:00:00	NVDA	Stock	46.6045	46.848	46.525	46.744	37277240.0
2023-07-28 16:00:00	NVDA	Stock	46.75	46.81	46.74	46.7837	20339490.0
2023-07-28 17:00:00	NVDA	Stock	46.785	46.82	46.75	46.775	752060.0
2023-07-28 18:00:00	NVDA	Stock	46.785	46.85	46.78	46.84	311780.0
2023-07-28 19:00:00	NVDA	Stock	46.82	46.868	46.815	46.845	378590.0
2023-07-28 04:00:00	AMZN	Stock	129.34	129.9	129.34	129.8	24734.0
2023-07-28 05:00:00	AMZN	Stock	129.77	130.19	129.68	130.17	21514.0

> showing 50 of 59,870 rows — these rows as CSV

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