PREVIEW / stock_1hour / 2009-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-26.parquet
  size:    816 KB
  rows:    40,443
  symbols: 3,306

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
2009-01-26 06:00:00	AAPL	Stock	3.1875	3.1875	3.1875	3.1875	28000.0
2009-01-26 07:00:00	AAPL	Stock	3.1875	3.1975	3.1543	3.1543	30800.0
2009-01-26 08:00:00	AAPL	Stock	3.1536	3.1821	3.1486	3.1782	410004.0
2009-01-26 09:00:00	AAPL	Stock	3.1771	3.2275	3.165	3.2064	92450820.0
2009-01-26 10:00:00	AAPL	Stock	3.2057	3.2489	3.2057	3.2164	117273828.0
2009-01-26 11:00:00	AAPL	Stock	3.2161	3.2268	3.205	3.2117	62935124.0
2009-01-26 12:00:00	AAPL	Stock	3.2118	3.2379	3.2118	3.225	74604600.0
2009-01-26 13:00:00	AAPL	Stock	3.225	3.2318	3.1961	3.2007	80743852.0
2009-01-26 14:00:00	AAPL	Stock	3.1996	3.2107	3.1536	3.2061	121892736.0
2009-01-26 15:00:00	AAPL	Stock	3.2061	3.2268	3.1868	3.2018	120571192.0
2009-01-26 16:00:00	AAPL	Stock	3.2014	3.2268	3.1957	3.2018	13024900.0
2009-01-26 17:00:00	AAPL	Stock	3.2018	3.227	3.1971	3.2	2840208.0
2009-01-26 18:00:00	AAPL	Stock	3.1982	3.2107	3.1982	3.21	6973960.0
2009-01-26 19:00:00	AAPL	Stock	3.2064	3.21	3.1961	3.1964	207760.0
2009-01-26 07:00:00	MSFT	Stock	17.3	17.3	17.19	17.2	4296.0
2009-01-26 08:00:00	MSFT	Stock	17.25	17.29	17.15	17.25	66217.0
2009-01-26 09:00:00	MSFT	Stock	17.27	17.51	17.22	17.501	9294904.0
2009-01-26 10:00:00	MSFT	Stock	17.51	17.81	17.501	17.66	14821297.0
2009-01-26 11:00:00	MSFT	Stock	17.67	17.76	17.61	17.73	7753017.0
2009-01-26 12:00:00	MSFT	Stock	17.73	17.8	17.7	17.715	8064676.0
2009-01-26 13:00:00	MSFT	Stock	17.712	17.78	17.42	17.47	10126871.0
2009-01-26 14:00:00	MSFT	Stock	17.47	17.48	17.26	17.45	9579050.0
2009-01-26 15:00:00	MSFT	Stock	17.45	17.65	17.42	17.6	14542265.0
2009-01-26 16:00:00	MSFT	Stock	17.58	17.74	17.52	17.56	14759524.0
2009-01-26 17:00:00	MSFT	Stock	17.54	17.645	17.53	17.56	30915.0
2009-01-26 18:00:00	MSFT	Stock	17.56	17.63	17.56	17.6	635343.0
2009-01-26 19:00:00	MSFT	Stock	17.6	17.6	17.56	17.59	3675.0
2009-01-26 08:00:00	NVDA	Stock	0.1888	0.1888	0.1885	0.1885	20000.0
2009-01-26 09:00:00	NVDA	Stock	0.1965	0.2005	0.1905	0.1988	77640040.0
2009-01-26 10:00:00	NVDA	Stock	0.1988	0.2038	0.1988	0.2018	91954520.0
2009-01-26 11:00:00	NVDA	Stock	0.2015	0.2035	0.2007	0.202	58598400.0
2009-01-26 12:00:00	NVDA	Stock	0.2023	0.205	0.2018	0.2047	84869560.0
2009-01-26 13:00:00	NVDA	Stock	0.2045	0.2045	0.2002	0.2007	66905680.0
2009-01-26 14:00:00	NVDA	Stock	0.2007	0.201	0.1972	0.2	72029000.0
2009-01-26 15:00:00	NVDA	Stock	0.2	0.2025	0.198	0.1992	109477400.0
2009-01-26 16:00:00	NVDA	Stock	0.1992	0.2035	0.1984	0.1992	5691000.0
2009-01-26 17:00:00	NVDA	Stock	0.201	0.2013	0.201	0.2013	44000.0
2009-01-26 18:00:00	NVDA	Stock	0.2013	0.2013	0.1992	0.2013	44880.0
2009-01-26 19:00:00	NVDA	Stock	0.2013	0.2013	0.1998	0.1998	24000.0
2009-01-26 08:00:00	AMZN	Stock	2.507	2.507	2.507	2.507	12000.0
2009-01-26 09:00:00	AMZN	Stock	2.515	2.5445	2.4905	2.508	10874660.0
2009-01-26 10:00:00	AMZN	Stock	2.51	2.5335	2.4775	2.4785	29690180.0
2009-01-26 11:00:00	AMZN	Stock	2.4785	2.499	2.45	2.4702	18506580.0
2009-01-26 12:00:00	AMZN	Stock	2.471	2.489	2.4595	2.4735	10465160.0
2009-01-26 13:00:00	AMZN	Stock	2.473	2.4854	2.432	2.4446	13247140.0
2009-01-26 14:00:00	AMZN	Stock	2.443	2.4655	2.426	2.459	18751900.0
2009-01-26 15:00:00	AMZN	Stock	2.46	2.487	2.4475	2.4815	37332540.0
2009-01-26 16:00:00	AMZN	Stock	2.4815	2.4885	2.461	2.4815	926060.0
2009-01-26 18:00:00	AMZN	Stock	2.482	2.482	2.4815	2.4815	9700.0
2009-01-26 19:00:00	AMZN	Stock	2.4725	2.49	2.4725	2.49	17600.0

> showing 50 of 40,443 rows — these rows as CSV

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