PREVIEW / stock_daily / 2009-03-17

all stock daily files

  file:    by_date/stock_daily/2009/2009-03-17.parquet
  size:    172 KB
  rows:    5,697
  symbols: 3,395

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-17	AAPL	Stock	3.4014	3.5604	3.3954	3.5593	786646000.0
2009-03-17	MSFT	Stock	16.32	16.9	16.26	16.9	62481000.0
2009-03-17	NVDA	Stock	0.2362	0.2478	0.2332	0.2473	1005384000.0
2009-03-17	AMZN	Stock	3.3685	3.5855	3.35	3.5675	238056000.0
2009-03-17	TLT	Stock	101.72	102.33	100.3876	100.56	3076121.0
2009-03-17	ES	Stock	21.13	21.21	20.69	21.15	9912000.0
2009-03-17	CL	Stock	28.63	29.515	28.61	29.455	5401000.0
2009-03-17	A	Stock	9.9428	10.3147	9.7997	10.3147	3554695.0
2009-03-17	AABA-DELISTED	Stock	13.33	14.04	13.21	14.0	17323272.0
2009-03-17	AACC-DELISTED	Stock	4.89	5.2	4.85	5.15	33896.0
2009-03-17	AACG	Stock	4.56	4.72	4.5	4.69	36700.0
2009-03-17	AAI-DELISTED	Stock	4.14	4.4	3.98	4.4	1763751.0
2009-03-17	AAIC-DELISTED	Stock	3.6	3.6	2.61	3.4	655663.0
2009-03-17	AAME	Stock	0.52	0.58	0.5	0.5	11200.0
2009-03-17	AAON	Stock	3.6879	3.7531	3.5042	3.7531	432844.0
2009-03-17	AAP	Stock	38.7	39.91	38.5	39.54	1495000.0
2009-03-17	AATI-DELISTED	Stock	3.31	3.48	3.31	3.4	148396.0
2009-03-17	AAU-DELISTED	Stock	0.63	0.69	0.62	0.65	38373.0
2009-03-17	AAUAF-DELISTED	Stock	0.63	0.69	0.62	0.65	38993.0
2009-03-17	AAV-DELISTED	Stock	2.69	2.98	2.69	2.9	1140999.0
2009-03-17	AAWW-DELISTED	Stock	13.46	14.86	13.29	14.47	238432.0
2009-03-17	AAXJ	Stock	31.27	31.67	31.0	31.67	75495.0
2009-03-17	AAXN-DELISTED	Stock	4.07	4.26	3.75	4.16	712910.0
2009-03-17	AB	Stock	13.0	13.38	12.38	13.33	479500.0
2009-03-17	ABAX-DELISTED	Stock	17.88	18.37	17.74	18.32	217313.0
2009-03-17	ABB-DELISTED	Stock	13.37	13.85	13.32	13.85	3740671.0
2009-03-17	ABBC-DELISTED	Stock	8.74	8.74	7.61	8.56	39575.0
2009-03-17	ABBNY-DELISTED	Stock	13.37	13.87	13.32	13.87	3745721.0
2009-03-17	ABC-DELISTED	Stock	15.36	15.7	15.16	15.69	2853078.0
2009-03-17	ABCB	Stock	5.8942	7.2948	5.8456	7.2948	17067.0
2009-03-17	ABCO-DELISTED	Stock	7.075	7.685	7.075	7.68	147926.0
2009-03-17	ABCW-DELISTED	Stock	0.82	0.84	0.74	0.78	95830.0
2009-03-17	ABD-DELISTED	Stock	1.21	1.27	1.11	1.25	195830.0
2009-03-17	ABE-DELISTED	Stock	11.92	11.92	11.6	11.73	6129.0
2009-03-17	ABEO	Stock	1750.0	1937.5	1687.5	1750.0	25.0
2009-03-17	ABFS-DELISTED	Stock	19.55	20.33	18.99	20.32	348287.0
2009-03-17	ABG	Stock	2.88	3.75	2.8	3.72	640500.0
2009-03-17	ABII-DELISTED	Stock	51.39	51.79	49.44	51.3476	27382.0
2009-03-17	ABK-DELISTED	Stock	0.7136	0.75	0.66	0.73	5344215.0
2009-03-17	ABM	Stock	15.72	16.09	15.5	16.04	530400.0
2009-03-17	ABMD-DELISTED	Stock	5.41	5.53	5.22	5.3	355908.0
2009-03-17	ABR	Stock	1.06	1.08	0.94	0.99	107200.0
2009-03-17	ABT	Stock	22.992	23.5918	22.9152	23.5774	22476032.0
2009-03-17	ABTL-DELISTED	Stock	1.3997	1.4008	1.3502	1.4003	8556.0
2009-03-17	ABV-DELISTED	Stock	43.23	44.41	43.23	44.34	394088.0
2009-03-17	ABVA-DELISTED	Stock	1.65	1.66	1.65	1.66	700.0
2009-03-17	ABVT-DELISTED	Stock	45.0	45.0	44.0	44.0	5600.0
2009-03-17	ABX-DELISTED	Stock	29.48	29.76	28.28	28.95	10002505.0
2009-03-17	ACAD	Stock	0.97	1.01	0.95	0.98	137800.0
2009-03-17	ACAP-DELISTED	Stock	41.1	43.66	41.1	43.66	39354.0

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

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