PREVIEW / stock_daily / 2011-03-09

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-09.parquet
  size:    197 KB
  rows:    6,076
  symbols: 3,553

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
2011-03-09	AAPL	Stock	12.6675	12.67	12.5214	12.5882	453306000.0
2011-03-09	MSFT	Stock	25.81	25.98	25.66	25.89	39789100.0
2011-03-09	NVDA	Stock	0.4872	0.492	0.4742	0.4785	1318976000.0
2011-03-09	AMZN	Stock	8.3335	8.4875	8.195	8.4525	142178000.0
2011-03-09	TSLA	Stock	1.644	1.666	1.618	1.648	13872000.0
2011-03-09	TLT	Stock	90.09	90.82	89.85	90.55	8906639.0
2011-03-09	ES	Stock	34.67	35.13	34.54	35.07	1317400.0
2011-03-09	CL	Stock	38.955	39.505	38.955	39.5	3783600.0
2011-03-09	A	Stock	32.6538	32.9399	31.9027	32.9399	4869653.0
2011-03-09	AABA-DELISTED	Stock	16.87	17.7	16.85	17.65	33526421.0
2011-03-09	AACC-DELISTED	Stock	5.75	5.75	5.66	5.73	5185.0
2011-03-09	AACG	Stock	7.74	7.75	7.62	7.75	4600.0
2011-03-09	AAI-DELISTED	Stock	7.41	7.44	7.34	7.4	1453011.0
2011-03-09	AAIC-DELISTED	Stock	28.43	28.43	27.66	27.73	35909.0
2011-03-09	AAME	Stock	2.05	2.06	2.03	2.04	3200.0
2011-03-09	AAON	Stock	6.1353	6.2222	6.084	6.1156	189337.0
2011-03-09	AAP	Stock	64.17	64.99	63.76	64.51	855800.0
2011-03-09	AAT	Stock	21.29	21.44	20.96	21.15	186400.0
2011-03-09	AATI-DELISTED	Stock	4.09	4.1	4.0288	4.07	75000.0
2011-03-09	AAU-DELISTED	Stock	3.85	4.0	3.72	3.7436	315655.0
2011-03-09	AAUAF-DELISTED	Stock	3.85	4.0	3.72	3.75	316255.0
2011-03-09	AAV-DELISTED	Stock	8.31	8.31	8.07	8.13	688725.0
2011-03-09	AAWW-DELISTED	Stock	68.87	69.35	66.86	67.83	193220.0
2011-03-09	AAXJ	Stock	62.12	62.29	61.81	62.22	276426.0
2011-03-09	AAXN-DELISTED	Stock	4.08	4.2	4.06	4.18	419809.0
2011-03-09	AB	Stock	22.85	22.95	22.6	22.71	481500.0
2011-03-09	ABAC-DELISTED	Stock	5.21	5.25	5.0601	5.13	32261.0
2011-03-09	ABAX-DELISTED	Stock	28.4	28.975	28.09	28.84	138808.0
2011-03-09	ABB-DELISTED	Stock	23.98	24.03	23.8	23.94	2245278.0
2011-03-09	ABBC-DELISTED	Stock	12.65	12.79	12.47	12.62	57869.0
2011-03-09	ABBNY-DELISTED	Stock	23.98	24.03	23.8	23.95	2261234.0
2011-03-09	ABC-DELISTED	Stock	37.41	38.83	37.22	38.48	3459074.0
2011-03-09	ABCB	Stock	10.0	10.01	9.87	9.97	16200.0
2011-03-09	ABCD-DELISTED	Stock	3.57	3.67	3.49	3.67	15140.0
2011-03-09	ABCO-DELISTED	Stock	24.9	25.03	24.74	24.96	66797.0
2011-03-09	ABCW-DELISTED	Stock	1.04	1.05	1.02	1.03	69400.0
2011-03-09	ABD-DELISTED	Stock	9.25	9.64	9.2	9.47	209930.0
2011-03-09	ABE-DELISTED	Stock	17.92	18.06	17.92	18.04	9784.0
2011-03-09	ABEO	Stock	2400.0	2537.5	2387.5	2512.5	7.0
2011-03-09	ABFS-DELISTED	Stock	24.56	25.15	24.1901	25.13	243246.0
2011-03-09	ABG	Stock	19.52	19.82	19.38	19.72	188000.0
2011-03-09	ABH-DELISTED	Stock	28.7	28.8	28.11	28.22	248174.0
2011-03-09	ABM	Stock	25.4	25.75	25.28	25.57	320000.0
2011-03-09	ABMD-DELISTED	Stock	13.6	14.18	13.6	14.14	223236.0
2011-03-09	ABR	Stock	6.19	6.19	5.85	5.88	115100.0
2011-03-09	ABT	Stock	23.3855	23.5726	23.2991	23.5438	13483326.0
2011-03-09	ABTL-DELISTED	Stock	6.05	6.65	6.05	6.45	187094.0
2011-03-09	ABUS	Stock	4.66	4.78	4.66	4.73	1500.0
2011-03-09	ABV-DELISTED	Stock	27.94	27.9999	27.58	27.87	1439859.0
2011-03-09	ABVA-DELISTED	Stock	4.78	5.0	4.78	4.9201	3500.0

> showing 50 of 6,076 rows — these rows as CSV

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