PREVIEW / stock_daily / 2011-01-31

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-31.parquet
  size:    197 KB
  rows:    6,090
  symbols: 3,554

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-31	AAPL	Stock	11.9929	12.1443	11.9393	12.1186	377246800.0
2011-01-31	MSFT	Stock	27.77	27.9	27.42	27.73	65029000.0
2011-01-31	NVDA	Stock	0.595	0.6063	0.5853	0.598	750160000.0
2011-01-31	AMZN	Stock	8.508	8.572	8.3705	8.482	134362000.0
2011-01-31	TSLA	Stock	1.6033	1.608	1.5667	1.6067	12454500.0
2011-01-31	TLT	Stock	91.66	91.98	91.05	91.22	8649186.0
2011-01-31	ES	Stock	32.91	33.18	32.68	32.92	2215900.0
2011-01-31	CL	Stock	38.38	38.465	38.2	38.385	6763600.0
2011-01-31	A	Stock	29.4778	29.9213	29.2489	29.9213	5160018.0
2011-01-31	AABA-DELISTED	Stock	15.82	16.2	15.79	16.11	22563451.0
2011-01-31	AACC-DELISTED	Stock	6.09	6.22	5.935	6.045	17806.0
2011-01-31	AACG	Stock	4.11	4.19	4.11	4.19	4800.0
2011-01-31	AAI-DELISTED	Stock	7.36	7.42	7.36	7.39	1787045.0
2011-01-31	AAIC-DELISTED	Stock	25.13	25.35	25.0	25.16	37473.0
2011-01-31	AAME	Stock	2.16	2.18	2.15	2.18	900.0
2011-01-31	AAON	Stock	5.3195	5.3768	5.2504	5.3195	189844.0
2011-01-31	AAP	Stock	64.54	65.16	63.9	63.94	839200.0
2011-01-31	AAT	Stock	21.3	21.4	21.25	21.29	197600.0
2011-01-31	AATI-DELISTED	Stock	4.03	4.03	3.96	3.98	98299.0
2011-01-31	AAU-DELISTED	Stock	3.98	3.98	3.73	3.81	378659.0
2011-01-31	AAUAF-DELISTED	Stock	3.98	3.98	3.73	3.82	387259.0
2011-01-31	AAV-DELISTED	Stock	7.26	7.4597	7.23	7.43	398445.0
2011-01-31	AAWW-DELISTED	Stock	50.68	51.01	49.79	50.81	195150.0
2011-01-31	AAXJ	Stock	61.38	61.71	61.26	61.54	1491306.0
2011-01-31	AAXN-DELISTED	Stock	4.25	4.26	4.17	4.18	556292.0
2011-01-31	AB	Stock	20.95	21.28	20.94	21.18	363700.0
2011-01-31	ABAC-DELISTED	Stock	5.3	5.3	5.02	5.11	68780.0
2011-01-31	ABAX-DELISTED	Stock	27.02	27.02	26.2	26.345	136535.0
2011-01-31	ABB-DELISTED	Stock	23.58	23.7828	23.58	23.69	2245235.0
2011-01-31	ABBC-DELISTED	Stock	12.41	12.66	12.23	12.44	255648.0
2011-01-31	ABBNY-DELISTED	Stock	23.61	23.7828	23.58	23.67	2251885.0
2011-01-31	ABC-DELISTED	Stock	36.14	36.38	35.84	35.87	2004999.0
2011-01-31	ABCB	Stock	9.7	9.71	9.37	9.53	280600.0
2011-01-31	ABCD-DELISTED	Stock	3.29	3.37	3.26	3.28	20075.0
2011-01-31	ABCO-DELISTED	Stock	24.94	25.15	24.56	24.73	137386.0
2011-01-31	ABCW-DELISTED	Stock	1.425	1.425	1.3752	1.415	94700.0
2011-01-31	ABD-DELISTED	Stock	8.15	8.31	8.05	8.21	256620.0
2011-01-31	ABE-DELISTED	Stock	17.86	18.38	17.86	18.25	21005.0
2011-01-31	ABEO	Stock	3112.5	3125.0	3062.5	3112.5	4.0
2011-01-31	ABFS-DELISTED	Stock	25.56	25.82	25.2301	25.55	101968.0
2011-01-31	ABG	Stock	18.52	18.82	18.29	18.41	199500.0
2011-01-31	ABH-DELISTED	Stock	27.55	27.79	26.73	27.04	223171.0
2011-01-31	ABM	Stock	25.65	26.06	25.3	25.7	227200.0
2011-01-31	ABMD-DELISTED	Stock	9.88	9.88	9.7	9.795	140694.0
2011-01-31	ABR	Stock	5.96	6.1	5.85	6.06	26700.0
2011-01-31	ABT	Stock	21.9988	22.0324	21.6246	21.6678	34672780.0
2011-01-31	ABTL-DELISTED	Stock	4.2541	4.3494	4.2028	4.3	3220.0
2011-01-31	ABUS	Stock	6.0	6.09	5.9	5.92	12100.0
2011-01-31	ABV-DELISTED	Stock	27.13	27.26	26.46	26.7	4714011.0
2011-01-31	ABVA-DELISTED	Stock	4.66	5.08	4.65	5.03	800.0

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

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