PREVIEW / stock_daily / 2012-08-08

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-08.parquet
  size:    199 KB
  rows:    6,165
  symbols: 3,501

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-08	AAPL	Stock	22.1211	22.2814	22.0393	22.1379	244706000.0
2012-08-08	MSFT	Stock	30.21	30.47	30.11	30.33	26257600.0
2012-08-08	NVDA	Stock	0.3535	0.3595	0.3525	0.3558	517064000.0
2012-08-08	AMZN	Stock	11.7645	11.8225	11.6795	11.719	30686000.0
2012-08-08	META	Stock	20.71	21.15	20.22	20.72	29537400.0
2012-08-08	TSLA	Stock	1.9933	2.0	1.906	1.9393	19633500.0
2012-08-08	TLT	Stock	126.16	126.39	125.04	125.16	7251608.0
2012-08-08	ES	Stock	39.56	39.61	39.15	39.45	937700.0
2012-08-08	CL	Stock	52.425	52.705	52.34	52.635	3280000.0
2012-08-08	A	Stock	28.8197	29.1416	28.691	29.0844	2704571.0
2012-08-08	AABA-DELISTED	Stock	16.15	16.32	16.09	16.17	7114482.0
2012-08-08	AACC-DELISTED	Stock	5.85	5.98	5.75	5.85	28449.0
2012-08-08	AACG	Stock	4.41	4.43	4.41	4.43	1500.0
2012-08-08	AAIC-DELISTED	Stock	22.84	22.91	22.72	22.88	55639.0
2012-08-08	AAME	Stock	2.68	2.7	2.68	2.7	400.0
2012-08-08	AAMRQ-DELISTED	Stock	0.5002	0.504	0.49	0.5	634242.0
2012-08-08	AAON	Stock	5.8015	5.9526	5.757	5.8519	285863.0
2012-08-08	AAP	Stock	70.63	71.45	70.39	70.57	1548200.0
2012-08-08	AAT	Stock	26.14	26.44	26.05	26.28	188000.0
2012-08-08	AAU-DELISTED	Stock	2.07	2.19	2.04	2.08	370153.0
2012-08-08	AAUAF-DELISTED	Stock	2.07	2.19	2.04	2.09	376653.0
2012-08-08	AAV-DELISTED	Stock	3.8	3.84	3.6	3.67	180767.0
2012-08-08	AAWW-DELISTED	Stock	52.39	53.07	51.15	51.28	283629.0
2012-08-08	AAXJ	Stock	53.96	54.3	53.87	54.06	353604.0
2012-08-08	AAXN-DELISTED	Stock	5.6	5.665	5.53	5.65	728468.0
2012-08-08	AB	Stock	12.52	12.75	12.23	12.29	164500.0
2012-08-08	ABAC-DELISTED	Stock	0.95	0.97	0.9	0.916	23352.0
2012-08-08	ABAX-DELISTED	Stock	37.0	38.04	35.77	37.79	101394.0
2012-08-08	ABB-DELISTED	Stock	17.83	18.06	17.82	18.0	2184098.0
2012-08-08	ABBNY-DELISTED	Stock	17.83	18.06	17.82	17.99	2338811.0
2012-08-08	ABC-DELISTED	Stock	39.18	39.18	38.64	38.69	3422692.0
2012-08-08	ABCB	Stock	11.88	11.88	11.67	11.73	48900.0
2012-08-08	ABCD-DELISTED	Stock	1.09	1.12	0.99	1.06	12629.0
2012-08-08	ABCO-DELISTED	Stock	42.47	42.81	42.2	42.45	421553.0
2012-08-08	ABCW-DELISTED	Stock	0.39	0.4	0.39	0.39	45376.0
2012-08-08	ABE-DELISTED	Stock	19.49	19.62	19.48	19.62	9284.0
2012-08-08	ABEO	Stock	537.5	612.5	512.5	612.5	26.0
2012-08-08	ABFS-DELISTED	Stock	10.4	10.66	10.31	10.36	296410.0
2012-08-08	ABG	Stock	26.62	27.04	26.46	26.75	251800.0
2012-08-08	ABM	Stock	18.77	19.01	18.75	18.91	168300.0
2012-08-08	ABMD-DELISTED	Stock	22.24	22.35	21.42	21.62	785116.0
2012-08-08	ABR	Stock	5.67	5.67	5.44	5.59	87100.0
2012-08-08	ABT	Stock	31.6332	31.758	31.5373	31.6188	8277616.0
2012-08-08	ABTL-DELISTED	Stock	3.52	3.7	3.46	3.58	9135.0
2012-08-08	ABUS	Stock	3.45	3.59	3.41	3.49	9300.0
2012-08-08	ABV-DELISTED	Stock	38.64	38.79	38.34	38.46	1575488.0
2012-08-08	ABVA-DELISTED	Stock	4.5	4.5	4.35	4.35	1990.0
2012-08-08	ABX-DELISTED	Stock	34.25	34.71	33.69	33.76	6812578.0
2012-08-08	ACAD	Stock	1.51	1.56	1.5	1.5	228700.0
2012-08-08	ACAS-DELISTED	Stock	10.57	10.9	10.55	10.86	4122612.0

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

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