PREVIEW / stock_1hour / 2001-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-05-18.parquet
  size:    357 KB
  rows:    17,196
  symbols: 1,301

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-05-18 08:00:00	AAPL	Stock	0.4214	0.4214	0.4148	0.4168	515200.0
2001-05-18 09:00:00	AAPL	Stock	0.4196	0.4227	0.4134	0.4188	25312000.0
2001-05-18 10:00:00	AAPL	Stock	0.4163	0.4204	0.4163	0.4188	23699200.0
2001-05-18 11:00:00	AAPL	Stock	0.4188	0.4188	0.4146	0.417	11491200.0
2001-05-18 12:00:00	AAPL	Stock	0.4173	0.418	0.4152	0.4161	8517600.0
2001-05-18 13:00:00	AAPL	Stock	0.4161	0.4182	0.413	0.4136	17785600.0
2001-05-18 14:00:00	AAPL	Stock	0.4134	0.4166	0.4129	0.4141	23755200.0
2001-05-18 15:00:00	AAPL	Stock	0.4136	0.4207	0.413	0.42	30637600.0
2001-05-18 16:00:00	AAPL	Stock	0.4202	0.4207	0.4161	0.4202	5112800.0
2001-05-18 18:00:00	AAPL	Stock	0.4198	0.4198	0.4198	0.4198	5600.0
2001-05-18 08:00:00	MSFT	Stock	34.07	34.08	33.7	33.83	122000.0
2001-05-18 09:00:00	MSFT	Stock	33.95	33.995	33.685	33.935	14743000.0
2001-05-18 10:00:00	MSFT	Stock	33.94	34.6	33.905	34.45	20362000.0
2001-05-18 11:00:00	MSFT	Stock	34.475	34.5	34.005	34.135	10395200.0
2001-05-18 12:00:00	MSFT	Stock	34.14	34.22	33.875	33.935	4689000.0
2001-05-18 13:00:00	MSFT	Stock	33.94	34.025	33.75	33.85	5687200.0
2001-05-18 14:00:00	MSFT	Stock	33.85	34.075	33.65	33.78	7078600.0
2001-05-18 15:00:00	MSFT	Stock	33.775	34.075	33.625	34.05	16421800.0
2001-05-18 16:00:00	MSFT	Stock	34.05	34.51	33.78	34.015	2936600.0
2001-05-18 17:00:00	MSFT	Stock	33.92	34.025	33.92	34.0	15200.0
2001-05-18 18:00:00	MSFT	Stock	33.96	33.96	33.95	33.95	600.0
2001-05-18 08:00:00	NVDA	Stock	0.36	0.3617	0.3583	0.3596	312000.0
2001-05-18 09:00:00	NVDA	Stock	0.3588	0.3644	0.3569	0.3637	70368000.0
2001-05-18 10:00:00	NVDA	Stock	0.3625	0.3708	0.3623	0.3675	108408000.0
2001-05-18 11:00:00	NVDA	Stock	0.3674	0.3689	0.356	0.356	82248000.0
2001-05-18 12:00:00	NVDA	Stock	0.356	0.359	0.355	0.3575	52152000.0
2001-05-18 13:00:00	NVDA	Stock	0.3578	0.3623	0.3528	0.3546	94008000.0
2001-05-18 14:00:00	NVDA	Stock	0.3545	0.3572	0.3525	0.3553	61224000.0
2001-05-18 15:00:00	NVDA	Stock	0.355	0.3604	0.3542	0.3596	68736000.0
2001-05-18 16:00:00	NVDA	Stock	0.3595	0.3613	0.3573	0.3592	7104000.0
2001-05-18 17:00:00	NVDA	Stock	0.3596	0.3596	0.3583	0.3593	960000.0
2001-05-18 08:00:00	AMZN	Stock	0.7615	0.7625	0.7335	0.7375	512000.0
2001-05-18 09:00:00	AMZN	Stock	0.74	0.7435	0.726	0.742	11404000.0
2001-05-18 10:00:00	AMZN	Stock	0.739	0.75	0.7365	0.739	9438000.0
2001-05-18 11:00:00	AMZN	Stock	0.741	0.745	0.7375	0.7385	9048000.0
2001-05-18 12:00:00	AMZN	Stock	0.739	0.7415	0.729	0.7305	26320000.0
2001-05-18 13:00:00	AMZN	Stock	0.73	0.7385	0.7275	0.738	4992000.0
2001-05-18 14:00:00	AMZN	Stock	0.7345	0.741	0.7245	0.7325	9872000.0
2001-05-18 15:00:00	AMZN	Stock	0.7315	0.743	0.7295	0.7385	18308000.0
2001-05-18 16:00:00	AMZN	Stock	0.7385	0.7435	0.733	0.736	2278000.0
2001-05-18 17:00:00	AMZN	Stock	0.736	0.7375	0.733	0.7375	568000.0
2001-05-18 09:00:00	CL	Stock	29.025	29.15	28.875	28.875	346600.0
2001-05-18 10:00:00	CL	Stock	28.875	29.025	28.845	28.895	278600.0
2001-05-18 11:00:00	CL	Stock	28.9	28.9	28.675	28.725	387400.0
2001-05-18 12:00:00	CL	Stock	28.71	28.75	28.605	28.615	197400.0
2001-05-18 13:00:00	CL	Stock	28.62	28.695	28.55	28.55	139200.0
2001-05-18 14:00:00	CL	Stock	28.565	28.65	28.5	28.58	353000.0
2001-05-18 15:00:00	CL	Stock	28.6	29.15	28.56	28.69	621200.0
2001-05-18 16:00:00	CL	Stock	28.685	28.7	28.685	28.7	73200.0

> showing 49 of 17,196 rows — these rows as CSV

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