PREVIEW / stock_daily / 2011-10-25

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-25.parquet
  size:    194 KB
  rows:    6,039
  symbols: 3,494

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-25	AAPL	Stock	14.4654	14.5196	14.1921	14.2061	430427200.0
2011-10-25	MSFT	Stock	27.08	27.23	26.72	26.81	53554600.0
2011-10-25	NVDA	Stock	0.3703	0.3733	0.3605	0.3612	577996000.0
2011-10-25	AMZN	Stock	11.9295	11.9505	11.2945	11.3575	280252000.0
2011-10-25	TSLA	Stock	1.882	1.924	1.8533	1.8833	9816000.0
2011-10-25	TLT	Stock	113.38	116.35	113.35	116.2	11791365.0
2011-10-25	ES	Stock	33.76	34.06	33.4	33.42	1270600.0
2011-10-25	CL	Stock	45.625	45.65	44.875	44.99	6079600.0
2011-10-25	A	Stock	26.4306	26.7454	25.6223	25.701	7371095.0
2011-10-25	AABA-DELISTED	Stock	16.69	16.7	16.18	16.23	23840750.0
2011-10-25	AACC-DELISTED	Stock	3.23	3.35	3.05	3.05	8754.0
2011-10-25	AACG	Stock	9.47	9.47	8.94	9.42	3000.0
2011-10-25	AAIC-DELISTED	Stock	24.5	24.7	24.28	24.41	22879.0
2011-10-25	AAME	Stock	1.84	1.89	1.69	1.88	7000.0
2011-10-25	AAON	Stock	5.8489	5.8667	5.6385	5.6711	190688.0
2011-10-25	AAP	Stock	63.22	63.9	63.2	63.54	439300.0
2011-10-25	AAT	Stock	19.94	20.14	19.55	19.64	142900.0
2011-10-25	AATI-DELISTED	Stock	4.47	4.47	4.38	4.4	215053.0
2011-10-25	AAU-DELISTED	Stock	2.58	2.66	2.45	2.54	398185.0
2011-10-25	AAUAF-DELISTED	Stock	2.58	2.66	2.45	2.53	399185.0
2011-10-25	AAV-DELISTED	Stock	5.22	5.25	4.9999	5.03	443908.0
2011-10-25	AAWW-DELISTED	Stock	38.94	38.94	37.42	37.71	171627.0
2011-10-25	AAXJ	Stock	52.64	52.79	52.04	52.21	471677.0
2011-10-25	AAXN-DELISTED	Stock	4.83	4.9	4.76	4.84	471088.0
2011-10-25	AB	Stock	14.31	14.45	14.01	14.25	436500.0
2011-10-25	ABAC-DELISTED	Stock	1.37	1.44	1.32	1.35	37308.0
2011-10-25	ABAX-DELISTED	Stock	24.9	24.94	24.34	24.72	151846.0
2011-10-25	ABB-DELISTED	Stock	19.6	19.68	19.242	19.39	2144503.0
2011-10-25	ABBNY-DELISTED	Stock	19.6	19.68	19.242	19.4	2178903.0
2011-10-25	ABC-DELISTED	Stock	40.26	40.65	39.55	39.62	1877400.0
2011-10-25	ABCB	Stock	9.52	9.65	9.4	9.49	216500.0
2011-10-25	ABCD-DELISTED	Stock	3.3	3.3	3.16	3.19	36935.0
2011-10-25	ABCO-DELISTED	Stock	31.08	31.4	30.46	30.54	232140.0
2011-10-25	ABCW-DELISTED	Stock	0.491	0.5378	0.489	0.489	25520.0
2011-10-25	ABD-DELISTED	Stock	5.91	5.98	5.71	5.8	239470.0
2011-10-25	ABE-DELISTED	Stock	17.7	17.7	17.4	17.4	5316.0
2011-10-25	ABEO	Stock	2162.5	2187.5	2050.0	2187.5	20.0
2011-10-25	ABFS-DELISTED	Stock	19.14	19.195	18.62	18.69	205702.0
2011-10-25	ABG	Stock	20.43	20.46	19.71	19.8	455900.0
2011-10-25	ABH-DELISTED	Stock	16.48	16.56	16.17	16.18	313307.0
2011-10-25	ABM	Stock	20.22	20.22	19.54	19.58	202300.0
2011-10-25	ABMD-DELISTED	Stock	12.38	12.86	12.25	12.78	239624.0
2011-10-25	ABR	Stock	3.57	3.68	3.5	3.61	51000.0
2011-10-25	ABT	Stock	25.6645	25.8324	25.4006	25.4246	20117757.0
2011-10-25	ABUS	Stock	1.7	1.7	1.67	1.7	13900.0
2011-10-25	ABV-DELISTED	Stock	33.84	33.84	33.25	33.56	2482131.0
2011-10-25	ABVA-DELISTED	Stock	5.1	5.19	5.08	5.17	107800.0
2011-10-25	ABVT-DELISTED	Stock	57.44	58.17	56.35	56.46	88719.0
2011-10-25	ABX-DELISTED	Stock	46.35	47.89	45.6	47.2	8612142.0
2011-10-25	ACAD	Stock	1.14	1.17	1.13	1.13	145500.0

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

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