PREVIEW / stock_daily / 2009-03-13

all stock daily files

  file:    by_date/stock_daily/2009/2009-03-13.parquet
  size:    174 KB
  rows:    5,732
  symbols: 3,428

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-03-13	AAPL	Stock	3.4393	3.4714	3.3932	3.4261	601168400.0
2009-03-13	MSFT	Stock	16.98	17.05	16.18	16.65	82965800.0
2009-03-13	NVDA	Stock	0.2428	0.2485	0.2388	0.245	1195156000.0
2009-03-13	AMZN	Stock	3.482	3.487	3.3765	3.4315	178068000.0
2009-03-13	TLT	Stock	102.75	103.88	102.33	102.73	2503935.0
2009-03-13	ES	Stock	20.7	20.81	19.84	19.9	4267700.0
2009-03-13	CL	Stock	28.435	28.9	28.13	28.81	6373400.0
2009-03-13	A	Stock	9.907	10.1144	9.8641	10.0072	3648500.0
2009-03-13	AABA-DELISTED	Stock	13.65	13.66	13.27	13.48	12478101.0
2009-03-13	AACC-DELISTED	Stock	5.16	5.17	4.83	4.85	85108.0
2009-03-13	AACG	Stock	4.78	4.88	4.62	4.76	24700.0
2009-03-13	AAI-DELISTED	Stock	3.96	4.19	3.87	4.0	1984279.0
2009-03-13	AAIC-DELISTED	Stock	2.798	2.8	2.5	2.8	375159.0
2009-03-13	AAME	Stock	0.54	0.54	0.54	0.54	100.0
2009-03-13	AAON	Stock	3.6306	3.6504	3.5477	3.5872	336656.0
2009-03-13	AAP	Stock	39.76	40.0	38.88	39.73	1450800.0
2009-03-13	AATI-DELISTED	Stock	3.63	3.63	3.33	3.48	117017.0
2009-03-13	AAU-DELISTED	Stock	0.7	0.73	0.7	0.7	25100.0
2009-03-13	AAUAF-DELISTED	Stock	0.7	0.73	0.7	0.7	25400.0
2009-03-13	AAV-DELISTED	Stock	2.4	2.77	2.3639	2.63	1436403.0
2009-03-13	AAWW-DELISTED	Stock	13.0	13.9399	12.78	13.57	242066.0
2009-03-13	AAXJ	Stock	30.65	31.01	30.47	30.9036	66948.0
2009-03-13	AAXN-DELISTED	Stock	4.17	4.35	4.13	4.22	330295.0
2009-03-13	AB	Stock	13.59	14.13	12.9	13.23	686300.0
2009-03-13	ABAX-DELISTED	Stock	17.85	18.17	17.57	18.02	203851.0
2009-03-13	ABB-DELISTED	Stock	13.21	13.45	12.95	13.41	4760313.0
2009-03-13	ABBC-DELISTED	Stock	8.2	8.34	8.04	8.15	53380.0
2009-03-13	ABBNY-DELISTED	Stock	13.21	13.45	12.95	13.4	4765331.0
2009-03-13	ABC-DELISTED	Stock	14.79	15.64	14.74	15.62	6879644.0
2009-03-13	ABCB	Stock	6.0401	6.4389	6.0109	6.0109	18506.0
2009-03-13	ABCO-DELISTED	Stock	7.528	7.622	7.283	7.587	150104.0
2009-03-13	ABCW-DELISTED	Stock	0.77	0.78	0.64	0.66	148800.0
2009-03-13	ABD-DELISTED	Stock	1.28	1.28	1.17	1.22	340210.0
2009-03-13	ABE-DELISTED	Stock	11.65	11.75	11.51	11.65	46260.0
2009-03-13	ABEO	Stock	2037.5	2125.0	2037.5	2125.0	7.0
2009-03-13	ABFS-DELISTED	Stock	19.03	19.97	18.97	19.74	439167.0
2009-03-13	ABG	Stock	2.15	2.37	2.09	2.29	313300.0
2009-03-13	ABII-DELISTED	Stock	54.46	56.86	54.0	54.75	19566.0
2009-03-13	ABK-DELISTED	Stock	0.545	0.6	0.53	0.589	6557532.0
2009-03-13	ABM	Stock	15.65	15.68	15.33	15.53	420000.0
2009-03-13	ABMD-DELISTED	Stock	5.89	5.91	5.61	5.74	308743.0
2009-03-13	ABR	Stock	1.15	1.39	1.15	1.22	219600.0
2009-03-13	ABT	Stock	22.5218	22.637	22.0756	22.4786	27657566.0
2009-03-13	ABTL-DELISTED	Stock	1.75	1.75	1.25	1.25	25899.0
2009-03-13	ABV-DELISTED	Stock	43.74	44.45	43.23	43.97	897230.0
2009-03-13	ABVA-DELISTED	Stock	1.75	1.75	1.75	1.75	200.0
2009-03-13	ABVT-DELISTED	Stock	40.0	40.0	40.0	40.0	125.0
2009-03-13	ABX-DELISTED	Stock	29.66	29.9	29.11	29.66	11885860.0
2009-03-13	ACAD	Stock	1.0	1.01	0.99	0.99	87400.0
2009-03-13	ACAP-DELISTED	Stock	43.52	44.222	42.07	42.82	29784.0

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

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