PREVIEW / stock_daily / 2006-05-09

all stock daily files

  file:    by_date/stock_daily/2006/2006-05-09.parquet
  size:    149 KB
  rows:    4,440
  symbols: 2,807

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-05-09	AAPL	Stock	2.565	2.5914	2.5221	2.5368	531666800.0
2006-05-09	MSFT	Stock	23.75	24.0	23.49	23.62	75345900.0
2006-05-09	NVDA	Stock	0.5183	0.521	0.5025	0.5032	561648000.0
2006-05-09	AMZN	Stock	1.721	1.763	1.7105	1.742	109694000.0
2006-05-09	CL	Stock	30.31	30.465	29.73	30.035	3943000.0
2006-05-09	A	Stock	27.9971	27.9971	27.6109	27.8112	2259867.0
2006-05-09	AABA-DELISTED	Stock	32.6800003051758	34.0	32.3499984741211	32.4900016784668	13396400.0
2006-05-09	AACC-DELISTED	Stock	19.99	20.0	19.07	19.15	296249.0
2006-05-09	AACQW-DELISTED	Stock	0.68	0.68	0.67	0.67	18500.0
2006-05-09	AAI-DELISTED	Stock	13.87	14.09	13.71	14.01	892000.0
2006-05-09	AAIC-DELISTED	Stock	215.2	220.6	214.6	220.4	1416900.0
2006-05-09	AAME	Stock	2.88	3.0	2.88	2.96	2600.0
2006-05-09	AAON	Stock	3.5687	3.6583	3.5187	3.52	317419.0
2006-05-09	AAP	Stock	41.7	42.3	40.53	40.69	2339200.0
2006-05-09	AATI-DELISTED	Stock	10.81	11.39	10.77	11.29	406433.0
2006-05-09	AAU-DELISTED	Stock	2.97	3.14	2.887	3.0	242167.0
2006-05-09	AAUAF-DELISTED	Stock	2.89	3.06	2.81	2.92	248800.0
2006-05-09	AAV-DELISTED	Stock	19.5	19.69	19.4	19.6	169300.0
2006-05-09	AAWW-DELISTED	Stock	50.5	50.75	49.95	50.75	52700.0
2006-05-09	AAXN-DELISTED	Stock	10.5600004196167	10.6400003433228	10.4700002670288	10.5100002288818	563300.0
2006-05-09	AB	Stock	69.57	70.47	69.4	69.79	233700.0
2006-05-09	ABAX-DELISTED	Stock	23.75	23.75	23.05	23.25	310232.0
2006-05-09	ABB-DELISTED	Stock	14.37	14.46	14.34	14.45	1293900.0
2006-05-09	ABBC-DELISTED	Stock	13.75	14.0	13.75	13.87	10100.0
2006-05-09	ABC-DELISTED	Stock	22.06	22.23	22.0	22.1	2160800.0
2006-05-09	ABCB	Stock	21.1355	21.3981	21.1355	21.1355	11926.0
2006-05-09	ABCO-DELISTED	Stock	26.66	27.49	26.66	27.46	235546.0
2006-05-09	ABCW-DELISTED	Stock	28.87	29.09	28.83	28.98	37040.0
2006-05-09	ABD-DELISTED	Stock	24.68	24.96	24.54	24.72	389110.0
2006-05-09	ABE-DELISTED	Stock	13.9	14.19	13.8401	14.13	60100.0
2006-05-09	ABFS-DELISTED	Stock	43.54	45.44	43.38	45.3	480861.0
2006-05-09	ABG	Stock	20.14	20.76	20.12	20.4	50400.0
2006-05-09	ABK-DELISTED	Stock	82.33	83.21	82.31	83.15	492200.0
2006-05-09	ABM	Stock	17.35	17.41	17.3	17.39	86500.0
2006-05-09	ABMD-DELISTED	Stock	13.59	13.77	12.9	12.95	220170.0
2006-05-09	ABP-DELISTED	Stock	5.64	5.73	5.36	5.54	666900.0
2006-05-09	ABR	Stock	24.82	24.94	24.7	24.75	150100.0
2006-05-09	ABT	Stock	20.2955	20.3675	20.1708	20.2716	5735932.0
2006-05-09	ABTL-DELISTED	Stock	21.7	21.9	21.3	21.3	21717.0
2006-05-09	ABV-DELISTED	Stock	48.5	48.77	47.93	48.63	695800.0
2006-05-09	ABVA-DELISTED	Stock	18.85	18.85	18.75	18.75	2337.0
2006-05-09	ABX-DELISTED	Stock	34.48	35.0	34.26	34.86	7291200.0
2006-05-09	ACAD	Stock	11.91	12.08	11.81	11.85	142800.0
2006-05-09	ACAP-DELISTED	Stock	46.02	46.16	45.35	45.5	67548.0
2006-05-09	ACAS-DELISTED	Stock	33.99	34.0	33.75	33.87	1281906.0
2006-05-09	ACAT-DELISTED	Stock	20.49	21.16	20.49	20.64	29046.0
2006-05-09	ACC-DELISTED	Stock	24.62	24.69	24.5	24.65	91800.0
2006-05-09	ACCL-DELISTED	Stock	7.03	7.14	6.9	6.91	59283.0
2006-05-09	ACCO	Stock	24.7	24.99	24.56	24.7	388900.0
2006-05-09	ACCP-DELISTED	Stock	1.4	1.4	1.35	1.35	12000.0

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

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