PREVIEW / stock_daily / 2009-10-13

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-13.parquet
  size:    187 KB
  rows:    5,849
  symbols: 3,485

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-10-13	AAPL	Stock	6.8082	6.8275	6.775	6.7864	348020400.0
2009-10-13	MSFT	Stock	25.59	25.94	25.52	25.81	37749000.0
2009-10-13	NVDA	Stock	0.3522	0.3562	0.3458	0.349	602124000.0
2009-10-13	AMZN	Stock	4.6915	4.7625	4.684	4.7415	94400000.0
2009-10-13	TLT	Stock	96.62	96.85	96.26	96.55	2886494.0
2009-10-13	ES	Stock	23.48	23.5	23.2	23.28	1169800.0
2009-10-13	CL	Stock	39.75	39.75	39.14	39.33	4809600.0
2009-10-13	A	Stock	19.6066	19.6924	19.4206	19.5207	1988935.0
2009-10-13	AABA-DELISTED	Stock	16.95	17.0	16.81	16.89	19315319.0
2009-10-13	AACC-DELISTED	Stock	7.27	7.27	6.95	7.12	23594.0
2009-10-13	AACG	Stock	5.91	5.96	5.9	5.96	13200.0
2009-10-13	AAI-DELISTED	Stock	5.04	5.12	4.95	5.09	7029617.0
2009-10-13	AAIC-DELISTED	Stock	11.6	11.8	11.09	11.8	33164.0
2009-10-13	AAME	Stock	1.33	1.33	1.2	1.26	111900.0
2009-10-13	AAON	Stock	3.7017	3.7017	3.5852	3.6227	332100.0
2009-10-13	AAP	Stock	37.94	38.38	37.94	38.14	850400.0
2009-10-13	AATI-DELISTED	Stock	3.09	3.15	3.09	3.15	964785.0
2009-10-13	AAU-DELISTED	Stock	0.8	0.83	0.78	0.79	299537.0
2009-10-13	AAUAF-DELISTED	Stock	0.8	0.83	0.78	0.79	304937.0
2009-10-13	AAV-DELISTED	Stock	7.18	7.36	7.16	7.22	1072506.0
2009-10-13	AAWW-DELISTED	Stock	34.25	35.15	34.052	35.0	229073.0
2009-10-13	AAXJ	Stock	53.27	53.53	52.98	53.53	360896.0
2009-10-13	AAXN-DELISTED	Stock	4.54	4.61	4.538	4.61	332288.0
2009-10-13	AB	Stock	28.4	28.49	27.88	28.0	743200.0
2009-10-13	ABAX-DELISTED	Stock	24.35	24.86	23.86	24.22	650771.0
2009-10-13	ABB-DELISTED	Stock	21.11	21.13	20.76	20.9	1977300.0
2009-10-13	ABBC-DELISTED	Stock	7.78	7.83	7.72	7.8	32273.0
2009-10-13	ABBNY-DELISTED	Stock	21.11	21.13	20.76	20.92	1977500.0
2009-10-13	ABC-DELISTED	Stock	22.69	22.76	22.53	22.64	2799505.0
2009-10-13	ABCB	Stock	6.6942	6.6942	6.5178	6.5668	12549.0
2009-10-13	ABCO-DELISTED	Stock	13.022	13.092	12.825	13.018	72683.0
2009-10-13	ABCW-DELISTED	Stock	1.25	1.26	1.08	1.21	226890.0
2009-10-13	ABD-DELISTED	Stock	7.59	7.66	7.203	7.34	286730.0
2009-10-13	ABE-DELISTED	Stock	17.5	17.6674	17.4301	17.58	5519.0
2009-10-13	ABEO	Stock	4375.0	4375.0	4250.0	4312.5	42.0
2009-10-13	ABFS-DELISTED	Stock	29.85	30.0	29.22	29.43	398780.0
2009-10-13	ABG	Stock	13.19	13.29	12.58	13.22	191700.0
2009-10-13	ABII-DELISTED	Stock	38.06	38.35	36.5	37.7	43798.0
2009-10-13	ABK-DELISTED	Stock	1.47	1.51	1.4	1.46	8765074.0
2009-10-13	ABM	Stock	20.59	20.59	19.92	20.07	122700.0
2009-10-13	ABMD-DELISTED	Stock	10.61	10.75	10.42	10.71	168076.0
2009-10-13	ABR	Stock	2.7	2.7	2.51	2.69	295700.0
2009-10-13	ABT	Stock	23.8796	23.9708	23.6637	23.8221	16954773.0
2009-10-13	ABTL-DELISTED	Stock	3.1	3.25	3.1	3.15	7600.0
2009-10-13	ABV-DELISTED	Stock	92.64	93.09	90.48	92.33	468708.0
2009-10-13	ABVA-DELISTED	Stock	2.75	2.75	2.2001	2.57	1590.0
2009-10-13	ABVT-DELISTED	Stock	49.97	50.0	49.72	49.87	122741.0
2009-10-13	ABX-DELISTED	Stock	39.63	40.34	38.88	39.88	16201056.0
2009-10-13	ACAD	Stock	1.77	1.8	1.74	1.8	411900.0
2009-10-13	ACAP-DELISTED	Stock	29.905	29.905	29.44	29.78	66496.0

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

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