PREVIEW / stock_daily / 2011-01-27

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-27.parquet
  size:    196 KB
  rows:    6,079
  symbols: 3,559

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-01-27	AAPL	Stock	12.2779	12.3104	12.2439	12.2575	285026000.0
2011-01-27	MSFT	Stock	28.75	29.46	28.49	28.87	146938600.0
2011-01-27	NVDA	Stock	0.6223	0.6238	0.6	0.6118	657396000.0
2011-01-27	AMZN	Stock	8.874	9.25	8.8655	9.2225	291888000.0
2011-01-27	TSLA	Stock	1.6493	1.672	1.6353	1.6613	13435500.0
2011-01-27	TLT	Stock	91.07	91.65	90.67	91.44	10869313.0
2011-01-27	ES	Stock	32.66	32.86	32.51	32.82	1847600.0
2011-01-27	CL	Stock	38.74	39.26	38.66	38.695	15442400.0
2011-01-27	A	Stock	30.5937	30.8226	30.3076	30.3648	4459201.0
2011-01-27	AABA-DELISTED	Stock	15.6	16.36	15.58	16.21	38059926.0
2011-01-27	AACC-DELISTED	Stock	6.44	7.21	6.29	7.02	44742.0
2011-01-27	AACG	Stock	4.19	4.29	4.11	4.12	12700.0
2011-01-27	AAI-DELISTED	Stock	7.43	7.47	7.42	7.45	1704525.0
2011-01-27	AAIC-DELISTED	Stock	24.41	24.86	24.3601	24.67	51799.0
2011-01-27	AAME	Stock	2.13	2.2	2.13	2.2	600.0
2011-01-27	AAON	Stock	5.523	5.5704	5.442	5.5328	89606.0
2011-01-27	AAP	Stock	64.29	64.73	63.79	64.15	958700.0
2011-01-27	AAT	Stock	21.2	21.4	21.2	21.4	450400.0
2011-01-27	AATI-DELISTED	Stock	4.2	4.2	4.09	4.09	85330.0
2011-01-27	AAU-DELISTED	Stock	3.93	3.93	3.68	3.68	320377.0
2011-01-27	AAUAF-DELISTED	Stock	3.9	3.9	3.65	3.68	324936.0
2011-01-27	AAV-DELISTED	Stock	7.28	7.38	7.24	7.31	272813.0
2011-01-27	AAWW-DELISTED	Stock	53.64	53.78	52.96	53.1	231515.0
2011-01-27	AAXJ	Stock	62.99	63.1	62.78	62.92	190008.0
2011-01-27	AAXN-DELISTED	Stock	4.16	4.24	4.16	4.21	430332.0
2011-01-27	AB	Stock	21.07	21.44	21.0	21.38	650400.0
2011-01-27	ABAC-DELISTED	Stock	5.56	5.6011	5.5	5.52	23517.0
2011-01-27	ABAX-DELISTED	Stock	27.52	27.52	26.84	27.3	129535.0
2011-01-27	ABB-DELISTED	Stock	24.22	24.315	24.08	24.28	2064469.0
2011-01-27	ABBC-DELISTED	Stock	12.1	12.55	11.98	12.51	2051578.0
2011-01-27	ABBNY-DELISTED	Stock	24.22	24.315	24.08	24.28	2064469.0
2011-01-27	ABC-DELISTED	Stock	36.51	37.08	36.48	36.83	3519863.0
2011-01-27	ABCB	Stock	10.19	10.3	10.12	10.21	20400.0
2011-01-27	ABCD-DELISTED	Stock	3.3	3.36	3.27	3.35	56883.0
2011-01-27	ABCO-DELISTED	Stock	24.95	25.31	24.9	25.14	66316.0
2011-01-27	ABCW-DELISTED	Stock	1.3606	1.4296	1.3606	1.4	145410.0
2011-01-27	ABD-DELISTED	Stock	8.54	8.65	8.35	8.43	272820.0
2011-01-27	ABE-DELISTED	Stock	18.76	18.84	18.47	18.69	13232.0
2011-01-27	ABEO	Stock	3212.5	3212.5	3062.5	3137.5	39.0
2011-01-27	ABFS-DELISTED	Stock	26.55	26.92	26.51	26.62	115228.0
2011-01-27	ABG	Stock	19.02	19.56	18.93	19.37	119900.0
2011-01-27	ABH-DELISTED	Stock	29.38	29.38	28.38	28.75	175357.0
2011-01-27	ABM	Stock	26.05	26.55	26.02	26.39	170900.0
2011-01-27	ABMD-DELISTED	Stock	9.99	10.1	9.95	10.0	60713.0
2011-01-27	ABR	Stock	6.15	6.2	6.11	6.17	38400.0
2011-01-27	ABT	Stock	22.3923	22.4498	22.1188	22.2531	37021884.0
2011-01-27	ABTL-DELISTED	Stock	4.6006	4.6006	4.3225	4.55	169729.0
2011-01-27	ABUS	Stock	6.89	6.9	6.52	6.61	19700.0
2011-01-27	ABV-DELISTED	Stock	28.34	28.56	27.69	27.71	3760028.0
2011-01-27	ABVA-DELISTED	Stock	4.52	5.0	4.52	4.95	2400.0

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

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