PREVIEW / stock_1hour / 2008-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-20.parquet
  size:    869 KB
  rows:    41,393
  symbols: 3,325

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-06-20 06:00:00	AAPL	Stock	6.4839	6.4839	6.4643	6.4643	47320.0
2008-06-20 07:00:00	AAPL	Stock	6.4536	6.4536	6.3929	6.4286	597324.0
2008-06-20 08:00:00	AAPL	Stock	6.4232	6.4257	6.4039	6.4168	1827924.0
2008-06-20 09:00:00	AAPL	Stock	6.4164	6.4643	6.3571	6.3679	168582596.0
2008-06-20 10:00:00	AAPL	Stock	6.3686	6.3786	6.3143	6.3479	139111224.0
2008-06-20 11:00:00	AAPL	Stock	6.3471	6.3732	6.3179	6.3732	88159456.0
2008-06-20 12:00:00	AAPL	Stock	6.3732	6.3761	6.3204	6.3293	62092520.0
2008-06-20 13:00:00	AAPL	Stock	6.3293	6.3511	6.2825	6.3068	84489888.0
2008-06-20 14:00:00	AAPL	Stock	6.3068	6.3189	6.2625	6.2696	94707704.0
2008-06-20 15:00:00	AAPL	Stock	6.2696	6.2936	6.25	6.2564	168861252.0
2008-06-20 16:00:00	AAPL	Stock	6.2564	6.4636	6.2482	6.2511	39733288.0
2008-06-20 17:00:00	AAPL	Stock	6.25	6.272	6.2493	6.2554	6884220.0
2008-06-20 18:00:00	AAPL	Stock	6.255	6.2554	6.25	6.2518	163716.0
2008-06-20 19:00:00	AAPL	Stock	6.2543	6.255	6.2429	6.2504	368312.0
2008-06-20 08:00:00	MSFT	Stock	28.85	28.85	28.7	28.7	12774.0
2008-06-20 09:00:00	MSFT	Stock	28.67	29.25	28.65	28.735	21843326.0
2008-06-20 10:00:00	MSFT	Stock	28.73	28.78	28.5	28.54	10656087.0
2008-06-20 11:00:00	MSFT	Stock	28.55	28.6	28.38	28.46	7452089.0
2008-06-20 12:00:00	MSFT	Stock	28.46	28.48	28.31	28.38	5255781.0
2008-06-20 13:00:00	MSFT	Stock	28.38	28.49	28.2	28.27	7805078.0
2008-06-20 14:00:00	MSFT	Stock	28.27	28.35	28.11	28.13	7743400.0
2008-06-20 15:00:00	MSFT	Stock	28.13	28.35	28.1	28.25	13096454.0
2008-06-20 16:00:00	MSFT	Stock	28.239	28.508	28.19	28.25	7462147.0
2008-06-20 17:00:00	MSFT	Stock	28.23	28.252	28.207	28.25	803348.0
2008-06-20 18:00:00	MSFT	Stock	28.25	28.25	28.23	28.23	2800.0
2008-06-20 19:00:00	MSFT	Stock	28.24	28.26	28.24	28.24	2134.0
2008-06-20 08:00:00	NVDA	Stock	0.4963	0.4972	0.484	0.4862	428600.0
2008-06-20 09:00:00	NVDA	Stock	0.4862	0.4928	0.4845	0.4905	132163320.0
2008-06-20 10:00:00	NVDA	Stock	0.4908	0.4918	0.4852	0.4898	127544720.0
2008-06-20 11:00:00	NVDA	Stock	0.4898	0.4963	0.4878	0.4942	85817800.0
2008-06-20 12:00:00	NVDA	Stock	0.494	0.497	0.4928	0.497	51129720.0
2008-06-20 13:00:00	NVDA	Stock	0.497	0.4995	0.4932	0.4945	77304240.0
2008-06-20 14:00:00	NVDA	Stock	0.4947	0.4948	0.4902	0.4908	66433240.0
2008-06-20 15:00:00	NVDA	Stock	0.491	0.4955	0.4892	0.493	147055160.0
2008-06-20 16:00:00	NVDA	Stock	0.4932	0.4941	0.4916	0.494	3729280.0
2008-06-20 17:00:00	NVDA	Stock	0.494	0.494	0.4925	0.4925	4203200.0
2008-06-20 18:00:00	NVDA	Stock	0.4925	0.4938	0.4925	0.4938	196000.0
2008-06-20 19:00:00	NVDA	Stock	0.4938	0.4938	0.4938	0.4938	20000.0
2008-06-20 08:00:00	AMZN	Stock	4.1775	4.1775	4.156	4.156	59100.0
2008-06-20 09:00:00	AMZN	Stock	4.173	4.173	4.109	4.1235	32408480.0
2008-06-20 10:00:00	AMZN	Stock	4.125	4.1265	4.066	4.0795	22543280.0
2008-06-20 11:00:00	AMZN	Stock	4.0795	4.102	4.0765	4.088	13028860.0
2008-06-20 12:00:00	AMZN	Stock	4.088	4.094	4.05	4.059	8437880.0
2008-06-20 13:00:00	AMZN	Stock	4.059	4.076	4.05	4.0575	11179840.0
2008-06-20 14:00:00	AMZN	Stock	4.057	4.0635	4.0305	4.0325	11060540.0
2008-06-20 15:00:00	AMZN	Stock	4.0325	4.0725	4.0255	4.0565	20881640.0
2008-06-20 16:00:00	AMZN	Stock	4.0575	4.107	4.0535	4.055	8253300.0
2008-06-20 17:00:00	AMZN	Stock	4.055	4.071	4.055	4.071	1126360.0
2008-06-20 08:00:00	TLT	Stock	90.0	90.0	90.0	90.0	1000.0
2008-06-20 09:00:00	TLT	Stock	89.95	90.07	89.94	89.97	492701.0

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

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