PREVIEW / stock_1hour / 2001-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-11-20.parquet
  size:    382 KB
  rows:    18,407
  symbols: 1,361

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-20 08:00:00	AAPL	Stock	0.3561	0.3561	0.3561	0.3561	28000.0
2001-11-20 09:00:00	AAPL	Stock	0.3557	0.3607	0.3523	0.3564	47527200.0
2001-11-20 10:00:00	AAPL	Stock	0.3568	0.3586	0.3518	0.3538	42352800.0
2001-11-20 11:00:00	AAPL	Stock	0.3541	0.3555	0.3514	0.3516	15887200.0
2001-11-20 12:00:00	AAPL	Stock	0.3516	0.3545	0.35	0.3543	14308000.0
2001-11-20 13:00:00	AAPL	Stock	0.3541	0.3563	0.3536	0.355	15192800.0
2001-11-20 14:00:00	AAPL	Stock	0.3546	0.3546	0.3496	0.352	19135200.0
2001-11-20 15:00:00	AAPL	Stock	0.3513	0.3527	0.3482	0.3489	68342400.0
2001-11-20 16:00:00	AAPL	Stock	0.3486	0.3518	0.3482	0.3488	33896800.0
2001-11-20 17:00:00	AAPL	Stock	0.3488	0.3488	0.3488	0.3488	28000.0
2001-11-20 08:00:00	MSFT	Stock	33.305	33.305	33.085	33.125	108800.0
2001-11-20 09:00:00	MSFT	Stock	33.125	33.7	33.122	33.675	9118800.0
2001-11-20 10:00:00	MSFT	Stock	33.68	33.9	33.42	33.435	14775200.0
2001-11-20 11:00:00	MSFT	Stock	33.46	33.67	33.38	33.38	5810400.0
2001-11-20 12:00:00	MSFT	Stock	33.38	33.525	33.095	33.23	8813200.0
2001-11-20 13:00:00	MSFT	Stock	33.23	33.45	33.2	33.33	6443200.0
2001-11-20 14:00:00	MSFT	Stock	33.34	33.39	32.775	32.91	7040600.0
2001-11-20 15:00:00	MSFT	Stock	32.915	32.92	32.515	32.7	9821600.0
2001-11-20 16:00:00	MSFT	Stock	32.7	33.69	32.57	32.7	2802200.0
2001-11-20 17:00:00	MSFT	Stock	32.7	32.7	32.575	32.575	117600.0
2001-11-20 18:00:00	MSFT	Stock	32.575	32.675	32.55	32.675	6000.0
2001-11-20 08:00:00	NVDA	Stock	0.4317	0.4317	0.4275	0.4305	1020000.0
2001-11-20 09:00:00	NVDA	Stock	0.4304	0.4363	0.428	0.436	226848000.0
2001-11-20 10:00:00	NVDA	Stock	0.4362	0.4374	0.4258	0.4275	141300000.0
2001-11-20 11:00:00	NVDA	Stock	0.4277	0.4321	0.4271	0.4297	57852000.0
2001-11-20 12:00:00	NVDA	Stock	0.43	0.4312	0.426	0.4279	86052000.0
2001-11-20 13:00:00	NVDA	Stock	0.4275	0.4307	0.4261	0.4295	69828000.0
2001-11-20 14:00:00	NVDA	Stock	0.4296	0.43	0.4111	0.415	184860000.0
2001-11-20 15:00:00	NVDA	Stock	0.415	0.4191	0.4125	0.4158	143436000.0
2001-11-20 16:00:00	NVDA	Stock	0.4157	0.4161	0.4137	0.4146	8556000.0
2001-11-20 17:00:00	NVDA	Stock	0.4141	0.4158	0.4141	0.4153	540000.0
2001-11-20 18:00:00	NVDA	Stock	0.4153	0.4154	0.4153	0.4154	204000.0
2001-11-20 08:00:00	AMZN	Stock	0.4595	0.4595	0.4475	0.456	170000.0
2001-11-20 09:00:00	AMZN	Stock	0.4505	0.465	0.4505	0.461	32208000.0
2001-11-20 10:00:00	AMZN	Stock	0.461	0.4635	0.45	0.4505	22962000.0
2001-11-20 11:00:00	AMZN	Stock	0.451	0.4555	0.444	0.4512	15980000.0
2001-11-20 12:00:00	AMZN	Stock	0.451	0.451	0.445	0.449	8402000.0
2001-11-20 13:00:00	AMZN	Stock	0.449	0.4525	0.4475	0.452	10900000.0
2001-11-20 14:00:00	AMZN	Stock	0.4525	0.454	0.4435	0.4465	16912000.0
2001-11-20 15:00:00	AMZN	Stock	0.446	0.4465	0.43	0.4305	32554000.0
2001-11-20 16:00:00	AMZN	Stock	0.43	0.4335	0.425	0.43	4170000.0
2001-11-20 17:00:00	AMZN	Stock	0.43	0.4335	0.43	0.43	248000.0
2001-11-20 18:00:00	AMZN	Stock	0.4325	0.433	0.4325	0.4325	22000.0
2001-11-20 09:00:00	CL	Stock	29.05	29.15	29.05	29.15	174800.0
2001-11-20 10:00:00	CL	Stock	29.15	29.275	29.06	29.275	320600.0
2001-11-20 11:00:00	CL	Stock	29.29	29.365	29.185	29.25	519600.0
2001-11-20 12:00:00	CL	Stock	29.265	29.365	29.225	29.245	167800.0
2001-11-20 13:00:00	CL	Stock	29.24	29.345	29.225	29.345	239000.0
2001-11-20 14:00:00	CL	Stock	29.325	29.435	29.255	29.295	260400.0
2001-11-20 15:00:00	CL	Stock	29.29	29.45	29.25	29.35	341200.0

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

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