PREVIEW / stock_1hour / 2026-06-17

all stock 1-hour files

  file:    by_date/stock_1hour/2026/2026-06-17.parquet
  size:    1.4 MB
  rows:    61,135
  symbols: 12

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-17 04:00:00	AAPL	Stock	299.5	299.7	298.28	298.96	39166.0
2026-06-17 05:00:00	AAPL	Stock	298.88	298.99	298.63	298.99	5611.0
2026-06-17 06:00:00	AAPL	Stock	298.79	298.9	298.43	298.5	4752.0
2026-06-17 07:00:00	AAPL	Stock	298.62	299.24	298.5	298.7469	15718.0
2026-06-17 08:00:00	AAPL	Stock	298.7318	298.88	298.44	298.72	14938.0
2026-06-17 09:00:00	AAPL	Stock	298.7	302.07	298.62	300.3	3754034.0
2026-06-17 10:00:00	AAPL	Stock	300.34	300.9675	298.35	298.54	3687027.0
2026-06-17 11:00:00	AAPL	Stock	298.55	298.77	296.64	298.555	3044879.0
2026-06-17 12:00:00	AAPL	Stock	298.56	299.16	298.095	298.2	1792652.0
2026-06-17 13:00:00	AAPL	Stock	298.215	298.22	296.42	297.53	2218686.0
2026-06-17 14:00:00	AAPL	Stock	297.53	297.54	294.36	294.59	3799083.0
2026-06-17 15:00:00	AAPL	Stock	294.605	296.22	294.39	295.88	5502941.0
2026-06-17 16:00:00	AAPL	Stock	295.85	296.4	295.36	295.8	10242321.0
2026-06-17 17:00:00	AAPL	Stock	295.81	299.58	295.8	297.35	275991.0
2026-06-17 18:00:00	AAPL	Stock	297.36	297.69	297.01	297.1	50662.0
2026-06-17 19:00:00	AAPL	Stock	297.01	297.38	296.66	297.1	22391.0
2026-06-17 04:00:00	MSFT	Stock	393.84	394.8	392.56	393.2	60766.0
2026-06-17 05:00:00	MSFT	Stock	393.2	393.2	392.138	392.3371	18144.0
2026-06-17 06:00:00	MSFT	Stock	392.31	392.4	391.78	392.12	15019.0
2026-06-17 07:00:00	MSFT	Stock	392.1887	392.434	391.48	391.7508	34669.0
2026-06-17 08:00:00	MSFT	Stock	391.72	392.0	390.9	390.9	58622.0
2026-06-17 09:00:00	MSFT	Stock	390.9913	391.06	386.75	389.8	3268051.0
2026-06-17 10:00:00	MSFT	Stock	389.815	389.885	384.63	384.9	3907870.0
2026-06-17 11:00:00	MSFT	Stock	384.92	386.63	384.72	385.375	2574991.0
2026-06-17 12:00:00	MSFT	Stock	385.365	386.1	384.04	384.11	2282692.0
2026-06-17 13:00:00	MSFT	Stock	384.13	385.98	383.2	385.75	1967368.0
2026-06-17 14:00:00	MSFT	Stock	385.75	385.78	381.42	381.8	3596297.0
2026-06-17 15:00:00	MSFT	Stock	381.805	382.47	377.32	378.8501	6855001.0
2026-06-17 16:00:00	MSFT	Stock	378.91	380.46	378.78	380.35	6888144.0
2026-06-17 17:00:00	MSFT	Stock	380.38	381.2	379.86	380.8	83137.0
2026-06-17 18:00:00	MSFT	Stock	380.8	382.4	380.6	381.6	83123.0
2026-06-17 19:00:00	MSFT	Stock	381.5869	382.3	381.5	382.2981	56806.0
2026-06-17 04:00:00	NVDA	Stock	208.9	209.0	207.968	208.35	229503.0
2026-06-17 05:00:00	NVDA	Stock	208.35	208.58	208.04	208.1	33820.0
2026-06-17 06:00:00	NVDA	Stock	208.05	208.35	207.92	208.02	53367.0
2026-06-17 07:00:00	NVDA	Stock	208.03	208.05	207.6	207.79	262181.0
2026-06-17 08:00:00	NVDA	Stock	207.83	208.68	207.73	208.4	285600.0
2026-06-17 09:00:00	NVDA	Stock	208.44	209.21	207.13	207.21	10205565.0
2026-06-17 10:00:00	NVDA	Stock	207.195	208.22	206.36	206.465	11756942.0
2026-06-17 11:00:00	NVDA	Stock	206.465	207.0399	205.91	206.41	9693291.0
2026-06-17 12:00:00	NVDA	Stock	206.41	207.6599	206.41	207.14	5859694.0
2026-06-17 13:00:00	NVDA	Stock	207.15	207.91	206.5	207.78	5115918.0
2026-06-17 14:00:00	NVDA	Stock	207.765	207.85	205.3	205.955	12163432.0
2026-06-17 15:00:00	NVDA	Stock	205.97	206.48	203.08	204.6767	15420996.0
2026-06-17 16:00:00	NVDA	Stock	204.69	205.3	204.33	205.1294	19884540.0
2026-06-17 17:00:00	NVDA	Stock	205.122	205.445	204.96	205.445	220956.0
2026-06-17 18:00:00	NVDA	Stock	205.45	205.75	205.2	205.4	248366.0
2026-06-17 19:00:00	NVDA	Stock	205.4001	206.38	205.4001	206.3	264815.0
2026-06-17 04:00:00	AMZN	Stock	247.0866	247.5424	246.4	246.5	34716.0
2026-06-17 05:00:00	AMZN	Stock	246.3208	246.47	245.88	245.88	4063.0

> showing 50 of 61,135 rows — these rows as CSV

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