PREVIEW / stock_daily / 2012-08-29

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-29.parquet
  size:    196 KB
  rows:    6,086
  symbols: 3,448

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-08-29	AAPL	Stock	24.1161	24.2025	24.0214	24.0525	202806800.0
2012-08-29	MSFT	Stock	30.65	30.75	30.44	30.65	23346800.0
2012-08-29	NVDA	Stock	0.357	0.3602	0.3562	0.358	250412000.0
2012-08-29	AMZN	Stock	12.339	12.3805	12.2295	12.356	35452000.0
2012-08-29	META	Stock	19.32	19.38	19.07	19.1	16124700.0
2012-08-29	TSLA	Stock	1.8993	1.9093	1.868	1.894	12583500.0
2012-08-29	TLT	Stock	125.61	125.63	124.95	125.29	3762842.0
2012-08-29	ES	Stock	37.76	37.86	37.44	37.8	1542800.0
2012-08-29	CL	Stock	53.375	53.45	53.18	53.215	2672200.0
2012-08-29	A	Stock	26.5165	26.6881	26.4163	26.5808	7025509.0
2012-08-29	AABA-DELISTED	Stock	14.75	14.94	14.7	14.85	17889147.0
2012-08-29	AACC-DELISTED	Stock	6.48	6.64	6.38	6.57	16042.0
2012-08-29	AACG	Stock	4.36	4.38	4.35	4.36	4100.0
2012-08-29	AAIC-DELISTED	Stock	23.02	23.02	22.9501	23.0	59034.0
2012-08-29	AAME	Stock	2.68	2.72	2.66	2.72	20700.0
2012-08-29	AAMRQ-DELISTED	Stock	0.467	0.474	0.45	0.45	1958304.0
2012-08-29	AAON	Stock	5.4548	5.5022	5.3481	5.4667	90788.0
2012-08-29	AAP	Stock	72.17	72.34	71.36	71.44	984700.0
2012-08-29	AAT	Stock	27.47	27.64	27.33	27.61	91000.0
2012-08-29	AAU-DELISTED	Stock	2.57	2.62	2.48	2.58	185275.0
2012-08-29	AAUAF-DELISTED	Stock	2.57	2.62	2.48	2.59	200975.0
2012-08-29	AAV-DELISTED	Stock	3.55	3.55	3.46	3.53	335336.0
2012-08-29	AAWW-DELISTED	Stock	50.56	51.65	50.39	51.52	114187.0
2012-08-29	AAXJ	Stock	53.35	53.44	53.12	53.26	178166.0
2012-08-29	AAXN-DELISTED	Stock	5.53	5.59	5.49	5.55	373118.0
2012-08-29	AB	Stock	14.24	14.43	14.19	14.37	672700.0
2012-08-29	ABAC-DELISTED	Stock	1.06	1.13	1.06	1.12	1080.0
2012-08-29	ABAX-DELISTED	Stock	37.97	38.44	37.5	38.09	48977.0
2012-08-29	ABB-DELISTED	Stock	17.44	17.45	17.3	17.38	934488.0
2012-08-29	ABBNY-DELISTED	Stock	17.44	17.45	17.3	17.38	947492.0
2012-08-29	ABC-DELISTED	Stock	37.63	37.75	37.41	37.67	2302701.0
2012-08-29	ABCB	Stock	12.1	12.14	12.0	12.07	18800.0
2012-08-29	ABCD-DELISTED	Stock	0.96	1.03	0.96	0.97	11656.0
2012-08-29	ABCO-DELISTED	Stock	43.64	44.49	43.46	44.4	216050.0
2012-08-29	ABCW-DELISTED	Stock	0.36	0.36	0.36	0.36	100.0
2012-08-29	ABE-DELISTED	Stock	19.5	19.5	18.81	19.4	10555.0
2012-08-29	ABEO	Stock	750.0	750.0	750.0	750.0	1.0
2012-08-29	ABFS-DELISTED	Stock	9.29	9.33	9.115	9.18	241277.0
2012-08-29	ABG	Stock	26.94	27.65	26.68	27.62	327000.0
2012-08-29	ABM	Stock	20.39	20.54	20.29	20.36	204700.0
2012-08-29	ABMD-DELISTED	Stock	22.5	22.68	22.39	22.55	448122.0
2012-08-29	ABR	Stock	5.65	5.77	5.65	5.67	72600.0
2012-08-29	ABT	Stock	31.5804	31.6668	31.4797	31.4797	5656732.0
2012-08-29	ABTL-DELISTED	Stock	3.7719	3.8	3.5608	3.69	14168.0
2012-08-29	ABUS	Stock	3.35	3.41	3.35	3.4	2100.0
2012-08-29	ABV-DELISTED	Stock	36.97	37.01	36.34	36.78	1258041.0
2012-08-29	ABVA-DELISTED	Stock	4.53	4.53	4.51	4.51	1000.0
2012-08-29	ABX-DELISTED	Stock	37.65	37.68	36.92	37.1	6767032.0
2012-08-29	ACAD	Stock	1.79	1.8	1.76	1.78	294800.0
2012-08-29	ACAS-DELISTED	Stock	11.2	11.22	11.12	11.12	1940225.0

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

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