PREVIEW / stock_daily / 2006-11-15

all stock daily files

  file:    by_date/stock_daily/2006/2006-11-15.parquet
  size:    154 KB
  rows:    4,598
  symbols: 2,912

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-11-15	AAPL	Stock	3.0375	3.0679	3.0	3.0018	655323200.0
2006-11-15	MSFT	Stock	29.13	29.36	29.11	29.12	63943200.0
2006-11-15	NVDA	Stock	0.6042	0.6125	0.5927	0.596	491892000.0
2006-11-15	AMZN	Stock	2.075	2.155	2.075	2.13	271134000.0
2006-11-15	CL	Stock	32.26	32.375	32.045	32.16	5195000.0
2006-11-15	A	Stock	23.6052	23.9127	23.5336	23.7053	4859029.0
2006-11-15	AABA-DELISTED	Stock	27.1800003051758	27.5	27.0300006866455	27.1499996185303	22112700.0
2006-11-15	AACC-DELISTED	Stock	16.81	16.91	16.7	16.85	289811.0
2006-11-15	AACQ-DELISTED	Stock	5.45	5.49	5.45	5.45	54500.0
2006-11-15	AACQW-DELISTED	Stock	0.64	0.65	0.62	0.65	47500.0
2006-11-15	AAI-DELISTED	Stock	12.11	13.42	12.11	12.81	12367600.0
2006-11-15	AAIC-DELISTED	Stock	145.8	146.6	143.0	145.4	1535500.0
2006-11-15	AAME	Stock	2.8	2.82	2.76	2.8	6700.0
2006-11-15	AAON	Stock	3.6188	3.8584	3.6188	3.8202	312862.0
2006-11-15	AAP	Stock	37.69	38.07	37.6	38.05	872600.0
2006-11-15	AATI-DELISTED	Stock	5.8	6.17	5.8	6.04	296906.0
2006-11-15	AAU-DELISTED	Stock	2.51	2.5699	2.51	2.51	29800.0
2006-11-15	AAUAF-DELISTED	Stock	2.51	2.5699	2.51	2.51	29800.0
2006-11-15	AAV-DELISTED	Stock	10.28	11.29	10.28	11.09	1787200.0
2006-11-15	AAWW-DELISTED	Stock	37.35	37.93	37.25	37.76	223289.0
2006-11-15	AAXN-DELISTED	Stock	9.07999992370605	9.35999965667725	9.07999992370605	9.21000003814697	609100.0
2006-11-15	AB	Stock	77.25	77.25	76.11	76.7	230900.0
2006-11-15	ABAX-DELISTED	Stock	20.81	21.15	20.48	20.52	122346.0
2006-11-15	ABB-DELISTED	Stock	15.78	16.04	15.76	15.99	1348500.0
2006-11-15	ABBC-DELISTED	Stock	16.14	16.2	16.1	16.2	14116.0
2006-11-15	ABC-DELISTED	Stock	23.19	23.59	23.15	23.5	3230800.0
2006-11-15	ABCB	Stock	27.2826	27.623	27.2826	27.5161	42667.0
2006-11-15	ABCO-DELISTED	Stock	28.87	28.96	28.47	28.87	143184.0
2006-11-15	ABCW-DELISTED	Stock	29.48	29.98	29.19	29.87	43840.0
2006-11-15	ABD-DELISTED	Stock	25.26	25.32	24.86	24.96	285000.0
2006-11-15	ABE-DELISTED	Stock	16.6	17.36	16.45	17.29	28000.0
2006-11-15	ABFS-DELISTED	Stock	40.03	40.49	39.99	40.36	247028.0
2006-11-15	ABG	Stock	23.26	24.17	23.26	23.92	951100.0
2006-11-15	ABK-DELISTED	Stock	83.86	84.04	83.69	83.73	552900.0
2006-11-15	ABM	Stock	20.6	20.69	20.52	20.68	137900.0
2006-11-15	ABMD-DELISTED	Stock	13.13	13.13	12.86	13.01	98343.0
2006-11-15	ABP-DELISTED	Stock	3.59	3.83	3.52	3.79	210900.0
2006-11-15	ABR	Stock	28.6	28.7	28.39	28.62	60600.0
2006-11-15	ABT	Stock	22.3587	22.6706	22.3443	22.5458	14662985.0
2006-11-15	ABTL-DELISTED	Stock	16.2	16.75	16.0	16.2	61234.0
2006-11-15	ABV-DELISTED	Stock	46.53	47.54	46.53	47.0	419000.0
2006-11-15	ABVA-DELISTED	Stock	15.719	15.72	15.66	15.66	1187.0
2006-11-15	ABX-DELISTED	Stock	28.79	29.57	28.77	29.31	4332600.0
2006-11-15	ACAD	Stock	9.61	9.83	9.61	9.8	100000.0
2006-11-15	ACAP-DELISTED	Stock	39.24	40.16	39.24	39.81	35609.0
2006-11-15	ACAS-DELISTED	Stock	43.83	43.97	43.4	43.94	714202.0
2006-11-15	ACAT-DELISTED	Stock	17.88	18.18	17.45	17.48	75960.0
2006-11-15	ACC-DELISTED	Stock	27.9	28.02	27.79	27.86	179987.0
2006-11-15	ACCL-DELISTED	Stock	6.26	6.41	6.1512	6.4	58871.0
2006-11-15	ACCO	Stock	25.26	25.32	24.86	24.96	307200.0

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

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