PREVIEW / stock_daily / 2006-10-12

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-12.parquet
  size:    151 KB
  rows:    4,524
  symbols: 2,857

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-10-12	AAPL	Stock	2.6289	2.6925	2.6286	2.6879	592855200.0
2006-10-12	MSFT	Stock	27.58	28.29	27.54	28.22	120174900.0
2006-10-12	NVDA	Stock	0.5422	0.5525	0.5335	0.5413	414720000.0
2006-10-12	AMZN	Stock	1.655	1.6855	1.6315	1.6775	119794000.0
2006-10-12	CL	Stock	31.1	31.1	30.575	30.74	5364800.0
2006-10-12	A	Stock	23.7554	24.1202	23.7268	24.02	2367793.0
2006-10-12	AABA-DELISTED	Stock	24.3199996948242	24.3799991607666	24.1000003814697	24.1200008392334	25824500.0
2006-10-12	AACC-DELISTED	Stock	16.86	17.22	16.81	17.14	98834.0
2006-10-12	AACQ-DELISTED	Stock	5.35	5.35	5.35	5.35	7500.0
2006-10-12	AACQU-DELISTED	Stock	6.04	6.04	6.02	6.02	12000.0
2006-10-12	AACQW-DELISTED	Stock	0.36	0.36	0.36	0.36	40000.0
2006-10-12	AAI-DELISTED	Stock	10.52	11.02	10.5	10.9499	2068500.0
2006-10-12	AAIC-DELISTED	Stock	162.2	164.2	159.6	161.8	1320600.0
2006-10-12	AAME	Stock	2.57	2.57	2.48	2.48	700.0
2006-10-12	AAON	Stock	3.1539	3.2053	3.1342	3.1592	175416.0
2006-10-12	AAP	Stock	34.47	35.1	34.47	34.98	421900.0
2006-10-12	AATI-DELISTED	Stock	5.2	5.28	5.14	5.2	423393.0
2006-10-12	AAU-DELISTED	Stock	2.36	2.39	2.3	2.36	93004.0
2006-10-12	AAUAF-DELISTED	Stock	2.35	2.38	2.2988	2.35	93200.0
2006-10-12	AAV-DELISTED	Stock	11.99	12.15	11.82	12.04	826400.0
2006-10-12	AAWW-DELISTED	Stock	46.49	46.86	46.29	46.75	135552.0
2006-10-12	AAXN-DELISTED	Stock	9.06999969482422	9.6899995803833	9.06999969482422	9.64999961853027	2325600.0
2006-10-12	AB	Stock	72.99	76.73	72.99	75.63	1052700.0
2006-10-12	ABAX-DELISTED	Stock	21.58	22.0	21.3	21.65	262396.0
2006-10-12	ABB-DELISTED	Stock	13.87	14.1	13.87	14.1	2490000.0
2006-10-12	ABBC-DELISTED	Stock	15.225	15.5	15.21	15.5	22112.0
2006-10-12	ABC-DELISTED	Stock	23.08	23.14	22.98	23.08	1534800.0
2006-10-12	ABCB	Stock	27.8371	28.2844	27.8273	28.0412	20151.0
2006-10-12	ABCO-DELISTED	Stock	27.29	27.47	27.26	27.34	216995.0
2006-10-12	ABCW-DELISTED	Stock	28.71	29.52	28.68	29.5	99260.0
2006-10-12	ABD-DELISTED	Stock	22.73	23.41	22.72	23.4	172400.0
2006-10-12	ABE-DELISTED	Stock	14.2	14.6	14.2	14.59	12000.0
2006-10-12	ABFS-DELISTED	Stock	47.67	48.4	47.15	48.4	308670.0
2006-10-12	ABG	Stock	22.28	22.95	22.22	22.56	697300.0
2006-10-12	ABK-DELISTED	Stock	85.0	85.28	84.89	85.15	464400.0
2006-10-12	ABM	Stock	19.2	19.5	19.2	19.5	208500.0
2006-10-12	ABMD-DELISTED	Stock	15.0	15.1	14.86	15.0	121293.0
2006-10-12	ABP-DELISTED	Stock	3.38	3.6	3.37	3.45	142400.0
2006-10-12	ABR	Stock	26.67	26.85	26.62	26.83	57400.0
2006-10-12	ABT	Stock	22.4546	22.4786	22.2387	22.2867	12993331.0
2006-10-12	ABTL-DELISTED	Stock	15.697	16.153	15.444	15.95	20299.0
2006-10-12	ABV-DELISTED	Stock	46.29	46.66	46.06	46.58	380000.0
2006-10-12	ABVA-DELISTED	Stock	17.1	17.22	17.1	17.139	886.0
2006-10-12	ABX-DELISTED	Stock	28.51	29.3	28.43	29.23	4034748.0
2006-10-12	ACAD	Stock	9.39	9.85	9.32	9.81	195900.0
2006-10-12	ACAP-DELISTED	Stock	51.29	51.42	49.65	51.27	30269.0
2006-10-12	ACAS-DELISTED	Stock	41.07	41.57	41.0	41.44	707302.0
2006-10-12	ACAT-DELISTED	Stock	17.0	17.21	16.36	17.17	233594.0
2006-10-12	ACC-DELISTED	Stock	25.99	26.22	25.9	26.1	61400.0
2006-10-12	ACCL-DELISTED	Stock	6.02	6.16	6.0	6.14	34253.0

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

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