PREVIEW / stock_1hour / 2024-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-09-13.parquet
  size:    1.3 MB
  rows:    59,381
  symbols: 860

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-09-13 04:00:00	AAPL	Stock	222.7	223.08	222.68	222.95	6864.0
2024-09-13 05:00:00	AAPL	Stock	223.0	223.31	223.0	223.22	4567.0
2024-09-13 06:00:00	AAPL	Stock	223.17	223.46	223.13	223.41	13449.0
2024-09-13 07:00:00	AAPL	Stock	223.46	224.05	223.14	224.05	32487.0
2024-09-13 08:00:00	AAPL	Stock	223.49	224.59	222.97	224.48	140116.0
2024-09-13 09:00:00	AAPL	Stock	224.45	224.47	222.2412	222.52	4070577.0
2024-09-13 10:00:00	AAPL	Stock	222.5	223.5	221.91	223.16	4482769.0
2024-09-13 11:00:00	AAPL	Stock	223.18	223.849	223.1401	223.81	2749223.0
2024-09-13 12:00:00	AAPL	Stock	223.8	223.99	223.055	223.88	1838419.0
2024-09-13 13:00:00	AAPL	Stock	223.88	224.04	223.32	223.69	1632682.0
2024-09-13 14:00:00	AAPL	Stock	223.7	224.02	222.41	222.4701	2611713.0
2024-09-13 15:00:00	AAPL	Stock	222.47	222.85	222.31	222.46	4270508.0
2024-09-13 16:00:00	AAPL	Stock	222.5	222.5	222.2	222.42	5875827.0
2024-09-13 17:00:00	AAPL	Stock	222.42	222.5	222.35	222.35	44324.0
2024-09-13 18:00:00	AAPL	Stock	222.37	222.37	222.2201	222.31	13235.0
2024-09-13 19:00:00	AAPL	Stock	222.27	222.28	222.16	222.23	24149.0
2024-09-13 04:00:00	MSFT	Stock	426.31	427.14	426.0	426.12	5253.0
2024-09-13 05:00:00	MSFT	Stock	426.38	426.38	426.24	426.28	1248.0
2024-09-13 06:00:00	MSFT	Stock	426.45	426.45	426.23	426.25	622.0
2024-09-13 07:00:00	MSFT	Stock	426.64	426.64	426.0	426.21	7535.0
2024-09-13 08:00:00	MSFT	Stock	426.3988	427.82	425.6478	426.8	25192.0
2024-09-13 09:00:00	MSFT	Stock	426.58	428.76	425.46	426.9	992884.0
2024-09-13 10:00:00	MSFT	Stock	426.92	429.0	426.35	428.57	1069486.0
2024-09-13 11:00:00	MSFT	Stock	428.6	429.18	428.1146	429.05	735058.0
2024-09-13 12:00:00	MSFT	Stock	428.98	430.3	428.08	430.28	773849.0
2024-09-13 13:00:00	MSFT	Stock	430.28	431.83	430.1675	431.21	849753.0
2024-09-13 14:00:00	MSFT	Stock	431.225	431.44	429.68	430.2928	641249.0
2024-09-13 15:00:00	MSFT	Stock	430.265	431.22	429.95	430.57	1208125.0
2024-09-13 16:00:00	MSFT	Stock	430.59	430.59	429.73	430.0	3503418.0
2024-09-13 17:00:00	MSFT	Stock	430.08	430.59	430.08	430.1	1056316.0
2024-09-13 18:00:00	MSFT	Stock	430.1	430.25	430.0	430.2	2606.0
2024-09-13 19:00:00	MSFT	Stock	430.2	430.34	430.19	430.19	4063.0
2024-09-13 04:00:00	NVDA	Stock	118.88	119.66	118.53	119.57	439380.0
2024-09-13 05:00:00	NVDA	Stock	119.56	119.64	119.15	119.28	190087.0
2024-09-13 06:00:00	NVDA	Stock	119.25	119.29	118.86	119.24	306753.0
2024-09-13 07:00:00	NVDA	Stock	119.25	119.54	119.11	119.34	789085.0
2024-09-13 08:00:00	NVDA	Stock	119.23	119.5369	118.75	119.01	2298467.0
2024-09-13 09:00:00	NVDA	Stock	119.03	119.955	118.35	118.675	33890318.0
2024-09-13 10:00:00	NVDA	Stock	118.675	119.69	117.6	119.395	46890200.0
2024-09-13 11:00:00	NVDA	Stock	119.39	119.79	118.82	118.91	25245621.0
2024-09-13 12:00:00	NVDA	Stock	118.9	119.3	118.3	119.2699	23368670.0
2024-09-13 13:00:00	NVDA	Stock	119.27	119.33	118.76	118.8066	16207952.0
2024-09-13 14:00:00	NVDA	Stock	118.804	119.02	118.3688	118.865	16924275.0
2024-09-13 15:00:00	NVDA	Stock	118.855	119.14	118.63	119.07	25193555.0
2024-09-13 16:00:00	NVDA	Stock	119.07	119.1	118.91	118.96	11270066.0
2024-09-13 17:00:00	NVDA	Stock	118.98	119.0	118.811	118.86	303199.0
2024-09-13 18:00:00	NVDA	Stock	118.86	118.8895	118.72	118.77	281583.0
2024-09-13 19:00:00	NVDA	Stock	118.7755	118.87	118.75	118.76	312016.0
2024-09-13 04:00:00	AMZN	Stock	186.75	186.84	186.56	186.66	6033.0
2024-09-13 05:00:00	AMZN	Stock	186.68	186.81	186.67	186.76	5655.0

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

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