PREVIEW / stock_daily / 2009-10-20

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-20.parquet
  size:    186 KB
  rows:    5,846
  symbols: 3,479

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-20	AAPL	Stock	7.1643	7.2054	7.0661	7.0986	1141039200.0
2009-10-20	MSFT	Stock	26.42	26.51	25.94	26.37	54604700.0
2009-10-20	NVDA	Stock	0.3482	0.3508	0.34	0.3428	660180000.0
2009-10-20	AMZN	Stock	4.7955	4.805	4.7135	4.749	155552000.0
2009-10-20	TLT	Stock	97.02	97.245	96.5402	96.72	2912315.0
2009-10-20	ES	Stock	23.93	23.93	23.34	23.38	1455300.0
2009-10-20	CL	Stock	39.695	40.205	39.49	39.72	4260200.0
2009-10-20	A	Stock	19.5351	19.5851	18.8555	18.9342	5498614.0
2009-10-20	AABA-DELISTED	Stock	17.37	17.41	16.87	17.17	37739241.0
2009-10-20	AACC-DELISTED	Stock	7.17	7.24	7.07	7.07	15292.0
2009-10-20	AACG	Stock	5.76	5.76	5.76	5.76	100.0
2009-10-20	AAI-DELISTED	Stock	5.5	5.57	5.3	5.39	8207888.0
2009-10-20	AAIC-DELISTED	Stock	14.0	14.05	13.72	14.05	166188.0
2009-10-20	AAME	Stock	1.42	1.62	1.38	1.38	10400.0
2009-10-20	AAON	Stock	3.7353	3.7353	3.68	3.7215	349312.0
2009-10-20	AAP	Stock	39.24	39.33	38.33	38.4	1422700.0
2009-10-20	AATI-DELISTED	Stock	3.52	3.58	3.31	3.38	516825.0
2009-10-20	AAU-DELISTED	Stock	0.78	0.78	0.6998	0.7	276700.0
2009-10-20	AAUAF-DELISTED	Stock	0.78	0.78	0.6998	0.7	277000.0
2009-10-20	AAV-DELISTED	Stock	7.7	7.79	7.52	7.57	1294998.0
2009-10-20	AAWW-DELISTED	Stock	37.7	37.97	35.93	36.88	278456.0
2009-10-20	AAXJ	Stock	55.22	55.22	54.56	55.0	479353.0
2009-10-20	AAXN-DELISTED	Stock	4.58	4.59	4.51	4.52	283243.0
2009-10-20	AB	Stock	27.02	27.06	26.39	26.52	488400.0
2009-10-20	ABAX-DELISTED	Stock	24.71	24.8	24.37	24.6	116844.0
2009-10-20	ABB-DELISTED	Stock	21.55	21.55	21.18	21.35	2134661.0
2009-10-20	ABBC-DELISTED	Stock	7.22	7.28	7.07	7.15	64525.0
2009-10-20	ABBNY-DELISTED	Stock	21.55	21.55	21.18	21.33	2156565.0
2009-10-20	ABC-DELISTED	Stock	23.36	23.86	23.36	23.72	3832631.0
2009-10-20	ABCB	Stock	6.5766	7.0667	6.5766	6.6844	63155.0
2009-10-20	ABCO-DELISTED	Stock	13.135	13.135	12.855	12.985	64643.0
2009-10-20	ABCW-DELISTED	Stock	1.0889	1.0889	0.9722	1.05	139410.0
2009-10-20	ABD-DELISTED	Stock	7.42	7.48	7.14	7.19	284810.0
2009-10-20	ABE-DELISTED	Stock	17.31	17.31	17.01	17.07	60671.0
2009-10-20	ABEO	Stock	4250.0	4300.0	4125.0	4162.5	23.0
2009-10-20	ABFS-DELISTED	Stock	30.23	30.39	29.39	29.95	749639.0
2009-10-20	ABG	Stock	14.13	14.14	13.74	13.99	141800.0
2009-10-20	ABII-DELISTED	Stock	36.47	37.26	35.36	36.39	41178.0
2009-10-20	ABK-DELISTED	Stock	1.31	1.31	1.19	1.23	10679473.0
2009-10-20	ABM	Stock	20.79	20.79	20.35	20.39	144100.0
2009-10-20	ABMD-DELISTED	Stock	11.11	11.14	10.42	10.57	187559.0
2009-10-20	ABR	Stock	2.64	2.66	2.47	2.62	136800.0
2009-10-20	ABT	Stock	24.94	25.0983	24.8201	24.8824	16214673.0
2009-10-20	ABTL-DELISTED	Stock	3.055	3.0705	3.045	3.045	4819.0
2009-10-20	ABV-DELISTED	Stock	94.59	95.81	91.95	93.93	979732.0
2009-10-20	ABVA-DELISTED	Stock	2.22	2.35	2.21	2.21	700.0
2009-10-20	ABVT-DELISTED	Stock	49.73	49.73	47.42	48.25	119526.0
2009-10-20	ABX-DELISTED	Stock	39.2	39.37	37.47	37.81	12580101.0
2009-10-20	ACAD	Stock	1.71	1.74	1.62	1.65	1154000.0
2009-10-20	ACAP-DELISTED	Stock	30.45	30.6	29.95	30.14	28197.0

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

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