PREVIEW / stock_1hour / 2024-07-03

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-07-03.parquet
  size:    961 KB
  rows:    39,408
  symbols: 861

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-07-03 04:00:00	AAPL	Stock	220.0	220.0	219.53	219.7	19423.0
2024-07-03 05:00:00	AAPL	Stock	219.62	219.75	219.49	219.71	16534.0
2024-07-03 06:00:00	AAPL	Stock	219.71	219.8	219.53	219.6	11862.0
2024-07-03 07:00:00	AAPL	Stock	219.64	219.7	219.21	219.45	40022.0
2024-07-03 08:00:00	AAPL	Stock	219.635	219.89	219.21	219.61	153518.0
2024-07-03 09:00:00	AAPL	Stock	219.6001	221.33	219.3	221.14	7021857.0
2024-07-03 10:00:00	AAPL	Stock	221.16	221.4	219.03	220.54	7363237.0
2024-07-03 11:00:00	AAPL	Stock	220.55	220.74	219.77	220.3099	4156018.0
2024-07-03 12:00:00	AAPL	Stock	220.32	221.55	220.32	221.54	6913197.0
2024-07-03 13:00:00	AAPL	Stock	221.51	221.71	220.7108	220.8488	4815574.0
2024-07-03 14:00:00	AAPL	Stock	220.85	221.55	220.75	221.07	43072.0
2024-07-03 15:00:00	AAPL	Stock	221.04	221.55	220.69	221.0	39438.0
2024-07-03 16:00:00	AAPL	Stock	220.88	221.08	220.84	221.08	10468.0
2024-07-03 04:00:00	MSFT	Stock	459.25	459.25	458.9	459.2	4417.0
2024-07-03 05:00:00	MSFT	Stock	459.28	459.36	459.28	459.35	689.0
2024-07-03 06:00:00	MSFT	Stock	459.61	459.61	459.61	459.61	103.0
2024-07-03 07:00:00	MSFT	Stock	459.1	459.14	458.71	458.71	5761.0
2024-07-03 08:00:00	MSFT	Stock	459.26	459.57	457.75	457.75	14318.0
2024-07-03 09:00:00	MSFT	Stock	458.0	460.48	457.75	459.11	1209409.0
2024-07-03 10:00:00	MSFT	Stock	459.2	459.57	458.0	458.75	994895.0
2024-07-03 11:00:00	MSFT	Stock	458.745	460.7799	458.51	459.32	893597.0
2024-07-03 12:00:00	MSFT	Stock	459.31	461.02	459.1763	460.77	1732253.0
2024-07-03 13:00:00	MSFT	Stock	460.77	460.77	459.6472	460.0	2014170.0
2024-07-03 14:00:00	MSFT	Stock	460.1	460.77	459.91	460.1865	128187.0
2024-07-03 15:00:00	MSFT	Stock	460.2	460.3851	460.0	460.0	2520.0
2024-07-03 16:00:00	MSFT	Stock	460.3	460.5	459.8	459.8	7409.0
2024-07-03 04:00:00	NVDA	Stock	121.55	122.0	121.02	121.03	384763.0
2024-07-03 05:00:00	NVDA	Stock	121.06	121.33	120.86	121.08	386871.0
2024-07-03 06:00:00	NVDA	Stock	121.07	121.2	120.4	121.12	400870.0
2024-07-03 07:00:00	NVDA	Stock	121.16	122.0	121.03	121.74	1171626.0
2024-07-03 08:00:00	NVDA	Stock	121.44	122.0	120.6319	121.9	2212966.0
2024-07-03 09:00:00	NVDA	Stock	121.9	122.77	121.4603	122.2394	26683141.0
2024-07-03 10:00:00	NVDA	Stock	122.25	125.76	121.36	125.35	46825589.0
2024-07-03 11:00:00	NVDA	Stock	125.36	127.49	124.47	127.01	45500404.0
2024-07-03 12:00:00	NVDA	Stock	127.01	128.28	126.37	128.28	47934665.0
2024-07-03 13:00:00	NVDA	Stock	128.01	128.69	125.2785	127.72	16957242.0
2024-07-03 14:00:00	NVDA	Stock	127.72	127.83	127.52	127.549	722225.0
2024-07-03 15:00:00	NVDA	Stock	127.535	127.65	127.25	127.41	486224.0
2024-07-03 16:00:00	NVDA	Stock	127.4	127.5	127.0	127.48	586265.0
2024-07-03 04:00:00	AMZN	Stock	200.12	200.95	200.12	200.89	16672.0
2024-07-03 05:00:00	AMZN	Stock	200.81	200.81	200.4	200.68	6439.0
2024-07-03 06:00:00	AMZN	Stock	200.68	200.8	200.43	200.59	12711.0
2024-07-03 07:00:00	AMZN	Stock	200.5	200.69	199.39	200.15	57967.0
2024-07-03 08:00:00	AMZN	Stock	200.7	200.82	199.36	199.9	178054.0
2024-07-03 09:00:00	AMZN	Stock	199.82	200.1854	198.59	198.705	4596916.0
2024-07-03 10:00:00	AMZN	Stock	198.73	199.05	197.25	197.37	7210384.0
2024-07-03 11:00:00	AMZN	Stock	197.365	198.0	196.7601	197.79	4171609.0
2024-07-03 12:00:00	AMZN	Stock	197.78	198.075	196.94	197.58	5940038.0
2024-07-03 13:00:00	AMZN	Stock	197.59	197.59	197.11	197.4101	2973846.0
2024-07-03 14:00:00	AMZN	Stock	197.5	197.59	197.33	197.45	46007.0

> showing 50 of 39,408 rows — these rows as CSV

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