PREVIEW / stock_daily / 2008-09-18

all stock daily files

  file:    by_date/stock_daily/2008/2008-09-18.parquet
  size:    185 KB
  rows:    5,805
  symbols: 3,506

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-09-18	AAPL	Stock	4.6632	4.8368	4.31	4.7889	1676253600.0
2008-09-18	MSFT	Stock	24.8	25.35	24.01	25.26	132291300.0
2008-09-18	NVDA	Stock	0.253	0.2855	0.2525	0.2723	1611060000.0
2008-09-18	AMZN	Stock	3.654	3.875	3.504	3.825	247944000.0
2008-09-18	TLT	Stock	97.95	98.49	96.92	97.05	4188273.0
2008-09-18	CL	Stock	38.32	38.82	37.27	38.44	12411600.0
2008-09-18	A	Stock	21.4592	22.4964	21.03	22.4392	5227402.0
2008-09-18	AABA-DELISTED	Stock	18.9	20.8	18.49	20.77	31594164.0
2008-09-18	AACC-DELISTED	Stock	10.36	11.69	10.29	11.6	476977.0
2008-09-18	AACG	Stock	9.8	9.85	9.75	9.85	11200.0
2008-09-18	AAI-DELISTED	Stock	2.6	2.94	2.5	2.63	3878447.0
2008-09-18	AAIC-DELISTED	Stock	31.2	39.6	26.4	39.6	1423998.0
2008-09-18	AAME	Stock	1.3	1.33	1.29	1.29	1700.0
2008-09-18	AAON	Stock	3.6958	3.8696	3.5556	3.8163	1143619.0
2008-09-18	AAP	Stock	41.2	41.37	37.51	38.28	3411600.0
2008-09-18	AATI-DELISTED	Stock	4.39	4.8	4.26	4.69	762241.0
2008-09-18	AAU-DELISTED	Stock	1.3	1.4	1.2	1.21	177862.0
2008-09-18	AAUAF-DELISTED	Stock	1.3	1.4	1.2	1.21	187482.0
2008-09-18	AAV-DELISTED	Stock	9.25	9.65	9.01	9.31	790443.0
2008-09-18	AAWW-DELISTED	Stock	46.93	50.41	45.01	49.02	421741.0
2008-09-18	AAXJ	Stock	41.41	43.16	41.0168	43.14	4420.0
2008-09-18	AAXN-DELISTED	Stock	6.13	7.06	6.13	7.02	2237470.0
2008-09-18	AB	Stock	33.01	39.93	32.15	38.7	2922700.0
2008-09-18	ABAX-DELISTED	Stock	19.38	21.2	18.32	20.91	735012.0
2008-09-18	ABB-DELISTED	Stock	20.06	20.41	19.16	20.25	11246524.0
2008-09-18	ABBC-DELISTED	Stock	10.12	10.32	9.91	10.32	264142.0
2008-09-18	ABBNY-DELISTED	Stock	20.06	20.41	19.16	20.2	11315327.0
2008-09-18	ABC-DELISTED	Stock	18.94	19.86	18.59	19.62	7227088.0
2008-09-18	ABCB	Stock	10.6601	13.7045	10.5532	13.6656	139517.0
2008-09-18	ABCO-DELISTED	Stock	15.42	15.905	15.205	15.325	778328.0
2008-09-18	ABCW-DELISTED	Stock	8.02	9.79	8.0	9.27	519160.0
2008-09-18	ABD-DELISTED	Stock	8.93	9.751	8.87	9.16	875990.0
2008-09-18	ABE-DELISTED	Stock	14.51	15.02	13.6	15.02	117392.0
2008-09-18	ABEO	Stock	3625.0	3937.5	3625.0	3750.0	65.0
2008-09-18	ABFS-DELISTED	Stock	37.47	39.91	36.94	39.81	1780083.0
2008-09-18	ABG	Stock	12.32	13.21	11.98	13.0	782400.0
2008-09-18	ABII-DELISTED	Stock	71.51	73.0	68.035	72.99	48575.0
2008-09-18	ABK-DELISTED	Stock	6.08	6.58	5.19	6.53	49306633.0
2008-09-18	ABM	Stock	21.03	22.18	20.33	21.92	778200.0
2008-09-18	ABMD-DELISTED	Stock	17.68	18.03	17.27	17.93	778561.0
2008-09-18	ABR	Stock	7.57	10.2	7.57	10.2	507900.0
2008-09-18	ABT	Stock	27.7084	28.3322	27.1807	27.8668	21911630.0
2008-09-18	ABTL-DELISTED	Stock	4.75	5.15	4.05	4.65	53231.0
2008-09-18	ABV-DELISTED	Stock	52.07	52.36	47.91	51.79	1190946.0
2008-09-18	ABVA-DELISTED	Stock	3.18	3.24	3.046	3.15	1878.0
2008-09-18	ABVT-DELISTED	Stock	51.0	54.03	51.0	54.03	1046.0
2008-09-18	ABX-DELISTED	Stock	34.14	35.73	29.85	31.65	42900667.0
2008-09-18	ACAD	Stock	2.6	3.0	2.37	2.96	390600.0
2008-09-18	ACAP-DELISTED	Stock	42.78	46.99	41.13	46.61	111789.0
2008-09-18	ACAS-DELISTED	Stock	19.0	24.22	18.39	24.08	9172491.0

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

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