PREVIEW / stock_1hour / 2005-02-18

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-02-18.parquet
  size:    536 KB
  rows:    25,166
  symbols: 1,933

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-02-18 08:00:00	AAPL	Stock	1.5716	1.583	1.5625	1.5734	8846432.0
2005-02-18 09:00:00	AAPL	Stock	1.5734	1.5755	1.5457	1.5539	284082008.0
2005-02-18 10:00:00	AAPL	Stock	1.5539	1.5598	1.543	1.5495	232985984.0
2005-02-18 11:00:00	AAPL	Stock	1.5496	1.5579	1.5411	1.5461	208177144.0
2005-02-18 12:00:00	AAPL	Stock	1.5463	1.5521	1.5446	1.5509	87043040.0
2005-02-18 13:00:00	AAPL	Stock	1.5511	1.5543	1.5402	1.5477	103561752.0
2005-02-18 14:00:00	AAPL	Stock	1.5477	1.5518	1.5445	1.5464	88664968.0
2005-02-18 15:00:00	AAPL	Stock	1.5463	1.5502	1.5421	1.5489	129427648.0
2005-02-18 16:00:00	AAPL	Stock	1.5498	1.5548	1.548	1.5548	7383600.0
2005-02-18 17:00:00	AAPL	Stock	1.5557	1.5566	1.552	1.555	937888.0
2005-02-18 18:00:00	AAPL	Stock	1.5541	1.5541	1.5536	1.5536	98280.0
2005-02-18 08:00:00	MSFT	Stock	25.64	25.68	25.62	25.64	15987.0
2005-02-18 09:00:00	MSFT	Stock	25.64	25.66	25.42	25.48	12474427.0
2005-02-18 10:00:00	MSFT	Stock	25.49	25.52	25.42	25.48	11515301.0
2005-02-18 11:00:00	MSFT	Stock	25.481	25.5	25.4	25.441	9088304.0
2005-02-18 12:00:00	MSFT	Stock	25.45	25.49	25.41	25.46	6445773.0
2005-02-18 13:00:00	MSFT	Stock	25.46	25.49	25.4	25.47	8414103.0
2005-02-18 14:00:00	MSFT	Stock	25.471	25.5	25.45	25.48	10028166.0
2005-02-18 15:00:00	MSFT	Stock	25.48	25.53	25.45	25.5	16061626.0
2005-02-18 16:00:00	MSFT	Stock	25.48	25.49	25.45	25.45	777340.0
2005-02-18 17:00:00	MSFT	Stock	25.47	25.48	25.45	25.47	3700.0
2005-02-18 08:00:00	NVDA	Stock	0.2327	0.2356	0.2292	0.2321	107745360.0
2005-02-18 09:00:00	NVDA	Stock	0.2317	0.2322	0.2222	0.2235	756077400.0
2005-02-18 10:00:00	NVDA	Stock	0.2237	0.2308	0.2233	0.229	574403160.0
2005-02-18 11:00:00	NVDA	Stock	0.2289	0.2327	0.2289	0.2324	508026840.0
2005-02-18 12:00:00	NVDA	Stock	0.2324	0.2332	0.2312	0.2327	209970600.0
2005-02-18 13:00:00	NVDA	Stock	0.2327	0.2329	0.2304	0.2323	199997880.0
2005-02-18 14:00:00	NVDA	Stock	0.2323	0.2343	0.2323	0.2336	275924280.0
2005-02-18 15:00:00	NVDA	Stock	0.2336	0.2358	0.2333	0.2356	478758120.0
2005-02-18 16:00:00	NVDA	Stock	0.2356	0.2365	0.2354	0.2365	12792600.0
2005-02-18 17:00:00	NVDA	Stock	0.2365	0.237	0.2362	0.2367	1568400.0
2005-02-18 18:00:00	NVDA	Stock	0.2367	0.2371	0.2366	0.2367	212400.0
2005-02-18 08:00:00	AMZN	Stock	1.7845	1.7845	1.7835	1.7835	14000.0
2005-02-18 09:00:00	AMZN	Stock	1.788	1.789	1.773	1.781	7136080.0
2005-02-18 10:00:00	AMZN	Stock	1.782	1.7865	1.7575	1.7625	22053920.0
2005-02-18 11:00:00	AMZN	Stock	1.7625	1.7745	1.755	1.7635	14973380.0
2005-02-18 12:00:00	AMZN	Stock	1.7635	1.769	1.76	1.7645	6356620.0
2005-02-18 13:00:00	AMZN	Stock	1.7645	1.765	1.7595	1.7635	6340460.0
2005-02-18 14:00:00	AMZN	Stock	1.7635	1.7655	1.761	1.7615	5980980.0
2005-02-18 15:00:00	AMZN	Stock	1.762	1.7705	1.7575	1.765	24573360.0
2005-02-18 16:00:00	AMZN	Stock	1.765	1.768	1.7645	1.7655	1936820.0
2005-02-18 17:00:00	AMZN	Stock	1.7715	1.7725	1.7655	1.7655	85400.0
2005-02-18 18:00:00	AMZN	Stock	1.771	1.771	1.771	1.771	5000.0
2005-02-18 09:00:00	CL	Stock	27.025	27.04	26.9	27.025	420000.0
2005-02-18 10:00:00	CL	Stock	27.02	27.045	26.85	26.87	546400.0
2005-02-18 11:00:00	CL	Stock	26.87	26.925	26.68	26.68	604000.0
2005-02-18 12:00:00	CL	Stock	26.665	26.785	26.655	26.77	409800.0
2005-02-18 13:00:00	CL	Stock	26.77	26.785	26.66	26.775	388800.0
2005-02-18 14:00:00	CL	Stock	26.77	26.78	26.64	26.655	414800.0
2005-02-18 15:00:00	CL	Stock	26.655	26.705	26.6	26.605	880600.0

> showing 50 of 25,166 rows — these rows as CSV

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