PREVIEW / stock_daily / 2009-09-14

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-14.parquet
  size:    184 KB
  rows:    5,797
  symbols: 3,441

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-14	AAPL	Stock	6.1011	6.2107	6.0804	6.2043	322011200.0
2009-09-14	MSFT	Stock	24.65	25.09	24.64	25.0	42806800.0
2009-09-14	NVDA	Stock	0.402	0.4053	0.3978	0.4013	490516000.0
2009-09-14	AMZN	Stock	4.1905	4.2285	4.173	4.193	71440000.0
2009-09-14	TLT	Stock	96.02	96.6695	95.65	95.74	2119468.0
2009-09-14	ES	Stock	23.63	24.02	23.61	24.01	761500.0
2009-09-14	CL	Stock	37.285	37.735	37.2	37.525	7033800.0
2009-09-14	A	Stock	19.9285	20.1574	19.7711	20.1001	4913131.0
2009-09-14	AABA-DELISTED	Stock	15.45	15.58	15.28	15.56	18980690.0
2009-09-14	AACC-DELISTED	Stock	7.39	7.66	7.36	7.65	22804.0
2009-09-14	AACG	Stock	6.48	6.77	6.46	6.52	2700.0
2009-09-14	AAI-DELISTED	Stock	6.47	6.59	6.3	6.53	2191686.0
2009-09-14	AAIC-DELISTED	Stock	9.8	9.8	9.2	9.6	469217.0
2009-09-14	AAME	Stock	0.71	0.72	0.71	0.72	2000.0
2009-09-14	AAON	Stock	3.996	4.0217	3.9842	4.0119	256162.0
2009-09-14	AAP	Stock	38.92	39.87	38.32	39.67	3092100.0
2009-09-14	AATI-DELISTED	Stock	4.52	4.54	4.45	4.51	337027.0
2009-09-14	AAU-DELISTED	Stock	0.6601	0.7	0.6601	0.67	49635.0
2009-09-14	AAUAF-DELISTED	Stock	0.6601	0.7	0.6601	0.67	51010.0
2009-09-14	AAV-DELISTED	Stock	6.2	6.41	6.1	6.39	1107267.0
2009-09-14	AAWW-DELISTED	Stock	28.95	29.78	28.145	29.53	428627.0
2009-09-14	AAXJ	Stock	51.33	51.77	51.02	51.7	648685.0
2009-09-14	AAXN-DELISTED	Stock	4.62	4.97	4.6105	4.86	1006765.0
2009-09-14	AB	Stock	23.91	24.91	23.76	24.83	475500.0
2009-09-14	ABAX-DELISTED	Stock	27.47	27.89	27.38	27.63	75662.0
2009-09-14	ABB-DELISTED	Stock	20.25	20.54	20.22	20.48	2259275.0
2009-09-14	ABBC-DELISTED	Stock	7.67	7.95	7.67	7.83	39633.0
2009-09-14	ABBNY-DELISTED	Stock	20.25	20.54	20.22	20.52	2260175.0
2009-09-14	ABC-DELISTED	Stock	21.59	21.77	21.43	21.74	2846594.0
2009-09-14	ABCB	Stock	5.8553	6.2152	5.8553	6.2055	20563.0
2009-09-14	ABCO-DELISTED	Stock	13.555	13.68	13.465	13.595	109874.0
2009-09-14	ABCW-DELISTED	Stock	1.2608	1.2811	1.2198	1.23	73430.0
2009-09-14	ABD-DELISTED	Stock	5.87	6.28	5.82	6.2	722830.0
2009-09-14	ABE-DELISTED	Stock	16.5	17.15	16.5	16.98	7814.0
2009-09-14	ABEO	Stock	4375.0	4375.0	4187.5	4375.0	25.0
2009-09-14	ABFS-DELISTED	Stock	33.86	34.49	33.52	33.95	605188.0
2009-09-14	ABG	Stock	14.02	14.55	13.88	14.48	202900.0
2009-09-14	ABII-DELISTED	Stock	26.5	27.08	25.97	27.07	54284.0
2009-09-14	ABK-DELISTED	Stock	1.58	1.8	1.57	1.76	26225976.0
2009-09-14	ABM	Stock	20.43	20.68	20.3	20.61	113800.0
2009-09-14	ABMD-DELISTED	Stock	7.91	8.17	7.91	8.15	69769.0
2009-09-14	ABR	Stock	1.86	1.89	1.85	1.88	50000.0
2009-09-14	ABT	Stock	22.4642	22.7713	22.4115	22.7089	21335765.0
2009-09-14	ABTL-DELISTED	Stock	2.7037	2.75	2.7037	2.75	2584.0
2009-09-14	ABV-DELISTED	Stock	75.53	77.37	75.4604	77.3	582575.0
2009-09-14	ABVA-DELISTED	Stock	2.38	2.73	2.38	2.73	1100.0
2009-09-14	ABVT-DELISTED	Stock	44.5	45.16	43.37	44.86	97079.0
2009-09-14	ABX-DELISTED	Stock	37.57	38.14	37.19	37.42	11221513.0
2009-09-14	ACAD	Stock	1.93	1.94	1.85	1.89	1738900.0
2009-09-14	ACAP-DELISTED	Stock	31.1	31.4	30.85	31.05	30066.0

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

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