PREVIEW / stock_1hour / 2001-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-04-19.parquet
  size:    358 KB
  rows:    16,949
  symbols: 1,294

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-19 08:00:00	AAPL	Stock	0.4643	0.4732	0.4554	0.4591	36327648.0
2001-04-19 09:00:00	AAPL	Stock	0.4598	0.4714	0.4214	0.4225	395774400.0
2001-04-19 10:00:00	AAPL	Stock	0.4229	0.435	0.422	0.435	330702400.0
2001-04-19 11:00:00	AAPL	Stock	0.435	0.4473	0.4336	0.4459	229012000.0
2001-04-19 12:00:00	AAPL	Stock	0.4455	0.4486	0.4411	0.445	153871200.0
2001-04-19 13:00:00	AAPL	Stock	0.4452	0.4523	0.4446	0.4509	191693600.0
2001-04-19 14:00:00	AAPL	Stock	0.4509	0.4564	0.4429	0.4438	182022400.0
2001-04-19 15:00:00	AAPL	Stock	0.4443	0.4598	0.4357	0.4591	224957600.0
2001-04-19 16:00:00	AAPL	Stock	0.4591	0.4598	0.4432	0.452	63946400.0
2001-04-19 17:00:00	AAPL	Stock	0.4554	0.458	0.4518	0.458	364000.0
2001-04-19 18:00:00	AAPL	Stock	0.4554	0.4625	0.4554	0.4589	464800.0
2001-04-19 08:00:00	MSFT	Stock	33.35	33.48	32.95	33.1	492600.0
2001-04-19 09:00:00	MSFT	Stock	33.1	33.52	32.45	33.45	18708000.0
2001-04-19 10:00:00	MSFT	Stock	33.43	34.18	33.375	33.75	29726200.0
2001-04-19 11:00:00	MSFT	Stock	33.75	33.82	33.29	33.525	12451800.0
2001-04-19 12:00:00	MSFT	Stock	33.5	33.9	33.44	33.865	10547000.0
2001-04-19 13:00:00	MSFT	Stock	33.875	34.055	33.815	33.975	10800800.0
2001-04-19 14:00:00	MSFT	Stock	33.99	34.05	33.595	33.725	13981600.0
2001-04-19 15:00:00	MSFT	Stock	33.74	34.175	33.685	34.02	31105200.0
2001-04-19 16:00:00	MSFT	Stock	34.02	35.5	33.535	35.4	16421200.0
2001-04-19 17:00:00	MSFT	Stock	35.41	36.2	33.97	35.96	4423000.0
2001-04-19 18:00:00	MSFT	Stock	35.985	36.25	35.925	36.175	907000.0
2001-04-19 08:00:00	NVDA	Stock	0.3103	0.3276	0.3103	0.3208	1032000.0
2001-04-19 09:00:00	NVDA	Stock	0.3219	0.3354	0.3208	0.3315	249576000.0
2001-04-19 10:00:00	NVDA	Stock	0.3319	0.3368	0.3302	0.3333	253176000.0
2001-04-19 11:00:00	NVDA	Stock	0.334	0.3363	0.3319	0.3336	130632000.0
2001-04-19 12:00:00	NVDA	Stock	0.334	0.3373	0.3329	0.3373	115896000.0
2001-04-19 13:00:00	NVDA	Stock	0.3373	0.3458	0.3342	0.3458	172320000.0
2001-04-19 14:00:00	NVDA	Stock	0.3458	0.3466	0.3386	0.339	247176000.0
2001-04-19 15:00:00	NVDA	Stock	0.339	0.3551	0.3358	0.3495	325320000.0
2001-04-19 16:00:00	NVDA	Stock	0.3495	0.3502	0.3384	0.3471	57912000.0
2001-04-19 17:00:00	NVDA	Stock	0.3488	0.3583	0.3487	0.3583	1584000.0
2001-04-19 18:00:00	NVDA	Stock	0.3583	0.3583	0.3513	0.3513	144000.0
2001-04-19 08:00:00	AMZN	Stock	0.85	0.9	0.8	0.835	510000.0
2001-04-19 09:00:00	AMZN	Stock	0.8375	0.85	0.809	0.811	15830000.0
2001-04-19 10:00:00	AMZN	Stock	0.8125	0.82	0.794	0.8195	26696000.0
2001-04-19 11:00:00	AMZN	Stock	0.8195	0.827	0.805	0.8125	28014000.0
2001-04-19 12:00:00	AMZN	Stock	0.8125	0.815	0.8005	0.801	12466000.0
2001-04-19 13:00:00	AMZN	Stock	0.801	0.807	0.7875	0.8005	22082000.0
2001-04-19 14:00:00	AMZN	Stock	0.801	0.808	0.7875	0.792	16502000.0
2001-04-19 15:00:00	AMZN	Stock	0.792	0.801	0.7845	0.799	37688000.0
2001-04-19 16:00:00	AMZN	Stock	0.7995	0.82	0.785	0.8165	7146000.0
2001-04-19 17:00:00	AMZN	Stock	0.8165	0.8245	0.7995	0.813	1024000.0
2001-04-19 18:00:00	AMZN	Stock	0.8135	0.8225	0.8125	0.82	180000.0
2001-04-19 09:00:00	CL	Stock	26.5	26.55	26.375	26.475	1233400.0
2001-04-19 10:00:00	CL	Stock	26.55	26.55	26.395	26.525	1576000.0
2001-04-19 11:00:00	CL	Stock	26.525	26.58	26.49	26.51	741600.0
2001-04-19 12:00:00	CL	Stock	26.515	26.6	26.45	26.595	549200.0
2001-04-19 13:00:00	CL	Stock	26.6	26.625	26.5	26.58	558000.0
2001-04-19 14:00:00	CL	Stock	26.55	26.6	26.485	26.5	589000.0

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

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