PREVIEW / stock_1hour / 2025-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-06-13.parquet
  size:    1.4 MB
  rows:    63,416
  symbols: 400

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-13 04:00:00	AAPL	Stock	196.11	197.37	196.0	196.68	25748.0
2025-06-13 05:00:00	AAPL	Stock	196.64	197.63	196.64	197.63	26362.0
2025-06-13 06:00:00	AAPL	Stock	197.47	198.61	197.24	198.61	39845.0
2025-06-13 07:00:00	AAPL	Stock	198.61	199.75	198.41	199.54	167266.0
2025-06-13 08:00:00	AAPL	Stock	199.0	200.2	195.87	200.0001	433371.0
2025-06-13 09:00:00	AAPL	Stock	200.0	200.37	196.76	196.9	6960021.0
2025-06-13 10:00:00	AAPL	Stock	196.93	197.3999	195.91	197.11	6142416.0
2025-06-13 11:00:00	AAPL	Stock	197.11	197.88	196.98	197.6888	3351148.0
2025-06-13 12:00:00	AAPL	Stock	197.68	198.0475	197.08	197.45	3014358.0
2025-06-13 13:00:00	AAPL	Stock	197.43	197.71	196.91	197.54	2181022.0
2025-06-13 14:00:00	AAPL	Stock	197.54	197.69	195.81	196.465	4195092.0
2025-06-13 15:00:00	AAPL	Stock	196.455	196.69	195.7	196.45	5987235.0
2025-06-13 16:00:00	AAPL	Stock	196.46	196.55	196.11	196.45	5541172.0
2025-06-13 17:00:00	AAPL	Stock	196.4484	196.5	196.31	196.45	31928.0
2025-06-13 18:00:00	AAPL	Stock	196.45	196.6	196.3901	196.46	33461.0
2025-06-13 19:00:00	AAPL	Stock	196.4599	196.48	196.3	196.3998	24697.0
2025-06-13 04:00:00	MSFT	Stock	473.01	474.32	472.88	473.5	9942.0
2025-06-13 05:00:00	MSFT	Stock	473.45	473.94	472.71	473.12	8637.0
2025-06-13 06:00:00	MSFT	Stock	473.12	474.02	472.82	474.02	6031.0
2025-06-13 07:00:00	MSFT	Stock	474.02	475.5	473.98	475.04	20004.0
2025-06-13 08:00:00	MSFT	Stock	474.49	475.47	471.79	474.53	68748.0
2025-06-13 09:00:00	MSFT	Stock	474.54	478.82	473.6177	478.42	1373029.0
2025-06-13 10:00:00	MSFT	Stock	478.5	479.18	474.95	476.4315	1529871.0
2025-06-13 11:00:00	MSFT	Stock	476.4	477.455	475.65	477.28	790316.0
2025-06-13 12:00:00	MSFT	Stock	477.3	478.08	475.9	476.66	731414.0
2025-06-13 13:00:00	MSFT	Stock	476.65	476.84	475.19	475.67	555596.0
2025-06-13 14:00:00	MSFT	Stock	475.66	476.04	472.76	474.345	1009975.0
2025-06-13 15:00:00	MSFT	Stock	474.35	475.18	473.7	474.96	1481589.0
2025-06-13 16:00:00	MSFT	Stock	474.96	476.1882	474.39	474.66	2555860.0
2025-06-13 17:00:00	MSFT	Stock	474.24	474.94	473.5	474.56	6171.0
2025-06-13 18:00:00	MSFT	Stock	474.59	474.59	474.0616	474.0616	799.0
2025-06-13 19:00:00	MSFT	Stock	474.15	474.7	474.15	474.1837	3798.0
2025-06-13 04:00:00	NVDA	Stock	142.13	143.19	141.4	142.14	837126.0
2025-06-13 05:00:00	NVDA	Stock	142.15	142.49	141.74	142.31	495098.0
2025-06-13 06:00:00	NVDA	Stock	142.31	142.45	141.9	142.44	302543.0
2025-06-13 07:00:00	NVDA	Stock	142.44	143.24	142.28	143.11	1075900.0
2025-06-13 08:00:00	NVDA	Stock	142.36	143.46	141.51	142.9	2802323.0
2025-06-13 09:00:00	NVDA	Stock	142.89	143.58	142.19	142.918	22116810.0
2025-06-13 10:00:00	NVDA	Stock	142.93	143.3602	141.07	142.31	28109798.0
2025-06-13 11:00:00	NVDA	Stock	142.315	143.32	142.17	143.064	14002856.0
2025-06-13 12:00:00	NVDA	Stock	143.065	143.37	142.8719	143.255	10157057.0
2025-06-13 13:00:00	NVDA	Stock	143.25	143.34	142.38	142.7345	11107570.0
2025-06-13 14:00:00	NVDA	Stock	142.74	142.8499	140.855	141.78	18802521.0
2025-06-13 15:00:00	NVDA	Stock	141.775	142.08	141.44	141.96	21825194.0
2025-06-13 16:00:00	NVDA	Stock	141.96	142.13	141.8	141.84	11753621.0
2025-06-13 17:00:00	NVDA	Stock	141.83	141.97	141.72	141.85	268261.0
2025-06-13 18:00:00	NVDA	Stock	141.82	141.88	141.75	141.82	161881.0
2025-06-13 19:00:00	NVDA	Stock	141.82	141.8498	141.71	141.8	271670.0
2025-06-13 04:00:00	AMZN	Stock	209.88	210.04	208.11	208.27	25954.0
2025-06-13 05:00:00	AMZN	Stock	208.42	209.3	208.0	209.06	22149.0

> showing 50 of 63,416 rows — these rows as CSV

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