PREVIEW / stock_daily / 2006-01-17

all stock daily files

  file:    by_date/stock_daily/2006/2006-01-17.parquet
  size:    145 KB
  rows:    4,351
  symbols: 2,764

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-01-17	AAPL	Stock	3.0607	3.085	2.9954	3.0254	835623600.0
2006-01-17	MSFT	Stock	26.9	27.19	26.9	26.99	58566600.0
2006-01-17	NVDA	Stock	0.3494	0.3542	0.3447	0.354	329232000.0
2006-01-17	AMZN	Stock	2.1975	2.216	2.183	2.2	112620000.0
2006-01-17	CL	Stock	27.36	27.43	27.205	27.245	2697200.0
2006-01-17	A	Stock	24.0844	24.1488	23.8197	24.1488	3496678.0
2006-01-17	AABA-DELISTED	Stock	39.0900001525879	40.3899993896484	38.9599990844727	40.1100006103516	41797000.0
2006-01-17	AACC-DELISTED	Stock	22.62	22.98	22.62	22.81	73578.0
2006-01-17	AACQW-DELISTED	Stock	0.59	0.6	0.59	0.6	58000.0
2006-01-17	AAI-DELISTED	Stock	14.5	14.66	13.83	13.84	3069100.0
2006-01-17	AAIC-DELISTED	Stock	218.2	218.6	214.0	214.4	999300.0
2006-01-17	AAME	Stock	2.66	2.66	2.66	2.66	800.0
2006-01-17	AAON	Stock	2.398	2.4191	2.3019	2.4033	78975.0
2006-01-17	AAP	Stock	44.37	44.47	43.14	43.51	1120900.0
2006-01-17	AATI-DELISTED	Stock	14.06	14.19	13.75	14.1	118494.0
2006-01-17	AAU-DELISTED	Stock	2.66	2.69	2.54	2.61	99000.0
2006-01-17	AAUAF-DELISTED	Stock	2.66	2.69	2.54	2.61	99000.0
2006-01-17	AAV-DELISTED	Stock	18.64	19.04	18.51	18.94	296800.0
2006-01-17	AAWW-DELISTED	Stock	45.0	45.0	44.5	45.0	20600.0
2006-01-17	AAXN-DELISTED	Stock	8.72999954223633	8.78999996185303	8.27999973297119	8.30000019073486	2304300.0
2006-01-17	ABAX-DELISTED	Stock	17.69	17.88	17.66	17.81	95239.0
2006-01-17	ABB-DELISTED	Stock	10.87	10.9	10.79	10.87	1506500.0
2006-01-17	ABBC-DELISTED	Stock	13.19	13.22	13.16	13.2	1532.0
2006-01-17	ABC-DELISTED	Stock	20.71	20.71	20.36	20.48	2075400.0
2006-01-17	ABCB	Stock	19.7738	19.9391	19.6571	19.9294	4318.0
2006-01-17	ABCO-DELISTED	Stock	23.15	23.25	23.07	23.18	432664.0
2006-01-17	ABCW-DELISTED	Stock	31.49	31.77	31.4	31.53	44660.0
2006-01-17	ABD-DELISTED	Stock	24.83	25.07	24.71	24.87	394540.0
2006-01-17	ABE-DELISTED	Stock	12.78	12.78	12.6	12.66	36800.0
2006-01-17	ABFS-DELISTED	Stock	45.1	45.74	44.52	44.84	310305.0
2006-01-17	ABG	Stock	16.76	16.76	16.05	16.38	46500.0
2006-01-17	ABK-DELISTED	Stock	77.76	78.3	77.34	77.55	229200.0
2006-01-17	ABM	Stock	19.7	19.7	19.5	19.5	137600.0
2006-01-17	ABMD-DELISTED	Stock	10.17	10.18	9.87	9.9	51274.0
2006-01-17	ABP-DELISTED	Stock	5.45	6.29	5.45	6.24	1376200.0
2006-01-17	ABR	Stock	27.1	27.42	26.12	26.65	180300.0
2006-01-17	ABT	Stock	19.5854	19.8205	19.5566	19.7054	7905169.0
2006-01-17	ABTL-DELISTED	Stock	24.8	25.25	24.65	25.25	36937.0
2006-01-17	ABV-DELISTED	Stock	41.2	41.26	39.55	40.48	650200.0
2006-01-17	ABVA-DELISTED	Stock	16.25	16.568	16.25	16.56	2003.0
2006-01-17	ABX-DELISTED	Stock	29.95	30.23	29.61	29.84	5733300.0
2006-01-17	ACAD	Stock	11.0	11.01	10.5	10.74	68700.0
2006-01-17	ACAP-DELISTED	Stock	47.65	48.2	47.15	47.47	30337.0
2006-01-17	ACAS-DELISTED	Stock	35.55	35.63	35.32	35.39	768627.0
2006-01-17	ACAT-DELISTED	Stock	22.26	22.4	22.06	22.16	80506.0
2006-01-17	ACC-DELISTED	Stock	24.9	25.02	24.61	24.8	67700.0
2006-01-17	ACCL-DELISTED	Stock	7.0	7.248	6.93	6.96	93218.0
2006-01-17	ACCO	Stock	24.85	25.09	24.73	24.85	398100.0
2006-01-17	ACE-DELISTED	Stock	54.9	54.98	54.21	54.86	1023100.0
2006-01-17	ACF-DELISTED	Stock	27.0	27.33	26.88	27.28	965400.0

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

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