PREVIEW / stock_1hour / 2025-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-06-18.parquet
  size:    1.4 MB
  rows:    61,252
  symbols: 393

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
2025-06-18 04:00:00	AAPL	Stock	196.15	196.6	196.13	196.5	17003.0
2025-06-18 05:00:00	AAPL	Stock	196.55	196.79	196.51	196.55	20622.0
2025-06-18 06:00:00	AAPL	Stock	196.58	196.6	195.81	195.99	17463.0
2025-06-18 07:00:00	AAPL	Stock	196.0	196.28	195.72	196.16	30752.0
2025-06-18 08:00:00	AAPL	Stock	195.98	196.66	195.51	196.07	71060.0
2025-06-18 09:00:00	AAPL	Stock	196.01	196.47	195.07	196.38	3599654.0
2025-06-18 10:00:00	AAPL	Stock	196.4	197.57	196.21	197.25	4193473.0
2025-06-18 11:00:00	AAPL	Stock	197.24	197.295	196.5003	196.82	2586511.0
2025-06-18 12:00:00	AAPL	Stock	196.82	197.23	196.42	196.455	1651859.0
2025-06-18 13:00:00	AAPL	Stock	196.45	196.8599	195.8	196.4999	2246407.0
2025-06-18 14:00:00	AAPL	Stock	196.46	196.98	195.11	195.36	3173082.0
2025-06-18 15:00:00	AAPL	Stock	195.37	197.11	195.14	196.24	8076046.0
2025-06-18 16:00:00	AAPL	Stock	196.58	196.72	195.95	196.12	7746014.0
2025-06-18 17:00:00	AAPL	Stock	196.3	196.3	195.81	196.05	47383.0
2025-06-18 18:00:00	AAPL	Stock	196.06	196.08	195.9	196.05	16146.0
2025-06-18 19:00:00	AAPL	Stock	196.08	196.16	195.9	196.06	15343.0
2025-06-18 04:00:00	MSFT	Stock	478.15	478.85	477.87	478.7	2421.0
2025-06-18 05:00:00	MSFT	Stock	479.29	479.29	478.77	478.77	1258.0
2025-06-18 06:00:00	MSFT	Stock	478.25	478.25	477.63	477.63	2291.0
2025-06-18 07:00:00	MSFT	Stock	477.51	477.92	476.94	477.71	9871.0
2025-06-18 08:00:00	MSFT	Stock	477.4	478.78	476.93	477.78	10612.0
2025-06-18 09:00:00	MSFT	Stock	477.85	479.17	475.2	477.21	1167194.0
2025-06-18 10:00:00	MSFT	Stock	477.21	479.489	474.46	479.44	1018192.0
2025-06-18 11:00:00	MSFT	Stock	479.415	479.6599	478.74	479.1079	703263.0
2025-06-18 12:00:00	MSFT	Stock	479.05	479.8	478.78	479.14	393480.0
2025-06-18 13:00:00	MSFT	Stock	479.11	479.78	477.98	479.52	439972.0
2025-06-18 14:00:00	MSFT	Stock	479.79	480.68	477.91	478.4625	939810.0
2025-06-18 15:00:00	MSFT	Stock	478.51	481.0	477.85	480.24	2234837.0
2025-06-18 16:00:00	MSFT	Stock	480.24	480.97	479.65	480.6	3962055.0
2025-06-18 17:00:00	MSFT	Stock	480.73	480.82	480.4387	480.4387	7527.0
2025-06-18 18:00:00	MSFT	Stock	480.69	480.82	480.2	480.48	3908.0
2025-06-18 19:00:00	MSFT	Stock	480.47	480.83	480.4	480.83	4055.0
2025-06-18 04:00:00	NVDA	Stock	144.2	144.8	143.89	144.7	223135.0
2025-06-18 05:00:00	NVDA	Stock	144.73	144.97	144.68	144.74	172145.0
2025-06-18 06:00:00	NVDA	Stock	144.73	144.79	144.17	144.28	210519.0
2025-06-18 07:00:00	NVDA	Stock	144.25	144.77	144.11	144.54	340365.0
2025-06-18 08:00:00	NVDA	Stock	144.21	144.94	143.9	144.45	769605.0
2025-06-18 09:00:00	NVDA	Stock	144.46	144.64	143.12	144.51	15927695.0
2025-06-18 10:00:00	NVDA	Stock	144.52	145.62	144.33	145.0899	21762628.0
2025-06-18 11:00:00	NVDA	Stock	145.085	145.4782	144.73	145.1488	12309844.0
2025-06-18 12:00:00	NVDA	Stock	145.145	145.6	144.895	145.4301	10059387.0
2025-06-18 13:00:00	NVDA	Stock	145.435	145.6	144.745	145.17	9911977.0
2025-06-18 14:00:00	NVDA	Stock	145.19	145.5	144.05	144.28	15728698.0
2025-06-18 15:00:00	NVDA	Stock	144.29	145.65	143.9	145.47	30032266.0
2025-06-18 16:00:00	NVDA	Stock	145.46	145.5	145.08	145.21	15737236.0
2025-06-18 17:00:00	NVDA	Stock	145.2	145.28	144.97	144.98	267349.0
2025-06-18 18:00:00	NVDA	Stock	144.99	145.12	144.9	145.04	216620.0
2025-06-18 19:00:00	NVDA	Stock	145.0209	145.1	145.0	145.07	229266.0
2025-06-18 04:00:00	AMZN	Stock	215.02	215.97	215.02	215.68	14094.0
2025-06-18 05:00:00	AMZN	Stock	215.72	216.01	215.71	215.95	5966.0

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

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