PREVIEW / stock_1hour / 2025-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-07-16.parquet
  size:    1.4 MB
  rows:    63,310
  symbols: 377

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-07-16 04:00:00	AAPL	Stock	209.15	209.67	209.15	209.49	16053.0
2025-07-16 05:00:00	AAPL	Stock	209.41	209.52	209.34	209.45	4837.0
2025-07-16 06:00:00	AAPL	Stock	209.56	209.87	209.43	209.78	27935.0
2025-07-16 07:00:00	AAPL	Stock	209.64	209.71	209.5	209.58	13857.0
2025-07-16 08:00:00	AAPL	Stock	209.55	210.18	209.08	210.0	142988.0
2025-07-16 09:00:00	AAPL	Stock	210.05	211.21	209.8	211.07	4216389.0
2025-07-16 10:00:00	AAPL	Stock	211.05	212.4	210.4893	210.7825	6209846.0
2025-07-16 11:00:00	AAPL	Stock	210.8	210.99	208.64	209.8307	5596417.0
2025-07-16 12:00:00	AAPL	Stock	209.85	210.43	209.37	210.39	2236817.0
2025-07-16 13:00:00	AAPL	Stock	210.395	210.948	210.19	210.27	2078842.0
2025-07-16 14:00:00	AAPL	Stock	210.26	210.47	209.87	210.4593	1590487.0
2025-07-16 15:00:00	AAPL	Stock	210.455	210.6366	209.97	210.15	4305186.0
2025-07-16 16:00:00	AAPL	Stock	210.12	210.29	209.8	210.0585	7872605.0
2025-07-16 17:00:00	AAPL	Stock	210.0019	210.1936	210.0	210.16	19465.0
2025-07-16 18:00:00	AAPL	Stock	210.16	210.198	209.9208	210.0	27501.0
2025-07-16 19:00:00	AAPL	Stock	209.99	210.1	209.794	210.04	22464.0
2025-07-16 04:00:00	MSFT	Stock	504.0	504.81	504.0	504.5	3358.0
2025-07-16 05:00:00	MSFT	Stock	504.36	505.73	504.36	505.67	5365.0
2025-07-16 06:00:00	MSFT	Stock	505.02	505.56	504.91	505.31	2256.0
2025-07-16 07:00:00	MSFT	Stock	505.27	505.27	504.49	504.5	3032.0
2025-07-16 08:00:00	MSFT	Stock	503.15	506.0	503.01	505.9	21465.0
2025-07-16 09:00:00	MSFT	Stock	505.9	506.35	502.32	502.825	1090703.0
2025-07-16 10:00:00	MSFT	Stock	502.89	505.02	502.48	504.29	1130330.0
2025-07-16 11:00:00	MSFT	Stock	504.33	505.5	501.89	504.455	1286276.0
2025-07-16 12:00:00	MSFT	Stock	504.41	505.055	503.25	505.0171	531438.0
2025-07-16 13:00:00	MSFT	Stock	505.025	505.84	504.96	505.34	535492.0
2025-07-16 14:00:00	MSFT	Stock	505.32	506.197	504.93	506.1936	449302.0
2025-07-16 15:00:00	MSFT	Stock	506.16	506.72	505.51	505.53	1092591.0
2025-07-16 16:00:00	MSFT	Stock	505.62	505.93	504.979	505.25	3334177.0
2025-07-16 17:00:00	MSFT	Stock	505.21	505.71	505.01	505.66	5408.0
2025-07-16 18:00:00	MSFT	Stock	504.5	504.52	504.5	504.52	500.0
2025-07-16 19:00:00	MSFT	Stock	504.6	505.0	504.452	504.75	1140.0
2025-07-16 04:00:00	NVDA	Stock	169.78	170.37	168.96	169.41	434507.0
2025-07-16 05:00:00	NVDA	Stock	169.44	169.72	169.2	169.69	162014.0
2025-07-16 06:00:00	NVDA	Stock	169.71	170.5	169.55	170.34	383673.0
2025-07-16 07:00:00	NVDA	Stock	170.31	170.89	170.22	170.85	456813.0
2025-07-16 08:00:00	NVDA	Stock	170.85	171.49	169.0	171.25	2531012.0
2025-07-16 09:00:00	NVDA	Stock	171.26	171.75	169.92	170.2012	22186381.0
2025-07-16 10:00:00	NVDA	Stock	170.21	170.64	169.28	169.8054	23459465.0
2025-07-16 11:00:00	NVDA	Stock	169.81	171.0	168.9	170.29	24709191.0
2025-07-16 12:00:00	NVDA	Stock	170.28	171.2	170.09	171.1049	12105652.0
2025-07-16 13:00:00	NVDA	Stock	171.1	171.42	170.6241	170.795	9600531.0
2025-07-16 14:00:00	NVDA	Stock	170.795	171.15	170.64	171.0482	7676525.0
2025-07-16 15:00:00	NVDA	Stock	171.04	171.45	170.675	171.34	15987392.0
2025-07-16 16:00:00	NVDA	Stock	171.34	171.3906	171.1	171.2	10780425.0
2025-07-16 17:00:00	NVDA	Stock	171.23	171.35	171.15	171.3201	197572.0
2025-07-16 18:00:00	NVDA	Stock	171.31	171.31	171.13	171.17	135385.0
2025-07-16 19:00:00	NVDA	Stock	171.1599	171.26	171.15	171.2099	159448.0
2025-07-16 04:00:00	AMZN	Stock	225.7	226.35	225.7	226.15	17867.0
2025-07-16 05:00:00	AMZN	Stock	226.15	226.21	224.6	225.41	51365.0

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

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