PREVIEW / stock_daily / 2009-09-28

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-28.parquet
  size:    185 KB
  rows:    5,818
  symbols: 3,466

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-09-28	AAPL	Stock	6.5668	6.6671	6.5475	6.6482	337444800.0
2009-09-28	MSFT	Stock	25.6	26.16	25.6	25.83	44358000.0
2009-09-28	NVDA	Stock	0.3638	0.38	0.3638	0.3708	467708000.0
2009-09-28	AMZN	Stock	4.552	4.6405	4.53	4.6105	70160000.0
2009-09-28	TLT	Stock	98.32	98.93	98.11	98.84	4264840.0
2009-09-28	ES	Stock	23.85	24.14	23.84	24.02	670000.0
2009-09-28	CL	Stock	38.435	38.54	38.15	38.19	3635800.0
2009-09-28	A	Stock	19.8069	20.1931	19.6638	19.9499	2935940.0
2009-09-28	AABA-DELISTED	Stock	17.01	17.47	16.95	17.45	25652009.0
2009-09-28	AACC-DELISTED	Stock	7.69	8.09	7.48	8.07	26031.0
2009-09-28	AACG	Stock	5.88	5.93	5.7	5.73	9600.0
2009-09-28	AAI-DELISTED	Stock	6.42	6.53	6.32	6.34	1288482.0
2009-09-28	AAIC-DELISTED	Stock	10.4	10.6	10.0	10.186	461857.0
2009-09-28	AAME	Stock	0.95	1.0	0.95	1.0	28000.0
2009-09-28	AAON	Stock	4.0277	4.1185	4.0277	4.0612	361969.0
2009-09-28	AAP	Stock	39.41	39.86	39.18	39.39	1562000.0
2009-09-28	AATI-DELISTED	Stock	4.06	4.14	4.06	4.1	177041.0
2009-09-28	AAU-DELISTED	Stock	0.67	0.68	0.6598	0.6603	62527.0
2009-09-28	AAUAF-DELISTED	Stock	0.67	0.68	0.66	0.6605	67553.0
2009-09-28	AAV-DELISTED	Stock	6.48	6.78	6.37	6.73	738040.0
2009-09-28	AAWW-DELISTED	Stock	32.48	33.01	31.94	32.19	223980.0
2009-09-28	AAXJ	Stock	51.59	52.17	51.38	51.76	82809.0
2009-09-28	AAXN-DELISTED	Stock	4.48	4.64	4.48	4.59	285496.0
2009-09-28	AB	Stock	25.52	26.67	25.52	26.64	368500.0
2009-09-28	ABAX-DELISTED	Stock	27.05	27.94	27.01	27.49	76831.0
2009-09-28	ABB-DELISTED	Stock	19.98	20.375	19.95	20.2	1603802.0
2009-09-28	ABBC-DELISTED	Stock	7.86	8.08	7.69	8.01	49552.0
2009-09-28	ABBNY-DELISTED	Stock	19.98	20.375	19.95	20.21	1673018.0
2009-09-28	ABC-DELISTED	Stock	21.54	22.03	21.51	21.75	2697951.0
2009-09-28	ABCB	Stock	6.9589	7.2235	6.8903	6.9099	26935.0
2009-09-28	ABCO-DELISTED	Stock	12.917	12.917	12.598	12.653	209020.0
2009-09-28	ABCW-DELISTED	Stock	1.3912	1.3912	1.3087	1.31	41020.0
2009-09-28	ABD-DELISTED	Stock	7.18	7.41	7.12	7.25	330980.0
2009-09-28	ABE-DELISTED	Stock	16.73	17.48	16.73	17.48	25693.0
2009-09-28	ABEO	Stock	3500.0	3500.0	3312.5	3437.5	26.0
2009-09-28	ABFS-DELISTED	Stock	30.15	30.7	30.04	30.37	303003.0
2009-09-28	ABG	Stock	12.84	13.32	12.84	13.13	331400.0
2009-09-28	ABII-DELISTED	Stock	34.9	35.95	32.72	35.3	112595.0
2009-09-28	ABK-DELISTED	Stock	1.76	1.84	1.73	1.81	13075435.0
2009-09-28	ABM	Stock	20.3	21.34	20.3	21.11	331700.0
2009-09-28	ABMD-DELISTED	Stock	9.37	10.03	9.3545	9.99	317219.0
2009-09-28	ABR	Stock	2.8	3.06	2.8	2.96	237300.0
2009-09-28	ABT	Stock	23.5822	23.8413	23.2655	23.3087	38624844.0
2009-09-28	ABTL-DELISTED	Stock	2.9977	3.1509	2.9972	3.0523	5408.0
2009-09-28	ABV-DELISTED	Stock	79.78	80.43	79.41	80.34	317368.0
2009-09-28	ABVA-DELISTED	Stock	2.34	2.34	2.34	2.34	250.0
2009-09-28	ABVT-DELISTED	Stock	48.89	49.68	48.66	48.92	119454.0
2009-09-28	ABX-DELISTED	Stock	36.44	37.29	36.27	36.33	8506789.0
2009-09-28	ACAD	Stock	1.75	1.89	1.7	1.8	1405200.0
2009-09-28	ACAP-DELISTED	Stock	30.08	30.14	29.49	29.53	50693.0

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

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