PREVIEW / stock_1hour / 2025-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-08-27.parquet
  size:    1.4 MB
  rows:    61,777
  symbols: 325

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-08-27 04:00:00	AAPL	Stock	229.67	229.73	229.33	229.4	7821.0
2025-08-27 05:00:00	AAPL	Stock	229.58	229.6	229.2	229.34	4601.0
2025-08-27 06:00:00	AAPL	Stock	229.22	229.35	229.14	229.35	5509.0
2025-08-27 07:00:00	AAPL	Stock	229.38	229.52	229.32	229.35	7753.0
2025-08-27 08:00:00	AAPL	Stock	229.41	230.12	228.49	229.2015	82826.0
2025-08-27 09:00:00	AAPL	Stock	229.3	230.25	228.26	229.795	3794539.0
2025-08-27 10:00:00	AAPL	Stock	229.755	230.71	229.29	230.18	4200983.0
2025-08-27 11:00:00	AAPL	Stock	230.18	230.34	229.3	229.915	2342973.0
2025-08-27 12:00:00	AAPL	Stock	229.92	230.088	229.6	229.78	1387704.0
2025-08-27 13:00:00	AAPL	Stock	229.77	230.09	229.67	229.99	1311338.0
2025-08-27 14:00:00	AAPL	Stock	229.98	230.68	229.89	230.15	1875325.0
2025-08-27 15:00:00	AAPL	Stock	230.155	230.9	229.72	230.5	3435003.0
2025-08-27 16:00:00	AAPL	Stock	230.45	231.36	230.0	231.28	4195221.0
2025-08-27 17:00:00	AAPL	Stock	231.3	231.36	231.01	231.11	30645.0
2025-08-27 18:00:00	AAPL	Stock	231.1399	231.1399	230.51	230.85	33627.0
2025-08-27 19:00:00	AAPL	Stock	230.8992	230.9	230.51	230.5493	24393.0
2025-08-27 04:00:00	MSFT	Stock	502.26	502.51	502.1	502.12	1105.0
2025-08-27 05:00:00	MSFT	Stock	502.6	503.06	502.6	503.06	2400.0
2025-08-27 06:00:00	MSFT	Stock	502.85	503.1	502.85	503.1	299.0
2025-08-27 07:00:00	MSFT	Stock	502.73	504.0	502.7	504.0	5366.0
2025-08-27 08:00:00	MSFT	Stock	502.9	504.3	502.1	504.0	37919.0
2025-08-27 09:00:00	MSFT	Stock	504.0999	504.15	499.9	500.265	1162698.0
2025-08-27 10:00:00	MSFT	Stock	500.265	505.12	500.17	503.93	1516715.0
2025-08-27 11:00:00	MSFT	Stock	503.96	504.85	503.475	504.61	895007.0
2025-08-27 12:00:00	MSFT	Stock	504.64	505.58	503.455	505.03	637515.0
2025-08-27 13:00:00	MSFT	Stock	505.06	506.585	504.895	506.32	654991.0
2025-08-27 14:00:00	MSFT	Stock	506.335	506.84	505.6401	506.31	507000.0
2025-08-27 15:00:00	MSFT	Stock	506.27	507.29	504.9151	506.58	1381475.0
2025-08-27 16:00:00	MSFT	Stock	506.74	506.86	503.0	506.6	2781469.0
2025-08-27 17:00:00	MSFT	Stock	506.69	508.2999	506.4	508.0	27051.0
2025-08-27 18:00:00	MSFT	Stock	507.75	507.9	506.33	506.8	13321.0
2025-08-27 19:00:00	MSFT	Stock	506.7	506.99	506.0	506.2	5699.0
2025-08-27 04:00:00	NVDA	Stock	182.3	182.63	182.1	182.6	290696.0
2025-08-27 05:00:00	NVDA	Stock	182.59	182.8	182.52	182.73	193856.0
2025-08-27 06:00:00	NVDA	Stock	182.74	183.2	182.72	182.92	355637.0
2025-08-27 07:00:00	NVDA	Stock	182.92	183.06	182.731	183.0	451303.0
2025-08-27 08:00:00	NVDA	Stock	182.92	183.19	182.05	182.43	1883045.0
2025-08-27 09:00:00	NVDA	Stock	182.42	182.69	179.1	180.19	28890520.0
2025-08-27 10:00:00	NVDA	Stock	180.18	182.44	180.01	182.0351	27244859.0
2025-08-27 11:00:00	NVDA	Stock	182.04	182.23	181.53	181.9676	16020208.0
2025-08-27 12:00:00	NVDA	Stock	181.965	182.2	181.11	181.88	14161551.0
2025-08-27 13:00:00	NVDA	Stock	181.88	182.02	181.63	182.005	10533824.0
2025-08-27 14:00:00	NVDA	Stock	182.005	182.49	181.87	181.92	13170832.0
2025-08-27 15:00:00	NVDA	Stock	181.915	181.94	180.93	181.6	26334407.0
2025-08-27 16:00:00	NVDA	Stock	181.6	183.4	171.86	176.74	33126878.0
2025-08-27 17:00:00	NVDA	Stock	176.73	178.8	175.47	176.7394	8204207.0
2025-08-27 18:00:00	NVDA	Stock	176.69	176.7391	175.58	176.04	2689448.0
2025-08-27 19:00:00	NVDA	Stock	176.03	176.5	175.8	175.9	1547376.0
2025-08-27 04:00:00	AMZN	Stock	228.33	228.71	228.19	228.37	19093.0
2025-08-27 05:00:00	AMZN	Stock	228.45	228.79	228.45	228.62	8210.0

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

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