PREVIEW / stock_daily / 2011-08-16

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-16.parquet
  size:    195 KB
  rows:    6,083
  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-16	AAPL	Stock	13.6257	13.6918	13.4307	13.5886	498750000.0
2011-08-16	MSFT	Stock	25.22	25.59	25.05	25.35	54251500.0
2011-08-16	NVDA	Stock	0.3305	0.335	0.3188	0.3248	716868000.0
2011-08-16	AMZN	Stock	10.057	10.0695	9.7375	9.884	104118000.0
2011-08-16	TSLA	Stock	1.742	1.7693	1.722	1.74	8065500.0
2011-08-16	TLT	Stock	104.66	106.64	104.6325	106.23	15993120.0
2011-08-16	ES	Stock	32.91	33.2	32.67	33.05	2462500.0
2011-08-16	CL	Stock	42.825	43.43	42.72	43.11	4065200.0
2011-08-16	A	Stock	26.4449	27.2747	25.7725	26.2017	10777182.0
2011-08-16	AABA-DELISTED	Stock	13.34	13.57	13.18	13.49	25453036.0
2011-08-16	AACC-DELISTED	Stock	4.26	4.67	4.02	4.3	55154.0
2011-08-16	AACG	Stock	9.48	9.55	9.15	9.19	3300.0
2011-08-16	AAIC-DELISTED	Stock	26.0	26.12	25.63	25.99	57091.0
2011-08-16	AAME	Stock	1.87	1.9	1.82	1.9	3700.0
2011-08-16	AAON	Stock	5.683	5.7807	5.6296	5.6444	300038.0
2011-08-16	AAP	Stock	55.69	56.23	55.13	55.64	1574300.0
2011-08-16	AAT	Stock	19.47	19.47	18.92	19.4	259900.0
2011-08-16	AATI-DELISTED	Stock	5.9	5.92	5.85	5.88	618161.0
2011-08-16	AAU-DELISTED	Stock	3.35	3.3899	3.16	3.23	245661.0
2011-08-16	AAUAF-DELISTED	Stock	3.35	3.3899	3.16	3.21	245961.0
2011-08-16	AAV-DELISTED	Stock	5.86	5.86	5.63	5.68	546991.0
2011-08-16	AAWW-DELISTED	Stock	44.1	44.45	43.09	43.36	179462.0
2011-08-16	AAXJ	Stock	56.07	56.56	55.64	56.13	265503.0
2011-08-16	AAXN-DELISTED	Stock	3.92	4.1	3.91	4.0	363085.0
2011-08-16	AB	Stock	14.5	14.62	14.13	14.26	227600.0
2011-08-16	ABAC-DELISTED	Stock	2.56	2.79	2.4	2.4072	85605.0
2011-08-16	ABAX-DELISTED	Stock	24.0	24.0	22.695	23.12	238590.0
2011-08-16	ABB-DELISTED	Stock	21.58	21.81	21.29	21.49	2615730.0
2011-08-16	ABBC-DELISTED	Stock	8.36	8.5	8.22	8.25	60942.0
2011-08-16	ABBNY-DELISTED	Stock	21.58	21.81	21.29	21.48	2624628.0
2011-08-16	ABC-DELISTED	Stock	38.61	38.72	37.9	38.51	3824295.0
2011-08-16	ABCB	Stock	9.08	9.13	8.75	8.98	90900.0
2011-08-16	ABCD-DELISTED	Stock	2.91	3.03	2.83	2.89	51748.0
2011-08-16	ABCO-DELISTED	Stock	28.44	29.08	28.36	28.84	127182.0
2011-08-16	ABCW-DELISTED	Stock	0.61	0.65	0.61	0.65	10860.0
2011-08-16	ABD-DELISTED	Stock	6.75	6.8	6.5	6.69	190550.0
2011-08-16	ABE-DELISTED	Stock	17.98	18.08	17.81	18.08	7712.0
2011-08-16	ABEO	Stock	2687.5	2750.0	2437.5	2687.5	5.0
2011-08-16	ABFS-DELISTED	Stock	21.34	21.52	20.8	21.19	408764.0
2011-08-16	ABG	Stock	17.9	18.07	17.34	17.91	362700.0
2011-08-16	ABH-DELISTED	Stock	16.91	17.06	16.68	16.78	722571.0
2011-08-16	ABM	Stock	19.31	19.54	19.03	19.37	202400.0
2011-08-16	ABMD-DELISTED	Stock	12.19	12.35	11.98	12.05	237149.0
2011-08-16	ABR	Stock	3.94	3.99	3.87	3.94	43500.0
2011-08-16	ABT	Stock	23.8748	24.1915	23.6206	24.0236	15011255.0
2011-08-16	ABTL-DELISTED	Stock	4.1114	4.4984	3.9663	4.45	80050.0
2011-08-16	ABUS	Stock	2.14	2.35	2.14	2.35	1100.0
2011-08-16	ABV-DELISTED	Stock	31.83	33.13	31.75	32.96	5368770.0
2011-08-16	ABVA-DELISTED	Stock	4.63	4.7469	4.501	4.65	12240.0
2011-08-16	ABVT-DELISTED	Stock	60.2	60.23	58.95	59.44	146981.0

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

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