PREVIEW / stock_daily / 2008-01-23

all stock daily files

  file:    by_date/stock_daily/2008/2008-01-23.parquet
  size:    181 KB
  rows:    5,687
  symbols: 3,446

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
2008-01-23	AAPL	Stock	4.8639	5.0	4.505	4.9668	3372969600.0
2008-01-23	MSFT	Stock	31.48	32.05	31.04	31.93	137597400.0
2008-01-23	NVDA	Stock	0.566	0.6185	0.5605	0.6008	929880000.0
2008-01-23	AMZN	Stock	3.78	3.84	3.4975	3.6985	408114000.0
2008-01-23	TLT	Stock	97.98	98.16	95.88	96.29	7636565.0
2008-01-23	CL	Stock	36.61	37.76	36.505	37.69	10327000.0
2008-01-23	A	Stock	22.6681	24.0057	22.4964	23.9127	6727595.0
2008-01-23	AABA-DELISTED	Stock	19.22	20.34	18.72	20.01	42124552.0
2008-01-23	AACC-DELISTED	Stock	8.02	9.25	8.02	9.1	265642.0
2008-01-23	AAI-DELISTED	Stock	7.14	8.18	7.14	8.0	2480509.0
2008-01-23	AAIC-DELISTED	Stock	63.8	67.4	60.7	63.8	3725325.0
2008-01-23	AAME	Stock	1.35	1.5	1.3	1.48	6100.0
2008-01-23	AAON	Stock	3.2494	3.597	3.1881	3.5259	486506.0
2008-01-23	AAP	Stock	31.46	34.02	31.46	33.6	1964300.0
2008-01-23	AATI-DELISTED	Stock	7.8	8.01	7.51	8.0	571602.0
2008-01-23	AAU-DELISTED	Stock	2.31	2.35	2.22	2.29	118800.0
2008-01-23	AAUAF-DELISTED	Stock	2.3	2.3399	2.22	2.3	119450.0
2008-01-23	AAV-DELISTED	Stock	8.68	8.88	8.45	8.62	963560.0
2008-01-23	AAWW-DELISTED	Stock	49.13	50.0	48.8	50.0	198005.0
2008-01-23	AAXN-DELISTED	Stock	8.74	9.14	8.16	9.14	3310805.0
2008-01-23	AB	Stock	60.73	63.95	58.8	63.68	889200.0
2008-01-23	ABAX-DELISTED	Stock	34.5	35.69	33.55	35.35	485261.0
2008-01-23	ABB-DELISTED	Stock	22.07	23.95	21.69	23.91	8006661.0
2008-01-23	ABBC-DELISTED	Stock	8.51	9.25	8.51	9.24	67749.0
2008-01-23	ABBNY-DELISTED	Stock	22.07	23.96	21.69	23.91	8007161.0
2008-01-23	ABC-DELISTED	Stock	22.5	22.92	21.62	22.89	3712030.0
2008-01-23	ABCB	Stock	12.9556	14.9592	12.6444	14.9009	76493.0
2008-01-23	ABCO-DELISTED	Stock	30.49	31.69	30.49	31.39	502458.0
2008-01-23	ABCW-DELISTED	Stock	20.96	23.81	20.96	23.81	144700.0
2008-01-23	ABD-DELISTED	Stock	13.1	14.29	12.88	14.11	1034770.0
2008-01-23	ABE-DELISTED	Stock	19.51	22.29	19.51	22.094	102486.0
2008-01-23	ABEO	Stock	2937.5	3625.0	2937.5	3625.0	7.0
2008-01-23	ABFS-DELISTED	Stock	20.18	24.6	20.04	24.21	1240055.0
2008-01-23	ABG	Stock	12.37	14.15	12.36	13.72	1245400.0
2008-01-23	ABII-DELISTED	Stock	61.02	61.49	57.02	61.01	11488.0
2008-01-23	ABK-DELISTED	Stock	7.96	14.79	7.8	14.27	27098421.0
2008-01-23	ABM	Stock	18.8	19.69	18.5	19.61	554300.0
2008-01-23	ABMD-DELISTED	Stock	12.88	13.34	12.43	13.33	241908.0
2008-01-23	ABP-DELISTED	Stock	3.5	3.51	3.15	3.32	289468.0
2008-01-23	ABR	Stock	14.46	16.84	14.46	16.8	413800.0
2008-01-23	ABT	Stock	27.4686	27.9052	26.2307	27.814	27695498.0
2008-01-23	ABTL-DELISTED	Stock	12.205	12.205	11.6	11.6	24372.0
2008-01-23	ABV-DELISTED	Stock	64.97	68.38	63.99	68.07	1195100.0
2008-01-23	ABVA-DELISTED	Stock	6.34	6.34	6.18	6.23	1000.0
2008-01-23	ABVT-DELISTED	Stock	78.0	80.0	76.0	80.0	2353.0
2008-01-23	ABX-DELISTED	Stock	48.53	50.39	46.99	48.32	19517356.0
2008-01-23	ACAD	Stock	11.06	11.59	10.63	11.52	317800.0
2008-01-23	ACAP-DELISTED	Stock	37.43	40.09	37.1	39.8	78733.0
2008-01-23	ACAS-DELISTED	Stock	27.62	31.13	27.18	30.87	5012230.0
2008-01-23	ACAT-DELISTED	Stock	7.18	7.95	7.18	7.86	213603.0

> showing 50 of 5,687 rows — these rows as CSV

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