PREVIEW / stock_1hour / 2026-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2026/2026-06-18.parquet
  size:    1.4 MB
  rows:    62,153
  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-18 04:00:00	AAPL	Stock	297.0	298.6058	297.0	297.71	60682.0
2026-06-18 05:00:00	AAPL	Stock	297.3469	297.69	297.3469	297.6	11610.0
2026-06-18 06:00:00	AAPL	Stock	297.65	297.677	297.03	297.53	16180.0
2026-06-18 07:00:00	AAPL	Stock	297.45	297.53	295.87	296.76	94951.0
2026-06-18 08:00:00	AAPL	Stock	296.7585	296.98	296.2	296.68	70614.0
2026-06-18 09:00:00	AAPL	Stock	296.6	300.4599	295.62	298.275	13926755.0
2026-06-18 10:00:00	AAPL	Stock	298.31	300.57	298.02	299.18	4765324.0
2026-06-18 11:00:00	AAPL	Stock	299.22	299.23	295.95	297.38	3441753.0
2026-06-18 12:00:00	AAPL	Stock	297.4	297.73	296.69	297.14	1963994.0
2026-06-18 13:00:00	AAPL	Stock	297.13	298.36	297.03	297.56	1848319.0
2026-06-18 14:00:00	AAPL	Stock	297.575	298.0785	297.01	297.7	1806090.0
2026-06-18 15:00:00	AAPL	Stock	297.705	299.24	297.04	297.89	5250462.0
2026-06-18 16:00:00	AAPL	Stock	297.865	298.9026	297.62	297.65	25518199.0
2026-06-18 17:00:00	AAPL	Stock	297.78	298.23	297.78	298.02	17760.0
2026-06-18 18:00:00	AAPL	Stock	298.03	298.04	297.0	297.1	26869.0
2026-06-18 19:00:00	AAPL	Stock	297.1562	297.39	297.01	297.23	10342.0
2026-06-18 04:00:00	MSFT	Stock	382.26	382.88	380.72	381.0	100822.0
2026-06-18 05:00:00	MSFT	Stock	380.93	381.3178	380.88	381.08	25949.0
2026-06-18 06:00:00	MSFT	Stock	381.14	382.82	379.66	380.01	97791.0
2026-06-18 07:00:00	MSFT	Stock	380.25	380.7	377.26	377.5278	234352.0
2026-06-18 08:00:00	MSFT	Stock	377.51	379.6	376.8	378.87	184912.0
2026-06-18 09:00:00	MSFT	Stock	378.9	381.0	373.28	376.23	9761483.0
2026-06-18 10:00:00	MSFT	Stock	376.215	379.62	375.29	376.5986	4345025.0
2026-06-18 11:00:00	MSFT	Stock	376.61	378.04	374.82	377.926	3403502.0
2026-06-18 12:00:00	MSFT	Stock	377.9	379.61	376.56	379.51	2340858.0
2026-06-18 13:00:00	MSFT	Stock	379.505	381.37	379.17	379.72	2210310.0
2026-06-18 14:00:00	MSFT	Stock	379.75	379.8	377.35	377.91	2069407.0
2026-06-18 15:00:00	MSFT	Stock	377.88	380.5	377.1191	379.05	4621434.0
2026-06-18 16:00:00	MSFT	Stock	379.05	380.3	378.98	379.8888	13401557.0
2026-06-18 17:00:00	MSFT	Stock	379.8853	380.0	379.51	379.7	41539.0
2026-06-18 18:00:00	MSFT	Stock	379.56	379.6753	378.4855	378.55	29161.0
2026-06-18 19:00:00	MSFT	Stock	378.76	379.25	378.57	379.1	22663.0
2026-06-18 04:00:00	NVDA	Stock	206.7	207.35	205.2	206.64	384514.0
2026-06-18 05:00:00	NVDA	Stock	206.61	207.25	206.4	207.15	95615.0
2026-06-18 06:00:00	NVDA	Stock	207.12	207.3	206.69	206.71	98519.0
2026-06-18 07:00:00	NVDA	Stock	206.75	207.29	206.45	207.0	349547.0
2026-06-18 08:00:00	NVDA	Stock	207.0167	207.85	206.75	207.7474	509945.0
2026-06-18 09:00:00	NVDA	Stock	207.7	208.35	206.5	207.81	28248842.0
2026-06-18 10:00:00	NVDA	Stock	207.85	209.87	207.5	209.325	14475315.0
2026-06-18 11:00:00	NVDA	Stock	209.33	209.66	207.64	208.97	9505232.0
2026-06-18 12:00:00	NVDA	Stock	208.98	211.2	208.97	210.08	11338806.0
2026-06-18 13:00:00	NVDA	Stock	210.085	210.51	209.82	209.9101	6220551.0
2026-06-18 14:00:00	NVDA	Stock	209.93	210.54	209.5801	209.7	7287945.0
2026-06-18 15:00:00	NVDA	Stock	209.7	211.39	209.52	210.2	14402714.0
2026-06-18 16:00:00	NVDA	Stock	210.2	210.69	209.9	210.1698	68340042.0
2026-06-18 17:00:00	NVDA	Stock	210.1901	210.82	210.15	210.69	237098.0
2026-06-18 18:00:00	NVDA	Stock	210.56	210.6	209.9	210.16	204608.0
2026-06-18 19:00:00	NVDA	Stock	210.15	210.33	210.0	210.33	128303.0
2026-06-18 04:00:00	AMZN	Stock	240.01	241.0	239.05	240.0	69631.0
2026-06-18 05:00:00	AMZN	Stock	240.1	240.8	239.81	240.2634	19672.0

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

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