PREVIEW / stock_daily / 2012-08-06

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-06.parquet
  size:    197 KB
  rows:    6,128
  symbols: 3,475

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-06	AAPL	Stock	22.0461	22.3168	21.9736	22.2339	302103200.0
2012-08-06	MSFT	Stock	30.0	30.11	29.81	29.95	27471800.0
2012-08-06	NVDA	Stock	0.3462	0.352	0.3458	0.3502	360324000.0
2012-08-06	AMZN	Stock	11.778	11.787	11.6905	11.6995	36874000.0
2012-08-06	META	Stock	21.39	22.15	21.3	21.92	27778900.0
2012-08-06	TSLA	Stock	1.8367	1.9133	1.8367	1.8847	22923000.0
2012-08-06	TLT	Stock	127.67	128.14	127.37	127.47	3673529.0
2012-08-06	ES	Stock	39.66	39.88	39.51	39.57	725400.0
2012-08-06	CL	Stock	53.185	53.475	52.975	53.175	2405800.0
2012-08-06	A	Stock	28.4192	28.5408	28.0401	28.0615	2807044.0
2012-08-06	AABA-DELISTED	Stock	16.0	16.0725	15.95	16.03	8772000.0
2012-08-06	AACC-DELISTED	Stock	5.76	5.89	5.61	5.83	140055.0
2012-08-06	AACG	Stock	4.21	4.71	4.1	4.68	20700.0
2012-08-06	AAIC-DELISTED	Stock	22.4	22.62	22.4	22.46	68907.0
2012-08-06	AAME	Stock	2.69	2.7	2.65	2.7	1400.0
2012-08-06	AAMRQ-DELISTED	Stock	0.505	0.512	0.501	0.506	473293.0
2012-08-06	AAON	Stock	5.5733	5.6652	5.5526	5.5704	154238.0
2012-08-06	AAP	Stock	68.24	69.47	68.09	69.11	886300.0
2012-08-06	AAT	Stock	26.27	26.64	26.24	26.45	80800.0
2012-08-06	AAU-DELISTED	Stock	1.96	2.0103	1.9598	1.98	93940.0
2012-08-06	AAUAF-DELISTED	Stock	1.94	1.99	1.94	1.98	95755.0
2012-08-06	AAV-DELISTED	Stock	3.87	3.9	3.75	3.79	151257.0
2012-08-06	AAWW-DELISTED	Stock	51.07	52.1	50.8701	51.78	332954.0
2012-08-06	AAXJ	Stock	53.75	54.06	53.7	53.84	76902.0
2012-08-06	AAXN-DELISTED	Stock	5.51	5.595	5.48	5.53	936147.0
2012-08-06	AB	Stock	12.32	12.85	12.27	12.61	192300.0
2012-08-06	ABAC-DELISTED	Stock	0.95	0.95	0.85	0.85	7001.0
2012-08-06	ABAX-DELISTED	Stock	37.31	37.91	36.93	37.31	68170.0
2012-08-06	ABB-DELISTED	Stock	18.07	18.1295	17.93	17.94	3159544.0
2012-08-06	ABBNY-DELISTED	Stock	18.07	18.1295	17.93	17.95	3617364.0
2012-08-06	ABC-DELISTED	Stock	39.4	39.66	39.2	39.21	2258347.0
2012-08-06	ABCB	Stock	11.94	12.01	11.74	11.8	35200.0
2012-08-06	ABCD-DELISTED	Stock	1.06	1.09	1.03	1.03	18007.0
2012-08-06	ABCO-DELISTED	Stock	43.39	44.09	42.76	42.79	336333.0
2012-08-06	ABCW-DELISTED	Stock	0.38	0.48	0.36	0.36	45577.0
2012-08-06	ABE-DELISTED	Stock	19.33	19.62	19.33	19.57	20085.0
2012-08-06	ABEO	Stock	687.5	687.5	537.5	612.5	72.0
2012-08-06	ABFS-DELISTED	Stock	9.92	10.42	9.75	10.24	424721.0
2012-08-06	ABG	Stock	27.01	27.1	26.56	27.0	301600.0
2012-08-06	ABM	Stock	18.88	19.08	18.73	18.88	157000.0
2012-08-06	ABMD-DELISTED	Stock	22.74	23.5	22.24	22.44	599056.0
2012-08-06	ABR	Stock	5.53	5.61	5.5	5.57	34200.0
2012-08-06	ABT	Stock	32.0027	32.065	31.8347	31.8443	6775323.0
2012-08-06	ABTL-DELISTED	Stock	3.43	3.68	3.43	3.66	84562.0
2012-08-06	ABUS	Stock	3.0	3.65	2.77	3.3	31800.0
2012-08-06	ABV-DELISTED	Stock	38.68	39.385	38.59	39.28	1509161.0
2012-08-06	ABX-DELISTED	Stock	33.05	33.84	32.85	33.39	5581357.0
2012-08-06	ACAD	Stock	1.52	1.58	1.52	1.57	78800.0
2012-08-06	ACAS-DELISTED	Stock	10.62	10.8001	10.6	10.69	2985244.0
2012-08-06	ACAT-DELISTED	Stock	44.18	44.928	43.83	44.43	142119.0

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

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