PREVIEW / stock_1hour / 2001-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-04-20.parquet
  size:    352 KB
  rows:    16,533
  symbols: 1,287

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-04-20 08:00:00	AAPL	Stock	0.4596	0.4596	0.442	0.442	2441600.0
2001-04-20 09:00:00	AAPL	Stock	0.4421	0.4577	0.442	0.4513	111742400.0
2001-04-20 10:00:00	AAPL	Stock	0.4513	0.4554	0.4438	0.4459	126582400.0
2001-04-20 11:00:00	AAPL	Stock	0.4457	0.4475	0.4393	0.4446	80393600.0
2001-04-20 12:00:00	AAPL	Stock	0.4446	0.4514	0.4427	0.4446	39804800.0
2001-04-20 13:00:00	AAPL	Stock	0.4446	0.4563	0.4441	0.4555	62372800.0
2001-04-20 14:00:00	AAPL	Stock	0.4555	0.4555	0.4464	0.4484	67586400.0
2001-04-20 15:00:00	AAPL	Stock	0.4484	0.4523	0.4459	0.4471	80180800.0
2001-04-20 16:00:00	AAPL	Stock	0.4464	0.4488	0.4425	0.4461	18362400.0
2001-04-20 17:00:00	AAPL	Stock	0.4464	0.4464	0.4455	0.4464	761600.0
2001-04-20 18:00:00	AAPL	Stock	0.4477	0.4477	0.4464	0.4464	16800.0
2001-04-20 08:00:00	MSFT	Stock	35.95	36.45	34.0	35.215	3857200.0
2001-04-20 09:00:00	MSFT	Stock	35.3	36.3	34.475	35.125	45017600.0
2001-04-20 10:00:00	MSFT	Stock	35.13	35.55	34.95	35.0	40310800.0
2001-04-20 11:00:00	MSFT	Stock	34.985	35.51	34.615	34.725	22948800.0
2001-04-20 12:00:00	MSFT	Stock	34.72	34.945	34.7	34.78	13977400.0
2001-04-20 13:00:00	MSFT	Stock	34.785	35.04	34.76	34.99	11444000.0
2001-04-20 14:00:00	MSFT	Stock	34.99	35.055	34.69	34.925	12246600.0
2001-04-20 15:00:00	MSFT	Stock	34.925	35.025	34.25	34.52	28583800.0
2001-04-20 16:00:00	MSFT	Stock	34.5	34.96	34.37	34.415	3897400.0
2001-04-20 17:00:00	MSFT	Stock	34.42	34.5	34.42	34.5	460800.0
2001-04-20 18:00:00	MSFT	Stock	34.885	34.885	34.5	34.535	17400.0
2001-04-20 08:00:00	NVDA	Stock	0.3458	0.3479	0.3415	0.3418	1248000.0
2001-04-20 09:00:00	NVDA	Stock	0.3417	0.3499	0.3363	0.3479	181200000.0
2001-04-20 10:00:00	NVDA	Stock	0.3481	0.3569	0.3409	0.3433	378288000.0
2001-04-20 11:00:00	NVDA	Stock	0.3433	0.3475	0.3378	0.3436	175848000.0
2001-04-20 12:00:00	NVDA	Stock	0.3437	0.3525	0.3434	0.3493	204624000.0
2001-04-20 13:00:00	NVDA	Stock	0.3497	0.364	0.349	0.361	214560000.0
2001-04-20 14:00:00	NVDA	Stock	0.3621	0.365	0.3575	0.3619	163296000.0
2001-04-20 15:00:00	NVDA	Stock	0.3623	0.3709	0.3573	0.3622	342096000.0
2001-04-20 16:00:00	NVDA	Stock	0.3613	0.3624	0.3579	0.3583	18264000.0
2001-04-20 17:00:00	NVDA	Stock	0.3583	0.3613	0.3583	0.3586	360000.0
2001-04-20 08:00:00	AMZN	Stock	0.801	0.825	0.7725	0.775	376000.0
2001-04-20 09:00:00	AMZN	Stock	0.775	0.8	0.77	0.7835	32038000.0
2001-04-20 10:00:00	AMZN	Stock	0.7855	0.81	0.775	0.783	27160000.0
2001-04-20 11:00:00	AMZN	Stock	0.783	0.784	0.7555	0.758	15216000.0
2001-04-20 12:00:00	AMZN	Stock	0.7565	0.765	0.7485	0.75	16752000.0
2001-04-20 13:00:00	AMZN	Stock	0.75	0.763	0.75	0.761	10890000.0
2001-04-20 14:00:00	AMZN	Stock	0.7605	0.762	0.7515	0.761	15750000.0
2001-04-20 15:00:00	AMZN	Stock	0.7605	0.7895	0.7605	0.7895	26266000.0
2001-04-20 16:00:00	AMZN	Stock	0.7895	0.798	0.775	0.798	3914000.0
2001-04-20 17:00:00	AMZN	Stock	0.798	0.799	0.798	0.799	16000.0
2001-04-20 18:00:00	AMZN	Stock	0.799	0.799	0.795	0.795	26000.0
2001-04-20 09:00:00	CL	Stock	26.325	26.325	26.01	26.06	774200.0
2001-04-20 10:00:00	CL	Stock	26.05	26.5	25.95	26.45	671600.0
2001-04-20 11:00:00	CL	Stock	26.45	26.45	26.05	26.125	545800.0
2001-04-20 12:00:00	CL	Stock	26.125	26.315	26.125	26.25	693400.0
2001-04-20 13:00:00	CL	Stock	26.25	26.755	26.135	26.75	723400.0
2001-04-20 14:00:00	CL	Stock	26.75	26.825	26.545	26.62	766200.0
2001-04-20 15:00:00	CL	Stock	26.625	26.75	26.625	26.63	687600.0

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

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