PREVIEW / stock_daily / 2009-10-19

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-19.parquet
  size:    187 KB
  rows:    5,866
  symbols: 3,486

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-19	AAPL	Stock	6.7089	6.7857	6.6268	6.7807	942230800.0
2009-10-19	MSFT	Stock	26.49	26.58	26.25	26.36	48143200.0
2009-10-19	NVDA	Stock	0.3333	0.3453	0.3305	0.3425	695588000.0
2009-10-19	AMZN	Stock	4.7675	4.814	4.7125	4.734	120348000.0
2009-10-19	TLT	Stock	95.59	96.21	95.38	96.2	3163768.0
2009-10-19	ES	Stock	23.61	24.01	23.45	23.94	1086200.0
2009-10-19	CL	Stock	39.62	39.845	39.285	39.735	4479800.0
2009-10-19	A	Stock	19.5565	19.7067	19.3634	19.5994	2850103.0
2009-10-19	AABA-DELISTED	Stock	16.82	17.29	16.7	17.23	17786060.0
2009-10-19	AACC-DELISTED	Stock	7.18	7.24	6.9	7.161	24842.0
2009-10-19	AACG	Stock	5.96	5.96	5.8	5.8	500.0
2009-10-19	AAI-DELISTED	Stock	5.39	5.54	5.29	5.37	8901253.0
2009-10-19	AAIC-DELISTED	Stock	13.61	14.24	13.61	14.0	153090.0
2009-10-19	AAME	Stock	1.44	1.72	1.3	1.42	66800.0
2009-10-19	AAON	Stock	3.7412	3.7412	3.6148	3.7353	552825.0
2009-10-19	AAP	Stock	39.62	39.92	38.83	39.41	1938900.0
2009-10-19	AATI-DELISTED	Stock	3.46	3.53	3.35	3.52	348468.0
2009-10-19	AAU-DELISTED	Stock	0.77	0.79	0.7499	0.77	184783.0
2009-10-19	AAUAF-DELISTED	Stock	0.77	0.79	0.7499	0.77	185083.0
2009-10-19	AAV-DELISTED	Stock	7.5	7.79	7.5	7.74	1093189.0
2009-10-19	AAWW-DELISTED	Stock	36.75	37.66	35.9	37.49	222764.0
2009-10-19	AAXJ	Stock	54.81	55.46	54.58	55.46	388065.0
2009-10-19	AAXN-DELISTED	Stock	4.64	4.64	4.54	4.6	302585.0
2009-10-19	AB	Stock	27.49	27.9	26.73	26.96	999900.0
2009-10-19	ABAX-DELISTED	Stock	24.15	24.75	23.98	24.64	351868.0
2009-10-19	ABB-DELISTED	Stock	21.3	21.61	21.2584	21.54	2006081.0
2009-10-19	ABBC-DELISTED	Stock	7.5	7.5	7.22	7.24	22559.0
2009-10-19	ABBNY-DELISTED	Stock	21.3	21.61	21.2584	21.51	2006888.0
2009-10-19	ABC-DELISTED	Stock	23.64	23.64	23.31	23.41	2126654.0
2009-10-19	ABCB	Stock	6.6354	6.6354	6.2336	6.606	25507.0
2009-10-19	ABCO-DELISTED	Stock	13.118	13.168	12.907	13.057	73303.0
2009-10-19	ABCW-DELISTED	Stock	1.14	1.2163	1.14	1.14	47040.0
2009-10-19	ABD-DELISTED	Stock	7.39	7.46	7.28	7.4	211950.0
2009-10-19	ABE-DELISTED	Stock	17.65	17.71	17.11	17.28	201398.0
2009-10-19	ABEO	Stock	4375.0	4375.0	4250.0	4300.0	30.0
2009-10-19	ABFS-DELISTED	Stock	30.09	30.4	29.57	29.95	739678.0
2009-10-19	ABG	Stock	13.84	14.19	13.63	14.1	210000.0
2009-10-19	ABII-DELISTED	Stock	37.55	38.08	36.57	36.59	35766.0
2009-10-19	ABK-DELISTED	Stock	1.38	1.4	1.25	1.26	14102788.0
2009-10-19	ABM	Stock	20.4	20.84	20.25	20.7	121400.0
2009-10-19	ABMD-DELISTED	Stock	10.96	11.25	10.58	11.1	226718.0
2009-10-19	ABR	Stock	2.59	2.7	2.57	2.65	114500.0
2009-10-19	ABT	Stock	24.6905	25.1223	24.6617	25.06	17922885.0
2009-10-19	ABTL-DELISTED	Stock	3.0554	3.2446	3.0549	3.2446	504.0
2009-10-19	ABV-DELISTED	Stock	94.23	96.67	94.18	96.33	620112.0
2009-10-19	ABVA-DELISTED	Stock	2.37	2.4	2.36	2.3799	1377.0
2009-10-19	ABVT-DELISTED	Stock	50.0	50.81	49.31	49.57	65869.0
2009-10-19	ABX-DELISTED	Stock	38.99	39.2699	38.07	38.95	11141755.0
2009-10-19	ACAD	Stock	1.74	1.78	1.66	1.74	827900.0
2009-10-19	ACAP-DELISTED	Stock	30.19	30.555	30.155	30.35	23375.0

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

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