PREVIEW / stock_1hour / 2006-12-13

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-13.parquet
  size:    659 KB
  rows:    31,485
  symbols: 2,471

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-12-13 06:00:00	AAPL	Stock	3.0804	3.1157	3.0804	3.1093	324072.0
2006-12-13 07:00:00	AAPL	Stock	3.1071	3.1279	3.1071	3.1214	1493380.0
2006-12-13 08:00:00	AAPL	Stock	3.1186	3.1282	3.1139	3.1279	11163936.0
2006-12-13 09:00:00	AAPL	Stock	3.1279	3.1521	3.1268	3.1336	170729216.0
2006-12-13 10:00:00	AAPL	Stock	3.1332	3.1386	3.1125	3.1346	170176188.0
2006-12-13 11:00:00	AAPL	Stock	3.1346	3.1432	3.1161	3.1361	58674476.0
2006-12-13 12:00:00	AAPL	Stock	3.1364	3.1393	3.12	3.1353	72124780.0
2006-12-13 13:00:00	AAPL	Stock	3.1354	3.1386	3.1232	3.1343	51263996.0
2006-12-13 14:00:00	AAPL	Stock	3.1346	3.1593	3.1343	3.1554	141940876.0
2006-12-13 15:00:00	AAPL	Stock	3.1557	3.1811	3.1518	3.1796	158940068.0
2006-12-13 16:00:00	AAPL	Stock	3.1796	3.1829	3.1775	3.1796	3646888.0
2006-12-13 17:00:00	AAPL	Stock	3.1796	3.185	3.1786	3.185	741468.0
2006-12-13 18:00:00	AAPL	Stock	3.1854	3.1871	3.1804	3.1864	312648.0
2006-12-13 19:00:00	AAPL	Stock	3.1864	3.1886	3.1839	3.1864	167104.0
2006-12-13 08:00:00	MSFT	Stock	29.45	29.49	29.43	29.48	15650.0
2006-12-13 09:00:00	MSFT	Stock	29.48	29.65	29.32	29.54	7112520.0
2006-12-13 10:00:00	MSFT	Stock	29.53	29.53	29.37	29.441	7627828.0
2006-12-13 11:00:00	MSFT	Stock	29.44	29.47	29.39	29.43	3556363.0
2006-12-13 12:00:00	MSFT	Stock	29.42	29.45	29.34	29.41	3512717.0
2006-12-13 13:00:00	MSFT	Stock	29.4	29.49	29.38	29.47	3838599.0
2006-12-13 14:00:00	MSFT	Stock	29.47	29.52	29.44	29.45	4232864.0
2006-12-13 15:00:00	MSFT	Stock	29.46	29.6	29.45	29.54	9815162.0
2006-12-13 16:00:00	MSFT	Stock	29.54	29.58	29.5	29.5	362801.0
2006-12-13 17:00:00	MSFT	Stock	29.55	29.55	29.55	29.55	425.0
2006-12-13 18:00:00	MSFT	Stock	29.57	29.6	29.55	29.55	9593.0
2006-12-13 19:00:00	MSFT	Stock	29.61	29.62	29.6	29.62	3985.0
2006-12-13 08:00:00	NVDA	Stock	0.5973	0.5997	0.5973	0.5997	295500.0
2006-12-13 09:00:00	NVDA	Stock	0.6013	0.608	0.5983	0.605	62404080.0
2006-12-13 10:00:00	NVDA	Stock	0.6053	0.6067	0.6018	0.6043	100304220.0
2006-12-13 11:00:00	NVDA	Stock	0.6045	0.6083	0.603	0.6078	62194080.0
2006-12-13 12:00:00	NVDA	Stock	0.6078	0.6082	0.6028	0.6043	54926160.0
2006-12-13 13:00:00	NVDA	Stock	0.6042	0.6063	0.6033	0.6058	42533880.0
2006-12-13 14:00:00	NVDA	Stock	0.6058	0.6073	0.6027	0.605	44535480.0
2006-12-13 15:00:00	NVDA	Stock	0.605	0.6067	0.6028	0.6038	76169220.0
2006-12-13 16:00:00	NVDA	Stock	0.6035	0.6042	0.6035	0.6042	216000.0
2006-12-13 17:00:00	NVDA	Stock	0.6038	0.6038	0.6038	0.6038	30000.0
2006-12-13 18:00:00	NVDA	Stock	0.6035	0.6035	0.6035	0.6035	85080.0
2006-12-13 19:00:00	NVDA	Stock	0.6037	0.6037	0.6037	0.6037	12000.0
2006-12-13 08:00:00	AMZN	Stock	1.9425	1.9425	1.925	1.935	10900.0
2006-12-13 09:00:00	AMZN	Stock	1.9375	1.9595	1.926	1.944	21021900.0
2006-12-13 10:00:00	AMZN	Stock	1.944	1.944	1.9165	1.935	15077780.0
2006-12-13 11:00:00	AMZN	Stock	1.935	1.9435	1.92	1.9265	10709040.0
2006-12-13 12:00:00	AMZN	Stock	1.9265	1.928	1.9095	1.918	7227580.0
2006-12-13 13:00:00	AMZN	Stock	1.918	1.926	1.913	1.9215	7401560.0
2006-12-13 14:00:00	AMZN	Stock	1.9205	1.93	1.916	1.92	8897560.0
2006-12-13 15:00:00	AMZN	Stock	1.92	1.9335	1.919	1.925	16281080.0
2006-12-13 16:00:00	AMZN	Stock	1.926	1.9275	1.9235	1.9275	60200.0
2006-12-13 18:00:00	AMZN	Stock	1.925	1.925	1.925	1.925	5240.0
2006-12-13 09:00:00	CL	Stock	32.88	33.065	32.88	32.935	318800.0
2006-12-13 10:00:00	CL	Stock	32.935	32.95	32.75	32.785	286000.0

> showing 50 of 31,485 rows — these rows as CSV

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