PREVIEW / stock_1hour / 2001-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-20.parquet
  size:    367 KB
  rows:    17,551
  symbols: 1,312

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-06-20 08:00:00	AAPL	Stock	0.3589	0.3605	0.3573	0.3573	1411200.0
2001-06-20 09:00:00	AAPL	Stock	0.3575	0.3696	0.3568	0.3691	46261600.0
2001-06-20 10:00:00	AAPL	Stock	0.3689	0.3784	0.3679	0.3779	63431200.0
2001-06-20 11:00:00	AAPL	Stock	0.3782	0.3807	0.3764	0.3771	67978400.0
2001-06-20 12:00:00	AAPL	Stock	0.3764	0.3802	0.3755	0.3761	37251200.0
2001-06-20 13:00:00	AAPL	Stock	0.3761	0.3786	0.3736	0.3766	33650400.0
2001-06-20 14:00:00	AAPL	Stock	0.3766	0.3838	0.3755	0.3818	50971200.0
2001-06-20 15:00:00	AAPL	Stock	0.382	0.3902	0.3818	0.387	98840000.0
2001-06-20 16:00:00	AAPL	Stock	0.387	0.3884	0.377	0.387	5717600.0
2001-06-20 17:00:00	AAPL	Stock	0.387	0.387	0.3857	0.3857	386400.0
2001-06-20 18:00:00	AAPL	Stock	0.3857	0.3857	0.3857	0.3857	5600.0
2001-06-20 08:00:00	MSFT	Stock	33.59	33.59	33.25	33.45	15000.0
2001-06-20 09:00:00	MSFT	Stock	33.3	34.2	33.3	34.09	9258000.0
2001-06-20 10:00:00	MSFT	Stock	34.115	34.445	34.0	34.335	13169400.0
2001-06-20 11:00:00	MSFT	Stock	34.335	34.46	34.11	34.14	6723400.0
2001-06-20 12:00:00	MSFT	Stock	34.14	34.345	34.07	34.13	3130400.0
2001-06-20 13:00:00	MSFT	Stock	34.115	34.13	33.65	33.82	6794200.0
2001-06-20 14:00:00	MSFT	Stock	33.825	34.325	33.75	34.26	7225800.0
2001-06-20 15:00:00	MSFT	Stock	34.26	34.795	34.245	34.705	12980800.0
2001-06-20 16:00:00	MSFT	Stock	34.71	34.75	34.095	34.675	1233800.0
2001-06-20 17:00:00	MSFT	Stock	33.555	34.715	33.555	34.65	202800.0
2001-06-20 18:00:00	MSFT	Stock	34.675	34.71	34.675	34.71	1800.0
2001-06-20 08:00:00	NVDA	Stock	0.3542	0.3558	0.3505	0.3525	2448000.0
2001-06-20 09:00:00	NVDA	Stock	0.3525	0.3635	0.3506	0.3622	270480000.0
2001-06-20 10:00:00	NVDA	Stock	0.3622	0.3677	0.3537	0.365	239712000.0
2001-06-20 11:00:00	NVDA	Stock	0.3646	0.3729	0.364	0.3669	210600000.0
2001-06-20 12:00:00	NVDA	Stock	0.3661	0.3668	0.359	0.359	105288000.0
2001-06-20 13:00:00	NVDA	Stock	0.359	0.3602	0.3456	0.3518	201840000.0
2001-06-20 14:00:00	NVDA	Stock	0.3519	0.3594	0.35	0.3515	199368000.0
2001-06-20 15:00:00	NVDA	Stock	0.3514	0.3792	0.3507	0.3754	428592000.0
2001-06-20 16:00:00	NVDA	Stock	0.375	0.3792	0.3742	0.3758	33624000.0
2001-06-20 17:00:00	NVDA	Stock	0.377	0.377	0.375	0.376	264000.0
2001-06-20 18:00:00	NVDA	Stock	0.3763	0.3766	0.3763	0.3766	96000.0
2001-06-20 08:00:00	AMZN	Stock	0.555	0.555	0.555	0.555	2000.0
2001-06-20 09:00:00	AMZN	Stock	0.5625	0.5775	0.5575	0.5645	12758000.0
2001-06-20 10:00:00	AMZN	Stock	0.5645	0.583	0.56	0.579	26116000.0
2001-06-20 11:00:00	AMZN	Stock	0.5825	0.596	0.5785	0.587	39460000.0
2001-06-20 12:00:00	AMZN	Stock	0.586	0.5995	0.585	0.5965	20704000.0
2001-06-20 13:00:00	AMZN	Stock	0.594	0.6	0.5785	0.5925	10880000.0
2001-06-20 14:00:00	AMZN	Stock	0.592	0.605	0.5895	0.6015	18950000.0
2001-06-20 15:00:00	AMZN	Stock	0.602	0.635	0.602	0.6265	68948000.0
2001-06-20 16:00:00	AMZN	Stock	0.6265	0.6305	0.625	0.6265	6474000.0
2001-06-20 17:00:00	AMZN	Stock	0.63	0.63	0.6265	0.627	116000.0
2001-06-20 09:00:00	CL	Stock	28.975	29.35	28.975	29.3	237600.0
2001-06-20 10:00:00	CL	Stock	29.295	29.44	29.165	29.26	351400.0
2001-06-20 11:00:00	CL	Stock	29.22	29.4	29.22	29.4	286400.0
2001-06-20 12:00:00	CL	Stock	29.37	29.59	29.355	29.545	551200.0
2001-06-20 13:00:00	CL	Stock	29.535	29.585	29.475	29.515	154800.0
2001-06-20 14:00:00	CL	Stock	29.5	29.78	29.5	29.655	533000.0
2001-06-20 15:00:00	CL	Stock	29.615	29.89	29.6	29.605	688800.0

> showing 50 of 17,551 rows — these rows as CSV

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