PREVIEW / stock_1hour / 2023-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-08.parquet
  size:    1.3 MB
  rows:    59,819
  symbols: 1,621

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-06-08 04:00:00	AAPL	Stock	177.69	177.77	177.21	177.77	10358.0
2023-06-08 05:00:00	AAPL	Stock	177.82	178.27	177.82	178.27	11363.0
2023-06-08 06:00:00	AAPL	Stock	178.01	178.36	177.83	177.91	9117.0
2023-06-08 07:00:00	AAPL	Stock	177.94	178.1	177.52	177.75	46851.0
2023-06-08 08:00:00	AAPL	Stock	177.99	178.5	176.58	177.96	190746.0
2023-06-08 09:00:00	AAPL	Stock	177.93	178.75	177.51	177.86	5029505.0
2023-06-08 10:00:00	AAPL	Stock	177.865	179.19	177.46	179.11	6194877.0
2023-06-08 11:00:00	AAPL	Stock	179.12	179.88	178.971	179.5099	4468688.0
2023-06-08 12:00:00	AAPL	Stock	179.505	180.0	179.31	179.615	3386707.0
2023-06-08 13:00:00	AAPL	Stock	179.615	179.87	179.01	179.53	2871677.0
2023-06-08 14:00:00	AAPL	Stock	179.54	180.24	179.466	179.926	4374575.0
2023-06-08 15:00:00	AAPL	Stock	179.93	180.84	179.73	180.55	7773819.0
2023-06-08 16:00:00	AAPL	Stock	180.54	180.6868	180.5	180.56	5837996.0
2023-06-08 17:00:00	AAPL	Stock	180.57	180.57	180.43	180.47	58631.0
2023-06-08 18:00:00	AAPL	Stock	180.47	180.56	180.4229	180.43	48009.0
2023-06-08 19:00:00	AAPL	Stock	180.45	180.52	180.32	180.5	42257.0
2023-06-08 04:00:00	MSFT	Stock	322.0	322.76	321.4	322.63	6213.0
2023-06-08 05:00:00	MSFT	Stock	322.9	323.42	322.55	323.42	5264.0
2023-06-08 06:00:00	MSFT	Stock	323.45	323.9	323.01	323.01	5456.0
2023-06-08 07:00:00	MSFT	Stock	323.36	323.52	322.65	322.85	14778.0
2023-06-08 08:00:00	MSFT	Stock	322.2	324.46	320.0	323.71	60480.0
2023-06-08 09:00:00	MSFT	Stock	323.78	325.21	323.32	324.2599	2858325.0
2023-06-08 10:00:00	MSFT	Stock	324.3	326.04	323.5	325.81	2558664.0
2023-06-08 11:00:00	MSFT	Stock	325.81	326.52	325.61	326.16	1657613.0
2023-06-08 12:00:00	MSFT	Stock	326.13	326.64	324.64	324.923	1363363.0
2023-06-08 13:00:00	MSFT	Stock	324.905	325.045	323.5	323.99	1303813.0
2023-06-08 14:00:00	MSFT	Stock	323.995	325.24	323.82	325.16	1040074.0
2023-06-08 15:00:00	MSFT	Stock	325.16	325.95	323.82	325.22	2060159.0
2023-06-08 16:00:00	MSFT	Stock	325.23	325.91	324.81	325.25	3210111.0
2023-06-08 17:00:00	MSFT	Stock	325.24	325.49	324.8	325.11	28359.0
2023-06-08 18:00:00	MSFT	Stock	325.08	325.08	324.08	324.25	16749.0
2023-06-08 19:00:00	MSFT	Stock	324.2	324.2	323.39	323.69	13563.0
2023-06-08 04:00:00	NVDA	Stock	37.618	37.902	37.618	37.738	228690.0
2023-06-08 05:00:00	NVDA	Stock	37.76	37.81	37.76	37.799	56950.0
2023-06-08 06:00:00	NVDA	Stock	37.791	37.92	37.783	37.81	107230.0
2023-06-08 07:00:00	NVDA	Stock	37.79	37.81	37.653	37.71	305270.0
2023-06-08 08:00:00	NVDA	Stock	37.797	37.82	37.374	37.755	1929690.0
2023-06-08 09:00:00	NVDA	Stock	37.76	38.36	37.505	38.246	58465440.0
2023-06-08 10:00:00	NVDA	Stock	38.25	38.373	37.96	38.328	55375850.0
2023-06-08 11:00:00	NVDA	Stock	38.335	38.779	38.321	38.689	44347960.0
2023-06-08 12:00:00	NVDA	Stock	38.686	38.864	38.545	38.6369	34178680.0
2023-06-08 13:00:00	NVDA	Stock	38.6407	38.7161	38.276	38.4195	34131130.0
2023-06-08 14:00:00	NVDA	Stock	38.421	38.715	38.37	38.689	29342550.0
2023-06-08 15:00:00	NVDA	Stock	38.695	38.75	38.382	38.51	42039720.0
2023-06-08 16:00:00	NVDA	Stock	38.51	38.543	38.497	38.538	19195550.0
2023-06-08 17:00:00	NVDA	Stock	38.541	38.67	38.53	38.66	350910.0
2023-06-08 18:00:00	NVDA	Stock	38.645	38.6786	38.6	38.6765	296100.0
2023-06-08 19:00:00	NVDA	Stock	38.65	38.65	38.593	38.645	405740.0
2023-06-08 04:00:00	AMZN	Stock	121.59	121.59	120.98	121.37	22905.0
2023-06-08 05:00:00	AMZN	Stock	121.41	121.82	121.31	121.81	10546.0

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

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