PREVIEW / stock_1hour / 2001-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-20.parquet
  size:    352 KB
  rows:    16,959
  symbols: 1,320

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-20 08:00:00	AAPL	Stock	0.324	0.3241	0.324	0.3241	268800.0
2001-08-20 09:00:00	AAPL	Stock	0.3236	0.325	0.3182	0.3198	46256000.0
2001-08-20 10:00:00	AAPL	Stock	0.32	0.3245	0.318	0.3229	40168800.0
2001-08-20 11:00:00	AAPL	Stock	0.323	0.3232	0.3214	0.3227	22332800.0
2001-08-20 12:00:00	AAPL	Stock	0.3225	0.323	0.3191	0.3193	35218400.0
2001-08-20 13:00:00	AAPL	Stock	0.3202	0.322	0.3195	0.322	26068000.0
2001-08-20 14:00:00	AAPL	Stock	0.322	0.3221	0.3205	0.322	20669600.0
2001-08-20 15:00:00	AAPL	Stock	0.3221	0.3238	0.3214	0.3238	40056800.0
2001-08-20 16:00:00	AAPL	Stock	0.3238	0.3257	0.3216	0.3236	5325600.0
2001-08-20 17:00:00	AAPL	Stock	0.3223	0.3257	0.3221	0.3257	1047200.0
2001-08-20 08:00:00	MSFT	Stock	30.9	31.08	30.85	30.85	52000.0
2001-08-20 09:00:00	MSFT	Stock	30.775	30.9374	30.56	30.625	6912400.0
2001-08-20 10:00:00	MSFT	Stock	30.675	30.99	30.55	30.98	8623400.0
2001-08-20 11:00:00	MSFT	Stock	30.965	31.09	30.885	30.985	5557400.0
2001-08-20 12:00:00	MSFT	Stock	30.985	31.095	30.755	30.79	4485200.0
2001-08-20 13:00:00	MSFT	Stock	30.79	31.02	30.71	30.98	5839600.0
2001-08-20 14:00:00	MSFT	Stock	30.985	31.23	30.9	31.155	4235800.0
2001-08-20 15:00:00	MSFT	Stock	31.1605	31.375	31.07	31.375	5342800.0
2001-08-20 16:00:00	MSFT	Stock	31.35	31.375	30.875	30.9199	2851600.0
2001-08-20 17:00:00	MSFT	Stock	31.35	31.35	31.3	31.305	289000.0
2001-08-20 18:00:00	MSFT	Stock	31.325	31.345	31.325	31.345	1000.0
2001-08-20 08:00:00	NVDA	Stock	0.3485	0.3535	0.3481	0.3496	3480000.0
2001-08-20 09:00:00	NVDA	Stock	0.35	0.35	0.336	0.3425	297888000.0
2001-08-20 10:00:00	NVDA	Stock	0.3426	0.3504	0.3396	0.3476	300600000.0
2001-08-20 11:00:00	NVDA	Stock	0.3477	0.3494	0.3445	0.347	125880000.0
2001-08-20 12:00:00	NVDA	Stock	0.347	0.3485	0.3453	0.3455	69408000.0
2001-08-20 13:00:00	NVDA	Stock	0.3454	0.3475	0.3452	0.3469	63048000.0
2001-08-20 14:00:00	NVDA	Stock	0.3469	0.3473	0.3454	0.3458	98112000.0
2001-08-20 15:00:00	NVDA	Stock	0.3458	0.3483	0.3448	0.3466	146640000.0
2001-08-20 16:00:00	NVDA	Stock	0.3466	0.3468	0.3456	0.3456	15840000.0
2001-08-20 17:00:00	NVDA	Stock	0.3456	0.3466	0.3455	0.3455	960000.0
2001-08-20 18:00:00	NVDA	Stock	0.3458	0.3458	0.3458	0.3458	24000.0
2001-08-20 08:00:00	AMZN	Stock	0.4985	0.5315	0.4975	0.5125	1306000.0
2001-08-20 09:00:00	AMZN	Stock	0.5125	0.5199	0.498	0.499	13434000.0
2001-08-20 10:00:00	AMZN	Stock	0.4985	0.5125	0.4975	0.5105	15516000.0
2001-08-20 11:00:00	AMZN	Stock	0.5105	0.5165	0.51	0.514	8126000.0
2001-08-20 12:00:00	AMZN	Stock	0.5155	0.5195	0.5085	0.5099	6310000.0
2001-08-20 13:00:00	AMZN	Stock	0.5085	0.5125	0.508	0.512	3768000.0
2001-08-20 14:00:00	AMZN	Stock	0.5115	0.514	0.51	0.512	3880000.0
2001-08-20 15:00:00	AMZN	Stock	0.5125	0.5205	0.51	0.5205	9504000.0
2001-08-20 16:00:00	AMZN	Stock	0.52	0.523	0.5095	0.52	7078000.0
2001-08-20 17:00:00	AMZN	Stock	0.52	0.52	0.52	0.52	110000.0
2001-08-20 09:00:00	CL	Stock	27.515	27.725	27.5	27.535	266000.0
2001-08-20 10:00:00	CL	Stock	27.54	27.67	27.51	27.61	298200.0
2001-08-20 11:00:00	CL	Stock	27.61	27.645	27.58	27.58	127000.0
2001-08-20 12:00:00	CL	Stock	27.58	27.645	27.55	27.57	170000.0
2001-08-20 13:00:00	CL	Stock	27.56	27.595	27.45	27.58	245200.0
2001-08-20 14:00:00	CL	Stock	27.575	27.79	27.54	27.72	232000.0
2001-08-20 15:00:00	CL	Stock	27.735	27.825	27.67	27.7	415600.0
2001-08-20 16:00:00	CL	Stock	27.715	27.725	27.71	27.725	54000.0

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

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