PREVIEW / stock_1hour / 2008-05-22

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-22.parquet
  size:    841 KB
  rows:    40,378
  symbols: 3,296

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-05-22 04:00:00	AAPL	Stock	6.3571	6.3586	6.3564	6.3586	11200.0
2008-05-22 06:00:00	AAPL	Stock	6.3668	6.37	6.3668	6.37	55300.0
2008-05-22 07:00:00	AAPL	Stock	6.3768	6.4125	6.3707	6.3843	743988.0
2008-05-22 08:00:00	AAPL	Stock	6.3886	6.4125	6.3329	6.4071	6396992.0
2008-05-22 09:00:00	AAPL	Stock	6.4064	6.4536	6.3529	6.3757	149064048.0
2008-05-22 10:00:00	AAPL	Stock	6.3768	6.4761	6.3757	6.4414	177735040.0
2008-05-22 11:00:00	AAPL	Stock	6.4418	6.4675	6.3754	6.3989	113017576.0
2008-05-22 12:00:00	AAPL	Stock	6.3989	6.4143	6.3529	6.3882	86939188.0
2008-05-22 13:00:00	AAPL	Stock	6.3882	6.3939	6.3232	6.3571	105122556.0
2008-05-22 14:00:00	AAPL	Stock	6.3575	6.3682	6.1429	6.2746	354330928.0
2008-05-22 15:00:00	AAPL	Stock	6.2757	6.3393	6.2236	6.3232	186100768.0
2008-05-22 16:00:00	AAPL	Stock	6.3232	6.3344	6.2609	6.3339	11900560.0
2008-05-22 17:00:00	AAPL	Stock	6.3321	6.35	6.2765	6.3393	729204.0
2008-05-22 18:00:00	AAPL	Stock	6.3393	6.3429	6.3354	6.3393	68600.0
2008-05-22 19:00:00	AAPL	Stock	6.3393	6.3464	6.3361	6.3375	180096.0
2008-05-22 08:00:00	MSFT	Stock	28.35	28.39	28.31	28.37	9440.0
2008-05-22 09:00:00	MSFT	Stock	28.35	28.44	28.19	28.36	8639111.0
2008-05-22 10:00:00	MSFT	Stock	28.36	28.6	28.32	28.47	11513427.0
2008-05-22 11:00:00	MSFT	Stock	28.47	28.5	28.37	28.49	5469611.0
2008-05-22 12:00:00	MSFT	Stock	28.49	28.68	28.43	28.67	4688667.0
2008-05-22 13:00:00	MSFT	Stock	28.68	28.7	28.53	28.54	4010350.0
2008-05-22 14:00:00	MSFT	Stock	28.54	28.62	28.47	28.55	5955422.0
2008-05-22 15:00:00	MSFT	Stock	28.54	28.59	28.34	28.45	9473393.0
2008-05-22 16:00:00	MSFT	Stock	28.45	28.47	28.42	28.44	1561590.0
2008-05-22 17:00:00	MSFT	Stock	28.45	28.506	28.42	28.45	18841.0
2008-05-22 18:00:00	MSFT	Stock	28.47	28.47	28.46	28.46	3550.0
2008-05-22 19:00:00	MSFT	Stock	28.5	28.55	28.46	28.46	3125.0
2008-05-22 08:00:00	NVDA	Stock	0.5775	0.5875	0.5775	0.5812	559520.0
2008-05-22 09:00:00	NVDA	Stock	0.585	0.5935	0.5812	0.5905	77644360.0
2008-05-22 10:00:00	NVDA	Stock	0.5903	0.596	0.5875	0.591	147214120.0
2008-05-22 11:00:00	NVDA	Stock	0.591	0.5925	0.5838	0.5885	79826040.0
2008-05-22 12:00:00	NVDA	Stock	0.5885	0.5933	0.586	0.5918	72398720.0
2008-05-22 13:00:00	NVDA	Stock	0.592	0.595	0.5905	0.5925	81666440.0
2008-05-22 14:00:00	NVDA	Stock	0.5925	0.5952	0.5905	0.5925	93520960.0
2008-05-22 15:00:00	NVDA	Stock	0.5925	0.5955	0.5762	0.5915	120520040.0
2008-05-22 16:00:00	NVDA	Stock	0.5912	0.5944	0.5595	0.5912	3763080.0
2008-05-22 17:00:00	NVDA	Stock	0.5912	0.593	0.59	0.59	6269080.0
2008-05-22 18:00:00	NVDA	Stock	0.59	0.59	0.59	0.59	40000.0
2008-05-22 19:00:00	NVDA	Stock	0.59	0.592	0.589	0.592	86000.0
2008-05-22 20:00:00	NVDA	Stock	0.5912	0.5912	0.5912	0.5912	96000.0
2008-05-22 08:00:00	AMZN	Stock	3.925	3.925	3.925	3.925	4000.0
2008-05-22 09:00:00	AMZN	Stock	3.925	3.9645	3.9	3.926	12788540.0
2008-05-22 10:00:00	AMZN	Stock	3.9265	3.972	3.9105	3.9405	18946620.0
2008-05-22 11:00:00	AMZN	Stock	3.9395	3.965	3.9275	3.938	10739960.0
2008-05-22 12:00:00	AMZN	Stock	3.9375	3.9845	3.928	3.9725	12251300.0
2008-05-22 13:00:00	AMZN	Stock	3.971	3.981	3.9555	3.96	11651320.0
2008-05-22 14:00:00	AMZN	Stock	3.9605	3.977	3.939	3.9705	17317600.0
2008-05-22 15:00:00	AMZN	Stock	3.97	3.9765	3.9435	3.9635	19717900.0
2008-05-22 16:00:00	AMZN	Stock	3.9635	3.973	3.9513	3.963	1712080.0
2008-05-22 17:00:00	AMZN	Stock	3.966	3.966	3.966	3.966	8000.0

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

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