PREVIEW / stock_daily / 2011-08-17

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-17.parquet
  size:    194 KB
  rows:    6,084
  symbols: 3,526

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-08-17	AAPL	Stock	13.6539	13.7329	13.5	13.5871	442061200.0
2011-08-17	MSFT	Stock	25.25	25.7	24.93	25.25	50923700.0
2011-08-17	NVDA	Stock	0.3258	0.3313	0.316	0.3203	553328000.0
2011-08-17	AMZN	Stock	9.9265	9.98	9.687	9.7965	79822000.0
2011-08-17	TSLA	Stock	1.7593	1.7767	1.7007	1.722	9655500.0
2011-08-17	TLT	Stock	106.32	108.1	105.77	108.09	15906542.0
2011-08-17	ES	Stock	33.22	33.67	33.0	33.18	1800000.0
2011-08-17	CL	Stock	43.25	43.54	42.745	43.155	3630000.0
2011-08-17	A	Stock	26.3734	26.6452	25.1645	25.608	6578289.0
2011-08-17	AABA-DELISTED	Stock	13.49	13.62	13.32	13.48	16649337.0
2011-08-17	AACC-DELISTED	Stock	4.39	4.5	4.1	4.41	27567.0
2011-08-17	AACG	Stock	9.35	9.35	9.2	9.26	1500.0
2011-08-17	AAIC-DELISTED	Stock	26.16	26.61	26.1	26.28	23371.0
2011-08-17	AAME	Stock	1.9	1.91	1.87	1.9	3300.0
2011-08-17	AAON	Stock	5.6652	5.7511	5.4015	5.4074	341888.0
2011-08-17	AAP	Stock	56.11	56.92	55.92	56.74	1330800.0
2011-08-17	AAT	Stock	19.49	20.01	19.38	19.88	127100.0
2011-08-17	AATI-DELISTED	Stock	5.9	5.95	5.86	5.88	649294.0
2011-08-17	AAU-DELISTED	Stock	3.27	3.345	3.23	3.25	120247.0
2011-08-17	AAUAF-DELISTED	Stock	3.26	3.34	3.23	3.26	121219.0
2011-08-17	AAV-DELISTED	Stock	5.77	5.93	5.74	5.83	628021.0
2011-08-17	AAWW-DELISTED	Stock	43.37	43.81	42.86	43.77	261533.0
2011-08-17	AAXJ	Stock	56.19	56.73	55.76	55.97	1157996.0
2011-08-17	AAXN-DELISTED	Stock	4.02	4.14	4.0	4.08	346872.0
2011-08-17	AB	Stock	14.31	14.5	14.14	14.38	314300.0
2011-08-17	ABAC-DELISTED	Stock	2.3	2.389	2.25	2.3	11628.0
2011-08-17	ABAX-DELISTED	Stock	23.23	23.89	23.09	23.68	141193.0
2011-08-17	ABB-DELISTED	Stock	21.72	21.86	21.269	21.38	3377924.0
2011-08-17	ABBC-DELISTED	Stock	8.42	8.5	8.26	8.33	28118.0
2011-08-17	ABBNY-DELISTED	Stock	21.72	21.86	21.269	21.37	3698824.0
2011-08-17	ABC-DELISTED	Stock	38.49	38.95	38.305	38.67	2128418.0
2011-08-17	ABCB	Stock	8.98	9.08	8.95	9.04	42800.0
2011-08-17	ABCD-DELISTED	Stock	2.86	3.03	2.85	2.96	30804.0
2011-08-17	ABCO-DELISTED	Stock	29.03	29.8	29.01	29.74	314340.0
2011-08-17	ABCW-DELISTED	Stock	0.6487	0.6587	0.6098	0.6113	23520.0
2011-08-17	ABD-DELISTED	Stock	6.75	6.79	6.4996	6.59	205480.0
2011-08-17	ABE-DELISTED	Stock	17.98	18.25	17.85	18.25	15522.0
2011-08-17	ABFS-DELISTED	Stock	21.41	21.42	20.33	20.42	296956.0
2011-08-17	ABG	Stock	18.1	18.39	17.01	17.57	363700.0
2011-08-17	ABH-DELISTED	Stock	16.84	17.19	16.72	17.02	364695.0
2011-08-17	ABM	Stock	19.52	19.6	19.06	19.35	103600.0
2011-08-17	ABMD-DELISTED	Stock	12.15	12.6	12.07	12.53	190241.0
2011-08-17	ABR	Stock	3.92	4.02	3.91	3.98	50100.0
2011-08-17	ABT	Stock	24.0428	24.2395	23.8077	24.062	10360984.0
2011-08-17	ABTL-DELISTED	Stock	4.4423	4.7454	4.4398	4.5	16350.0
2011-08-17	ABUS	Stock	2.36	2.36	2.15	2.16	1800.0
2011-08-17	ABV-DELISTED	Stock	33.11	33.45	32.87	33.19	3195502.0
2011-08-17	ABVT-DELISTED	Stock	59.36	59.36	57.01	58.05	211952.0
2011-08-17	ABX-DELISTED	Stock	50.07	51.03	50.01	50.44	5920422.0
2011-08-17	ACAD	Stock	1.5	1.52	1.48	1.51	134000.0

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

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