PREVIEW / stock_1hour / 2024-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-11-13.parquet
  size:    1.4 MB
  rows:    62,069
  symbols: 708

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
2024-11-13 04:00:00	AAPL	Stock	223.88	224.05	223.57	223.75	5608.0
2024-11-13 05:00:00	AAPL	Stock	223.83	223.84	223.55	223.59	3325.0
2024-11-13 06:00:00	AAPL	Stock	223.59	223.59	223.12	223.15	5220.0
2024-11-13 07:00:00	AAPL	Stock	223.3	223.55	223.2	223.52	21954.0
2024-11-13 08:00:00	AAPL	Stock	223.35	224.18	223.27	223.52	111561.0
2024-11-13 09:00:00	AAPL	Stock	223.5	225.2099	222.76	223.54	3507341.0
2024-11-13 10:00:00	AAPL	Stock	223.55	224.31	223.15	224.05	3253737.0
2024-11-13 11:00:00	AAPL	Stock	224.05	224.6	223.77	224.55	2340346.0
2024-11-13 12:00:00	AAPL	Stock	224.555	226.61	224.555	226.521	2988006.0
2024-11-13 13:00:00	AAPL	Stock	226.53	226.65	225.82	226.025	1983230.0
2024-11-13 14:00:00	AAPL	Stock	226.03	226.23	225.34	225.43	1699077.0
2024-11-13 15:00:00	AAPL	Stock	225.42	225.93	224.42	225.22	4875862.0
2024-11-13 16:00:00	AAPL	Stock	225.12	225.5	224.92	225.27	10168464.0
2024-11-13 17:00:00	AAPL	Stock	225.3	225.3	225.05	225.0503	7029.0
2024-11-13 18:00:00	AAPL	Stock	225.14	225.15	224.95	224.9699	14028.0
2024-11-13 19:00:00	AAPL	Stock	224.9	224.9898	224.73	224.73	15478.0
2024-11-13 04:00:00	MSFT	Stock	423.03	423.03	422.02	422.3	5390.0
2024-11-13 05:00:00	MSFT	Stock	422.23	422.23	421.1	421.52	2157.0
2024-11-13 06:00:00	MSFT	Stock	421.2	421.45	421.11	421.45	2536.0
2024-11-13 07:00:00	MSFT	Stock	421.27	422.06	421.27	421.61	8146.0
2024-11-13 08:00:00	MSFT	Stock	421.29	423.0439	421.27	421.84	36852.0
2024-11-13 09:00:00	MSFT	Stock	421.72	422.47	418.65	419.15	1300529.0
2024-11-13 10:00:00	MSFT	Stock	419.21	420.53	418.21	419.83	1254468.0
2024-11-13 11:00:00	MSFT	Stock	419.83	425.57	419.55	424.79	1166886.0
2024-11-13 12:00:00	MSFT	Stock	424.73	428.73	424.5401	428.5646	1233557.0
2024-11-13 13:00:00	MSFT	Stock	428.593	429.325	427.3838	428.88	938076.0
2024-11-13 14:00:00	MSFT	Stock	428.82	428.86	426.29	426.45	924961.0
2024-11-13 15:00:00	MSFT	Stock	426.475	426.5	423.71	425.34	1992588.0
2024-11-13 16:00:00	MSFT	Stock	425.2	425.88	424.49	425.36	3931142.0
2024-11-13 17:00:00	MSFT	Stock	425.2	425.34	425.09	425.2512	363908.0
2024-11-13 18:00:00	MSFT	Stock	425.25	425.5	425.25	425.4915	11482.0
2024-11-13 19:00:00	MSFT	Stock	425.35	425.654	425.2336	425.35	2963.0
2024-11-13 04:00:00	NVDA	Stock	148.65	148.95	147.43	147.9	398781.0
2024-11-13 05:00:00	NVDA	Stock	147.92	148.64	147.89	148.5	366474.0
2024-11-13 06:00:00	NVDA	Stock	148.52	149.0	148.3	148.46	334923.0
2024-11-13 07:00:00	NVDA	Stock	148.47	148.75	148.0	148.09	625458.0
2024-11-13 08:00:00	NVDA	Stock	147.75	149.4	147.6	148.85	2884038.0
2024-11-13 09:00:00	NVDA	Stock	148.85	149.66	147.5507	148.03	25892529.0
2024-11-13 10:00:00	NVDA	Stock	148.04	148.1	146.55	147.1897	24520482.0
2024-11-13 11:00:00	NVDA	Stock	147.19	147.49	145.9	146.785	18753645.0
2024-11-13 12:00:00	NVDA	Stock	146.78	147.2807	146.41	147.1925	12392760.0
2024-11-13 13:00:00	NVDA	Stock	147.19	147.84	146.88	147.73	10919154.0
2024-11-13 14:00:00	NVDA	Stock	147.74	147.76	146.51	146.82	12483794.0
2024-11-13 15:00:00	NVDA	Stock	146.81	147.1999	145.94	146.41	20522455.0
2024-11-13 16:00:00	NVDA	Stock	146.27	146.73	146.245	146.51	13154693.0
2024-11-13 17:00:00	NVDA	Stock	146.51	146.63	146.27	146.58	5705349.0
2024-11-13 18:00:00	NVDA	Stock	146.58	146.61	146.41	146.55	154748.0
2024-11-13 19:00:00	NVDA	Stock	146.56	146.75	146.55	146.75	259287.0
2024-11-13 04:00:00	AMZN	Stock	208.8	208.96	208.6	208.96	11198.0
2024-11-13 05:00:00	AMZN	Stock	208.95	208.95	208.65	208.74	2839.0

> showing 50 of 62,069 rows — these rows as CSV

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