PREVIEW / stock_daily / 2012-08-24

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-24.parquet
  size:    197 KB
  rows:    6,090
  symbols: 3,464

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-24	AAPL	Stock	23.5539	23.91	23.4125	23.6864	437340400.0
2012-08-24	MSFT	Stock	30.25	30.63	30.18	30.56	22943300.0
2012-08-24	NVDA	Stock	0.3578	0.3668	0.357	0.365	347724000.0
2012-08-24	AMZN	Stock	12.084	12.3435	12.068	12.287	73976000.0
2012-08-24	META	Stock	19.52	19.68	19.25	19.41	29622200.0
2012-08-24	TSLA	Stock	2.004	2.016	1.9607	1.9667	21441000.0
2012-08-24	TLT	Stock	125.47	125.56	124.67	124.81	5001658.0
2012-08-24	ES	Stock	37.66	38.02	37.63	37.97	830600.0
2012-08-24	CL	Stock	52.455	52.955	52.25	52.885	2335800.0
2012-08-24	A	Stock	26.6524	27.1888	26.6094	27.0744	4022465.0
2012-08-24	AABA-DELISTED	Stock	14.82	14.94	14.765	14.92	8603186.0
2012-08-24	AACC-DELISTED	Stock	6.35	6.56	6.19	6.47	24198.0
2012-08-24	AACG	Stock	4.38	4.4	4.38	4.38	1000.0
2012-08-24	AAIC-DELISTED	Stock	22.81	22.99	22.81	22.92	27371.0
2012-08-24	AAME	Stock	2.7	2.7	2.54	2.69	10200.0
2012-08-24	AAMRQ-DELISTED	Stock	0.481	0.499	0.48	0.4856	444400.0
2012-08-24	AAON	Stock	5.4193	5.4252	5.3274	5.36	79988.0
2012-08-24	AAP	Stock	71.87	72.35	71.55	71.97	831000.0
2012-08-24	AAT	Stock	27.05	27.41	27.0	27.28	94600.0
2012-08-24	AAU-DELISTED	Stock	2.3602	2.42	2.3206	2.4	114744.0
2012-08-24	AAUAF-DELISTED	Stock	2.38	2.44	2.3401	2.38	115580.0
2012-08-24	AAV-DELISTED	Stock	3.73	3.73	3.61	3.7	139235.0
2012-08-24	AAWW-DELISTED	Stock	51.84	52.62	51.18	52.21	156350.0
2012-08-24	AAXJ	Stock	53.91	54.06	53.53	53.95	174044.0
2012-08-24	AAXN-DELISTED	Stock	5.36	5.41	5.27	5.285	215790.0
2012-08-24	AB	Stock	13.31	13.67	13.22	13.59	534100.0
2012-08-24	ABAC-DELISTED	Stock	1.13	1.22	0.9225	1.059	25134.0
2012-08-24	ABAX-DELISTED	Stock	37.82	38.5	37.62	38.08	36318.0
2012-08-24	ABB-DELISTED	Stock	17.51	17.67	17.49	17.53	1625537.0
2012-08-24	ABBNY-DELISTED	Stock	17.51	17.67	17.49	17.54	1648974.0
2012-08-24	ABC-DELISTED	Stock	37.89	38.26	37.8206	38.09	2080276.0
2012-08-24	ABCB	Stock	11.73	12.0	11.73	11.94	12300.0
2012-08-24	ABCD-DELISTED	Stock	0.99	0.99	0.93	0.93	10600.0
2012-08-24	ABCO-DELISTED	Stock	42.69	43.51	42.69	43.15	265380.0
2012-08-24	ABCW-DELISTED	Stock	0.39	0.48	0.3625	0.48	41388.0
2012-08-24	ABE-DELISTED	Stock	19.45	19.58	19.3	19.58	11416.0
2012-08-24	ABEO	Stock	625.0	800.0	575.0	800.0	65.0
2012-08-24	ABFS-DELISTED	Stock	9.91	9.99	9.69	9.73	261499.0
2012-08-24	ABG	Stock	26.31	26.56	26.02	26.39	99800.0
2012-08-24	ABM	Stock	20.25	20.68	20.23	20.53	184100.0
2012-08-24	ABMD-DELISTED	Stock	21.7	21.99	21.38	21.8	173786.0
2012-08-24	ABR	Stock	5.44	5.55	5.44	5.55	36900.0
2012-08-24	ABT	Stock	31.2302	31.6188	31.2302	31.59	7971863.0
2012-08-24	ABTL-DELISTED	Stock	3.77	3.86	3.69	3.8	9627.0
2012-08-24	ABUS	Stock	3.48	3.5	3.45	3.45	1800.0
2012-08-24	ABV-DELISTED	Stock	37.29	37.8	37.25	37.5	1169129.0
2012-08-24	ABX-DELISTED	Stock	37.94	38.22	37.61	37.77	6571228.0
2012-08-24	ACAD	Stock	1.85	1.85	1.79	1.8	543000.0
2012-08-24	ACAS-DELISTED	Stock	11.14	11.22	11.14	11.16	2731691.0
2012-08-24	ACAT-DELISTED	Stock	42.87	43.43	42.27	42.93	217724.0

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

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