PREVIEW / stock_1hour / 2008-03-18

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-18.parquet
  size:    823 KB
  rows:    41,112
  symbols: 3,295

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
2008-03-18 06:00:00	AAPL	Stock	4.5921	4.6064	4.5861	4.6054	163436.0
2008-03-18 07:00:00	AAPL	Stock	4.5975	4.6082	4.5893	4.6054	553952.0
2008-03-18 08:00:00	AAPL	Stock	4.6039	4.6136	4.5893	4.5946	5944512.0
2008-03-18 09:00:00	AAPL	Stock	4.5979	4.6564	4.5954	4.6296	165319112.0
2008-03-18 10:00:00	AAPL	Stock	4.6296	4.645	4.6004	4.6214	134542604.0
2008-03-18 11:00:00	AAPL	Stock	4.6207	4.6554	4.6161	4.625	110168044.0
2008-03-18 12:00:00	AAPL	Stock	4.6247	4.6782	4.6182	4.6671	104747832.0
2008-03-18 13:00:00	AAPL	Stock	4.6675	4.6961	4.6671	4.6821	105261800.0
2008-03-18 14:00:00	AAPL	Stock	4.6831	4.7293	4.61	4.7221	308986972.0
2008-03-18 15:00:00	AAPL	Stock	4.7225	4.75	4.6875	4.7482	231137676.0
2008-03-18 16:00:00	AAPL	Stock	4.7474	4.75	4.6539	4.7375	19951120.0
2008-03-18 17:00:00	AAPL	Stock	4.74	4.7436	4.6221	4.7364	1916236.0
2008-03-18 18:00:00	AAPL	Stock	4.74	4.7611	4.7368	4.755	1185212.0
2008-03-18 19:00:00	AAPL	Stock	4.7536	4.7557	4.7496	4.7518	270340.0
2008-03-18 06:00:00	MSFT	Stock	28.7	28.7	28.7	28.7	100.0
2008-03-18 08:00:00	MSFT	Stock	28.72	28.75	28.3	28.75	1002749.0
2008-03-18 09:00:00	MSFT	Stock	28.75	29.1	28.63	28.94	8179308.0
2008-03-18 10:00:00	MSFT	Stock	28.94	29.137	28.9	29.02	9762435.0
2008-03-18 11:00:00	MSFT	Stock	29.03	29.07	28.82	28.83	8080717.0
2008-03-18 12:00:00	MSFT	Stock	28.83	29.17	28.79	29.16	7292569.0
2008-03-18 13:00:00	MSFT	Stock	29.16	29.23	29.02	29.19	6221290.0
2008-03-18 14:00:00	MSFT	Stock	29.192	29.31	28.68	29.29	22244503.0
2008-03-18 15:00:00	MSFT	Stock	29.28	29.47	29.15	29.46	14602086.0
2008-03-18 16:00:00	MSFT	Stock	29.449	29.48	29.046	29.43	4197361.0
2008-03-18 17:00:00	MSFT	Stock	29.41	29.45	28.969	29.3	20149.0
2008-03-18 18:00:00	MSFT	Stock	29.4	29.4	29.18	29.35	1328.0
2008-03-18 19:00:00	MSFT	Stock	29.34	29.49	28.87	29.49	368127.0
2008-03-18 08:00:00	NVDA	Stock	0.4548	0.4612	0.4548	0.4588	284640.0
2008-03-18 09:00:00	NVDA	Stock	0.4588	0.4593	0.4478	0.449	75396680.0
2008-03-18 10:00:00	NVDA	Stock	0.449	0.4525	0.444	0.4478	100946680.0
2008-03-18 11:00:00	NVDA	Stock	0.4478	0.4528	0.4458	0.4505	73754200.0
2008-03-18 12:00:00	NVDA	Stock	0.4505	0.46	0.4488	0.4575	116584680.0
2008-03-18 13:00:00	NVDA	Stock	0.4575	0.463	0.4562	0.4598	126059080.0
2008-03-18 14:00:00	NVDA	Stock	0.4598	0.4658	0.45	0.4655	204005440.0
2008-03-18 15:00:00	NVDA	Stock	0.4655	0.475	0.4628	0.4742	289260640.0
2008-03-18 16:00:00	NVDA	Stock	0.4742	0.4748	0.4556	0.4742	83373240.0
2008-03-18 17:00:00	NVDA	Stock	0.4745	0.475	0.4742	0.475	184000.0
2008-03-18 18:00:00	NVDA	Stock	0.475	0.4753	0.47	0.4753	102800.0
2008-03-18 19:00:00	NVDA	Stock	0.4775	0.4775	0.4775	0.4775	16520.0
2008-03-18 07:00:00	AMZN	Stock	3.375	3.375	3.375	3.375	2000.0
2008-03-18 08:00:00	AMZN	Stock	3.375	3.42	3.3265	3.4125	1078000.0
2008-03-18 09:00:00	AMZN	Stock	3.405	3.4615	3.3795	3.429	16958140.0
2008-03-18 10:00:00	AMZN	Stock	3.4295	3.45	3.412	3.43	17678340.0
2008-03-18 11:00:00	AMZN	Stock	3.4322	3.495	3.43	3.4535	19044640.0
2008-03-18 12:00:00	AMZN	Stock	3.4535	3.472	3.4485	3.4665	11743640.0
2008-03-18 13:00:00	AMZN	Stock	3.4675	3.49	3.4595	3.4685	11115380.0
2008-03-18 14:00:00	AMZN	Stock	3.467	3.5535	3.42	3.5425	40724600.0
2008-03-18 15:00:00	AMZN	Stock	3.541	3.5964	3.5095	3.5845	63094560.0
2008-03-18 16:00:00	AMZN	Stock	3.5806	3.5995	3.4595	3.571	5397600.0
2008-03-18 17:00:00	AMZN	Stock	3.5705	3.5705	3.565	3.565	59000.0

> showing 50 of 41,112 rows — these rows as CSV

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