PREVIEW / stock_1hour / 2000-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-09-28.parquet
  size:    317 KB
  rows:    15,979
  symbols: 1,222

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-09-28 08:00:00	AAPL	Stock	0.8733	0.8733	0.8733	0.8733	4715200.0
2000-09-28 09:00:00	AAPL	Stock	0.8772	0.8884	0.8761	0.8817	32289600.0
2000-09-28 10:00:00	AAPL	Stock	0.8817	0.8839	0.8594	0.8795	56823200.0
2000-09-28 11:00:00	AAPL	Stock	0.8806	0.9046	0.8761	0.9046	57814400.0
2000-09-28 12:00:00	AAPL	Stock	0.904	0.9163	0.9018	0.9118	37049600.0
2000-09-28 13:00:00	AAPL	Stock	0.9118	0.9297	0.9096	0.9241	32435200.0
2000-09-28 14:00:00	AAPL	Stock	0.9241	0.9442	0.9196	0.9408	36164800.0
2000-09-28 15:00:00	AAPL	Stock	0.942	0.9609	0.9353	0.9554	51878400.0
2000-09-28 16:00:00	AAPL	Stock	0.9542	0.9576	0.9464	0.9559	10802400.0
2000-09-28 17:00:00	AAPL	Stock	0.9107	0.9431	0.3571	0.5179	456881600.0
2000-09-28 18:00:00	AAPL	Stock	0.5195	0.5804	0.5022	0.5212	191340800.0
2000-09-28 08:00:00	MSFT	Stock	30.5	30.5	30.0	30.3125	50800.0
2000-09-28 09:00:00	MSFT	Stock	30.3438	30.75	30.25	30.4375	8407400.0
2000-09-28 10:00:00	MSFT	Stock	30.4375	30.8125	30.375	30.7812	8498000.0
2000-09-28 11:00:00	MSFT	Stock	30.8125	30.9062	30.5	30.8438	5511000.0
2000-09-28 12:00:00	MSFT	Stock	30.8438	30.9375	30.625	30.6562	5027200.0
2000-09-28 13:00:00	MSFT	Stock	30.6562	30.9375	30.5938	30.8125	5852200.0
2000-09-28 14:00:00	MSFT	Stock	30.8438	30.8438	30.5625	30.8125	6037200.0
2000-09-28 15:00:00	MSFT	Stock	30.8438	30.8438	30.5625	30.6562	8227200.0
2000-09-28 16:00:00	MSFT	Stock	30.625	30.6719	29.8125	30.3438	2428800.0
2000-09-28 17:00:00	MSFT	Stock	30.3125	30.8438	30.0312	30.25	461000.0
2000-09-28 18:00:00	MSFT	Stock	30.25	30.2812	30.1875	30.25	10000.0
2000-09-28 08:00:00	NVDA	Stock	0.3406	0.3417	0.3406	0.3417	432000.0
2000-09-28 09:00:00	NVDA	Stock	0.3396	0.3451	0.3292	0.3396	44544000.0
2000-09-28 10:00:00	NVDA	Stock	0.3396	0.3531	0.3375	0.3518	59184000.0
2000-09-28 11:00:00	NVDA	Stock	0.3518	0.3531	0.3432	0.3461	52968000.0
2000-09-28 12:00:00	NVDA	Stock	0.3462	0.3479	0.3396	0.3396	43056000.0
2000-09-28 13:00:00	NVDA	Stock	0.3396	0.3448	0.3354	0.3448	25800000.0
2000-09-28 14:00:00	NVDA	Stock	0.3448	0.3477	0.3427	0.3456	27048000.0
2000-09-28 15:00:00	NVDA	Stock	0.3461	0.3526	0.3458	0.351	64320000.0
2000-09-28 16:00:00	NVDA	Stock	0.351	0.3521	0.3474	0.3474	3240000.0
2000-09-28 17:00:00	NVDA	Stock	0.3479	0.3479	0.3458	0.3458	72000.0
2000-09-28 08:00:00	AMZN	Stock	1.9	1.9	1.85	1.8812	96000.0
2000-09-28 09:00:00	AMZN	Stock	1.8781	1.9156	1.8562	1.8719	15960000.0
2000-09-28 10:00:00	AMZN	Stock	1.8719	1.9328	1.8688	1.9312	25078000.0
2000-09-28 11:00:00	AMZN	Stock	1.9344	1.9812	1.925	1.9812	21486000.0
2000-09-28 12:00:00	AMZN	Stock	1.9812	2.0125	1.9719	1.9781	17478000.0
2000-09-28 13:00:00	AMZN	Stock	1.9781	1.9875	1.9562	1.9688	5288000.0
2000-09-28 14:00:00	AMZN	Stock	1.9656	2.0	1.9594	1.9953	7856000.0
2000-09-28 15:00:00	AMZN	Stock	1.9938	2.0062	1.9844	2.0	17070000.0
2000-09-28 16:00:00	AMZN	Stock	1.9938	2.0031	1.975	1.9812	2484000.0
2000-09-28 17:00:00	AMZN	Stock	1.9625	1.975	1.8562	1.925	80000.0
2000-09-28 18:00:00	AMZN	Stock	1.9938	1.9938	1.95	1.95	24000.0
2000-09-28 09:00:00	CL	Stock	22.275	22.6	22.26	22.41	214400.0
2000-09-28 10:00:00	CL	Stock	22.435	23.0	22.405	22.985	863000.0
2000-09-28 11:00:00	CL	Stock	22.99	23.275	22.965	23.25	743800.0
2000-09-28 12:00:00	CL	Stock	23.25	23.375	23.195	23.245	563800.0
2000-09-28 13:00:00	CL	Stock	23.23	23.275	23.175	23.25	274400.0
2000-09-28 14:00:00	CL	Stock	23.2	23.775	23.18	23.74	893800.0
2000-09-28 15:00:00	CL	Stock	23.725	23.725	23.45	23.62	869800.0

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

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