PREVIEW / stock_1hour / 2005-03-18

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-18.parquet
  size:    572 KB
  rows:    26,573
  symbols: 1,939

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-03-18 08:00:00	AAPL	Stock	1.5571	1.5675	1.5436	1.5543	14972216.0
2005-03-18 09:00:00	AAPL	Stock	1.5539	1.5571	1.5179	1.5279	229458992.0
2005-03-18 10:00:00	AAPL	Stock	1.5279	1.5375	1.525	1.535	151064592.0
2005-03-18 11:00:00	AAPL	Stock	1.5354	1.5414	1.53	1.5329	79160564.0
2005-03-18 12:00:00	AAPL	Stock	1.5332	1.5346	1.5254	1.5264	38853836.0
2005-03-18 13:00:00	AAPL	Stock	1.5264	1.5304	1.5179	1.5225	78733256.0
2005-03-18 14:00:00	AAPL	Stock	1.5225	1.5318	1.52	1.5232	70812448.0
2005-03-18 15:00:00	AAPL	Stock	1.5236	1.5364	1.5186	1.5332	171109736.0
2005-03-18 16:00:00	AAPL	Stock	1.5325	1.5396	1.5321	1.5337	17904740.0
2005-03-18 17:00:00	AAPL	Stock	1.5393	1.5393	1.5337	1.5389	11794720.0
2005-03-18 18:00:00	AAPL	Stock	1.5389	1.5404	1.5339	1.5393	3673208.0
2005-03-18 08:00:00	MSFT	Stock	24.51	24.55	24.4	24.53	45071.0
2005-03-18 09:00:00	MSFT	Stock	24.53	24.57	24.45	24.52	18509451.0
2005-03-18 10:00:00	MSFT	Stock	24.51	24.68	24.5	24.55	11475085.0
2005-03-18 11:00:00	MSFT	Stock	24.55	24.67	24.53	24.59	6608986.0
2005-03-18 12:00:00	MSFT	Stock	24.59	24.6	24.45	24.46	4072354.0
2005-03-18 13:00:00	MSFT	Stock	24.46	24.91	24.37	24.45	10186133.0
2005-03-18 14:00:00	MSFT	Stock	24.45	24.48	24.35	24.37	11295673.0
2005-03-18 15:00:00	MSFT	Stock	24.37	24.47	24.28	24.33	28339762.0
2005-03-18 16:00:00	MSFT	Stock	24.33	24.37	24.305	24.35	11191973.0
2005-03-18 17:00:00	MSFT	Stock	24.325	24.38	24.303	24.32	5422260.0
2005-03-18 18:00:00	MSFT	Stock	24.36	24.36	24.32	24.36	1907814.0
2005-03-18 08:00:00	NVDA	Stock	0.2077	0.2077	0.2061	0.2061	84000.0
2005-03-18 09:00:00	NVDA	Stock	0.2062	0.2064	0.2011	0.2015	114175320.0
2005-03-18 10:00:00	NVDA	Stock	0.2014	0.2037	0.2004	0.2009	139349040.0
2005-03-18 11:00:00	NVDA	Stock	0.2009	0.2034	0.2009	0.2019	65594040.0
2005-03-18 12:00:00	NVDA	Stock	0.2021	0.2027	0.2011	0.2012	35569800.0
2005-03-18 13:00:00	NVDA	Stock	0.2012	0.2013	0.1988	0.1996	68911200.0
2005-03-18 14:00:00	NVDA	Stock	0.1996	0.2006	0.1991	0.1999	48311040.0
2005-03-18 15:00:00	NVDA	Stock	0.1999	0.2012	0.1977	0.2005	120118680.0
2005-03-18 16:00:00	NVDA	Stock	0.2002	0.2015	0.1992	0.2013	8482080.0
2005-03-18 17:00:00	NVDA	Stock	0.2	0.2014	0.1999	0.1999	2251680.0
2005-03-18 18:00:00	NVDA	Stock	0.2013	0.2013	0.2013	0.2013	13560.0
2005-03-18 08:00:00	AMZN	Stock	1.705	1.705	1.7	1.7025	43200.0
2005-03-18 09:00:00	AMZN	Stock	1.703	1.7085	1.6945	1.6955	6465100.0
2005-03-18 10:00:00	AMZN	Stock	1.6955	1.701	1.6825	1.683	17992920.0
2005-03-18 11:00:00	AMZN	Stock	1.6825	1.694	1.6825	1.687	12615240.0
2005-03-18 12:00:00	AMZN	Stock	1.687	1.71	1.687	1.705	12204240.0
2005-03-18 13:00:00	AMZN	Stock	1.705	1.707	1.6995	1.707	13053580.0
2005-03-18 14:00:00	AMZN	Stock	1.7065	1.714	1.7015	1.707	15956060.0
2005-03-18 15:00:00	AMZN	Stock	1.707	1.7105	1.697	1.706	22758080.0
2005-03-18 16:00:00	AMZN	Stock	1.702	1.709	1.7005	1.708	718460.0
2005-03-18 17:00:00	AMZN	Stock	1.708	1.708	1.708	1.708	2000.0
2005-03-18 09:00:00	CL	Stock	25.895	25.99	25.75	25.755	1192200.0
2005-03-18 10:00:00	CL	Stock	25.7505	25.88	25.71	25.88	500200.0
2005-03-18 11:00:00	CL	Stock	25.88	26.025	25.875	25.985	480600.0
2005-03-18 12:00:00	CL	Stock	25.985	26.02	25.945	26.01	233200.0
2005-03-18 13:00:00	CL	Stock	26.015	26.025	25.96	26.025	430600.0
2005-03-18 14:00:00	CL	Stock	26.025	26.055	25.965	26.0	354800.0
2005-03-18 15:00:00	CL	Stock	25.995	26.13	25.98	26.07	758800.0

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

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