PREVIEW / stock_1hour / 2026-07-23

all stock 1-hour files

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

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-23 04:00:00	AAPL	Stock	325.0	325.89	323.61	324.3	45490.0
2026-07-23 05:00:00	AAPL	Stock	324.25	324.44	323.6	324.06	10510.0
2026-07-23 06:00:00	AAPL	Stock	324.26	324.26	323.75	324.24	6461.0
2026-07-23 07:00:00	AAPL	Stock	324.03	324.25	322.4	323.09	116382.0
2026-07-23 08:00:00	AAPL	Stock	323.0	325.076	322.69	323.34	92536.0
2026-07-23 09:00:00	AAPL	Stock	323.4	324.25	319.35	320.07	4299603.0
2026-07-23 10:00:00	AAPL	Stock	320.1455	322.93	319.8	321.27	3457437.0
2026-07-23 11:00:00	AAPL	Stock	321.285	322.29	320.44	320.86	2576215.0
2026-07-23 12:00:00	AAPL	Stock	320.89	321.55	320.0	320.6105	2318135.0
2026-07-23 13:00:00	AAPL	Stock	320.62	321.399	320.3	320.5124	1671558.0
2026-07-23 14:00:00	AAPL	Stock	320.51	320.72	319.76	320.72	2303909.0
2026-07-23 15:00:00	AAPL	Stock	320.71	321.98	320.04	321.575	4626677.0
2026-07-23 16:00:00	AAPL	Stock	321.49	322.0	320.5	320.56	7280326.0
2026-07-23 17:00:00	AAPL	Stock	320.64	321.2	320.5	320.9	13360.0
2026-07-23 18:00:00	AAPL	Stock	320.97	321.66	320.77	321.6252	15904.0
2026-07-23 19:00:00	AAPL	Stock	321.61	321.65	321.04	321.39	8722.0
2026-07-23 04:00:00	MSFT	Stock	387.19	389.2162	386.0	386.1015	64905.0
2026-07-23 05:00:00	MSFT	Stock	386.16	386.86	385.52	386.6	21063.0
2026-07-23 06:00:00	MSFT	Stock	386.6	391.24	385.4	388.6	141311.0
2026-07-23 07:00:00	MSFT	Stock	388.4	391.05	387.9	388.39	108738.0
2026-07-23 08:00:00	MSFT	Stock	388.15	389.27	386.99	387.52	89003.0
2026-07-23 09:00:00	MSFT	Stock	387.698	391.78	387.15	388.36	3349782.0
2026-07-23 10:00:00	MSFT	Stock	388.37	388.91	378.84	379.25	4404931.0
2026-07-23 11:00:00	MSFT	Stock	379.29	379.82	377.39	379.625	3575375.0
2026-07-23 12:00:00	MSFT	Stock	379.64	381.39	379.525	381.335	1749057.0
2026-07-23 13:00:00	MSFT	Stock	381.335	382.15	380.67	380.91	1209998.0
2026-07-23 14:00:00	MSFT	Stock	380.9	382.2001	380.77	381.965	1371116.0
2026-07-23 15:00:00	MSFT	Stock	381.965	382.45	379.43	381.48	3744899.0
2026-07-23 16:00:00	MSFT	Stock	381.43	382.46	380.21	382.3	4680134.0
2026-07-23 17:00:00	MSFT	Stock	382.3	383.33	382.3	382.6	23473.0
2026-07-23 18:00:00	MSFT	Stock	382.81	383.39	382.23	383.28	22939.0
2026-07-23 19:00:00	MSFT	Stock	383.3	383.39	382.0	382.0	21491.0
2026-07-23 04:00:00	NVDA	Stock	210.54	212.46	210.0	211.59	224899.0
2026-07-23 05:00:00	NVDA	Stock	211.64	211.86	210.75	210.75	59804.0
2026-07-23 06:00:00	NVDA	Stock	210.75	210.97	210.36	210.92	93909.0
2026-07-23 07:00:00	NVDA	Stock	210.92	211.25	209.73	210.67	385270.0
2026-07-23 08:00:00	NVDA	Stock	210.6443	210.6725	208.95	209.16	571285.0
2026-07-23 09:00:00	NVDA	Stock	209.15	210.8687	208.27	208.93	10981513.0
2026-07-23 10:00:00	NVDA	Stock	208.95	209.97	207.2	207.305	11472145.0
2026-07-23 11:00:00	NVDA	Stock	207.31	208.25	205.96	208.1801	11019099.0
2026-07-23 12:00:00	NVDA	Stock	208.19	210.39	208.04	209.88	8437678.0
2026-07-23 13:00:00	NVDA	Stock	209.89	210.43	209.0	209.07	5663883.0
2026-07-23 14:00:00	NVDA	Stock	209.09	209.1099	207.33	207.675	6439775.0
2026-07-23 15:00:00	NVDA	Stock	207.6742	208.98	206.89	208.7	11362996.0
2026-07-23 16:00:00	NVDA	Stock	208.7	210.04	208.556	209.14	17144509.0
2026-07-23 17:00:00	NVDA	Stock	209.14	209.1739	208.04	208.4	199590.0
2026-07-23 18:00:00	NVDA	Stock	208.45	208.45	207.52	208.44	133020.0
2026-07-23 19:00:00	NVDA	Stock	208.4239	208.5	207.78	207.99	93777.0
2026-07-23 04:00:00	AMZN	Stock	241.5	242.51	239.6	239.95	48545.0
2026-07-23 05:00:00	AMZN	Stock	239.76	240.19	239.16	239.9	18832.0

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

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