PREVIEW / stock_1hour / 2001-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-09.parquet
  size:    355 KB
  rows:    16,849
  symbols: 1,324

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
2001-08-09 08:00:00	AAPL	Stock	0.3375	0.3375	0.3354	0.3373	330400.0
2001-08-09 09:00:00	AAPL	Stock	0.3389	0.3402	0.3348	0.34	18592000.0
2001-08-09 10:00:00	AAPL	Stock	0.34	0.3402	0.3343	0.337	40476800.0
2001-08-09 11:00:00	AAPL	Stock	0.3371	0.3405	0.3354	0.3357	31740800.0
2001-08-09 12:00:00	AAPL	Stock	0.3357	0.3382	0.3348	0.3377	14302400.0
2001-08-09 13:00:00	AAPL	Stock	0.3377	0.3414	0.3366	0.3391	17197600.0
2001-08-09 14:00:00	AAPL	Stock	0.3391	0.3418	0.3375	0.34	17444000.0
2001-08-09 15:00:00	AAPL	Stock	0.34	0.342	0.3354	0.3402	42179200.0
2001-08-09 16:00:00	AAPL	Stock	0.3402	0.3427	0.3393	0.3393	4054400.0
2001-08-09 17:00:00	AAPL	Stock	0.3409	0.3409	0.3409	0.3409	5600.0
2001-08-09 18:00:00	AAPL	Stock	0.3425	0.3425	0.3425	0.3425	11200.0
2001-08-09 08:00:00	MSFT	Stock	32.5	32.65	32.015	32.6	215400.0
2001-08-09 09:00:00	MSFT	Stock	32.6	32.7	32.055	32.695	7010800.0
2001-08-09 10:00:00	MSFT	Stock	32.695	32.72	32.15	32.3	8035800.0
2001-08-09 11:00:00	MSFT	Stock	32.3	32.56	32.16	32.27	6031600.0
2001-08-09 12:00:00	MSFT	Stock	32.265	32.585	32.21	32.55	4787000.0
2001-08-09 13:00:00	MSFT	Stock	32.555	32.75	32.465	32.55	4927400.0
2001-08-09 14:00:00	MSFT	Stock	32.56	32.68	32.375	32.52	3348400.0
2001-08-09 15:00:00	MSFT	Stock	32.52	32.67	32.45	32.505	6910200.0
2001-08-09 16:00:00	MSFT	Stock	32.5	32.75	32.425	32.51	2137800.0
2001-08-09 17:00:00	MSFT	Stock	32.495	32.55	32.495	32.55	3000.0
2001-08-09 18:00:00	MSFT	Stock	32.55	32.55	32.55	32.55	1600.0
2001-08-09 08:00:00	NVDA	Stock	0.3592	0.3599	0.3573	0.3583	1056000.0
2001-08-09 09:00:00	NVDA	Stock	0.3583	0.3629	0.357	0.3623	168480000.0
2001-08-09 10:00:00	NVDA	Stock	0.3623	0.3648	0.3475	0.35	365664000.0
2001-08-09 11:00:00	NVDA	Stock	0.3502	0.3544	0.3488	0.3505	266016000.0
2001-08-09 12:00:00	NVDA	Stock	0.3503	0.3524	0.3482	0.3516	92136000.0
2001-08-09 13:00:00	NVDA	Stock	0.3518	0.3565	0.3515	0.3533	203424000.0
2001-08-09 14:00:00	NVDA	Stock	0.3535	0.354	0.3467	0.3488	200904000.0
2001-08-09 15:00:00	NVDA	Stock	0.3485	0.3546	0.3484	0.353	271704000.0
2001-08-09 16:00:00	NVDA	Stock	0.353	0.3542	0.3511	0.3535	15960000.0
2001-08-09 17:00:00	NVDA	Stock	0.3542	0.3542	0.3542	0.3542	24000.0
2001-08-09 18:00:00	NVDA	Stock	0.3538	0.354	0.3538	0.354	144000.0
2001-08-09 08:00:00	AMZN	Stock	0.5555	0.5555	0.5555	0.5555	4000.0
2001-08-09 09:00:00	AMZN	Stock	0.557	0.5585	0.545	0.55	10080000.0
2001-08-09 10:00:00	AMZN	Stock	0.5495	0.5495	0.5125	0.5205	27462000.0
2001-08-09 11:00:00	AMZN	Stock	0.522	0.5475	0.516	0.535	21990000.0
2001-08-09 12:00:00	AMZN	Stock	0.5355	0.5435	0.531	0.535	12630000.0
2001-08-09 13:00:00	AMZN	Stock	0.5325	0.5395	0.5325	0.534	13956000.0
2001-08-09 14:00:00	AMZN	Stock	0.534	0.5355	0.526	0.5305	8174000.0
2001-08-09 15:00:00	AMZN	Stock	0.531	0.5325	0.5225	0.5225	18228000.0
2001-08-09 16:00:00	AMZN	Stock	0.523	0.5525	0.521	0.533	3788000.0
2001-08-09 17:00:00	AMZN	Stock	0.5295	0.5295	0.5295	0.5295	8000.0
2001-08-09 09:00:00	CL	Stock	26.495	26.595	26.455	26.51	589800.0
2001-08-09 10:00:00	CL	Stock	26.515	26.575	26.425	26.575	490600.0
2001-08-09 11:00:00	CL	Stock	26.58	26.805	26.5	26.72	323000.0
2001-08-09 12:00:00	CL	Stock	26.745	26.975	26.72	26.94	908000.0
2001-08-09 13:00:00	CL	Stock	26.94	26.965	26.835	26.835	461000.0
2001-08-09 14:00:00	CL	Stock	26.85	26.85	26.675	26.71	561000.0
2001-08-09 15:00:00	CL	Stock	26.7	26.815	26.675	26.73	860000.0

> showing 50 of 16,849 rows — these rows as CSV

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