PREVIEW / stock_daily / 2012-05-17

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-17.parquet
  size:    200 KB
  rows:    6,175
  symbols: 3,541

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
2012-05-17	AAPL	Stock	19.4754	19.5536	18.9329	18.9329	717220000.0
2012-05-17	MSFT	Stock	29.99	30.21	29.71	29.72	48484000.0
2012-05-17	NVDA	Stock	0.3198	0.3228	0.3163	0.3163	335364000.0
2012-05-17	AMZN	Stock	11.2525	11.3	10.9045	10.918	90110000.0
2012-05-17	TSLA	Stock	1.9533	1.986	1.8827	1.9047	17235000.0
2012-05-17	TLT	Stock	122.03	124.28	122.02	124.17	14863875.0
2012-05-17	ES	Stock	35.63	35.63	35.1	35.1	1674500.0
2012-05-17	CL	Stock	50.605	50.69	49.905	49.905	4256200.0
2012-05-17	A	Stock	29.9714	29.9785	28.3405	28.3476	6900248.0
2012-05-17	AABA-DELISTED	Stock	15.26	15.37	14.85	14.87	16426558.0
2012-05-17	AACC-DELISTED	Stock	5.82	5.8791	5.541	5.64	27406.0
2012-05-17	AACG	Stock	6.76	6.8	6.75	6.8	11900.0
2012-05-17	AAIC-DELISTED	Stock	23.24	23.55	22.791	22.86	67179.0
2012-05-17	AAME	Stock	2.75	2.75	2.66	2.73	3200.0
2012-05-17	AAMRQ-DELISTED	Stock	0.501	0.509	0.491	0.502	1425110.0
2012-05-17	AAON	Stock	5.68	5.7511	5.5793	5.6237	184275.0
2012-05-17	AAP	Stock	72.28	73.8	67.22	68.17	6813900.0
2012-05-17	AAT	Stock	23.61	23.65	23.25	23.3	104700.0
2012-05-17	AAU-DELISTED	Stock	1.81	1.97	1.8	1.82	151615.0
2012-05-17	AAUAF-DELISTED	Stock	1.81	1.97	1.8	1.82	152415.0
2012-05-17	AAV-DELISTED	Stock	2.93	2.96	2.82	2.82	309430.0
2012-05-17	AAWW-DELISTED	Stock	47.0	47.2	45.54	45.79	322955.0
2012-05-17	AAXJ	Stock	51.3	51.41	50.74	50.74	750104.0
2012-05-17	AAXN-DELISTED	Stock	5.18	5.32	5.04	5.06	790744.0
2012-05-17	AB	Stock	14.39	14.59	14.07	14.15	184400.0
2012-05-17	ABAC-DELISTED	Stock	1.32	1.42	1.31	1.42	4320.0
2012-05-17	ABAX-DELISTED	Stock	34.2	34.35	33.47	33.57	75587.0
2012-05-17	ABB-DELISTED	Stock	16.3	16.35	16.02	16.09	3100787.0
2012-05-17	ABBNY-DELISTED	Stock	16.3	16.35	16.02	16.07	3133828.0
2012-05-17	ABC-DELISTED	Stock	36.51	36.76	36.44	36.45	2453328.0
2012-05-17	ABCB	Stock	11.76	11.78	11.32	11.47	89600.0
2012-05-17	ABCD-DELISTED	Stock	1.47	1.47	1.3201	1.37	34755.0
2012-05-17	ABCO-DELISTED	Stock	47.5	47.83	46.97	47.33	245753.0
2012-05-17	ABCW-DELISTED	Stock	0.5824	0.5824	0.4518	0.502	21690.0
2012-05-17	ABE-DELISTED	Stock	18.28	18.3	18.118	18.26	994.0
2012-05-17	ABEO	Stock	700.0	800.0	562.5	562.5	288.0
2012-05-17	ABFS-DELISTED	Stock	13.08	13.3	12.63	12.65	333858.0
2012-05-17	ABG	Stock	25.82	25.93	25.24	25.35	642000.0
2012-05-17	ABH-DELISTED	Stock	10.55	10.72	10.15	10.27	602560.0
2012-05-17	ABM	Stock	22.87	22.94	22.04	22.1	245700.0
2012-05-17	ABMD-DELISTED	Stock	23.39	23.69	22.9208	23.17	651229.0
2012-05-17	ABR	Stock	6.21	6.33	6.11	6.16	47700.0
2012-05-17	ABT	Stock	29.9491	30.1314	29.8436	29.858	12340142.0
2012-05-17	ABTL-DELISTED	Stock	3.9005	4.0118	3.8448	3.85	21251.0
2012-05-17	ABUS	Stock	2.16	2.16	2.05	2.13	2800.0
2012-05-17	ABV-DELISTED	Stock	38.74	38.91	38.35	38.66	3906803.0
2012-05-17	ABVA-DELISTED	Stock	4.29	4.3	4.28	4.3	7100.0
2012-05-17	ABVT-DELISTED	Stock	83.25	83.28	83.12	83.12	716811.0
2012-05-17	ABX-DELISTED	Stock	35.59	37.67	35.57	37.38	14843556.0
2012-05-17	ACAD	Stock	1.55	1.55	1.48	1.5	385000.0

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

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