PREVIEW / stock_daily / 2011-07-25

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-25.parquet
  size:    197 KB
  rows:    6,119
  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-07-25	AAPL	Stock	13.9411	14.2857	13.915	14.2321	589806000.0
2011-07-25	MSFT	Stock	27.26	28.09	27.19	27.91	108482400.0
2011-07-25	NVDA	Stock	0.3692	0.3708	0.3638	0.369	566920000.0
2011-07-25	AMZN	Stock	10.7745	10.804	10.65	10.6745	66856000.0
2011-07-25	TSLA	Stock	1.934	1.95	1.896	1.8993	10099500.0
2011-07-25	TLT	Stock	94.97	96.05	94.83	95.0	10869366.0
2011-07-25	ES	Stock	35.09	35.26	35.03	35.08	1584900.0
2011-07-25	CL	Stock	43.475	43.66	43.355	43.39	3677600.0
2011-07-25	A	Stock	33.0401	33.4192	32.9757	33.1903	2576654.0
2011-07-25	AABA-DELISTED	Stock	13.84	13.88	13.68	13.69	16645881.0
2011-07-25	AACC-DELISTED	Stock	4.38	4.55	4.38	4.5	15399.0
2011-07-25	AACG	Stock	10.26	10.26	9.66	10.0	29700.0
2011-07-25	AAIC-DELISTED	Stock	31.3	31.53	31.12	31.15	27978.0
2011-07-25	AAME	Stock	1.95	2.05	1.94	2.05	5800.0
2011-07-25	AAON	Stock	6.9333	7.0785	6.877	6.8889	126563.0
2011-07-25	AAP	Stock	55.51	57.06	55.22	56.96	1639200.0
2011-07-25	AAT	Stock	22.18	22.65	21.89	22.33	109800.0
2011-07-25	AATI-DELISTED	Stock	6.09	6.09	6.07	6.07	236038.0
2011-07-25	AAU-DELISTED	Stock	3.9	3.918	3.65	3.67	374410.0
2011-07-25	AAUAF-DELISTED	Stock	3.93	3.95	3.67	3.67	371766.0
2011-07-25	AAV-DELISTED	Stock	7.49	7.6	7.46	7.46	215258.0
2011-07-25	AAWW-DELISTED	Stock	55.48	57.1	55.48	56.2	133796.0
2011-07-25	AAXJ	Stock	62.24	62.83	62.24	62.56	244761.0
2011-07-25	AAXN-DELISTED	Stock	4.15	4.25	4.15	4.22	200370.0
2011-07-25	AB	Stock	18.39	18.67	18.25	18.64	297100.0
2011-07-25	ABAC-DELISTED	Stock	2.88	2.9499	2.7	2.75	31870.0
2011-07-25	ABAX-DELISTED	Stock	29.73	29.97	29.52	29.6	99786.0
2011-07-25	ABB-DELISTED	Stock	24.96	25.1	24.87	24.9301	2464773.0
2011-07-25	ABBC-DELISTED	Stock	10.23	10.3	10.1	10.14	24266.0
2011-07-25	ABBNY-DELISTED	Stock	24.96	25.1	24.87	24.95	2468069.0
2011-07-25	ABC-DELISTED	Stock	40.43	40.58	40.06	40.35	2813968.0
2011-07-25	ABCB	Stock	10.09	10.21	9.78	10.08	54000.0
2011-07-25	ABCD-DELISTED	Stock	3.3	3.38	3.27	3.29	11178.0
2011-07-25	ABCO-DELISTED	Stock	27.86	28.53	27.86	28.22	90474.0
2011-07-25	ABCW-DELISTED	Stock	0.68	0.7	0.68	0.69	37660.0
2011-07-25	ABD-DELISTED	Stock	7.255	7.415	7.155	7.265	306860.0
2011-07-25	ABE-DELISTED	Stock	19.21	19.42	19.21	19.38	14428.0
2011-07-25	ABEO	Stock	2975.0	2975.0	2637.5	2975.0	30.0
2011-07-25	ABFS-DELISTED	Stock	25.51	25.83	25.25	25.45	330668.0
2011-07-25	ABG	Stock	20.08	20.4	19.95	20.1	270800.0
2011-07-25	ABH-DELISTED	Stock	19.16	19.58	19.11	19.23	356368.0
2011-07-25	ABM	Stock	23.44	23.57	23.17	23.19	188500.0
2011-07-25	ABMD-DELISTED	Stock	16.73	16.76	16.42	16.43	84790.0
2011-07-25	ABR	Stock	4.6	4.63	4.46	4.46	60100.0
2011-07-25	ABT	Stock	25.2855	25.5254	25.1847	25.2279	14621301.0
2011-07-25	ABTL-DELISTED	Stock	5.252	5.354	5.099	5.15	15663.0
2011-07-25	ABUS	Stock	2.6	2.6	2.56	2.56	4500.0
2011-07-25	ABV-DELISTED	Stock	31.74	31.95	31.33	31.52	1664259.0
2011-07-25	ABVA-DELISTED	Stock	4.54	4.54	4.38	4.389	1800.0
2011-07-25	ABVT-DELISTED	Stock	63.0	63.48	62.8508	63.27	139954.0

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

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