PREVIEW / stock_1hour / 2001-11-19

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-11-19.parquet
  size:    382 KB
  rows:    18,335
  symbols: 1,357

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-11-19 08:00:00	AAPL	Stock	0.3425	0.3425	0.3411	0.3425	72800.0
2001-11-19 09:00:00	AAPL	Stock	0.3393	0.3516	0.3386	0.3516	41748000.0
2001-11-19 10:00:00	AAPL	Stock	0.3516	0.3546	0.3507	0.3527	58682400.0
2001-11-19 11:00:00	AAPL	Stock	0.3527	0.3545	0.3513	0.3513	35190400.0
2001-11-19 12:00:00	AAPL	Stock	0.3513	0.3536	0.3486	0.3527	29489600.0
2001-11-19 13:00:00	AAPL	Stock	0.3527	0.3532	0.3498	0.3516	25961600.0
2001-11-19 14:00:00	AAPL	Stock	0.3516	0.3541	0.3504	0.3534	27546400.0
2001-11-19 15:00:00	AAPL	Stock	0.3532	0.358	0.3527	0.3571	65688000.0
2001-11-19 16:00:00	AAPL	Stock	0.3571	0.3584	0.3522	0.3554	20714400.0
2001-11-19 17:00:00	AAPL	Stock	0.3588	0.3588	0.3563	0.358	1512000.0
2001-11-19 18:00:00	AAPL	Stock	0.3571	0.3589	0.3571	0.3589	84000.0
2001-11-19 08:00:00	MSFT	Stock	33.05	33.55	33.025	33.1	26000.0
2001-11-19 09:00:00	MSFT	Stock	33.1	33.19	32.8525	33.15	7284400.0
2001-11-19 10:00:00	MSFT	Stock	33.155	33.385	33.11	33.355	8626200.0
2001-11-19 11:00:00	MSFT	Stock	33.355	33.475	33.125	33.185	7755000.0
2001-11-19 12:00:00	MSFT	Stock	33.185	33.325	33.08	33.2555	5753400.0
2001-11-19 13:00:00	MSFT	Stock	33.255	33.28	33.11	33.25	5026800.0
2001-11-19 14:00:00	MSFT	Stock	33.2505	33.29	33.095	33.21	5993800.0
2001-11-19 15:00:00	MSFT	Stock	33.21	33.32	33.16	33.274	10629800.0
2001-11-19 16:00:00	MSFT	Stock	33.274	33.415	33.2056	33.33	2484800.0
2001-11-19 17:00:00	MSFT	Stock	33.27	33.47	33.27	33.34	225400.0
2001-11-19 18:00:00	MSFT	Stock	33.355	33.37	33.355	33.37	2400.0
2001-11-19 08:00:00	NVDA	Stock	0.4458	0.45	0.4417	0.4467	1140000.0
2001-11-19 09:00:00	NVDA	Stock	0.4479	0.4479	0.4375	0.444	97272000.0
2001-11-19 10:00:00	NVDA	Stock	0.444	0.444	0.4396	0.4425	93252000.0
2001-11-19 11:00:00	NVDA	Stock	0.4425	0.4433	0.4315	0.4337	132504000.0
2001-11-19 12:00:00	NVDA	Stock	0.4336	0.4351	0.4285	0.4336	158064000.0
2001-11-19 13:00:00	NVDA	Stock	0.4335	0.434	0.4292	0.4308	81756000.0
2001-11-19 14:00:00	NVDA	Stock	0.4309	0.4346	0.4042	0.4229	802440000.0
2001-11-19 15:00:00	NVDA	Stock	0.4222	0.4293	0.42	0.4278	531216000.0
2001-11-19 16:00:00	NVDA	Stock	0.4278	0.4332	0.4067	0.4325	21012000.0
2001-11-19 17:00:00	NVDA	Stock	0.4325	0.4327	0.4278	0.4314	2376000.0
2001-11-19 18:00:00	NVDA	Stock	0.4324	0.4325	0.4312	0.4321	300000.0
2001-11-19 08:00:00	AMZN	Stock	0.4495	0.4625	0.4495	0.4575	1994000.0
2001-11-19 09:00:00	AMZN	Stock	0.4575	0.475	0.4565	0.4725	44580000.0
2001-11-19 10:00:00	AMZN	Stock	0.4725	0.475	0.465	0.47	33568000.0
2001-11-19 11:00:00	AMZN	Stock	0.47	0.4705	0.45	0.4535	35386000.0
2001-11-19 12:00:00	AMZN	Stock	0.4536	0.4595	0.4505	0.458	18114000.0
2001-11-19 13:00:00	AMZN	Stock	0.458	0.458	0.4515	0.454	10348000.0
2001-11-19 14:00:00	AMZN	Stock	0.454	0.4595	0.4524	0.454	11390000.0
2001-11-19 15:00:00	AMZN	Stock	0.454	0.461	0.451	0.4595	20524000.0
2001-11-19 16:00:00	AMZN	Stock	0.4605	0.463	0.4555	0.4625	4556000.0
2001-11-19 17:00:00	AMZN	Stock	0.4625	0.4625	0.4595	0.461	698000.0
2001-11-19 18:00:00	AMZN	Stock	0.4615	0.464	0.46	0.464	386000.0
2001-11-19 09:00:00	CL	Stock	29.35	29.475	29.275	29.335	259200.0
2001-11-19 10:00:00	CL	Stock	29.33	29.46	29.2	29.215	415400.0
2001-11-19 11:00:00	CL	Stock	29.21	29.29	29.075	29.095	219800.0
2001-11-19 12:00:00	CL	Stock	29.1	29.4	29.1	29.375	258400.0
2001-11-19 13:00:00	CL	Stock	29.365	29.42	29.28	29.28	227800.0
2001-11-19 14:00:00	CL	Stock	29.305	29.325	29.17	29.235	280400.0

> showing 50 of 18,335 rows — these rows as CSV

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