PREVIEW / stock_1hour / 2006-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-07.parquet
  size:    613 KB
  rows:    28,900
  symbols: 2,226

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
2006-04-07 06:00:00	AAPL	Stock	2.5714	2.5732	2.5696	2.5696	16800.0
2006-04-07 07:00:00	AAPL	Stock	2.5554	2.5554	2.5429	2.5429	204148.0
2006-04-07 08:00:00	AAPL	Stock	2.5443	2.5539	2.5179	2.5382	12142144.0
2006-04-07 09:00:00	AAPL	Stock	2.5382	2.5439	2.4914	2.495	256778032.0
2006-04-07 10:00:00	AAPL	Stock	2.4946	2.5139	2.46	2.4707	307373192.0
2006-04-07 11:00:00	AAPL	Stock	2.4704	2.4745	2.4454	2.4543	206825192.0
2006-04-07 12:00:00	AAPL	Stock	2.4543	2.5	2.4471	2.495	178420480.0
2006-04-07 13:00:00	AAPL	Stock	2.495	2.5316	2.4846	2.5021	215058060.0
2006-04-07 14:00:00	AAPL	Stock	2.5025	2.5211	2.4946	2.5204	155823948.0
2006-04-07 15:00:00	AAPL	Stock	2.5207	2.5214	2.4821	2.4918	193683448.0
2006-04-07 16:00:00	AAPL	Stock	2.4918	2.4946	2.4893	2.4925	3457636.0
2006-04-07 17:00:00	AAPL	Stock	2.4921	2.5243	2.49	2.4918	680260.0
2006-04-07 18:00:00	AAPL	Stock	2.4911	2.4911	2.4893	2.49	142912.0
2006-04-07 07:00:00	MSFT	Stock	27.56	27.56	27.5	27.5	1260.0
2006-04-07 08:00:00	MSFT	Stock	27.51	27.64	27.51	27.61	57234.0
2006-04-07 09:00:00	MSFT	Stock	27.64	27.72	27.56	27.57	4586750.0
2006-04-07 10:00:00	MSFT	Stock	27.57	27.65	27.36	27.41	7566161.0
2006-04-07 11:00:00	MSFT	Stock	27.41	27.535	27.28	27.36	6758129.0
2006-04-07 12:00:00	MSFT	Stock	27.35	27.38	27.3	27.33	5177754.0
2006-04-07 13:00:00	MSFT	Stock	27.33	27.39	27.26	27.29	3931704.0
2006-04-07 14:00:00	MSFT	Stock	27.29	27.4	27.28	27.38	4366690.0
2006-04-07 15:00:00	MSFT	Stock	27.38	27.39	27.23	27.25	12781247.0
2006-04-07 16:00:00	MSFT	Stock	27.25	27.399	27.25	27.28	663332.0
2006-04-07 18:00:00	MSFT	Stock	27.29	27.384	27.29	27.384	4000.0
2006-04-07 07:00:00	NVDA	Stock	0.51	0.5102	0.5008	0.5017	232560.0
2006-04-07 08:00:00	NVDA	Stock	0.505	0.5078	0.5007	0.5067	7451340.0
2006-04-07 09:00:00	NVDA	Stock	0.5068	0.5125	0.5037	0.505	147289200.0
2006-04-07 10:00:00	NVDA	Stock	0.5052	0.5085	0.4998	0.5027	158698560.0
2006-04-07 11:00:00	NVDA	Stock	0.5027	0.5072	0.4988	0.5003	87110700.0
2006-04-07 12:00:00	NVDA	Stock	0.5003	0.5052	0.5003	0.5033	49887120.0
2006-04-07 13:00:00	NVDA	Stock	0.5033	0.5063	0.5027	0.5044	51143100.0
2006-04-07 14:00:00	NVDA	Stock	0.5043	0.509	0.5027	0.505	67246260.0
2006-04-07 15:00:00	NVDA	Stock	0.505	0.5107	0.5047	0.5087	103816500.0
2006-04-07 16:00:00	NVDA	Stock	0.5088	0.5093	0.5067	0.5083	858240.0
2006-04-07 17:00:00	NVDA	Stock	0.509	0.5125	0.509	0.5125	1011960.0
2006-04-07 18:00:00	NVDA	Stock	0.5108	0.5125	0.51	0.51	60000.0
2006-04-07 08:00:00	AMZN	Stock	1.9255	1.9255	1.92	1.925	192500.0
2006-04-07 09:00:00	AMZN	Stock	1.926	1.9335	1.9055	1.908	11213260.0
2006-04-07 10:00:00	AMZN	Stock	1.908	1.911	1.888	1.8895	19344180.0
2006-04-07 11:00:00	AMZN	Stock	1.8895	1.8975	1.865	1.8665	18502520.0
2006-04-07 12:00:00	AMZN	Stock	1.8665	1.875	1.8595	1.8625	16383580.0
2006-04-07 13:00:00	AMZN	Stock	1.862	1.867	1.8505	1.856	10900540.0
2006-04-07 14:00:00	AMZN	Stock	1.8555	1.8715	1.8535	1.862	10354700.0
2006-04-07 15:00:00	AMZN	Stock	1.862	1.864	1.85	1.8525	21258860.0
2006-04-07 16:00:00	AMZN	Stock	1.853	1.8762	1.8525	1.8762	352180.0
2006-04-07 18:00:00	AMZN	Stock	1.8748	1.8748	1.8615	1.8615	318000.0
2006-04-07 09:00:00	CL	Stock	29.015	29.055	28.95	28.98	286000.0
2006-04-07 10:00:00	CL	Stock	29.0	29.005	28.79	28.825	427200.0
2006-04-07 11:00:00	CL	Stock	28.825	28.866	28.74	28.805	365200.0
2006-04-07 12:00:00	CL	Stock	28.805	28.89	28.75	28.78	473400.0

> showing 50 of 28,900 rows — these rows as CSV

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