PREVIEW / stock_1hour / 2001-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-08.parquet
  size:    357 KB
  rows:    16,790
  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-08 08:00:00	AAPL	Stock	0.3429	0.3438	0.3429	0.3438	11200.0
2001-08-08 09:00:00	AAPL	Stock	0.3429	0.35	0.3405	0.35	24040800.0
2001-08-08 10:00:00	AAPL	Stock	0.3498	0.3511	0.3455	0.35	30273600.0
2001-08-08 11:00:00	AAPL	Stock	0.3502	0.3518	0.3482	0.3495	22948800.0
2001-08-08 12:00:00	AAPL	Stock	0.3496	0.3509	0.3491	0.3496	16240000.0
2001-08-08 13:00:00	AAPL	Stock	0.3495	0.3507	0.3455	0.3468	23492000.0
2001-08-08 14:00:00	AAPL	Stock	0.3466	0.3466	0.3339	0.337	64092000.0
2001-08-08 15:00:00	AAPL	Stock	0.3371	0.3389	0.3311	0.3375	72139200.0
2001-08-08 16:00:00	AAPL	Stock	0.3375	0.3384	0.3321	0.3375	12516000.0
2001-08-08 17:00:00	AAPL	Stock	0.3375	0.3375	0.3375	0.3375	16800.0
2001-08-08 08:00:00	MSFT	Stock	33.25	33.45	33.1	33.275	235600.0
2001-08-08 09:00:00	MSFT	Stock	33.275	33.4	33.015	33.275	6994400.0
2001-08-08 10:00:00	MSFT	Stock	33.29	33.535	33.245	33.465	7921800.0
2001-08-08 11:00:00	MSFT	Stock	33.47	33.62	33.355	33.445	5950800.0
2001-08-08 12:00:00	MSFT	Stock	33.45	33.475	33.305	33.345	3471800.0
2001-08-08 13:00:00	MSFT	Stock	33.35	33.37	33.05	33.1	4731400.0
2001-08-08 14:00:00	MSFT	Stock	33.1	33.115	32.45	32.645	10180400.0
2001-08-08 15:00:00	MSFT	Stock	32.64	32.655	32.245	32.425	11837600.0
2001-08-08 16:00:00	MSFT	Stock	32.43	33.305	32.375	32.5	1555400.0
2001-08-08 17:00:00	MSFT	Stock	32.5	32.5	32.465	32.475	11600.0
2001-08-08 18:00:00	MSFT	Stock	32.5	32.59	32.5	32.555	7600.0
2001-08-08 08:00:00	NVDA	Stock	0.365	0.365	0.363	0.3646	720000.0
2001-08-08 09:00:00	NVDA	Stock	0.3632	0.3722	0.3632	0.3719	112992000.0
2001-08-08 10:00:00	NVDA	Stock	0.372	0.3747	0.3668	0.3731	189552000.0
2001-08-08 11:00:00	NVDA	Stock	0.3731	0.375	0.3692	0.3693	99024000.0
2001-08-08 12:00:00	NVDA	Stock	0.3693	0.37	0.3675	0.3684	57528000.0
2001-08-08 13:00:00	NVDA	Stock	0.3684	0.3688	0.3613	0.3615	164904000.0
2001-08-08 14:00:00	NVDA	Stock	0.3615	0.3645	0.3586	0.363	185568000.0
2001-08-08 15:00:00	NVDA	Stock	0.3627	0.3628	0.3578	0.3599	258864000.0
2001-08-08 16:00:00	NVDA	Stock	0.36	0.3677	0.3583	0.3592	19440000.0
2001-08-08 17:00:00	NVDA	Stock	0.3594	0.3594	0.3588	0.3588	72000.0
2001-08-08 18:00:00	NVDA	Stock	0.3598	0.3598	0.3598	0.3598	96000.0
2001-08-08 08:00:00	AMZN	Stock	0.575	0.575	0.575	0.575	2000.0
2001-08-08 09:00:00	AMZN	Stock	0.58	0.58	0.566	0.573	6612000.0
2001-08-08 10:00:00	AMZN	Stock	0.573	0.575	0.5695	0.572	8762000.0
2001-08-08 11:00:00	AMZN	Stock	0.5725	0.575	0.57	0.5725	9376000.0
2001-08-08 12:00:00	AMZN	Stock	0.5725	0.5745	0.57	0.571	3732000.0
2001-08-08 13:00:00	AMZN	Stock	0.571	0.5725	0.5675	0.568	4708000.0
2001-08-08 14:00:00	AMZN	Stock	0.5675	0.57	0.56	0.564	10714000.0
2001-08-08 15:00:00	AMZN	Stock	0.5635	0.5655	0.5515	0.5565	18502000.0
2001-08-08 16:00:00	AMZN	Stock	0.5605	0.573	0.5545	0.5565	2278000.0
2001-08-08 17:00:00	AMZN	Stock	0.5565	0.558	0.5565	0.558	126000.0
2001-08-08 09:00:00	CL	Stock	26.45	26.45	26.28	26.425	175200.0
2001-08-08 10:00:00	CL	Stock	26.42	26.85	26.325	26.85	458600.0
2001-08-08 11:00:00	CL	Stock	26.85	26.855	26.705	26.735	697000.0
2001-08-08 12:00:00	CL	Stock	26.74	26.77	26.63	26.705	169400.0
2001-08-08 13:00:00	CL	Stock	26.705	26.705	26.575	26.58	432400.0
2001-08-08 14:00:00	CL	Stock	26.575	26.635	26.44	26.63	322000.0
2001-08-08 15:00:00	CL	Stock	26.625	26.625	26.455	26.495	546200.0
2001-08-08 16:00:00	CL	Stock	26.51	26.51	26.495	26.495	59400.0

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

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