PREVIEW / stock_daily / 2006-12-13

all stock daily files

  file:    by_date/stock_daily/2006/2006-12-13.parquet
  size:    156 KB
  rows:    4,646
  symbols: 2,948

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2006-12-13	AAPL	Stock	3.1411	3.1811	3.1125	3.1804	857052000.0
2006-12-13	MSFT	Stock	29.6	29.6	29.32	29.55	46002500.0
2006-12-13	NVDA	Stock	0.6013	0.6083	0.6013	0.6035	491952000.0
2006-12-13	AMZN	Stock	1.9305	1.9595	1.9095	1.925	93556000.0
2006-12-13	CL	Stock	32.99	33.065	32.585	32.78	2518400.0
2006-12-13	A	Stock	24.2203	24.3205	24.0486	24.206	3256781.0
2006-12-13	AABA-DELISTED	Stock	27.0499992370605	27.2299995422363	26.5100002288818	26.6000003814697	20428600.0
2006-12-13	AACC-DELISTED	Stock	16.12	16.19	16.09	16.11	76923.0
2006-12-13	AACQ-DELISTED	Stock	5.45	5.45	5.44	5.44	174300.0
2006-12-13	AACQW-DELISTED	Stock	0.55	0.56	0.55	0.56	20485.0
2006-12-13	AAI-DELISTED	Stock	12.76	12.88	12.271	12.86	4272200.0
2006-12-13	AAIC-DELISTED	Stock	151.0	152.2	148.2	148.6	1138400.0
2006-12-13	AAME	Stock	2.9	3.0	2.9	3.0	2400.0
2006-12-13	AAON	Stock	3.6135	3.6135	3.4252	3.4634	179972.0
2006-12-13	AAP	Stock	35.7	35.77	35.35	35.6	712400.0
2006-12-13	AATI-DELISTED	Stock	5.24	5.27	5.16	5.17	114687.0
2006-12-13	AAU-DELISTED	Stock	2.35	2.4	2.3	2.3	72800.0
2006-12-13	AAUAF-DELISTED	Stock	2.35	2.4	2.3	2.3	72800.0
2006-12-13	AAV-DELISTED	Stock	11.62	11.65	11.4	11.4799	592900.0
2006-12-13	AAWW-DELISTED	Stock	45.79	45.95	45.42	45.94	124079.0
2006-12-13	AAXN-DELISTED	Stock	8.14000034332275	8.31999969482422	7.98000001907349	8.03999996185303	1521300.0
2006-12-13	AB	Stock	78.97	79.03	77.92	78.43	146900.0
2006-12-13	ABAX-DELISTED	Stock	19.47	19.47	19.14	19.34	76871.0
2006-12-13	ABB-DELISTED	Stock	16.85	16.99	16.82	16.99	2169200.0
2006-12-13	ABBC-DELISTED	Stock	19.35	19.35	19.05	19.09	85050.0
2006-12-13	ABC-DELISTED	Stock	24.0	24.01	23.42	23.62	2820800.0
2006-12-13	ABCB	Stock	27.234	27.3215	26.9422	27.234	9870.0
2006-12-13	ABCO-DELISTED	Stock	26.98	27.03	26.51	26.66	141460.0
2006-12-13	ABCW-DELISTED	Stock	28.65	28.68	28.47	28.68	24500.0
2006-12-13	ABD-DELISTED	Stock	25.61	26.28	25.61	26.28	210200.0
2006-12-13	ABE-DELISTED	Stock	17.31	18.13	17.31	18.0	94600.0
2006-12-13	ABFS-DELISTED	Stock	36.56	36.56	35.68	35.7	460444.0
2006-12-13	ABG	Stock	23.9	23.99	23.73	23.82	132100.0
2006-12-13	ABK-DELISTED	Stock	85.77	86.02	84.64	85.48	421100.0
2006-12-13	ABM	Stock	22.79	22.79	21.05	21.49	654600.0
2006-12-13	ABMD-DELISTED	Stock	13.08	13.21	12.98	13.15	69517.0
2006-12-13	ABP-DELISTED	Stock	3.63	3.78	3.63	3.74	119800.0
2006-12-13	ABR	Stock	29.17	29.25	28.64	28.68	69900.0
2006-12-13	ABT	Stock	23.0304	23.136	22.968	23.0112	5461651.0
2006-12-13	ABTL-DELISTED	Stock	16.449	17.251	16.449	17.201	64538.0
2006-12-13	ABV-DELISTED	Stock	48.3	48.35	47.88	48.02	646800.0
2006-12-13	ABVA-DELISTED	Stock	16.0	16.15	16.0	16.0	1600.0
2006-12-13	ABX-DELISTED	Stock	29.9	30.28	29.71	30.2	3031200.0
2006-12-13	ACAD	Stock	8.78	9.2	8.78	9.15	232600.0
2006-12-13	ACAP-DELISTED	Stock	39.19	39.34	38.77	38.99	51533.0
2006-12-13	ACAS-DELISTED	Stock	44.71	44.9	44.57	44.9	542961.0
2006-12-13	ACAT-DELISTED	Stock	18.25	18.25	17.83	18.01	130668.0
2006-12-13	ACC-DELISTED	Stock	29.17	29.48	28.85	29.27	104200.0
2006-12-13	ACCL-DELISTED	Stock	5.71	5.72	5.6	5.64	105386.0
2006-12-13	ACCO	Stock	25.61	26.28	25.61	26.28	224500.0

> showing 50 of 4,646 rows — these rows as CSV

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