PREVIEW / stock_1hour / 2023-10-09

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-09.parquet
  size:    1.3 MB
  rows:    57,606
  symbols: 1,360

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-09 04:00:00	AAPL	Stock	176.0	176.3	175.73	176.18	21667.0
2023-10-09 05:00:00	AAPL	Stock	176.1	176.17	175.84	175.88	10388.0
2023-10-09 06:00:00	AAPL	Stock	175.99	176.35	175.99	176.0	28748.0
2023-10-09 07:00:00	AAPL	Stock	175.98	176.08	175.85	176.01	49984.0
2023-10-09 08:00:00	AAPL	Stock	175.94	176.4899	175.5	176.3387	195733.0
2023-10-09 09:00:00	AAPL	Stock	176.35	177.299	175.8	177.18	4756039.0
2023-10-09 10:00:00	AAPL	Stock	177.18	177.36	176.2006	176.37	4772477.0
2023-10-09 11:00:00	AAPL	Stock	176.365	177.23	176.19	177.195	3764743.0
2023-10-09 12:00:00	AAPL	Stock	177.2	178.07	177.18	177.6	3700214.0
2023-10-09 13:00:00	AAPL	Stock	177.61	178.79	177.56	178.72	3650394.0
2023-10-09 14:00:00	AAPL	Stock	178.72	179.04	178.42	178.8879	4374568.0
2023-10-09 15:00:00	AAPL	Stock	178.89	179.05	178.665	179.0	6116696.0
2023-10-09 16:00:00	AAPL	Stock	178.99	179.01	178.81	178.87	4525126.0
2023-10-09 17:00:00	AAPL	Stock	178.84	178.9	178.81	178.82	10805.0
2023-10-09 18:00:00	AAPL	Stock	178.87	178.89	178.79	178.85	17425.0
2023-10-09 19:00:00	AAPL	Stock	178.85	179.0	178.82	178.88	20970.0
2023-10-09 04:00:00	MSFT	Stock	324.0	326.6	324.0	326.52	10376.0
2023-10-09 05:00:00	MSFT	Stock	326.46	326.49	325.61	325.9	2873.0
2023-10-09 06:00:00	MSFT	Stock	325.9	326.33	325.58	326.33	6991.0
2023-10-09 07:00:00	MSFT	Stock	326.33	326.4	324.85	325.03	38390.0
2023-10-09 08:00:00	MSFT	Stock	326.21	326.4166	323.77	325.11	73766.0
2023-10-09 09:00:00	MSFT	Stock	325.1077	327.37	323.18	327.0111	2652386.0
2023-10-09 10:00:00	MSFT	Stock	326.995	327.96	325.68	326.17	2173382.0
2023-10-09 11:00:00	MSFT	Stock	326.13	327.605	325.388	327.47	1016356.0
2023-10-09 12:00:00	MSFT	Stock	327.475	328.46	327.19	327.885	1268686.0
2023-10-09 13:00:00	MSFT	Stock	327.88	330.22	327.84	330.2	1255834.0
2023-10-09 14:00:00	MSFT	Stock	330.22	330.3	329.0585	329.79	1308565.0
2023-10-09 15:00:00	MSFT	Stock	329.8	330.07	329.21	329.82	1785986.0
2023-10-09 16:00:00	MSFT	Stock	329.82	330.15	329.35	329.6202	2765734.0
2023-10-09 17:00:00	MSFT	Stock	329.622	330.0	329.622	329.8	3007.0
2023-10-09 18:00:00	MSFT	Stock	329.98	330.19	329.75	330.19	5718.0
2023-10-09 19:00:00	MSFT	Stock	330.19	330.4899	330.0	330.45	8243.0
2023-10-09 04:00:00	NVDA	Stock	44.986	45.009	44.73	44.8	922130.0
2023-10-09 05:00:00	NVDA	Stock	44.78	44.813	44.6	44.631	560050.0
2023-10-09 06:00:00	NVDA	Stock	44.637	44.729	44.587	44.701	443010.0
2023-10-09 07:00:00	NVDA	Stock	44.699	44.963	44.645	44.955	1778710.0
2023-10-09 08:00:00	NVDA	Stock	44.699	44.974	44.6	44.847	3037560.0
2023-10-09 09:00:00	NVDA	Stock	44.86	45.05	44.46	44.782	62673650.0
2023-10-09 10:00:00	NVDA	Stock	44.7875	44.87	44.418	44.481	49979400.0
2023-10-09 11:00:00	NVDA	Stock	44.481	44.659	44.368	44.627	30132330.0
2023-10-09 12:00:00	NVDA	Stock	44.631	44.87	44.593	44.8555	26522670.0
2023-10-09 13:00:00	NVDA	Stock	44.86	45.475	44.808	45.4699	42118570.0
2023-10-09 14:00:00	NVDA	Stock	45.471	45.605	45.291	45.5065	42462310.0
2023-10-09 15:00:00	NVDA	Stock	45.509	45.5414	45.174	45.273	42644480.0
2023-10-09 16:00:00	NVDA	Stock	45.273	45.273	45.14	45.234	12489460.0
2023-10-09 17:00:00	NVDA	Stock	45.228	45.245	45.181	45.2	195740.0
2023-10-09 18:00:00	NVDA	Stock	45.2	45.22	45.182	45.205	112150.0
2023-10-09 19:00:00	NVDA	Stock	45.201	45.201	45.147	45.17	295290.0
2023-10-09 04:00:00	AMZN	Stock	126.0	126.94	126.0	126.76	53931.0
2023-10-09 05:00:00	AMZN	Stock	126.66	126.81	126.44	126.44	11385.0

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

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