PREVIEW / stock_1hour / 2025-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-07-15.parquet
  size:    1.4 MB
  rows:    60,809
  symbols: 372

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-15 04:00:00	AAPL	Stock	208.43	209.88	208.43	209.4	44526.0
2025-07-15 05:00:00	AAPL	Stock	209.37	209.74	209.32	209.59	25539.0
2025-07-15 06:00:00	AAPL	Stock	209.55	209.88	209.08	209.13	20144.0
2025-07-15 07:00:00	AAPL	Stock	209.17	209.36	208.98	209.1	33139.0
2025-07-15 08:00:00	AAPL	Stock	209.28	209.93	208.099	209.25	214948.0
2025-07-15 09:00:00	AAPL	Stock	209.3	211.13	208.92	209.645	5309829.0
2025-07-15 10:00:00	AAPL	Stock	209.65	210.3	209.1977	209.35	3699831.0
2025-07-15 11:00:00	AAPL	Stock	209.35	211.89	209.26	210.79	4715900.0
2025-07-15 12:00:00	AAPL	Stock	210.79	210.985	210.36	210.58	2036943.0
2025-07-15 13:00:00	AAPL	Stock	210.56	211.35	210.44	211.28	1599956.0
2025-07-15 14:00:00	AAPL	Stock	211.2701	211.67	210.43	210.51	2259835.0
2025-07-15 15:00:00	AAPL	Stock	210.52	210.6863	208.98	209.01	4347060.0
2025-07-15 16:00:00	AAPL	Stock	209.11	209.13	208.86	208.89	4723873.0
2025-07-15 17:00:00	AAPL	Stock	208.91	209.11	208.86	208.92	27666.0
2025-07-15 18:00:00	AAPL	Stock	208.95	209.02	208.75	208.85	30136.0
2025-07-15 19:00:00	AAPL	Stock	208.87	208.99	208.77	208.92	22324.0
2025-07-15 04:00:00	MSFT	Stock	503.04	503.04	502.13	502.16	2243.0
2025-07-15 05:00:00	MSFT	Stock	502.3	502.4	501.56	501.6	1672.0
2025-07-15 06:00:00	MSFT	Stock	501.6	502.28	501.6	502.28	2476.0
2025-07-15 07:00:00	MSFT	Stock	502.25	502.58	501.7	501.7	3471.0
2025-07-15 08:00:00	MSFT	Stock	502.34	504.0	501.4	502.7995	36335.0
2025-07-15 09:00:00	MSFT	Stock	502.62	505.65	502.0327	505.275	1180087.0
2025-07-15 10:00:00	MSFT	Stock	505.295	506.29	504.3701	504.825	960985.0
2025-07-15 11:00:00	MSFT	Stock	504.83	507.39	504.67	507.075	918219.0
2025-07-15 12:00:00	MSFT	Stock	507.09	507.7399	506.22	506.445	607333.0
2025-07-15 13:00:00	MSFT	Stock	506.425	508.2	506.41	508.14	484913.0
2025-07-15 14:00:00	MSFT	Stock	508.15	508.3	506.88	506.96	575062.0
2025-07-15 15:00:00	MSFT	Stock	506.91	507.1	505.63	505.685	1308815.0
2025-07-15 16:00:00	MSFT	Stock	505.82	505.82	504.5	505.2	2277423.0
2025-07-15 17:00:00	MSFT	Stock	505.25	505.82	503.71	503.71	7279.0
2025-07-15 18:00:00	MSFT	Stock	504.41	504.69	501.0	503.0	20939.0
2025-07-15 19:00:00	MSFT	Stock	503.01	504.4982	503.01	503.7214	2947.0
2025-07-15 04:00:00	NVDA	Stock	170.48	172.0	169.05	171.55	1552019.0
2025-07-15 05:00:00	NVDA	Stock	171.55	172.87	171.42	172.47	988172.0
2025-07-15 06:00:00	NVDA	Stock	172.47	172.52	171.56	171.78	715894.0
2025-07-15 07:00:00	NVDA	Stock	171.76	171.8	170.92	171.449	1587267.0
2025-07-15 08:00:00	NVDA	Stock	171.44	172.81	169.67	172.3	7276575.0
2025-07-15 09:00:00	NVDA	Stock	172.3	172.34	169.195	169.61	48029334.0
2025-07-15 10:00:00	NVDA	Stock	169.613	172.4	169.47	171.005	39464664.0
2025-07-15 11:00:00	NVDA	Stock	171.01	171.55	170.6847	171.255	16630736.0
2025-07-15 12:00:00	NVDA	Stock	171.255	171.605	170.37	170.65	12958171.0
2025-07-15 13:00:00	NVDA	Stock	170.65	171.0	170.25	170.93	12423253.0
2025-07-15 14:00:00	NVDA	Stock	170.925	171.11	170.24	170.29	10962905.0
2025-07-15 15:00:00	NVDA	Stock	170.27	171.0	169.94	170.55	22146626.0
2025-07-15 16:00:00	NVDA	Stock	170.55	170.95	169.87	170.06	14516687.0
2025-07-15 17:00:00	NVDA	Stock	170.04	170.7	169.93	170.16	319236.0
2025-07-15 18:00:00	NVDA	Stock	170.15	170.22	169.85	170.19	272414.0
2025-07-15 19:00:00	NVDA	Stock	170.2	170.3191	170.11	170.2	270729.0
2025-07-15 04:00:00	AMZN	Stock	225.69	226.34	225.57	225.69	13189.0
2025-07-15 05:00:00	AMZN	Stock	225.61	226.2	225.4	226.01	22608.0

> showing 50 of 60,809 rows — these rows as CSV

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