PREVIEW / stock_daily / 2009-12-07

all stock daily files

  file:    by_date/stock_daily/2009/2009-12-07.parquet
  size:    187 KB
  rows:    5,882
  symbols: 3,489

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-12-07	AAPL	Stock	6.9043	6.9204	6.7386	6.7482	714758800.0
2009-12-07	MSFT	Stock	29.78	30.08	29.68	29.79	38082700.0
2009-12-07	NVDA	Stock	0.3962	0.4112	0.3775	0.4022	2732184000.0
2009-12-07	AMZN	Stock	6.9	6.95	6.692	6.7105	156740000.0
2009-12-07	TLT	Stock	93.27	93.74	93.09	93.46	2774138.0
2009-12-07	ES	Stock	24.59	24.91	24.59	24.7	1301400.0
2009-12-07	CL	Stock	42.095	42.29	41.08	41.49	8540800.0
2009-12-07	A	Stock	21.2303	21.4521	21.216	21.3734	4039521.0
2009-12-07	AABA-DELISTED	Stock	15.35	15.65	15.32	15.45	16991509.0
2009-12-07	AACC-DELISTED	Stock	6.01	6.18	6.01	6.16	53223.0
2009-12-07	AACG	Stock	4.99	5.0	4.99	5.0	700.0
2009-12-07	AAI-DELISTED	Stock	5.24	5.25	4.94	5.07	4871163.0
2009-12-07	AAIC-DELISTED	Stock	13.8	14.95	13.8	14.76	91918.0
2009-12-07	AAON	Stock	3.8143	3.8281	3.763	3.7788	250594.0
2009-12-07	AAP	Stock	39.83	40.9	39.26	40.75	2056900.0
2009-12-07	AATI-DELISTED	Stock	3.59	3.72	3.44	3.7	610425.0
2009-12-07	AAU-DELISTED	Stock	1.06	1.12	0.99	1.088	474452.0
2009-12-07	AAUAF-DELISTED	Stock	1.06	1.12	0.99	1.088	475112.0
2009-12-07	AAV-DELISTED	Stock	5.63	5.71	5.53	5.61	490460.0
2009-12-07	AAWW-DELISTED	Stock	33.74	34.59	33.44	34.13	258102.0
2009-12-07	AAXJ	Stock	56.38	56.386	55.93	56.19	74925.0
2009-12-07	AAXN-DELISTED	Stock	4.39	4.49	4.27	4.34	464292.0
2009-12-07	AB	Stock	26.89	27.0	26.46	26.73	455900.0
2009-12-07	ABAX-DELISTED	Stock	23.53	24.0	23.53	23.98	53739.0
2009-12-07	ABB-DELISTED	Stock	18.26	18.43	18.22	18.24	3808033.0
2009-12-07	ABBC-DELISTED	Stock	6.97	7.04	6.81	7.0	15314.0
2009-12-07	ABBNY-DELISTED	Stock	18.26	18.43	18.22	18.25	3830003.0
2009-12-07	ABC-DELISTED	Stock	24.61	24.88	24.54	24.64	2929849.0
2009-12-07	ABCB	Stock	6.8511	6.8511	6.6942	6.7825	18467.0
2009-12-07	ABCO-DELISTED	Stock	13.313	13.373	13.107	13.137	100266.0
2009-12-07	ABCW-DELISTED	Stock	0.6895	0.7195	0.6601	0.6905	185490.0
2009-12-07	ABD-DELISTED	Stock	6.91	7.1	6.86	7.02	177290.0
2009-12-07	ABE-DELISTED	Stock	16.89	16.97	16.83	16.85	6247.0
2009-12-07	ABEO	Stock	3475.0	3687.5	3475.0	3662.5	22.0
2009-12-07	ABFS-DELISTED	Stock	27.23	27.595	27.02	27.08	154219.0
2009-12-07	ABG	Stock	11.48	12.07	11.32	11.9	444300.0
2009-12-07	ABII-DELISTED	Stock	36.34	37.52	36.34	36.85	24811.0
2009-12-07	ABK-DELISTED	Stock	0.8697	0.8697	0.83	0.83	6528289.0
2009-12-07	ABM	Stock	19.66	21.35	19.65	20.85	578500.0
2009-12-07	ABMD-DELISTED	Stock	8.99	9.22	8.99	9.21	130504.0
2009-12-07	ABR	Stock	1.73	1.77	1.72	1.72	74000.0
2009-12-07	ABT	Stock	25.8324	26.0292	25.7269	25.7461	11116507.0
2009-12-07	ABTL-DELISTED	Stock	4.9	5.35	4.85	5.25	16312.0
2009-12-07	ABV-DELISTED	Stock	98.8	100.4791	98.32	99.4	552348.0
2009-12-07	ABVA-DELISTED	Stock	2.69	2.7	2.3	2.6	1419.0
2009-12-07	ABVT-DELISTED	Stock	55.74	57.79	55.3799	57.73	165005.0
2009-12-07	ABX-DELISTED	Stock	41.66	42.94	40.91	42.43	22759412.0
2009-12-07	ACAD	Stock	1.2	1.25	1.18	1.21	296200.0
2009-12-07	ACAP-DELISTED	Stock	28.32	28.59	27.99	28.17	49616.0
2009-12-07	ACAS-DELISTED	Stock	2.98	3.07	2.97	3.02	3490719.0

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

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