PREVIEW / stock_daily / 2011-10-11

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-11.parquet
  size:    193 KB
  rows:    6,061
  symbols: 3,508

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-10-11	AAPL	Stock	14.0204	14.3993	13.9821	14.2961	605687600.0
2011-10-11	MSFT	Stock	26.86	27.07	26.72	27.0	38826200.0
2011-10-11	NVDA	Stock	0.3665	0.3725	0.3642	0.3655	816080000.0
2011-10-11	AMZN	Stock	11.53	11.8375	11.45	11.774	100074000.0
2011-10-11	TSLA	Stock	1.834	1.8513	1.806	1.8407	8635500.0
2011-10-11	TLT	Stock	117.29	117.36	115.9	116.18	7520113.0
2011-10-11	ES	Stock	32.76	32.82	32.23	32.31	1870500.0
2011-10-11	CL	Stock	45.795	45.805	45.075	45.175	4008000.0
2011-10-11	A	Stock	23.5122	24.3991	23.2904	24.2704	5474009.0
2011-10-11	AABA-DELISTED	Stock	15.79	15.95	15.59	15.86	17965490.0
2011-10-11	AACC-DELISTED	Stock	3.09	3.1	3.03	3.04	12076.0
2011-10-11	AACG	Stock	8.69	8.69	8.1	8.46	8200.0
2011-10-11	AAIC-DELISTED	Stock	24.44	24.68	24.09	24.53	44068.0
2011-10-11	AAME	Stock	1.83	1.83	1.76	1.8	2100.0
2011-10-11	AAON	Stock	5.3481	5.3985	5.1289	5.2385	225788.0
2011-10-11	AAP	Stock	60.85	61.11	60.09	60.95	428600.0
2011-10-11	AAT	Stock	17.6	17.82	17.25	17.36	185900.0
2011-10-11	AATI-DELISTED	Stock	4.45	4.48	4.435	4.46	250203.0
2011-10-11	AAU-DELISTED	Stock	2.71	2.76	2.55	2.67	80310.0
2011-10-11	AAUAF-DELISTED	Stock	2.71	2.76	2.55	2.67	82310.0
2011-10-11	AAV-DELISTED	Stock	4.18	4.48	4.18	4.45	562811.0
2011-10-11	AAWW-DELISTED	Stock	34.5	35.62	34.48	35.12	195199.0
2011-10-11	AAXJ	Stock	49.42	50.41	49.32	50.21	1084477.0
2011-10-11	AAXN-DELISTED	Stock	4.51	4.65	4.51	4.61	437315.0
2011-10-11	AB	Stock	13.75	14.03	13.7	13.9	280700.0
2011-10-11	ABAC-DELISTED	Stock	1.8	1.8	1.78	1.78	7619.0
2011-10-11	ABAX-DELISTED	Stock	23.3	23.81	23.3	23.6	105366.0
2011-10-11	ABB-DELISTED	Stock	18.58	18.83	18.48	18.8	2269973.0
2011-10-11	ABBNY-DELISTED	Stock	18.58	18.83	18.48	18.8	2298307.0
2011-10-11	ABC-DELISTED	Stock	36.74	37.13	36.65	37.03	1274871.0
2011-10-11	ABCB	Stock	9.31	9.52	9.25	9.43	55700.0
2011-10-11	ABCD-DELISTED	Stock	2.99	3.05	2.99	3.04	37848.0
2011-10-11	ABCO-DELISTED	Stock	31.65	32.5	31.43	31.43	322188.0
2011-10-11	ABCW-DELISTED	Stock	0.5	0.52	0.4864	0.52	30630.0
2011-10-11	ABD-DELISTED	Stock	5.23	5.4059	5.18	5.37	288790.0
2011-10-11	ABE-DELISTED	Stock	17.12	17.4	17.12	17.26	3583.0
2011-10-11	ABEO	Stock	2125.0	2187.5	2062.5	2137.5	8.0
2011-10-11	ABFS-DELISTED	Stock	16.74	16.81	16.46	16.72	499308.0
2011-10-11	ABG	Stock	18.68	19.22	18.23	19.07	365700.0
2011-10-11	ABH-DELISTED	Stock	15.83	16.31	15.61	15.95	154812.0
2011-10-11	ABM	Stock	19.84	20.13	19.69	19.94	218600.0
2011-10-11	ABMD-DELISTED	Stock	12.01	12.1	11.61	11.71	94010.0
2011-10-11	ABR	Stock	3.24	3.35	3.2	3.32	48400.0
2011-10-11	ABT	Stock	25.2183	25.3718	25.1031	25.2855	48235723.0
2011-10-11	ABTL-DELISTED	Stock	4.4	4.4	4.0505	4.2	6965.0
2011-10-11	ABUS	Stock	1.85	1.85	1.85	1.85	21500.0
2011-10-11	ABV-DELISTED	Stock	32.35	32.84	32.09	32.62	1882372.0
2011-10-11	ABVA-DELISTED	Stock	4.9	4.96	4.9	4.95	4494.0
2011-10-11	ABVT-DELISTED	Stock	57.12	57.71	56.59	57.54	105074.0
2011-10-11	ABX-DELISTED	Stock	47.81	48.07	47.06	47.86	4098734.0

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

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