PREVIEW / stock_daily / 2009-06-23

all stock daily files

  file:    by_date/stock_daily/2009/2009-06-23.parquet
  size:    180 KB
  rows:    5,761
  symbols: 3,438

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
2009-06-23	AAPL	Stock	4.8714	4.8911	4.7457	4.7861	706532400.0
2009-06-23	MSFT	Stock	23.38	23.66	23.21	23.34	56752700.0
2009-06-23	NVDA	Stock	0.2663	0.2668	0.2523	0.2625	589764000.0
2009-06-23	AMZN	Stock	3.9485	3.955	3.8125	3.884	148310000.0
2009-06-23	TLT	Stock	92.77	93.81	92.58	93.67	5359875.0
2009-06-23	ES	Stock	22.04	22.06	21.52	21.56	2424200.0
2009-06-23	CL	Stock	35.295	35.4	34.94	35.18	4324400.0
2009-06-23	A	Stock	13.226	13.3691	13.133	13.269	3580138.0
2009-06-23	AABA-DELISTED	Stock	14.76	14.9	14.55	14.69	15744231.0
2009-06-23	AACC-DELISTED	Stock	8.42	8.53	8.1612	8.26	86649.0
2009-06-23	AACG	Stock	9.25	9.59	8.67	9.5	62000.0
2009-06-23	AAI-DELISTED	Stock	5.5	5.55	5.2399	5.29	3204531.0
2009-06-23	AAIC-DELISTED	Stock	7.4	8.4	7.2	8.4	964848.0
2009-06-23	AAME	Stock	0.72	0.87	0.72	0.87	4600.0
2009-06-23	AAON	Stock	3.7195	3.7511	3.6662	3.68	268312.0
2009-06-23	AAP	Stock	42.27	42.42	41.74	41.86	1357200.0
2009-06-23	AATI-DELISTED	Stock	4.52	4.52	4.34	4.35	228035.0
2009-06-23	AAU-DELISTED	Stock	0.62	0.64	0.6	0.6	100800.0
2009-06-23	AAUAF-DELISTED	Stock	0.62	0.64	0.6	0.6	101400.0
2009-06-23	AAV-DELISTED	Stock	4.46	4.49	4.16	4.37	1245776.0
2009-06-23	AAWW-DELISTED	Stock	22.16	22.49	20.85	21.05	389580.0
2009-06-23	AAXJ	Stock	42.04	42.42	41.46	42.09	211945.0
2009-06-23	AAXN-DELISTED	Stock	4.48	4.49	4.38	4.415	276738.0
2009-06-23	AB	Stock	18.85	19.49	18.67	19.18	339900.0
2009-06-23	ABAX-DELISTED	Stock	19.24	19.32	18.92	18.96	162793.0
2009-06-23	ABB-DELISTED	Stock	15.06	15.24	14.84	15.128	3599236.0
2009-06-23	ABBC-DELISTED	Stock	8.37	8.46	8.16	8.38	61788.0
2009-06-23	ABBNY-DELISTED	Stock	15.06	15.24	14.84	15.14	3638358.0
2009-06-23	ABC-DELISTED	Stock	18.01	18.15	17.65	17.67	4037921.0
2009-06-23	ABCB	Stock	5.8845	6.0498	5.7483	5.8262	13057.0
2009-06-23	ABCO-DELISTED	Stock	12.812	13.087	12.683	12.812	92766.0
2009-06-23	ABCW-DELISTED	Stock	0.92	1.48	0.91	1.41	546320.0
2009-06-23	ABD-DELISTED	Stock	2.85	3.14	2.71	2.89	239270.0
2009-06-23	ABE-DELISTED	Stock	14.16	14.31	14.0	14.2	17939.0
2009-06-23	ABEO	Stock	2800.0	2800.0	2725.0	2737.5	3.0
2009-06-23	ABFS-DELISTED	Stock	28.22	28.43	27.03	27.15	722993.0
2009-06-23	ABG	Stock	9.93	10.02	9.4	9.89	353600.0
2009-06-23	ABII-DELISTED	Stock	37.68	37.68	36.0001	37.4	33703.0
2009-06-23	ABK-DELISTED	Stock	1.06	1.12	1.02	1.11	6235468.0
2009-06-23	ABM	Stock	17.06	17.07	16.67	16.83	265800.0
2009-06-23	ABMD-DELISTED	Stock	8.27	8.39	8.0	8.205	261250.0
2009-06-23	ABR	Stock	1.77	1.88	1.77	1.8	138100.0
2009-06-23	ABT	Stock	22.5026	22.6466	22.2147	22.4834	13477491.0
2009-06-23	ABTL-DELISTED	Stock	2.2489	2.3256	1.9933	2.3	40814.0
2009-06-23	ABV-DELISTED	Stock	62.91	63.53	62.1	63.2	493678.0
2009-06-23	ABVT-DELISTED	Stock	76.86	78.24	75.62	76.33	53987.0
2009-06-23	ABX-DELISTED	Stock	32.16	33.27	31.59	33.22	7502551.0
2009-06-23	ACAD	Stock	1.97	2.03	1.9	1.94	146000.0
2009-06-23	ACAP-DELISTED	Stock	39.54	39.73	38.94	38.94	28541.0
2009-06-23	ACAS-DELISTED	Stock	2.9	2.91	2.5	2.63	5560344.0

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

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