PREVIEW / stock_daily / 2011-01-24

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-24.parquet
  size:    196 KB
  rows:    6,090
  symbols: 3,562

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-24	AAPL	Stock	11.6739	12.0518	11.6686	12.0518	574683200.0
2011-01-24	MSFT	Stock	28.02	28.56	27.99	28.38	52047800.0
2011-01-24	NVDA	Stock	0.581	0.6263	0.5745	0.6183	2056900000.0
2011-01-24	AMZN	Stock	8.8975	8.9245	8.7075	8.8425	112006000.0
2011-01-24	TSLA	Stock	1.5687	1.654	1.5487	1.6327	24676500.0
2011-01-24	TLT	Stock	91.87	91.9	91.38	91.56	7700336.0
2011-01-24	ES	Stock	32.64	32.98	32.61	32.82	1199000.0
2011-01-24	CL	Stock	39.43	39.95	39.43	39.92	5271200.0
2011-01-24	A	Stock	30.1717	30.608	30.093	30.5937	2890365.0
2011-01-24	AABA-DELISTED	Stock	15.98	16.24	15.76	16.09	22504724.0
2011-01-24	AACC-DELISTED	Stock	6.03	6.082	6.0199	6.0499	85172.0
2011-01-24	AACG	Stock	4.08	4.19	4.08	4.19	16700.0
2011-01-24	AAI-DELISTED	Stock	7.49	7.54	7.48	7.52	2502892.0
2011-01-24	AAIC-DELISTED	Stock	23.94	24.5	23.94	24.23	18046.0
2011-01-24	AAME	Stock	2.2	2.2	2.12	2.18	2300.0
2011-01-24	AAON	Stock	5.2859	5.4262	5.2859	5.359	112894.0
2011-01-24	AAP	Stock	63.72	63.9	63.16	63.44	576100.0
2011-01-24	AAT	Stock	21.2	21.39	21.1	21.3	354300.0
2011-01-24	AATI-DELISTED	Stock	4.1	4.25	3.92	4.23	153249.0
2011-01-24	AAU-DELISTED	Stock	4.21	4.21	3.63	3.71	1000497.0
2011-01-24	AAUAF-DELISTED	Stock	4.21	4.21	3.63	3.71	1008885.0
2011-01-24	AAV-DELISTED	Stock	7.22	7.3	7.15	7.3	296024.0
2011-01-24	AAWW-DELISTED	Stock	50.9	52.44	50.76	51.98	233905.0
2011-01-24	AAXJ	Stock	62.2	62.47	62.08	62.38	1069934.0
2011-01-24	AAXN-DELISTED	Stock	4.6	4.7	4.56	4.59	451617.0
2011-01-24	AB	Stock	21.75	21.75	21.32	21.35	609300.0
2011-01-24	ABAC-DELISTED	Stock	5.7	5.81	5.7	5.77	16184.0
2011-01-24	ABAX-DELISTED	Stock	26.6	27.43	26.59	26.82	75221.0
2011-01-24	ABB-DELISTED	Stock	23.14	23.47	23.14	23.36	1434731.0
2011-01-24	ABBC-DELISTED	Stock	11.04	11.54	11.04	11.32	46999.0
2011-01-24	ABBNY-DELISTED	Stock	23.14	23.47	23.1399	23.35	1435231.0
2011-01-24	ABC-DELISTED	Stock	36.03	36.42	36.03	36.3	2449385.0
2011-01-24	ABCB	Stock	10.03	10.12	9.82	9.87	22800.0
2011-01-24	ABCD-DELISTED	Stock	3.25	3.27	3.2	3.25	122998.0
2011-01-24	ABCO-DELISTED	Stock	24.44	24.62	24.08	24.16	154442.0
2011-01-24	ABCW-DELISTED	Stock	1.35	1.37	1.29	1.35	77840.0
2011-01-24	ABD-DELISTED	Stock	7.87	8.191	7.85	8.14	123800.0
2011-01-24	ABE-DELISTED	Stock	18.9	19.05	18.84	18.909	6914.0
2011-01-24	ABEO	Stock	3037.5	3175.0	3000.0	3175.0	24.0
2011-01-24	ABFS-DELISTED	Stock	25.55	26.08	25.281	26.02	103810.0
2011-01-24	ABG	Stock	18.14	18.41	18.1	18.31	104600.0
2011-01-24	ABH-DELISTED	Stock	27.36	29.29	27.36	28.9	1721877.0
2011-01-24	ABM	Stock	25.54	25.82	25.2	25.61	266400.0
2011-01-24	ABMD-DELISTED	Stock	9.78	9.92	9.66	9.85	63832.0
2011-01-24	ABR	Stock	5.66	5.81	5.65	5.72	31500.0
2011-01-24	ABT	Stock	22.9824	23.1264	22.968	23.112	15529179.0
2011-01-24	ABTL-DELISTED	Stock	4.6	4.6	4.45	4.55	3659.0
2011-01-24	ABUS	Stock	6.76	6.98	6.61	6.9	40900.0
2011-01-24	ABV-DELISTED	Stock	27.03	27.52	26.99	27.45	2007399.0
2011-01-24	ABVA-DELISTED	Stock	4.56	4.65	4.4	4.4612	3900.0

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

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