PREVIEW / stock_1hour / 2026-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2026/2026-06-23.parquet
  size:    1.4 MB
  rows:    62,380
  symbols: 11

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-06-23 04:00:00	AAPL	Stock	295.31	299.99	294.09	295.56	169538.0
2026-06-23 05:00:00	AAPL	Stock	295.5184	296.31	295.47	296.02	38660.0
2026-06-23 06:00:00	AAPL	Stock	296.07	296.3	295.6313	295.93	14910.0
2026-06-23 07:00:00	AAPL	Stock	295.69	296.0	294.48	294.7	60767.0
2026-06-23 08:00:00	AAPL	Stock	294.63	296.268	294.06	295.0013	64283.0
2026-06-23 09:00:00	AAPL	Stock	295.0274	301.64	294.95	299.11	4881326.0
2026-06-23 10:00:00	AAPL	Stock	299.085	300.88	298.795	300.09	4090947.0
2026-06-23 11:00:00	AAPL	Stock	300.09	300.32	297.35	298.065	3291798.0
2026-06-23 12:00:00	AAPL	Stock	298.07	299.28	297.95	298.99	2890089.0
2026-06-23 13:00:00	AAPL	Stock	299.01	300.085	297.88	298.96	2727139.0
2026-06-23 14:00:00	AAPL	Stock	298.99	299.38	297.45	297.53	2979937.0
2026-06-23 15:00:00	AAPL	Stock	297.52	298.8676	294.18	294.29	9380839.0
2026-06-23 16:00:00	AAPL	Stock	294.32	295.22	293.5	295.0	11401456.0
2026-06-23 17:00:00	AAPL	Stock	295.0	295.0	294.3	294.77	35852.0
2026-06-23 18:00:00	AAPL	Stock	294.75	294.82	293.5	293.99	40337.0
2026-06-23 19:00:00	AAPL	Stock	293.93	294.82	293.52	294.7	25334.0
2026-06-23 04:00:00	MSFT	Stock	366.7	372.47	365.68	370.97	277216.0
2026-06-23 05:00:00	MSFT	Stock	370.74	372.38	370.32	372.11	79014.0
2026-06-23 06:00:00	MSFT	Stock	372.0	372.55	371.0	371.225	65655.0
2026-06-23 07:00:00	MSFT	Stock	371.3	372.95	370.2466	372.08	208625.0
2026-06-23 08:00:00	MSFT	Stock	372.0	373.54	371.62	372.91	200939.0
2026-06-23 09:00:00	MSFT	Stock	372.82	375.9	370.67	374.86	4589564.0
2026-06-23 10:00:00	MSFT	Stock	374.855	377.22	373.22	374.71	4104997.0
2026-06-23 11:00:00	MSFT	Stock	374.71	375.0	372.46	373.41	2827072.0
2026-06-23 12:00:00	MSFT	Stock	373.41	373.55	371.61	372.885	2103442.0
2026-06-23 13:00:00	MSFT	Stock	372.9	374.58	372.43	373.535	2100514.0
2026-06-23 14:00:00	MSFT	Stock	373.56	374.24	372.27	372.845	2310214.0
2026-06-23 15:00:00	MSFT	Stock	372.87	376.1212	372.77	373.905	4520881.0
2026-06-23 16:00:00	MSFT	Stock	373.9215	374.64	373.24	374.14	6423240.0
2026-06-23 17:00:00	MSFT	Stock	374.09	374.09	373.1085	373.66	22737.0
2026-06-23 18:00:00	MSFT	Stock	373.33	373.52	372.0	373.16	37395.0
2026-06-23 19:00:00	MSFT	Stock	373.29	374.3	372.45	374.0011	24420.0
2026-06-23 04:00:00	NVDA	Stock	202.32	206.2617	201.66	202.45	788307.0
2026-06-23 05:00:00	NVDA	Stock	202.5	202.9	202.1249	202.4	186948.0
2026-06-23 06:00:00	NVDA	Stock	202.35	202.76	201.85	202.65	125551.0
2026-06-23 07:00:00	NVDA	Stock	202.63	204.15	202.209	203.88	622764.0
2026-06-23 08:00:00	NVDA	Stock	203.88	204.0	202.6	203.0118	766121.0
2026-06-23 09:00:00	NVDA	Stock	203.03	203.77	200.04	203.41	17325479.0
2026-06-23 10:00:00	NVDA	Stock	203.37	203.58	201.9	202.235	11939091.0
2026-06-23 11:00:00	NVDA	Stock	202.24	202.49	200.43	201.85	11528521.0
2026-06-23 12:00:00	NVDA	Stock	201.83	202.961	201.8	202.31	6345371.0
2026-06-23 13:00:00	NVDA	Stock	202.32	202.8	201.61	201.6101	5237673.0
2026-06-23 14:00:00	NVDA	Stock	201.615	202.01	200.3	200.63	7453226.0
2026-06-23 15:00:00	NVDA	Stock	200.62	201.7187	200.0	200.012	16666095.0
2026-06-23 16:00:00	NVDA	Stock	200.07	200.81	200.0	200.48	27241887.0
2026-06-23 17:00:00	NVDA	Stock	200.46	201.1	200.46	200.98	182777.0
2026-06-23 18:00:00	NVDA	Stock	200.93	201.1696	200.4	200.53	315310.0
2026-06-23 19:00:00	NVDA	Stock	200.56	200.9013	200.2	200.89	239260.0
2026-06-23 04:00:00	AMZN	Stock	230.17	232.6786	229.36	230.58	131369.0
2026-06-23 05:00:00	AMZN	Stock	230.32	230.77	229.87	230.66	26905.0

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

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