PREVIEW / stock_daily / 2011-04-26

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-26.parquet
  size:    198 KB
  rows:    6,128
  symbols: 3,580

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-04-26	AAPL	Stock	12.6293	12.6782	12.4768	12.515	338800000.0
2011-04-26	MSFT	Stock	25.74	26.44	25.67	26.19	69200000.0
2011-04-26	NVDA	Stock	0.4742	0.4872	0.4695	0.4825	676000000.0
2011-04-26	AMZN	Stock	9.3135	9.321	9.037	9.115	224000000.0
2011-04-26	TSLA	Stock	1.7773	1.8167	1.754	1.7953	21000000.0
2011-04-26	TLT	Stock	93.27	93.87	93.18	93.85	7507239.0
2011-04-26	ES	Stock	34.75	35.09	34.67	34.79	1900000.0
2011-04-26	CL	Stock	40.03	40.415	40.0	40.275	6781600.0
2011-04-26	A	Stock	34.6423	35.9371	34.6352	35.3362	6710400.0
2011-04-26	AABA-DELISTED	Stock	17.14	17.37	17.02	17.29	17312827.0
2011-04-26	AACC-DELISTED	Stock	5.6	5.9	5.6	5.87	9500.0
2011-04-26	AACG	Stock	8.0	8.19	7.88	7.88	24100.0
2011-04-26	AAI-DELISTED	Stock	7.44	7.51	7.43	7.49	6524389.0
2011-04-26	AAIC-DELISTED	Stock	30.2999	30.89	30.27	30.82	28569.0
2011-04-26	AAME	Stock	2.05	2.06	2.0	2.05	1700.0
2011-04-26	AAON	Stock	6.5185	6.5896	6.5047	6.5442	151369.0
2011-04-26	AAP	Stock	65.95	66.45	65.75	65.91	548200.0
2011-04-26	AAT	Stock	21.77	22.05	21.66	21.95	191700.0
2011-04-26	AATI-DELISTED	Stock	4.22	4.36	4.22	4.34	149583.0
2011-04-26	AAU-DELISTED	Stock	4.41	4.84	4.26	4.75	1247956.0
2011-04-26	AAUAF-DELISTED	Stock	4.41	4.84	4.26	4.71	1248956.0
2011-04-26	AAV-DELISTED	Stock	8.31	8.51	8.22	8.47	439453.0
2011-04-26	AAWW-DELISTED	Stock	65.38	68.37	64.92	67.34	274549.0
2011-04-26	AAXJ	Stock	64.6	64.85	64.38	64.69	200977.0
2011-04-26	AAXN-DELISTED	Stock	4.46	4.5	4.27	4.4	1058443.0
2011-04-26	AB	Stock	21.62	22.12	21.6	22.05	320400.0
2011-04-26	ABAC-DELISTED	Stock	3.58	3.58	3.47	3.5	36496.0
2011-04-26	ABAX-DELISTED	Stock	28.65	29.7	28.6116	28.95	88894.0
2011-04-26	ABB-DELISTED	Stock	25.63	25.94	25.42	25.86	3127538.0
2011-04-26	ABBC-DELISTED	Stock	12.2	12.46	12.17	12.36	31997.0
2011-04-26	ABBNY-DELISTED	Stock	25.63	25.94	25.42	25.88	3385570.0
2011-04-26	ABC-DELISTED	Stock	41.21	41.53	40.81	41.05	1783477.0
2011-04-26	ABCB	Stock	9.65	10.0	9.63	9.91	33000.0
2011-04-26	ABCD-DELISTED	Stock	3.33	3.45	3.33	3.45	32501.0
2011-04-26	ABCO-DELISTED	Stock	22.71	23.63	22.71	23.15	130472.0
2011-04-26	ABCW-DELISTED	Stock	0.8575	0.8575	0.8176	0.8225	67610.0
2011-04-26	ABD-DELISTED	Stock	9.73	9.88	9.63	9.65	168550.0
2011-04-26	ABE-DELISTED	Stock	19.13	19.1899	19.04	19.1899	7527.0
2011-04-26	ABEO	Stock	2875.0	2875.0	2750.0	2750.0	9.0
2011-04-26	ABFS-DELISTED	Stock	23.52	23.63	22.36	22.72	1306327.0
2011-04-26	ABG	Stock	18.0	18.12	16.88	16.94	679900.0
2011-04-26	ABH-DELISTED	Stock	25.65	25.89	25.57	25.64	493375.0
2011-04-26	ABM	Stock	24.07	24.16	23.92	24.03	247500.0
2011-04-26	ABMD-DELISTED	Stock	16.42	16.92	16.28	16.72	128820.0
2011-04-26	ABR	Stock	5.07	5.4	5.07	5.34	48800.0
2011-04-26	ABT	Stock	24.5514	24.8728	24.465	24.8392	15214673.0
2011-04-26	ABTL-DELISTED	Stock	7.0	7.151	6.84	6.95	38179.0
2011-04-26	ABUS	Stock	3.13	3.14	3.11	3.13	4000.0
2011-04-26	ABV-DELISTED	Stock	31.71	32.32	31.62	32.29	2295956.0
2011-04-26	ABVA-DELISTED	Stock	6.65	6.659	6.61	6.6346	5539.0

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

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