PREVIEW / stock_1hour / 2005-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-03.parquet
  size:    568 KB
  rows:    27,283
  symbols: 2,053

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
2005-08-03 08:00:00	AAPL	Stock	1.5425	1.5464	1.5389	1.5461	182000.0
2005-08-03 09:00:00	AAPL	Stock	1.5436	1.5446	1.5293	1.5296	33575612.0
2005-08-03 10:00:00	AAPL	Stock	1.5296	1.5468	1.5275	1.5379	59196984.0
2005-08-03 11:00:00	AAPL	Stock	1.5379	1.5407	1.5332	1.5354	21993580.0
2005-08-03 12:00:00	AAPL	Stock	1.535	1.5429	1.535	1.5393	15484000.0
2005-08-03 13:00:00	AAPL	Stock	1.5396	1.5446	1.5389	1.5429	24590888.0
2005-08-03 14:00:00	AAPL	Stock	1.5432	1.5443	1.5321	1.5375	34482252.0
2005-08-03 15:00:00	AAPL	Stock	1.5371	1.5436	1.535	1.5432	46482128.0
2005-08-03 16:00:00	AAPL	Stock	1.5425	1.5725	1.5354	1.5436	12910100.0
2005-08-03 17:00:00	AAPL	Stock	1.5504	1.5504	1.5432	1.5446	791644.0
2005-08-03 18:00:00	AAPL	Stock	1.5446	1.545	1.5446	1.5446	50120.0
2005-08-03 07:00:00	MSFT	Stock	26.76	26.8	26.69	26.7	16834.0
2005-08-03 08:00:00	MSFT	Stock	26.71	26.8	26.67	26.71	190709.0
2005-08-03 09:00:00	MSFT	Stock	26.71	27.2	26.65	27.12	23069793.0
2005-08-03 10:00:00	MSFT	Stock	27.12	27.43	26.965	27.33	31817242.0
2005-08-03 11:00:00	MSFT	Stock	27.32	27.33	27.12	27.24	22146207.0
2005-08-03 12:00:00	MSFT	Stock	27.23	27.39	27.18	27.25	13576931.0
2005-08-03 13:00:00	MSFT	Stock	27.25	27.32	27.2	27.28	9597111.0
2005-08-03 14:00:00	MSFT	Stock	27.28	27.35	27.19	27.27	15356575.0
2005-08-03 15:00:00	MSFT	Stock	27.26	27.38	27.22	27.23	21338244.0
2005-08-03 16:00:00	MSFT	Stock	27.22	27.338	27.19	27.19	1218891.0
2005-08-03 17:00:00	MSFT	Stock	27.2	27.25	27.2	27.248	220370.0
2005-08-03 18:00:00	MSFT	Stock	27.21	27.21	27.19	27.21	6239.0
2005-08-03 08:00:00	NVDA	Stock	0.2351	0.2351	0.232	0.2321	2544000.0
2005-08-03 09:00:00	NVDA	Stock	0.232	0.2342	0.2308	0.2312	97515000.0
2005-08-03 10:00:00	NVDA	Stock	0.2311	0.2322	0.2299	0.231	101234040.0
2005-08-03 11:00:00	NVDA	Stock	0.2311	0.2322	0.2306	0.2317	43665480.0
2005-08-03 12:00:00	NVDA	Stock	0.2318	0.234	0.2318	0.2332	45875400.0
2005-08-03 13:00:00	NVDA	Stock	0.2332	0.234	0.2321	0.2339	44336880.0
2005-08-03 14:00:00	NVDA	Stock	0.234	0.2341	0.2321	0.2327	70389360.0
2005-08-03 15:00:00	NVDA	Stock	0.2327	0.2328	0.2315	0.2315	92323200.0
2005-08-03 16:00:00	NVDA	Stock	0.232	0.232	0.2311	0.2312	528000.0
2005-08-03 17:00:00	NVDA	Stock	0.232	0.232	0.2318	0.232	307080.0
2005-08-03 08:00:00	AMZN	Stock	2.3255	2.3255	2.3055	2.3095	405960.0
2005-08-03 09:00:00	AMZN	Stock	2.31	2.3364	2.2925	2.293	21320660.0
2005-08-03 10:00:00	AMZN	Stock	2.2935	2.305	2.2925	2.3025	16769220.0
2005-08-03 11:00:00	AMZN	Stock	2.3025	2.309	2.297	2.3055	9437780.0
2005-08-03 12:00:00	AMZN	Stock	2.306	2.3065	2.299	2.3017	10043140.0
2005-08-03 13:00:00	AMZN	Stock	2.302	2.3025	2.2978	2.2985	7432000.0
2005-08-03 14:00:00	AMZN	Stock	2.2985	2.3015	2.293	2.3005	10462240.0
2005-08-03 15:00:00	AMZN	Stock	2.3005	2.3055	2.292	2.3045	18574920.0
2005-08-03 16:00:00	AMZN	Stock	2.3045	2.3055	2.299	2.305	600220.0
2005-08-03 17:00:00	AMZN	Stock	2.305	2.305	2.305	2.305	14800.0
2005-08-03 09:00:00	CL	Stock	26.895	26.895	26.465	26.475	447800.0
2005-08-03 10:00:00	CL	Stock	26.475	26.665	26.425	26.65	456400.0
2005-08-03 11:00:00	CL	Stock	26.65	26.655	26.565	26.6	1043800.0
2005-08-03 12:00:00	CL	Stock	26.605	26.62	26.585	26.595	353200.0
2005-08-03 13:00:00	CL	Stock	26.59	26.595	26.545	26.58	460800.0
2005-08-03 14:00:00	CL	Stock	26.575	26.59	26.51	26.555	545800.0
2005-08-03 15:00:00	CL	Stock	26.56	26.615	26.55	26.56	607400.0

> showing 50 of 27,283 rows — these rows as CSV

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