PREVIEW / stock_daily / 2011-02-23

all stock daily files

  file:    by_date/stock_daily/2011/2011-02-23.parquet
  size:    198 KB
  rows:    6,094
  symbols: 3,560

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-02-23	AAPL	Stock	12.0989	12.3086	12.0932	12.2364	671854400.0
2011-02-23	MSFT	Stock	26.53	26.86	26.43	26.59	60234100.0
2011-02-23	NVDA	Stock	0.5802	0.5858	0.5445	0.5528	1491604000.0
2011-02-23	AMZN	Stock	9.0125	9.0575	8.7195	8.834	109640000.0
2011-02-23	TSLA	Stock	1.4787	1.5	1.4073	1.4553	24084000.0
2011-02-23	TLT	Stock	91.1	91.55	90.74	91.16	14522987.0
2011-02-23	ES	Stock	33.5	33.69	33.3	33.3	1721200.0
2011-02-23	CL	Stock	39.325	39.555	39.07	39.185	4921400.0
2011-02-23	A	Stock	30.4435	30.5794	28.5694	28.9342	9889732.0
2011-02-23	AABA-DELISTED	Stock	17.03	17.1	16.35	16.58	35000766.0
2011-02-23	AACC-DELISTED	Stock	5.71	5.75	5.65	5.65	5866.0
2011-02-23	AACG	Stock	5.0	5.0	4.9	4.98	22600.0
2011-02-23	AAI-DELISTED	Stock	7.34	7.35	7.3	7.32	2603118.0
2011-02-23	AAIC-DELISTED	Stock	27.4	27.8533	27.4	27.5	49577.0
2011-02-23	AAME	Stock	2.06	2.06	1.97	2.06	700.0
2011-02-23	AAON	Stock	5.837	6.0207	5.837	5.9615	272362.0
2011-02-23	AAP	Stock	61.31	61.9	60.35	60.7	1231700.0
2011-02-23	AAT	Stock	21.21	21.49	20.9	21.22	171700.0
2011-02-23	AATI-DELISTED	Stock	4.27	4.3299	4.2	4.25	262370.0
2011-02-23	AAU-DELISTED	Stock	4.05	4.14	3.94	4.09	281009.0
2011-02-23	AAUAF-DELISTED	Stock	4.05	4.14	3.94	4.08	282009.0
2011-02-23	AAV-DELISTED	Stock	7.69	7.7163	7.57	7.67	325900.0
2011-02-23	AAWW-DELISTED	Stock	68.54	69.36	64.63	66.96	444618.0
2011-02-23	AAXJ	Stock	59.75	59.78	58.96	59.46	555230.0
2011-02-23	AAXN-DELISTED	Stock	4.06	4.12	3.9	3.96	938647.0
2011-02-23	AB	Stock	22.22	22.71	21.61	21.71	782900.0
2011-02-23	ABAC-DELISTED	Stock	4.61	4.97	4.59	4.76	195134.0
2011-02-23	ABAX-DELISTED	Stock	26.21	26.29	25.62	25.73	121335.0
2011-02-23	ABB-DELISTED	Stock	23.76	23.84	23.45	23.61	3576358.0
2011-02-23	ABBC-DELISTED	Stock	12.93	12.99	12.63	12.74	300232.0
2011-02-23	ABBNY-DELISTED	Stock	23.76	23.84	23.45	23.59	3951876.0
2011-02-23	ABC-DELISTED	Stock	37.3	37.3	36.62	36.86	2335549.0
2011-02-23	ABCB	Stock	9.83	9.97	9.83	9.92	58700.0
2011-02-23	ABCD-DELISTED	Stock	3.66	3.73	3.66	3.69	37719.0
2011-02-23	ABCO-DELISTED	Stock	25.71	25.83	25.34	25.42	235770.0
2011-02-23	ABCW-DELISTED	Stock	1.19	1.19	1.16	1.16	125820.0
2011-02-23	ABD-DELISTED	Stock	8.6	8.65	8.09	8.23	221040.0
2011-02-23	ABE-DELISTED	Stock	17.81	17.9	17.4	17.71	14791.0
2011-02-23	ABEO	Stock	2925.0	3000.0	2875.0	2987.5	27.0
2011-02-23	ABFS-DELISTED	Stock	24.6	24.68	23.87	23.98	226357.0
2011-02-23	ABG	Stock	19.36	19.5	18.13	18.42	326600.0
2011-02-23	ABH-DELISTED	Stock	28.15	28.16	26.32	27.24	1105699.0
2011-02-23	ABM	Stock	26.72	26.78	25.99	26.06	234600.0
2011-02-23	ABMD-DELISTED	Stock	12.84	12.92	12.21	12.31	291064.0
2011-02-23	ABR	Stock	6.2	6.32	6.1	6.2	35900.0
2011-02-23	ABT	Stock	22.4882	22.5458	22.2387	22.2963	21472072.0
2011-02-23	ABTL-DELISTED	Stock	5.9	5.9	5.6	5.9	58579.0
2011-02-23	ABUS	Stock	5.05	5.19	4.9	5.0	12600.0
2011-02-23	ABV-DELISTED	Stock	27.05	27.15	26.28	26.38	3903096.0
2011-02-23	ABVT-DELISTED	Stock	60.42	60.86	59.45	59.47	65455.0

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

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