PREVIEW / stock_1hour / 2000-07-05

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-05.parquet
  size:    295 KB
  rows:    15,423
  symbols: 1,192

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
2000-07-05 08:00:00	AAPL	Stock	0.9481	0.9509	0.9442	0.9475	280000.0
2000-07-05 09:00:00	AAPL	Stock	0.9442	0.9799	0.9353	0.9777	41098400.0
2000-07-05 10:00:00	AAPL	Stock	0.9777	0.9855	0.9576	0.9587	58161600.0
2000-07-05 11:00:00	AAPL	Stock	0.9587	0.9598	0.9453	0.9475	35599200.0
2000-07-05 12:00:00	AAPL	Stock	0.9475	0.9498	0.9364	0.9364	23816800.0
2000-07-05 13:00:00	AAPL	Stock	0.9364	0.9375	0.9275	0.933	23161600.0
2000-07-05 14:00:00	AAPL	Stock	0.9319	0.933	0.9107	0.9152	32048800.0
2000-07-05 15:00:00	AAPL	Stock	0.9124	0.9286	0.9063	0.9219	39900000.0
2000-07-05 16:00:00	AAPL	Stock	0.9219	0.9375	0.9219	0.9219	8405600.0
2000-07-05 17:00:00	AAPL	Stock	0.9241	0.9252	0.9174	0.9174	380800.0
2000-07-05 08:00:00	MSFT	Stock	39.8125	39.9688	39.5	39.8125	52800.0
2000-07-05 09:00:00	MSFT	Stock	39.75	39.9688	39.375	39.625	5353200.0
2000-07-05 10:00:00	MSFT	Stock	39.625	39.75	39.375	39.5312	4288400.0
2000-07-05 11:00:00	MSFT	Stock	39.5312	39.9375	39.5	39.9062	4071200.0
2000-07-05 12:00:00	MSFT	Stock	39.9219	39.9375	39.6875	39.7188	2140200.0
2000-07-05 13:00:00	MSFT	Stock	39.75	39.9375	39.6875	39.875	2489200.0
2000-07-05 14:00:00	MSFT	Stock	39.875	39.9062	39.625	39.6562	3999800.0
2000-07-05 15:00:00	MSFT	Stock	39.6562	39.75	39.1562	39.25	6940400.0
2000-07-05 16:00:00	MSFT	Stock	39.25	39.6094	39.0625	39.25	4316200.0
2000-07-05 17:00:00	MSFT	Stock	39.3438	39.375	39.3438	39.375	2000.0
2000-07-05 18:00:00	MSFT	Stock	39.5781	39.5781	39.3438	39.3438	800.0
2000-07-05 08:00:00	NVDA	Stock	0.2547	0.2547	0.2547	0.2547	192000.0
2000-07-05 09:00:00	NVDA	Stock	0.2531	0.2542	0.2411	0.2448	184056000.0
2000-07-05 10:00:00	NVDA	Stock	0.2448	0.2469	0.2411	0.2417	63048000.0
2000-07-05 11:00:00	NVDA	Stock	0.2417	0.2435	0.2333	0.2396	192768000.0
2000-07-05 12:00:00	NVDA	Stock	0.2401	0.2401	0.2315	0.2328	71784000.0
2000-07-05 13:00:00	NVDA	Stock	0.2328	0.2341	0.2276	0.2313	75168000.0
2000-07-05 14:00:00	NVDA	Stock	0.2302	0.2313	0.225	0.2255	76848000.0
2000-07-05 15:00:00	NVDA	Stock	0.2263	0.2279	0.2219	0.2273	102288000.0
2000-07-05 16:00:00	NVDA	Stock	0.2276	0.2292	0.2273	0.2292	4224000.0
2000-07-05 17:00:00	NVDA	Stock	0.2273	0.2281	0.2273	0.2281	72000.0
2000-07-05 18:00:00	NVDA	Stock	0.2273	0.2273	0.2273	0.2273	48000.0
2000-07-05 08:00:00	AMZN	Stock	1.8406	1.8531	1.825	1.8281	50000.0
2000-07-05 09:00:00	AMZN	Stock	1.8281	1.8594	1.8188	1.8391	8720000.0
2000-07-05 10:00:00	AMZN	Stock	1.8406	1.925	1.8344	1.8938	24550000.0
2000-07-05 11:00:00	AMZN	Stock	1.8906	1.9031	1.8688	1.9	9326000.0
2000-07-05 12:00:00	AMZN	Stock	1.9	1.9062	1.8875	1.8938	6922000.0
2000-07-05 13:00:00	AMZN	Stock	1.8906	1.8938	1.8688	1.8719	8700000.0
2000-07-05 14:00:00	AMZN	Stock	1.8719	1.8719	1.8375	1.8375	8922000.0
2000-07-05 15:00:00	AMZN	Stock	1.8375	1.8531	1.8219	1.825	13542000.0
2000-07-05 16:00:00	AMZN	Stock	1.825	1.8312	1.8188	1.825	2072000.0
2000-07-05 17:00:00	AMZN	Stock	1.8188	1.825	1.8125	1.8125	10000.0
2000-07-05 18:00:00	AMZN	Stock	1.8125	1.8125	1.8125	1.8125	8000.0
2000-07-05 09:00:00	CL	Stock	29.5	29.8438	29.5	29.6562	388200.0
2000-07-05 10:00:00	CL	Stock	29.6562	29.7188	29.4375	29.5312	557600.0
2000-07-05 11:00:00	CL	Stock	29.5625	29.6875	29.5	29.6875	394400.0
2000-07-05 12:00:00	CL	Stock	29.6875	29.6875	29.5	29.5938	332800.0
2000-07-05 13:00:00	CL	Stock	29.625	29.625	29.5312	29.5938	406200.0
2000-07-05 14:00:00	CL	Stock	29.625	29.9062	29.5938	29.8125	369800.0
2000-07-05 15:00:00	CL	Stock	29.8125	29.875	29.5938	29.6562	539600.0

> showing 50 of 15,423 rows — these rows as CSV

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