PREVIEW / stock_daily / 2012-07-27

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-27.parquet
  size:    199 KB
  rows:    6,143
  symbols: 3,492

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-07-27	AAPL	Stock	20.5361	20.9225	20.4139	20.8986	403936400.0
2012-07-27	MSFT	Stock	29.48	29.85	29.18	29.76	44242600.0
2012-07-27	NVDA	Stock	0.33	0.338	0.3275	0.337	376516000.0
2012-07-27	AMZN	Stock	11.2625	11.917	11.225	11.866	226278000.0
2012-07-27	META	Stock	23.19	24.54	22.28	23.71	123102300.0
2012-07-27	TSLA	Stock	1.914	1.9773	1.8733	1.9673	25095000.0
2012-07-27	TLT	Stock	129.89	130.01	126.96	128.48	14685589.0
2012-07-27	ES	Stock	40.39	40.53	39.79	39.96	2897900.0
2012-07-27	CL	Stock	52.405	53.84	52.345	53.585	6594800.0
2012-07-27	A	Stock	26.3591	27.2818	26.2446	27.1388	4033789.0
2012-07-27	AABA-DELISTED	Stock	15.88	16.17	15.84	16.11	14198992.0
2012-07-27	AACC-DELISTED	Stock	6.03	6.12	5.95	6.09	42251.0
2012-07-27	AACG	Stock	3.71	3.95	3.71	3.83	8800.0
2012-07-27	AAIC-DELISTED	Stock	22.19	22.58	22.04	22.48	44353.0
2012-07-27	AAME	Stock	2.7	2.7	2.68	2.7	2800.0
2012-07-27	AAMRQ-DELISTED	Stock	0.519	0.54	0.5	0.504	1128873.0
2012-07-27	AAON	Stock	5.4341	5.6059	5.4311	5.5733	184613.0
2012-07-27	AAP	Stock	70.03	70.43	69.18	69.61	2205000.0
2012-07-27	AAT	Stock	25.49	26.12	25.46	25.87	121200.0
2012-07-27	AAU-DELISTED	Stock	1.95	2.1088	1.941	2.07	156854.0
2012-07-27	AAUAF-DELISTED	Stock	1.99	2.1495	1.9789	2.07	154174.0
2012-07-27	AAV-DELISTED	Stock	3.59	3.79	3.57	3.7	382461.0
2012-07-27	AAWW-DELISTED	Stock	44.01	45.59	43.7793	45.38	99792.0
2012-07-27	AAXJ	Stock	52.08	53.02	52.01	52.85	387004.0
2012-07-27	AAXN-DELISTED	Stock	5.35	5.49	5.23	5.36	603883.0
2012-07-27	AB	Stock	12.11	12.4	11.99	12.27	139000.0
2012-07-27	ABAC-DELISTED	Stock	1.06	1.1	1.0	1.0	13399.0
2012-07-27	ABAX-DELISTED	Stock	34.7	37.92	34.43	36.7	354842.0
2012-07-27	ABB-DELISTED	Stock	17.29	17.6	17.25	17.52	4017853.0
2012-07-27	ABBNY-DELISTED	Stock	17.29	17.6	17.25	17.52	4209095.0
2012-07-27	ABC-DELISTED	Stock	38.15	38.93	37.93	38.65	5413878.0
2012-07-27	ABCB	Stock	11.75	12.32	11.63	12.24	48800.0
2012-07-27	ABCD-DELISTED	Stock	1.07	1.28	1.07	1.24	20113.0
2012-07-27	ABCO-DELISTED	Stock	45.02	46.75	44.4	46.09	317203.0
2012-07-27	ABCW-DELISTED	Stock	0.4	0.49	0.34	0.37	53094.0
2012-07-27	ABE-DELISTED	Stock	19.025	19.31	19.025	19.26	17464.0
2012-07-27	ABEO	Stock	637.5	775.0	637.5	775.0	9.0
2012-07-27	ABFS-DELISTED	Stock	11.28	11.95	11.17	11.8	402599.0
2012-07-27	ABG	Stock	25.72	26.81	25.62	26.42	297500.0
2012-07-27	ABM	Stock	18.72	19.1	18.54	18.89	320000.0
2012-07-27	ABMD-DELISTED	Stock	22.02	22.81	21.86	22.08	248680.0
2012-07-27	ABR	Stock	5.35	5.4	5.35	5.4	17800.0
2012-07-27	ABT	Stock	31.115	32.0458	31.115	31.8539	19158399.0
2012-07-27	ABTL-DELISTED	Stock	3.66	3.75	3.65	3.7	4700.0
2012-07-27	ABUS	Stock	2.95	3.1	2.95	3.07	21200.0
2012-07-27	ABV-DELISTED	Stock	38.48	39.85	38.36	39.83	3110531.0
2012-07-27	ABVA-DELISTED	Stock	4.39	4.5499	4.35	4.45	2997.0
2012-07-27	ABX-DELISTED	Stock	32.98	33.02	31.86	32.33	13072309.0
2012-07-27	ACAD	Stock	1.57	1.63	1.56	1.6	191700.0
2012-07-27	ACAS-DELISTED	Stock	9.82	9.92	9.74	9.87	3000170.0

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

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