PREVIEW / stock_1hour / 2005-05-26

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-26.parquet
  size:    544 KB
  rows:    26,164
  symbols: 1,981

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
2005-05-26 07:00:00	AAPL	Stock	1.4293	1.4336	1.4293	1.4336	9800.0
2005-05-26 08:00:00	AAPL	Stock	1.4304	1.4464	1.4304	1.4454	5428304.0
2005-05-26 09:00:00	AAPL	Stock	1.4454	1.4479	1.4264	1.4425	90364400.0
2005-05-26 10:00:00	AAPL	Stock	1.4425	1.4621	1.3857	1.4536	125839588.0
2005-05-26 11:00:00	AAPL	Stock	1.4536	1.4564	1.4507	1.455	46366964.0
2005-05-26 12:00:00	AAPL	Stock	1.455	1.4589	1.4521	1.4571	37988636.0
2005-05-26 13:00:00	AAPL	Stock	1.4571	1.4571	1.4457	1.4464	49748132.0
2005-05-26 14:00:00	AAPL	Stock	1.4461	1.4514	1.4418	1.4439	71016988.0
2005-05-26 15:00:00	AAPL	Stock	1.4439	1.4571	1.4439	1.455	84230160.0
2005-05-26 16:00:00	AAPL	Stock	1.455	1.457	1.4173	1.4561	8202348.0
2005-05-26 17:00:00	AAPL	Stock	1.4554	1.4561	1.4539	1.4554	558572.0
2005-05-26 18:00:00	AAPL	Stock	1.4554	1.4554	1.4546	1.4546	33600.0
2005-05-26 08:00:00	MSFT	Stock	25.79	25.79	25.76	25.78	35949.0
2005-05-26 09:00:00	MSFT	Stock	25.76	25.96	25.71	25.92	9864547.0
2005-05-26 10:00:00	MSFT	Stock	25.92	25.94	25.86	25.9	8054076.0
2005-05-26 11:00:00	MSFT	Stock	25.9	26.0	25.75	25.82	7225016.0
2005-05-26 12:00:00	MSFT	Stock	25.81	25.88	25.8	25.842	4155214.0
2005-05-26 13:00:00	MSFT	Stock	25.85	25.87	25.79	25.86	4003707.0
2005-05-26 14:00:00	MSFT	Stock	25.86	25.9	25.83	25.83	4144771.0
2005-05-26 15:00:00	MSFT	Stock	25.83	25.92	25.83	25.88	8343398.0
2005-05-26 16:00:00	MSFT	Stock	25.9	25.9	25.645	25.87	860690.0
2005-05-26 17:00:00	MSFT	Stock	25.87	25.9	25.87	25.89	54950.0
2005-05-26 18:00:00	MSFT	Stock	25.85	25.88	25.85	25.88	2514.0
2005-05-26 08:00:00	NVDA	Stock	0.2247	0.2262	0.2247	0.2262	515280.0
2005-05-26 09:00:00	NVDA	Stock	0.2262	0.2282	0.2253	0.2277	113147040.0
2005-05-26 10:00:00	NVDA	Stock	0.2277	0.2296	0.2272	0.2288	147513840.0
2005-05-26 11:00:00	NVDA	Stock	0.2288	0.2303	0.2287	0.2302	55173360.0
2005-05-26 12:00:00	NVDA	Stock	0.2302	0.2326	0.2295	0.2312	140795640.0
2005-05-26 13:00:00	NVDA	Stock	0.2313	0.2317	0.2302	0.2309	80868600.0
2005-05-26 14:00:00	NVDA	Stock	0.2309	0.2322	0.2307	0.231	80518200.0
2005-05-26 15:00:00	NVDA	Stock	0.231	0.2319	0.2303	0.2307	136010280.0
2005-05-26 16:00:00	NVDA	Stock	0.2305	0.2312	0.2302	0.2302	1219560.0
2005-05-26 17:00:00	NVDA	Stock	0.2302	0.2302	0.2302	0.2302	36000.0
2005-05-26 08:00:00	AMZN	Stock	1.7675	1.77	1.7675	1.7675	62000.0
2005-05-26 09:00:00	AMZN	Stock	1.7675	1.7725	1.7585	1.7635	14053520.0
2005-05-26 10:00:00	AMZN	Stock	1.764	1.784	1.762	1.771	17444420.0
2005-05-26 11:00:00	AMZN	Stock	1.77	1.7715	1.7595	1.7615	9919580.0
2005-05-26 12:00:00	AMZN	Stock	1.7615	1.765	1.76	1.761	5848800.0
2005-05-26 13:00:00	AMZN	Stock	1.7615	1.765	1.7605	1.7645	6489700.0
2005-05-26 14:00:00	AMZN	Stock	1.7645	1.7665	1.7595	1.761	6612760.0
2005-05-26 15:00:00	AMZN	Stock	1.761	1.778	1.7605	1.7725	28040460.0
2005-05-26 16:00:00	AMZN	Stock	1.771	1.775	1.769	1.772	5198060.0
2005-05-26 17:00:00	AMZN	Stock	1.7725	1.7725	1.7725	1.7725	192400.0
2005-05-26 18:00:00	AMZN	Stock	1.773	1.773	1.7725	1.7725	16000.0
2005-05-26 09:00:00	CL	Stock	25.3	25.325	25.215	25.25	206000.0
2005-05-26 10:00:00	CL	Stock	25.25	25.29	25.17	25.185	340800.0
2005-05-26 11:00:00	CL	Stock	25.18	25.225	25.155	25.2	304600.0
2005-05-26 12:00:00	CL	Stock	25.19	25.225	25.15	25.155	256200.0
2005-05-26 13:00:00	CL	Stock	25.16	25.19	25.145	25.155	243400.0
2005-05-26 14:00:00	CL	Stock	25.155	25.17	25.13	25.135	320200.0

> showing 50 of 26,164 rows — these rows as CSV

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