PREVIEW / stock_1hour / 2026-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2026/2026-07-14.parquet
  size:    1.4 MB
  rows:    59,988

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
2026-07-14 04:00:00	AAPL	Stock	313.81	316.64	312.5	313.44	135638.0
2026-07-14 05:00:00	AAPL	Stock	313.4	313.86	312.5	313.61	31488.0
2026-07-14 06:00:00	AAPL	Stock	313.62	313.98	313.54	313.8238	10338.0
2026-07-14 07:00:00	AAPL	Stock	313.82	315.44	313.71	314.55	104862.0
2026-07-14 08:00:00	AAPL	Stock	314.59	317.0	313.84	314.0	196060.0
2026-07-14 09:00:00	AAPL	Stock	313.9304	315.685	311.91	314.5	3593895.0
2026-07-14 10:00:00	AAPL	Stock	314.4925	316.19	313.06	314.9501	3056630.0
2026-07-14 11:00:00	AAPL	Stock	315.0	316.05	313.191	313.26	2582050.0
2026-07-14 12:00:00	AAPL	Stock	313.29	314.24	312.87	314.12	2192717.0
2026-07-14 13:00:00	AAPL	Stock	314.12	315.235	313.89	315.18	1844480.0
2026-07-14 14:00:00	AAPL	Stock	315.2	315.6	314.8	315.48	1551277.0
2026-07-14 15:00:00	AAPL	Stock	315.49	315.87	314.59	314.92	3393741.0
2026-07-14 16:00:00	AAPL	Stock	314.93	315.23	313.52	314.6439	7468681.0
2026-07-14 17:00:00	AAPL	Stock	314.574	315.18	314.574	314.7876	7143.0
2026-07-14 18:00:00	AAPL	Stock	314.9	315.09	314.4	314.8	28141.0
2026-07-14 19:00:00	AAPL	Stock	314.56	315.8	314.4	315.53	32750.0
2026-07-14 04:00:00	MSFT	Stock	386.0	389.95	385.6	386.84	90929.0
2026-07-14 05:00:00	MSFT	Stock	386.68	387.6858	386.55	387.456	9194.0
2026-07-14 06:00:00	MSFT	Stock	387.68	388.18	387.2065	387.74	7145.0
2026-07-14 07:00:00	MSFT	Stock	387.97	388.08	377.8	378.87	581488.0
2026-07-14 08:00:00	MSFT	Stock	378.94	381.43	377.35	379.25	405829.0
2026-07-14 09:00:00	MSFT	Stock	379.2	385.27	378.65	385.2425	3695040.0
2026-07-14 10:00:00	MSFT	Stock	385.235	387.7499	382.8	387.46	3279280.0
2026-07-14 11:00:00	MSFT	Stock	387.49	387.66	384.41	384.78	1998049.0
2026-07-14 12:00:00	MSFT	Stock	384.75	387.5995	384.14	387.53	1444567.0
2026-07-14 13:00:00	MSFT	Stock	387.5599	388.19	386.2	387.14	1381668.0
2026-07-14 14:00:00	MSFT	Stock	387.14	387.63	385.25	385.2731	1359370.0
2026-07-14 15:00:00	MSFT	Stock	385.315	386.35	384.73	384.94	3302915.0
2026-07-14 16:00:00	MSFT	Stock	384.93	385.7	384.73	385.35	4904198.0
2026-07-14 17:00:00	MSFT	Stock	385.32	385.76	384.7834	385.2109	27848.0
2026-07-14 18:00:00	MSFT	Stock	385.2	385.7536	384.74	385.25	15789.0
2026-07-14 19:00:00	MSFT	Stock	385.35	386.8696	385.1556	386.5	23671.0
2026-07-14 04:00:00	NVDA	Stock	204.97	205.5	203.23	204.76	285676.0
2026-07-14 05:00:00	NVDA	Stock	204.72	204.98	204.38	204.52	57789.0
2026-07-14 06:00:00	NVDA	Stock	204.5072	204.6438	204.35	204.57	27849.0
2026-07-14 07:00:00	NVDA	Stock	204.55	206.66	204.35	206.2117	807897.0
2026-07-14 08:00:00	NVDA	Stock	206.2	207.94	205.62	207.09	992946.0
2026-07-14 09:00:00	NVDA	Stock	207.09	208.51	203.8	205.0	10899394.0
2026-07-14 10:00:00	NVDA	Stock	204.99	207.68	204.06	207.5	11182646.0
2026-07-14 11:00:00	NVDA	Stock	207.5	209.3188	207.21	209.17	10576118.0
2026-07-14 12:00:00	NVDA	Stock	209.1882	210.915	208.31	210.87	10085454.0
2026-07-14 13:00:00	NVDA	Stock	210.87	211.52	210.51	211.3101	9794094.0
2026-07-14 14:00:00	NVDA	Stock	211.32	212.55	211.15	212.32	9293424.0
2026-07-14 15:00:00	NVDA	Stock	212.32	212.335	211.02	211.79	13689289.0
2026-07-14 16:00:00	NVDA	Stock	211.81	211.92	211.23	211.66	16662251.0
2026-07-14 17:00:00	NVDA	Stock	211.6527	211.7	211.4	211.53	118173.0
2026-07-14 18:00:00	NVDA	Stock	211.55	211.63	211.26	211.39	89072.0
2026-07-14 19:00:00	NVDA	Stock	211.47	211.88	211.25	211.8009	211561.0
2026-07-14 04:00:00	AMZN	Stock	246.66	247.16	245.69	245.8137	18592.0
2026-07-14 05:00:00	AMZN	Stock	245.67	246.34	245.67	246.27	5030.0

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

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