PREVIEW / stock_1hour / 2023-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-31.parquet
  size:    1.3 MB
  rows:    59,430
  symbols: 1,458

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-31 04:00:00	AAPL	Stock	187.8	187.83	187.65	187.7	7814.0
2023-08-31 05:00:00	AAPL	Stock	187.71	187.74	187.21	187.29	22717.0
2023-08-31 06:00:00	AAPL	Stock	187.3	187.67	187.3	187.56	6772.0
2023-08-31 07:00:00	AAPL	Stock	187.56	188.35	187.44	188.25	35742.0
2023-08-31 08:00:00	AAPL	Stock	187.59	188.36	187.2851	187.8	268698.0
2023-08-31 09:00:00	AAPL	Stock	187.84	188.5099	187.45	188.0544	5167145.0
2023-08-31 10:00:00	AAPL	Stock	188.08	188.76	187.65	188.485	5451408.0
2023-08-31 11:00:00	AAPL	Stock	188.49	188.6481	188.095	188.225	3344211.0
2023-08-31 12:00:00	AAPL	Stock	188.23	188.48	187.48	187.82	4008061.0
2023-08-31 13:00:00	AAPL	Stock	187.82	188.19	187.74	188.02	3039819.0
2023-08-31 14:00:00	AAPL	Stock	188.015	188.69	187.98	188.51	3925431.0
2023-08-31 15:00:00	AAPL	Stock	188.5	189.12	187.75	187.87	10597989.0
2023-08-31 16:00:00	AAPL	Stock	187.88	188.25	187.63	188.13	13553919.0
2023-08-31 17:00:00	AAPL	Stock	188.13	188.24	188.0	188.12	68450.0
2023-08-31 18:00:00	AAPL	Stock	188.14	188.25	187.9665	188.07	23650.0
2023-08-31 19:00:00	AAPL	Stock	188.05	188.2	187.91	188.11	24396.0
2023-08-31 04:00:00	MSFT	Stock	329.59	329.7	329.19	329.59	1239.0
2023-08-31 05:00:00	MSFT	Stock	329.13	329.13	328.7	328.7	4298.0
2023-08-31 06:00:00	MSFT	Stock	328.7	328.88	328.7	328.88	800.0
2023-08-31 07:00:00	MSFT	Stock	328.7	329.3	328.7	329.3	2850.0
2023-08-31 08:00:00	MSFT	Stock	328.72	329.6	328.01	328.9	36125.0
2023-08-31 09:00:00	MSFT	Stock	328.9	330.9099	328.0	329.05	1608123.0
2023-08-31 10:00:00	MSFT	Stock	329.08	330.07	327.58	328.3	1540640.0
2023-08-31 11:00:00	MSFT	Stock	328.28	328.4	327.09	327.95	1458905.0
2023-08-31 12:00:00	MSFT	Stock	327.95	328.08	326.78	327.47	1088985.0
2023-08-31 13:00:00	MSFT	Stock	327.49	328.57	327.28	328.3934	794771.0
2023-08-31 14:00:00	MSFT	Stock	328.375	329.03	327.58	327.76	856363.0
2023-08-31 15:00:00	MSFT	Stock	327.76	328.98	327.57	327.75	2103716.0
2023-08-31 16:00:00	MSFT	Stock	327.79	328.5	327.51	327.78	9770790.0
2023-08-31 17:00:00	MSFT	Stock	327.83	327.84	327.61	327.63	3284.0
2023-08-31 18:00:00	MSFT	Stock	327.8	328.21	327.67	327.95	8717.0
2023-08-31 19:00:00	MSFT	Stock	328.0	328.4	328.0	328.31	5100.0
2023-08-31 04:00:00	NVDA	Stock	49.331	49.35	48.8	49.22	219270.0
2023-08-31 05:00:00	NVDA	Stock	49.2	49.229	49.1	49.133	85350.0
2023-08-31 06:00:00	NVDA	Stock	49.165	49.233	49.155	49.232	34060.0
2023-08-31 07:00:00	NVDA	Stock	49.25	49.446	49.215	49.38	763750.0
2023-08-31 08:00:00	NVDA	Stock	49.256	49.569	49.21	49.377	3192160.0
2023-08-31 09:00:00	NVDA	Stock	49.4114	49.74	49.188	49.702	62495780.0
2023-08-31 10:00:00	NVDA	Stock	49.714	49.744	49.28	49.496	58636680.0
2023-08-31 11:00:00	NVDA	Stock	49.496	49.665	49.409	49.64	40469060.0
2023-08-31 12:00:00	NVDA	Stock	49.641	49.6462	48.958	49.159	54230930.0
2023-08-31 13:00:00	NVDA	Stock	49.159	49.44	49.108	49.284	36178080.0
2023-08-31 14:00:00	NVDA	Stock	49.2845	49.518	49.275	49.4635	39876380.0
2023-08-31 15:00:00	NVDA	Stock	49.457	49.706	49.36	49.365	59603560.0
2023-08-31 16:00:00	NVDA	Stock	49.365	49.4	49.05	49.219	49015950.0
2023-08-31 17:00:00	NVDA	Stock	49.223	49.25	49.14	49.23	672410.0
2023-08-31 18:00:00	NVDA	Stock	49.235	49.235	49.1039	49.131	452750.0
2023-08-31 19:00:00	NVDA	Stock	49.106	49.148	49.052	49.135	708520.0
2023-08-31 04:00:00	AMZN	Stock	135.12	135.26	135.12	135.22	4145.0
2023-08-31 05:00:00	AMZN	Stock	135.18	135.18	134.88	134.91	4183.0

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

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